How to translate this php query into mysql?

Question

Trying to use this query to get the data using the 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();

I was thinking something like this

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

Please post the result of your MySQL query and tell us what you are trying to achieve — Jesuisme
– Jesuisme, Commented Mar 17, 2019 at 5:21
I was just trying to use the same query the php is using to get the same result using navicat or mysql — Jane Doe
– Jane Doe, Commented Mar 17, 2019 at 5:51

Satish Saini · Accepted Answer · 2019-03-17 04:57:30Z

1

Try this:

$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();

converts to

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

You can use this SELECT query in your PHP code and pass $id dynamically.

answered Mar 17, 2019 at 4:57

Satish Saini

2,9783 gold badges27 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to translate this php query into mysql?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related