对于每个如果为true的mysqli结果

debugcn 发表于 Dev

你

您好，我尝试从表格中打印所有结果，时间不多了：谢谢您的帮助或提示。

<?php
function show_entrys($all){

$connectSQL = mysqli_connect("localhost", "root", "Timur", "eventdb");

// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

foreach ($all as $one){
         $Eid = $one['event_id'];
             $Tid = $one['time_id'];
     $dtA = $one['endtime'];
     $dtB = date('Y-m-d H:i:s');
       $date1 = strtotime("7 February 2008"); 
       $date2 = strtotime("8 February 2008");

实际上，我想检查$ dtB和$ dtA：

    SQL QUERY QUESRION:
    can i make a innerjoin query with the following query? : "select starttime, endtime from time where id = $ "

如果没有，我会用另一种方式解决这个问题。查询如下：

if($date2 > $date1){ 
   $sql = $connectSQL->query("SELECT name, description, genre_id, photo FROM eventWHER id=$Eid");

在这里我想将表中的每个条目都提取到一个数组中

}
else {
  echo" no events in the future ";
    }
   }

while($row= mysqli_fetch_array($sql,MYSQLI_ASSOC)){
                $events[] = $row;
                }
        foreach ($events as $one){
        echo $one['name'];
        echo $one['description'];
        echo $one['genre_id'];
        echo $one['photo'];
        }
        mysqli_close($connectSQL);
}

一切正常，除了我在div中使用while。

水晶

您需要在If语句中解析MySQL结果。否则，您将只有最后一次运行foreach（$ all为$ one）。

然后，查询为FROM event WHERE id=$Eid，而不是FROM eventWHER id=$Eid。

<?php
function show_entrys($all){

$connectSQL = mysqli_connect("localhost", "root", "Timur", "eventdb");

// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

foreach ($all as $one){
         $Eid = $one['event_id'];
     $dtA = $one['endtime'];
     $dtB = date('Y-m-d H:i:s');
       $date1 = strtotime("7 February 2008"); 
       $date2 = strtotime("8 February 2008"); 

if($date2 > $date1){ 
    $sql = $connectSQL->query("SELECT name, description, genre_id, photo FROM event WHERE id=$Eid");

while($row= mysqli_fetch_array($sql,MYSQLI_ASSOC)){
                $events[] = $row;
                }
foreach ($events as $one){
    echo $one['name'];
    echo $one['description'];
    echo $one['genre_id'];
    echo $one['photo'];
    }
}

   }
   else
  echo" no events in the future ";
   }
mysqli_close($connectSQL);

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。