How to convert SQL Query to CodeIgniter?

Question

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.

Naim Malek · Accepted Answer · 2017-11-16 13:10:54Z

1

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

answered Nov 16, 2017 at 13:10

Naim Malek

1,1841 gold badge11 silver badges21 bronze badges

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

Comments

ponytails_soda · Accepted Answer · 2017-11-17 04:30:55Z

0

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

answered Nov 17, 2017 at 4:30

ponytails_soda

9510 bronze badges

Collectives™ on Stack Overflow

How to convert SQL Query to CodeIgniter?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related