数据库连接和检索到PHP - Databases are join and retrieve to the PHP

Databases are join and retrieve to the PHP

本文关键字：PHP 检索数据库连接 | 更新日期: 2023-09-27

我想从item表中检索item名称，这等于inventory表中的项目编号，而库存其他详细信息则直接填充。但是它跑不动。我如何纠正这个问题?

<?php include '../../config/Database.php';
 $pdo = Database::connect();
 $sql = 'SELECT * FROM `tbl_inventory`';
 $sql2 = 'SELECT tbl_item.item_name FROM tbl_item,tbl_inventory 
          WHERE tbl_inventory.tbl_item_item_ID = tbl_item.item_ID';
    foreach ($pdo->query($sql) as $row) {
        echo '<tr>';
        echo '<td>' . $row['tbl_item_item_ID'] . '</td>';
        foreach ($pdo->query($sql2) as $row1) {
            echo '<td>' . $row1['item_name'] . '</td>';
        }
        echo '<td>' . $row['qty'] . '</td>';
        echo '</tr>';
    }
    Database::disconnect();
?>

尝试将行sql2替换为我的sql2:

$sql2 = 'SELECT tbl_item.item_name as item_name FROM tbl_item,tbl_inventory WHERE tbl_inventory.tbl_item_item_ID = tbl_item.item_ID';

你必须修改$sql2字符串，当你使用select语句时，你所写的将成为结果数组关联数组名称tbl_item.item_name，但你试图获得item_name，不会出现在结果数组中，所以你不会得到任何结果。给别名tbl_item。

item_name to item_name using 作为关键字