我有一些主要的困难弄清楚我在下面代码中的while和foreach循环中做错了什么。我有一种混合面向对象和过程mqsqli的倾向,但是每次我认为我做对了,我就会得到一个错误。
我在这段代码中的循环中做错了什么?
现在我得到这个错误
Warning: mysqli::query() expects parameter 1 to be string,
完整代码try {
$con = new mysqli("localhost", "", "", "");
if (mysqli_connect_errno()) {
throw new Exception("Connect failed: %s'n", mysqli_connect_error());
exit();
}
$cid = $_GET['cid'];
$tid = $_GET['tid'];
$userid = ( isset( $_SESSION['user'] ) ? $_SESSION['user'] : "" );
echo $cid . "<br>";
echo $tid;
//Prepare
if ($stmt = $con->prepare("SELECT * FROM forum_topics WHERE `category_id`=? AND `id`=? LIMIT 1")) {
$stmt->bind_param("ii", $cid, $tid);
//$stmt->fetch();
if (!$stmt) {
throw new Exception($con->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
if($stmt2 = $con->prepare("SELECT * FROM forum_posts WHERE `category_id`=? AND `topic_id`=?")) {
//var_dump($stmt2);
$stmt2->bind_param("ii", $cid, $tid);
$stmt2->execute();
}
if ($result = $con->query($stmt)) {
while ($row2 = $result->fetch_assoc() ) {
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>";
}
if ($stmt = $con->prepare("SELECT * FROM forum_topics WHERE `category_id`=? AND `id`=? LIMIT 1")) {
$stmt->bind_param("ii", $cid, $tid);
//$stmt->fetch();
if (!$stmt) {
throw new Exception($con->error);
}
}
$stmt->store_result();
$numrows = $stmt->num_rows;
在循环执行foreach($stmt as $row) {
之前,您不会实际执行$stmt
。
你要把这个放在那里:
$stmt->execute()
你的逻辑有点乱。您看起来像是在循环您从未执行过的查询的结果,然后您尝试在这里重新查询原始$stmt
:
if ($result = $con->query($stmt)) {
编辑:在与你聊天之后,你需要编辑你的原始查询来查询特定的列,这样你就可以像这样引用它们:
if ($stmt = $con->prepare("SELECT topic_creator FROM forum_topics WHERE `category_id`=? AND `id`=? LIMIT 1")) {
…
$stmt->bind_result($topic_creator);
while ($stmt->fetch()) {
echo "TC: " . $topic_creator . "<br>";
}
您可以将此应用于while
循环中的子查询。