您的位置: 首页  >  技术问答  >  准备准备好的声明中失败的一部分 - 直接在另一个准备好的声明

准备准备好的声明中失败的一部分 - 直接在另一个准备好的声明

分类: 技术问答 • 2022-05-24 10:44:48
问题描述：

我有以下几点是失败的一份声明的准备......准备准备好的声明中失败的一部分 - 直接在另一个准备好的声明

$stmt2 = $con->prepare("SELECT * FROM forum_posts WHERE `category_id`=? AND `topic_id`=?"); 
    //var_dump($stmt2); 
    if (!$stmt2 || !empty($con->error)) { 
     die('Select forum posts prepare() failed: ' . htmlspecialchars($con->error)); 
    }

我有我的第一个准备好的声明几乎完全一样的准备和它经历得很好。我不知道，如果我有两个准备好的声明，如果这导致问题或情况可能是正确的事实？

现在我得到这个错误...

- 选择论坛帖子准备（）失败： -

这使得自上面的代码准备失败的错误。

有没有人看到任何会导致此失败？

$con = mysqli_connect("localhost", "root", "", "db"); 
if (mysqli_connect_errno()) { 
    printf("Connect failed: %s\n", mysqli_connect_error()); 
    exit(); 
} 
$cid = $_GET['cid']; 
$tid = $_GET['tid']; 
$userid = (isset($_SESSION['user']) ? $_SESSION['user'] : ""); 

//Prepared SELECT stmt to get forum topics 
$stmt = $con->prepare("SELECT * FROM forum_topics WHERE `category_id`=? AND id=? LIMIT 1"); 
if (!$stmt || $con->error) { 
    die('Select topics prepare() failed: ' . htmlspecialchars($con->error)); 
} 
if(!$stmt->bind_param('ii', $cid, $tid)) { 
    die('Select topics bind_param() failed: ' . htmlspecialchars($stmt->error)); 
} 
if(!$stmt->execute()) { 
    die('Select topics execute() failed: ' . htmlspecialchars($stmt->error)); 
} 
$stmt->store_result(); 
$numrows = $stmt->num_rows; 
if($numrows == 1){ 
    echo "<table width='100%'>"; 
    if ($_SESSION['user']) { 
     echo "<tr><td colspan='2'><input type='submit' value='Add Reply' onClick=\"window.location = 
    'forum_post_reply.php?cid=".$cid."$tid=".$tid."'\"> <hr />"; 
    } else { 
     echo "<tr><td colspan='2'><p>Please log in to add your reply</p><hr /></td></tr>"; 
    } 
    foreach($stmt as $row) { 

     //Prepared SELECT stmt to get forum posts 
     $stmt2 = $con->prepare("SELECT * FROM forum_posts WHERE `category_id`=? AND `topic_id`=?"); 
     //var_dump($stmt2); 
     if (!$stmt2 || !empty($con->error)) { 
      die('Select forum posts prepare() failed: ' . htmlspecialchars($con->error)); 
     } 
     //var_dump($con->error); 
     if(!$stmt2->bind_param('ii', $cid, $tid)) { 
      die('Select forum posts bind_param() failed: ' . htmlspecialchars($stmt2->error)); 
     } 
     if(!$stmt2->execute()) { 
      die('Select forum posts execute() failed: ' . htmlspecialchars($stmt2->error)); 
     } 
     //while($row2 = mysqli_fetch_assoc($stmt2)){ 
     foreach($stmt2 as $row2) { 
      echo "<tr><td valign='top' style='border: 1px solid #000000;'> 
      <div style='min-height: 125px;'>".$row['topic_title']."<br /> 
      by ".$row2['post_creator']." - " .$row2['post_date']. "<hr />" . $row2['post_content'] ."</div></td> 
      <td width='200' valign='top' align='center' style='border: 1px solid #000000;'>User Info Here!</td></tr> 
      <tr><td colspan='2'><hr /></td></tr>"; 
     } 
    } 
} else { 
    echo "<p>This topic does not exist.</p>"; 
}

更新 - 可能的INNER JOIN，像这样？

