处理sql查询结果 - process sql query results

process sql query results

本文关键字：结果查询 sql 处理 | 更新日期: 2023-09-27

我得到了一个名为">Serials"的表，其中包含5个组件序列号、代码、名称、已兑换、已兑换日期

我正在使用以下查询从该表中选择一些字段：

$query = "SELECT `Name`,`Redeemed`,`Redeem_date` FROM `Serials` WHERE `Serial` = '$serial' AND `Code` = '$code'";
$db->setQuery($query);
$db->query();

但是我不知道如何在下面的变量中传递这些值，所以我可以在以后的if语句中使用它们

$name= //retured value from column Name
$redeemed= //retured value from column Redeemed
$redeem_date= //retured value from column Redeem_date

就像这样。。

// Your query here..
$query = "SELECT `Name`,`Redeemed`,`Redeem_date` FROM `Serials` WHERE `Serial` = '$serial' AND `Code` = '$code'";
$db->setQuery($query);
$results = $db->query();
//fetch data and stored into variables
while($row = fetch_array($results)){
  $name = $row['Name'];
  $redeemed = $row['Redeemed'];
  $redeem_date = $row['Redeem_date'];
}

试试这样的东西：

<?php
$result = $db->query("SELECT `Name`,`Redeemed`,`Redeem_date` FROM `Serials` WHERE `Serial` = '$serial' AND `Code` = '$code'");
while (list($name, $redeemed, $redeem_date) = $result->fetch(PDO::FETCH_NUM)) {
 // DO SOMETHING
}
?>

while ($row = $db->fetch()) {
$name= $row['name'];
$redeemed= $row['redeemed'];
$redeem_date= $row['redeem_date'];
}

这个可能会获取您的结果并分配给vars