我如何才能根据某些电子邮件ID获取所有存储在mysqli数据库中的记录。
就像我想获取所有针对[email protected]存储的问题字段的记录一样,下面将提到我到目前为止所做的事情。但我的for循环代码仅打印www.google.com。我如何获得其他两个领域?
<?php
$email = $_SESSION["email"];
$prevq = "Select * FROM `askadoc` WHERE `email` = '$email'";
$result = mysqli_query($conn, $prevq);
$prevq = "";
$location = "";
if(mysqli_num_rows($result)>0){
while($row = mysqli_fetch_assoc($result)) {
$prevq = $row["question"];
$date = $row["date"];
}
}
?>
<div class="tab-content">
<div role="tabpanel" class="tab-pane active" id="home">
<?php
for($i=0; $i<=count($email); $i++){
echo $date;
echo "<br>";
echo $prevq;
echo "<br>";
}
?>
</div>
</div>
试试这个,它将起作用:
<?php
$email = $_SESSION["email"];
$prevq = "Select * FROM `askadoc` WHERE `email` = '$email'";
$result = mysqli_query($conn, $prevq);
$prevq = "";
$location = "";
if (mysqli_num_rows($result) > 0):
?>
<div class="tab-content">
<div role="tabpanel" class="tab-pane active" id="home">
<?php
while ($row = mysqli_fetch_assoc($result)) :
$prevq = $row["question"];
$date = $row["date"];
echo $date;
echo "<br>";
echo $prevq;
echo "<br>";
endwhile;
?>
</div>
</div>
<?php
endif;
?>
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句