时间戳

首页 > 解决方案 > 带有准备好的语句返回布尔值的 mysqli 子查询

php - 带有准备好的语句返回布尔值的 mysqli 子查询

问题描述

所以我准备了一个已经在 mysql 中工作的查询（在 phpmyadmin 中测试），但是我在使用 mysqli 类获取结果时遇到问题，而且没有得到结果真的很奇怪，因为我相信查询是正确的。任何人都可以在以下代码中指出我的错误。

<?php

include_once __DIR__ . '/includes/init.php';

$sql = 'SELECT 
                    `purchase_order`.`id`, 
                    `purchase_order`.`po_date` AS po_date, 
                    `purchase_order`.`po_number`, 
                    `purchase_order`.`customer_id` AS customer_id , 
                    `customer`.`name` AS customer_name, 
                    `purchase_order`.`status` AS po_status, 
                    `purchase_order_items`.`product_id`, 
                    `purchase_order_items`.`po_item_name`, 
                    `product`.`weight` as product_weight,
                    `product`.`pending` as product_pending,
                    `product`.`company_owner` as company_owner,
                    `purchase_order_items`.`uom`, 
                    `purchase_order_items`.`po_item_type`, 
                    `purchase_order_items`.`order_sequence`, 
                    `purchase_order_items`.`pending_balance`, 
                    `purchase_order_items`.`quantity`, 
                    `purchase_order_items`.`notes`, 
                    `purchase_order_items`.`status` AS po_item_status,
                    `purchase_order_items`.`id` AS po_item_id
                  FROM (SELECT id, po_date, po_number, customer_id, status
            FROM purchase_order  GROUP BY  id   DESC  LIMIT ?, ? ) as purchase_order  
                  INNER JOIN customer ON `customer`.`id` = `purchase_order`.`customer_id`  
                  INNER JOIN purchase_order_items ON `purchase_order_items`.`po_id` = `purchase_order`.`id` 
                  INNER JOIN product ON `purchase_order_items`.`product_id` = `product`.`id` 
                   GROUP BY  id';

$mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$statement = $mysqli->prepare($sql);
$statement->execute();
$offset = 0;
$perpage = 10;
$statement->bind_param('ii', $offset, $perpage);
$result = $statement->get_result();
while ($row = $result->fetch_assoc())
{
    echo '<pre>';
    print_r($row);
    echo '</pre>';
}

提前致谢。

标签： phpmysqlmysqli

解决方案

您准备/绑定和执行语句和值的顺序不正确...

$statement = $mysqli->prepare($sql);
$offset = 0;
$perpage = 10;
$statement->bind_param('ii', $offset, $perpage);
$statement->execute();

您需要bind_param()在 the 之前使用，execute()以便它知道要使用的值。

推荐阅读