//Prepared SELECT stmt to get forum topics 
$stmt = $con->prepare("SELECT * FROM forum_topics AS f INNER JOIN forum_posts AS p ON 
f.category_id=p.category_id ON f.id=p.topic_id WHERE s.category_id=? AND s.id=? LIMIT 1"); 
if (!$stmt || $con->error) { 
    die('Select topics prepare() failed: ' . htmlspecialchars($con->error)); 
} 
if(!$stmt->bind_param('ii', $cid, $tid)) { 
    die('Select topics bind_param() failed: ' . htmlspecialchars($stmt->error)); 
} 
if(!$stmt->execute()) { 
    die('Select topics execute() failed: ' . htmlspecialchars($stmt->error)); 
} 
$stmt->store_result(); 
$numrows = $stmt->num_rows; 
if($numrows == 1){ 
    echo "<table width='100%'>"; 
    if ($_SESSION['user']) { 
     echo "<tr><td colspan='2'><input type='submit' value='Add Reply' onClick=\"window.location = 
    'forum_post_reply.php?cid=".$cid."$tid=".$tid."'\"> <hr />"; 
    } else { 
     echo "<tr><td colspan='2'><p>Please log in to add your reply</p><hr /></td></tr>"; 
    } 
    foreach($stmt as $row) { 
      echo "<tr><td valign='top' style='border: 1px solid #000000;'> 
      <div style='min-height: 125px;'>".$row['topic_title']."<br /> 
      by ".$row2['post_creator']." - " .$row2['post_date']. "<hr />" . $row2['post_content'] ."</div></td> 
      <td width='200' valign='top' align='center' style='border: 1px solid #000000;'>User Info Here!</td></tr> 
      <tr><td colspan='2'><hr /></td></tr>"; 
     } 
    } 
} else { 
    echo "<p>This topic does not exist.</p>"; 
} 

}*/ 
/*$stmt = $con->prepare("SELECT topic_title, post_content FROM forum_topics, forum_posts 
WHERE forum_topics.category_id=forum_posts.category_id 
AND forum_topics.category_id=?");*/ 
//$stmt = $con->prepare("SELECT topic_title, topic_creator FROM forum_posts AS f LEFT JOIN forum_topics AS p ON f.category_id=p.category_id WHERE f.category_id=?"); 
$stmt = $con->prepare("SELECT topic_title, topic_creator FROM forum_posts AS p, forum_topics AS f WHERE f.category_id=? AND p.topic_id=? LIMIT 1"); 
if (!$stmt || $con->error) { 
die('Select forum prepare() failed: ' . htmlspecialchars($con->error)); 
} 
if(!$stmt->bind_param('ii', $cid, $tid)) { 
die('Select forum bind_param() failed: ' . htmlspecialchars($stmt->error)); 
} 
if(!$stmt->execute()) { 
die('Select forum execute() failed: ' . htmlspecialchars($stmt->error)); 
} 
mysqli_stmt_bind_result($stmt, $post_content, $topic_title); 
$stmt->store_result(); 
echo $stmt->store_result(); 
$numrows = $stmt->num_rows; 
if($stmt->num_rows > 0){ 
echo "<table width='100%'>"; 
if ($_SESSION['user']) { 
    echo "<tr><td colspan='2'><input type='submit' value='Add Reply' onClick=\"window.location = 
'forum_post_reply.php?cid=".$cid."$tid=".$tid."'\"> <hr />"; 
} else { 
    echo "<tr><td colspan='2'><p>Please log in to add your reply</p><hr /></td></tr>"; 
} 
while (mysqli_stmt_fetch($stmt)) { 
echo "<tr><td valign='top' style='border: 1px solid #000000;'> 
<div style='min-height: 125px;'>".$topic_title."<br /> 
by " . $post_content ."</div></td> 
<td width='200' valign='top' align='center' style='border: 1px solid #000000;'>User Info Here!</td></tr> 
<tr><td colspan='2'><hr /></td></tr>"; 
} 
mysqli_stmt_close($stmt); 
} else { 
echo "<p>This topic does not exist.</p>"; 
} 

?> 
    </body> 
</html>
+0

评论是不适合扩展讨论;这个谈话已经[转移到聊天]（http://chat.stackoverflow.com/rooms/83776/discussion-on-question-by-paul-prepare-part-of-prepared-statement-failing-dire）。 –

答

花5小时在聊天OP后，终于解决了问题

问题;

  • 第二查询失败
  • 与1查询结果没有显示

没有需要;

  • 没有必要加入表
  • 无需第二个选择查询的
  • 没有的foreach

解决方案;

//bind the result 
mysqli_stmt_bind_result($stmt, $topic_title, $topic_creator, $postDate, $postcontent); 
//use while loop instead foreach 
while (mysqli_stmt_fetch($stmt))

工作代码;

//Prepared SELECT stmt to get forum topics 
$stmt = $con->prepare("SELECT topic_title, topic_creator, post_date, post_content FROM forum_posts AS p, forum_topics AS f WHERE f.category_id=? AND p.topic_id=?"); 
if (!$stmt || $con->error) { 
    die('Select forum prepare() failed: ' . htmlspecialchars($con->error)); 
} 
if(!$stmt->bind_param('ii', $cid, $tid)) { 
    die('Select forum bind_param() failed: ' . htmlspecialchars($stmt->error)); 
} 
if(!$stmt->execute()) { 
    die('Select forum execute() failed: ' . htmlspecialchars($stmt->error)); 
} 
mysqli_stmt_bind_result($stmt, $topic_title, $topic_creator, $postDate, $postcontent); 
$stmt->store_result(); 
if($stmt->num_rows > 0){ 

    echo "<table width='100%'>"; 
    if ($_SESSION['user']) { 
     echo "<tr><td colspan='2'><input type='submit' value='Add Reply' onClick=\"window.location = 
    'forum_post_reply.php?cid=".$cid."$tid=".$tid."'\"> <hr />"; 
    } else { 
     echo "<tr><td colspan='2'><p>Please log in to add your reply</p><hr /></td></tr>"; 
    } 
    while (mysqli_stmt_fetch($stmt)) { 
     echo "<tr><td valign='top' style='border: 1px solid #000000;'> 
     <div style='min-height: 125px;'>".$topic_title."<br /> 
     by ".$topic_creator." - " .$postDate. "<hr />" . $postcontent ."</div></td> 
     <td width='200' valign='top' align='center' style='border: 1px solid #000000;'>User Info Here!</td></tr> 
     <tr><td colspan='2'><hr /></td></tr>"; 
     } 
     mysqli_stmt_close($stmt); 
} else { 
    echo "<p>This topic does not exist.</p>"; 
}

忘记提及，这是我第一次与mysqli，我读过它，但从来没有尝试过。

+0

我回到家后，真的看着它，它仍然是不正确的。它没有得到正确的职位。它只显示循环中的第一篇文章。我加回了'LIMIT'。 \ – Paul

+0

不知道我希望如此。我只是将我的代码添加到底部的原始问题中。这非常混乱，但我评论了我没有使用的东西。 – Paul

+0

是的，它看起来像，但我很担心得到的东西输出我没有把两个和两个在一起。如果我点击主题，我会获得所有帖子，而不仅仅是与该主题相关的帖子。 – Paul

相关推荐