如果没有正确显示结果 [英] If else not showing results correctly
本文介绍了如果没有正确显示结果的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试根据它返回的行做一个 if else,但它无法正常工作我不知道我做错了什么,如果有人可以给我一些关于我做错了什么的现场非常感谢您的帮助
$dbconnect=mysqli_connect($hostname,$username,$password,$db);如果($dbconnect->connect_error){die("数据库连接失败:" . $dbconnect->connect_error);}$query=mysqli_query($dbconnect,"SELECT DISTINCT companyname,client_id,feedback,status from review WHERE status=1 ORDER BY RAND() LIMIT 5");$query3=mysqli_query($dbconnect,"SELECT companyname,client_id,feedback,status from review WHERE status=3");$rows_get = mysqli_num_rows($query);如果($rows_get > 0){{$row1 = mysqli_fetch_assoc($query);$row2 = mysqli_fetch_assoc($query3);$row3 = mysqli_fetch_assoc($query3);$row4 = mysqli_fetch_assoc($query3);$row5 = mysqli_fetch_assoc($query3);}}else if ($rows_get >1) {{$row1 = mysqli_fetch_assoc($query);$row2 = mysqli_fetch_assoc($query);$row3 = mysqli_fetch_assoc($query3);$row4 = mysqli_fetch_assoc($query3);$row5 = mysqli_fetch_assoc($query3);}}else if ($rows_get >2) {{$row1 = mysqli_fetch_assoc($query);$row2 = mysqli_fetch_assoc($query);$row3 = mysqli_fetch_assoc($query);$row4 = mysqli_fetch_assoc($query3);$row5 = mysqli_fetch_assoc($query3);}}else if ($rows_get >3) {{$row1 = mysqli_fetch_assoc($query);$row2 = mysqli_fetch_assoc($query);$row3 = mysqli_fetch_assoc($query);$row4 = mysqli_fetch_assoc($query);$row5 = mysqli_fetch_assoc($query3);}}else if ($rows_get >4) {{$row1 = mysqli_fetch_assoc($query);$row2 = mysqli_fetch_assoc($query);$row3 = mysqli_fetch_assoc($query);$row4 = mysqli_fetch_assoc($query);$row5 = mysqli_fetch_assoc($query);}}别的 {$row1 = mysqli_fetch_assoc($query3);$row2 = mysqli_fetch_assoc($query3);$row3 = mysqli_fetch_assoc($query3);$row4 = mysqli_fetch_assoc($query3);$row5 = mysqli_fetch_assoc($query3);}
这是帖子被拉到的 php/html 方面,这是我遇到问题的地方
<p class="mb-0">"<?php echo $row1['feedback']; ?>"</p><footer class="blockquote-footer"><?php echo $row1['client_id'];?>@ <?php echo $row1['companyname'];?></footer></blockquote><blockquote class="blockquote-reverse"><p class="mb-0">"<?php echo $row2['feedback']; ?>"</p><footer class="blockquote-footer"><?php echo $row2['client_id'];?>@ <?php echo $row2['companyname'];?></footer></blockquote><blockquote class="blockquote"><p class="mb-0">"<?php echo $row3['feedback']; ?>"</p><footer class="blockquote-footer"><?php echo $row3['client_id'];?>@ <?php echo $row['companyname'];?></footer></blockquote><blockquote class="blockquote-reverse"><p class="mb-0">"<?php echo $row4['feedback']; ?>"</p><footer class="blockquote-footer"><?php echo $row4['client_id'];?>@ <?php echo $row4['companyname'];?></footer></blockquote><blockquote class="blockquote"><p class="mb-0">"<?php echo $row5['feedback']; ?>"</p><footer class="blockquote-footer"><?php echo $row5['client_id'];?>@ <?php echo $row5['companyname'];?></footer></blockquote>
解决方案
这可能是您问题的解决方案,即使它有点棘手:
if ($dbconnect->connect_error) {die("数据库连接失败:" . $dbconnect->connect_error);}$query=mysqli_query($dbconnect,"SELECT DISTINCT companyname,client_id,feedback,status from review WHERE status=1 ORDER BY RAND() LIMIT 5");$query3=mysqli_query($dbconnect,"SELECT companyname,client_id,feedback,status from review WHERE status=3");$rows_get = mysqli_num_rows($query);$nq=0;while($row=mysqli_fetch_array($query,MYSQLI_ASSOC)){如果 ($rows_get == 1 && $nq < 1) {回声 $row['公司名称'];回声 $row['client_id'];回声 $row['反馈'];回声 $row['status'];++$nq;} else if ($rows_get == 2 && $nq < 2) {回声 $row['公司名称'];回声 $row['client_id'];回声 $row['反馈'];回声 $row['status'];++$nq;} else if ($rows_get == 3 && $nq < 3) {回声 $row['公司名称'];回声 $row['client_id'];回声 $row['反馈'];回声 $row['status'];++$nq;} else if ($rows_get == 4 && $nq < 4) {回声 $row['公司名称'];回声 $row['client_id'];回声 $row['反馈'];回声 $row['status'];++$nq;} else if ($rows_get == 5 && $nq < 5) {回声 $row['公司名称'];回声 $row['client_id'];回声 $row['反馈'];回声 $row['status'];++$nq;} 别的 {休息;}}$nq=0;while($row3=mysqli_fetch_array($query3,MYSQLI_ASSOC)){如果 ($rows_get == 0 && $nq < 5) {回声 $row3['公司名称'];回声 $row3['client_id'];回声 $row3['反馈'];echo $row3['status'];++$nq;} else if ($rows_get == 1 && $nq < 4) {回声 $row3['公司名称'];回声 $row3['client_id'];回声 $row3['反馈'];echo $row3['status'];++$nq;} else if ($rows_get == 2 && $nq < 3) {回声 $row3['公司名称'];回声 $row3['client_id'];回声 $row3['反馈'];echo $row3['status'];++$nq;} else if ($rows_get == 3 && $nq < 2) {回声 $row3['公司名称'];回声 $row3['client_id'];回声 $row3['反馈'];echo $row3['status'];++$nq;} else if ($rows_get == 4 && $nq < 1) {回声 $row3['公司名称'];回声 $row3['client_id'];回声 $row3['反馈'];echo $row3['status'];++$nq;} 别的 {休息;}}
I'm trying to do a if else depending on the rows that it get back but its not working right i dont know what i'm doing wrong if anyone can give me some insite on what i'm doing wrong would be so much of a help thank you in advance
$dbconnect=mysqli_connect($hostname,$username,$password,$db);
if ($dbconnect->connect_error) {
die("Database connection failed: " . $dbconnect->connect_error);
}
$query=mysqli_query($dbconnect,"SELECT DISTINCT companyname,client_id,feedback,status from review WHERE status=1 ORDER BY RAND() LIMIT 5");
$query3=mysqli_query($dbconnect,"SELECT companyname,client_id,feedback,status from review WHERE status=3");
$rows_get = mysqli_num_rows($query);
if ($rows_get >0) {
{
$row1 = mysqli_fetch_assoc($query);
$row2 = mysqli_fetch_assoc($query3);
$row3 = mysqli_fetch_assoc($query3);
$row4 = mysqli_fetch_assoc($query3);
$row5 = mysqli_fetch_assoc($query3);
}
}else if ($rows_get >1) {
{
$row1 = mysqli_fetch_assoc($query);
$row2 = mysqli_fetch_assoc($query);
$row3 = mysqli_fetch_assoc($query3);
$row4 = mysqli_fetch_assoc($query3);
$row5 = mysqli_fetch_assoc($query3);
}
}else if ($rows_get >2) {
{
$row1 = mysqli_fetch_assoc($query);
$row2 = mysqli_fetch_assoc($query);
$row3 = mysqli_fetch_assoc($query);
$row4 = mysqli_fetch_assoc($query3);
$row5 = mysqli_fetch_assoc($query3);
}
}else if ($rows_get >3) {
{
$row1 = mysqli_fetch_assoc($query);
$row2 = mysqli_fetch_assoc($query);
$row3 = mysqli_fetch_assoc($query);
$row4 = mysqli_fetch_assoc($query);
$row5 = mysqli_fetch_assoc($query3);
}
}else if ($rows_get >4) {
{
$row1 = mysqli_fetch_assoc($query);
$row2 = mysqli_fetch_assoc($query);
$row3 = mysqli_fetch_assoc($query);
$row4 = mysqli_fetch_assoc($query);
$row5 = mysqli_fetch_assoc($query);
}
}else {
$row1 = mysqli_fetch_assoc($query3);
$row2 = mysqli_fetch_assoc($query3);
$row3 = mysqli_fetch_assoc($query3);
$row4 = mysqli_fetch_assoc($query3);
$row5 = mysqli_fetch_assoc($query3);
}
this is the php/html side where the post get pulled to this is where i'm running in to issues
<blockquote class="blockquote" >
<p class="mb-0">"<?php echo $row1['feedback']; ?>"</p>
<footer class="blockquote-footer"><?php echo $row1['client_id']; ?> @ <?php echo $row1['companyname']; ?></footer>
</blockquote>
<blockquote class="blockquote-reverse">
<p class="mb-0">"<?php echo $row2['feedback']; ?>"</p>
<footer class="blockquote-footer"><?php echo $row2['client_id']; ?> @ <?php echo $row2['companyname']; ?></footer>
</blockquote>
<blockquote class="blockquote">
<p class="mb-0">"<?php echo $row3['feedback']; ?>"</p>
<footer class="blockquote-footer"><?php echo $row3['client_id']; ?> @ <?php echo $row['companyname']; ?></footer>
</blockquote>
<blockquote class="blockquote-reverse">
<p class="mb-0">"<?php echo $row4['feedback']; ?>"</p>
<footer class="blockquote-footer"><?php echo $row4['client_id']; ?> @ <?php echo $row4['companyname']; ?></footer>
</blockquote>
<blockquote class="blockquote">
<p class="mb-0">"<?php echo $row5['feedback']; ?>"</p>
<footer class="blockquote-footer"><?php echo $row5['client_id']; ?> @ <?php echo $row5['companyname']; ?></footer>
</blockquote>
</div>
</div>
解决方案
This is could be a solution for your problem, even if it's a bit tricky:
if ($dbconnect->connect_error) {
die("Database connection failed: " . $dbconnect->connect_error);
}
$query=mysqli_query($dbconnect,"SELECT DISTINCT companyname,client_id,feedback,status from review WHERE status=1 ORDER BY RAND() LIMIT 5");
$query3=mysqli_query($dbconnect,"SELECT companyname,client_id,feedback,status from review WHERE status=3");
$rows_get = mysqli_num_rows($query);
$nq=0;
while($row=mysqli_fetch_array($query,MYSQLI_ASSOC))
{
if ($rows_get == 1 && $nq < 1) {
echo $row['companyname'];
echo $row['client_id'];
echo $row['feedback'];
echo $row['status'];
++$nq;
} else if ($rows_get == 2 && $nq < 2) {
echo $row['companyname'];
echo $row['client_id'];
echo $row['feedback'];
echo $row['status'];
++$nq;
} else if ($rows_get == 3 && $nq < 3) {
echo $row['companyname'];
echo $row['client_id'];
echo $row['feedback'];
echo $row['status'];
++$nq;
} else if ($rows_get == 4 && $nq < 4) {
echo $row['companyname'];
echo $row['client_id'];
echo $row['feedback'];
echo $row['status'];
++$nq;
} else if ($rows_get == 5 && $nq < 5) {
echo $row['companyname'];
echo $row['client_id'];
echo $row['feedback'];
echo $row['status'];
++$nq;
} else {
break;
}
}
$nq=0;
while($row3=mysqli_fetch_array($query3,MYSQLI_ASSOC))
{
if ($rows_get == 0 && $nq < 5) {
echo $row3['companyname'];
echo $row3['client_id'];
echo $row3['feedback'];
echo $row3['status'];
++$nq;
} else if ($rows_get == 1 && $nq < 4) {
echo $row3['companyname'];
echo $row3['client_id'];
echo $row3['feedback'];
echo $row3['status'];
++$nq;
} else if ($rows_get == 2 && $nq < 3) {
echo $row3['companyname'];
echo $row3['client_id'];
echo $row3['feedback'];
echo $row3['status'];
++$nq;
} else if ($rows_get == 3 && $nq < 2) {
echo $row3['companyname'];
echo $row3['client_id'];
echo $row3['feedback'];
echo $row3['status'];
++$nq;
} else if ($rows_get == 4 && $nq < 1) {
echo $row3['companyname'];
echo $row3['client_id'];
echo $row3['feedback'];
echo $row3['status'];
++$nq;
} else {
break;
}
}
这篇关于如果没有正确显示结果的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文