php – 从变量打印mysql查询结果

发布时间：2020-12-13 16:35:00 所属栏目：PHP教程来源：网络整理

导读：所以我早些时候写了(在 PHP中),但是每次我尝试echo $test“,我只是得到资源id 5.有没有人知道如何从变量中实际打印出mysql查询？ $dave= mysql_query("SELECT order_date,no_of_items,shipping_charge,SUM(total_order_amount) as test FROM `orders` WHERE

所以我早些时候写了(在 PHP中),但是每次我尝试echo $test“,我只是得到资源id 5.有没有人知道如何从变量中实际打印出mysql查询？

$dave= mysql_query("SELECT order_date,no_of_items,shipping_charge,SUM(total_order_amount) as test FROM `orders` WHERE DATE(`order_date`) = DATE(NOW()) GROUP BY DATE(`order_date`)") or die(mysql_error());
print $dave;

这将打印出查询：

$query = "SELECT order_date,SUM(total_order_amount) as test FROM `orders` WHERE DATE(`order_date`) = DATE(NOW()) GROUP BY DATE(`order_date`)";

$dave= mysql_query($query) or die(mysql_error());
print $query;

这将打印出结果：

$query = "SELECT order_date,SUM(total_order_amount) as test FROM `orders` WHERE DATE(`order_date`) = DATE(NOW()) GROUP BY DATE(`order_date`)";

$dave= mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_assoc($dave)){
    foreach($row as $cname => $cvalue){
        print "$cname: $cvaluet";
    }
    print "rn";
}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!