显示来自多个 MySQL 表的数据 [英] Displaying Data From Multiple MySQL Tables

问题描述

我在显示数据库中的数据时遇到了一个小问题...

我有两个数据库表:

• 类别(cat_id，cat_name)
• menu_items(menu_id, menu_name, cat_id, menu_description, menu_price)

<小时>

我想将数据显示为:

类别 1 名称

• cat_id = 1, menu_name, menu_description, menu_price
• cat_id = 1, menu_name, menu_description, menu_price
• cat_id = 1, ...

类别 2 名称

• cat_id = 2、menu_name、menu_description、menu_price
• cat_id = 2、menu_name、menu_description、menu_price
• cat_id = 2, ...

类别 3 名称

• cat_id = 3、menu_name、menu_description、menu_price
• cat_id = 3、menu_name、menu_description、menu_price
• cat_id = 3, ....

...

<小时>

我的代码:

function get_menu_items() {//查询数据库以获取类别列表$conn = db_connect();$query = "从类别中选择 cat_id, cat_name";$result = @$conn->query($query);如果(！$结果){返回假；}$num_cats = @$result->num_rows;如果($num_cats == 0){返回假；}$result = db_result_to_array($result);返回 $result;}功能 display_menu_items($menu_array) {如果(！is_array($menu_array)){echo "
当前没有可用的菜单项
";返回;}foreach ($menu_array 作为 $row) {echo "<section id='".$row['cat_name']."'>";echo "
";echo "<h3>".$row['cat_name']."</h3>";***/* 问题 */***echo "
";foreach... {echo "<li>cat_id = #, menu_name, menu_description, menu_price</li>";}回声</ul>***/* 问题 */***echo "</div>";echo "</section>";}}

<小时>

有什么建议吗?

谢谢.

解决方案

catRecordset = select * from CategoriescatRecordset 中的 foreach 猫{打印(猫名)；menuRecordset = select * from menu where menyu.cat_id = cat.cat_idforeach( menuRecordSet 中的 menuItem ){打印(菜单项.无论什么)；}}

I'm having a little problem displaying data from a database...

I have two database tables:

• categories(cat_id, cat_name)
• menu_items(menu_id, menu_name, cat_id, menu_description, menu_price)

---

I would like to display data as:

Categorie 1 Name

• cat_id = 1, menu_name, menu_description, menu_price
• cat_id = 1, menu_name, menu_description, menu_price
• cat_id = 1, ...

Categorie 2 Name

• cat_id = 2, menu_name, menu_description, menu_price
• cat_id = 2, menu_name, menu_description, menu_price
• cat_id = 2, ...

Categorie 3 Name

• cat_id = 3, menu_name, menu_description, menu_price
• cat_id = 3, menu_name, menu_description, menu_price
• cat_id = 3, ....

...

---

My code:

function get_menu_items() {
       // query database for a list of categories
       $conn = db_connect();
       $query = "select cat_id, cat_name from categories";
       $result = @$conn->query($query);
       if (!$result) {
         return false;
       }
       $num_cats = @$result->num_rows;
       if ($num_cats == 0) {
          return false;
       }
       $result = db_result_to_array($result);
       return $result;
    }


function display_menu_items($menu_array) {
  if (!is_array($menu_array)) {
     echo "<p>No menu items currently available</p>";
     return;
  }
  foreach ($menu_array as $row)  {
    echo "<section id='".$row['cat_name']."'>";
    echo "<div class='group course'>";
    echo "<h3>".$row['cat_name']."</h3>";

    ***/* Problem */***

     echo "<ul>";
foreach... {
    echo "<li>cat_id = #, menu_name, menu_description, menu_price</li>";
    }
    echo "</ul>

    ***/* Problem */***

    echo "</div>";
    echo "</section>";
  }
}

---

Any suggestions?

Thanks.

解决方案

catRecordset = select * from categories
foreach cat in catRecordset
{
    print( cat.name );  
    menuRecordset = select * from menu where menyu.cat_id = cat.cat_id
    foreach( menuItem in menuRecordSet )
    {
        print( menuItem.whatever );
    }
}

这篇关于显示来自多个 MySQL 表的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！