CODEWITHSUNDEEP
sqlcodeigniterjoin
Adrian
Adrian

Reputation: 3

How to convert SQL Query to CodeIgniter?

How to convert this query :

SELECT pembelian_detail_tb.kode_beli, pembelian_detail_tb.kode_produk, produk_tb.nama, pembelian_detail_tb.jumlah
FROM pembelian_detail_tb
INNER JOIN produk_tb ON pembelian_detail_tb.kode_produk = produk_tb.kode_produk;

I have try many code, and i still got undefine.

Upvotes: 0

Views: 45

Answers (2)

ponytails_soda
ponytails_soda

Reputation: 95

I like to use Query Bindings once a join is involved in a query:

https://www.codeigniter.com/userguide3/database/queries.html

search page for "query bindings"

this escapes values for you of course and if you need to debug dump $this->db->last_query();

Upvotes: 0

Naim Malek
Naim Malek

Reputation: 1184

Try this

$query = $this->db->select('pembelian_detail_tb.kode_beli, pembelian_detail_tb.kode_produk, produk_tb.nama, pembelian_detail_tb.jumlah')
->from('pembelian_detail_tb')
->join('produk_tb', 'pembelian_detail_tb.kode_produk = produk_tb.kode_produk', 'inner')
->get();

Upvotes: 1

Related Questions