php - 如何将这个php查询翻译成mysql？

Question

尝试使用此查询来使用 mysql 获取数据

$this->db->select("ii.id,oi.user_id as uid,oi.id as oid")->from("order_info oi")->join("iform_info ii","oi.id = ii.order_id")->where("oi.order_no",$id)->get()->row_array();

我在想这样的事情

SELECT * FROM `order_info` JOIN(iform_info) WHERE `order_id` = '1'

Answer 1

试试这个:

$this->db->select("ii.id,oi.user_id as uid,oi.id as oid")->from("order_info oi")->join("iform_info ii","oi.id = ii.order_id")->where("oi.order_no",$id)->get()->row_array();

转换为

SELECT ii.id, oi.user_id as uid, oi.id as oid
FROM order_info oi JOIN iform_info ii ON oi.id = ii.order_id 
WHERE oi.order_no = $id

您可以在 PHP 代码中使用此 SELECT 查询并动态传递 $id。