問題描述

我的數(shù)據(jù)庫有一個(gè)名為 tblprojects 的表，其列名稱為 project_num、project_status、project_name.我想使用foreach循環(huán)從數(shù)據(jù)庫中獲取數(shù)據(jù)并在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.

但是我無法使用以下代碼顯示記錄.請幫我改正.剛開始使用 PHP.

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

以下是我寫的代碼:

<?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>

請幫我解決問題，回復(fù)更正的代碼(首選).非常感謝.

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

推薦答案

foreach 這里不需要.

<?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
    }
?>

這篇關(guān)于如何使用foreach從數(shù)據(jù)庫表中獲取數(shù)據(jù)——的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！