如何使用foreach从数据库表中获取数据 - [英] How to use foreach get data from the database table --

问题描述

我的数据库有一个名为 tblprojects 的表，列名称为 project_num，project_status，project_name 。我想使用foreach循环从数据库中获取数据，并显示在php表中的记录。

但是我无法用下面的代码显示记录。请帮我纠正它。

以下是我写的代码：

 <？php 
 $ projects = array（）; 
 //从数据库中获取数据
 $ records = mysql_query（'select project_num，project_status，project_name from tblprojects'）或者die（Query fail：。mysqli_error（））; 
？> 
 
 
< table class =table table-striped table-condensedid =tblData> 
< thead> 
< tr> 
< th>项目名称< / th> 
< th>项目编号< / th> 
< th>项目状态< / th> 
< / tr> 
< / thead> 
 
< tbody> 
 <？php 
 while（$ row = mysql_fetch_assoc（$ records））
 {
 $ projects [] = $ row; 
 foreach（$ projects为$ project）：
？> 
< tr> 
< td><？echo $ project ['proj_name']; ？>< / TD> 
< td><？echo $ proj ['proj_num']; ？>< / TD> 
< td><？echo $ proj ['proj_status']; ？>< / TD> 
< / tr> 
 
<？php endforeach; 
} 
？> 
 
 
< / tbody> 
< / table> 
  

请帮我解决问题，回复正确的代码（首选）。非常感谢。

解决方案 这里不需要。

 <？php 
 $ projects = array（）; 
 while（$ project = mysql_fetch_assoc（$ records））
 {
 $ projects [] = $ project; 
} 
 foreach（$ projects as $ project）
 {
？> 
< tr> 
< td><？php echo $ project ['proj_name']; ？>< / TD> 
< td><？php echo $ project ['proj_num']; ？>< / TD> 
< td><？php echo $ project ['proj_status']; ？>< / TD> 
< / tr> 
<？php 
} 
？> 
  

My database has a table called tblprojects with column names say, project_num, project_status, project_name. I want to use foreach loop to get the data from the database and display the records in php table.

However I am unable to display the records with following code. Please help me in correcting it. Am new to using PHP.

Following is the code I have written:

<?php
     $projects = array();
     // fetch data from the database
     $records = mysql_query('select project_num, project_status, project_name from tblprojects') or die("Query fail: " . mysqli_error());
?>


<table  class="table table-striped table-condensed" id="tblData">
    <thead>
        <tr>
            <th>Project Name</th>
            <th>Project Number</th>
            <th>Project Status</th>
       </tr>
    </thead>

    <tbody>
       <?php 
            while (  $row =  mysql_fetch_assoc($records)    )
            {
                $projects[] = $row;
                foreach ($projects as $project):
      ?>
        <tr>
            <td><?echo $project['proj_name']; ?></td>
            <td><?echo $proj['proj_num']; ?></td>
            <td><?echo $proj['proj_status']; ?></td>
        </tr>

      <?php endforeach; 
           }
      ?>


    </tbody>        
</table>

Please help me in solving the problem,reply with corrected code ( preferred ). Thanks a lot in advance.

解决方案

The foreach not needed here.

<?php 
    $projects = array();
    while ($project =  mysql_fetch_assoc($records))
    {
        $projects[] = $project;
    }
    foreach ($projects as $project)
    {
?>
    <tr>
        <td><?php echo $project['proj_name']; ?></td>
        <td><?php echo $project['proj_num']; ?></td>
        <td><?php echo $project['proj_status']; ?></td>
    </tr>
<?php
    }
?>

这篇关于如何使用foreach从数据库表中获取数据 - 的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！