mysql select 1 gt 2,如何将Codeigniter预格式化查询转换为原始Mysql查询（例如$ this-> db-> select（'table1。*，table2。*...

I have a website which is using a CodeIgniter framework and almost using CodeIgniter's preformatted query class in every request to process data from database built by my ex coworker.

One of the example is like this:

function tampilkan_data(){

$this->db->select('barang.*,barang_keluar.*,barang_masuk.*');

$this->db->from('barang');

$this->db->join('barang_keluar', 'barang.id_barang=barang_keluar.id_barang','left');

$this->db->join('barang_masuk', 'barang.id_barang=barang_masuk.id_barang','left');

$this->db->order_by('barang.id_barang','asc');

$this->db->order_by('barang.kode_barang','asc');

$this->db->where('barang.status','0');

return $query = $this->db->get()->result();

}

I want to change the result from that query, but in order to understand it first I have to translate it into an original MySQL query. Attempted to do this:

SELECT `barang`.*, `barang_keluar`.*, `barang_masuk`.*

FROM `barang` AS A

LEFT JOIN `barang_keluar` AS B ON A.id_barang = B.id_barang

LEFT JOIN `barang_masuk` AS C ON A.id_barang = C.id_barang

ORDER BY A.id_barang ASC, A.kode_barang ASC

WHERE A.status = 0

But I got this error

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE A.status = 0 LIMIT 0, 25' at line 6

I tried to remove the WHERE A.status = 0 to see which is wrong from my code the I got this error

1051 - Unknown table 'barang'

I thought the problem is in the line SELECT barang.*, barang_keluar.*, barang_masuk.*, because I didn't really know how to write it in an MySQL original formatted.

I already searched for this topic and I even tried to write the query straight to the search bar but I didn't find the right approach according to my case.

Hope someone can help

解决方案

You can simply print your query, Then you can see your query in original sql format.

function tampilkan_data(){

$this->db->select('barang.*,barang_keluar.*,barang_masuk.*');

$this->db->from('barang');

$this->db->join('barang_keluar', 'barang.id_barang=barang_keluar.id_barang','left');

$this->db->join('barang_masuk', 'barang.id_barang=barang_masuk.id_barang','left');

$this->db->order_by('barang.id_barang','asc');

$this->db->order_by('barang.kode_barang','asc');

$this->db->where('barang.status','0');

$query = $this->db->get()->result(); // notice that i have removed the return keyword

echo $this->db->last_query(); // This will print your query directly on the screen.

}

But the error which you are getting is -> You don't have a table named barang.

Make sure that the table exists.

Hope It Helps...