{"id":212,"date":"2025-05-26T06:56:23","date_gmt":"2025-05-26T06:56:23","guid":{"rendered":"https:\/\/teknovista.id\/?p=212"},"modified":"2026-10-13T10:39:19","modified_gmt":"2026-10-13T03:39:19","slug":"membuat-storeprocedure-di-mysql-dan-memanggil-storeprocedure-dengan-codeigniter-4-untuk-memanggil-data-join-table","status":"publish","type":"post","link":"https:\/\/teknovista.id\/en\/membuat-storeprocedure-di-mysql-dan-memanggil-storeprocedure-dengan-codeigniter-4-untuk-memanggil-data-join-table\/","title":{"rendered":"Menggunakan StoreProcedure untuk perintah SELECT Multiple Table dengan MySQL dan CodeIgniter 4"},"content":{"rendered":"<p class=\"wp-block-paragraph\">Kita ketahui bersama bahwa <strong>MySQL Function<\/strong> <em>tidak bisa<\/em> secara langsung melakukan query <code>SELECT ... JOIN<\/code> lalu mengembalikan hasil banyak baris. Fungsi hanya bisa mengembalikan <strong>satu nilai (scalar)<\/strong>, bukan satu set hasil (result set). <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Jika kamu ingin mengembalikan banyak baris dari query join, kamu perlu memakai <strong>Stored Procedure<\/strong> atau melakukan query langsung di aplikasi kamu (PHP, Python, dsb.).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tetapi jika kamu hanya ingin, misalnya, mengambil <strong>satu nilai<\/strong> dari hasil join (misalnya: nama pelanggan dari tabel <code>customers<\/code> berdasarkan <code>id_order<\/code> dari tabel <code>orders<\/code>), maka kita bisa buat seperti ini.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>","protected":false},"excerpt":{"rendered":"<p>Kita ketahui bersama bahwa MySQL Function tidak bisa secara langsung melakukan query SELECT &#8230; JOIN lalu mengembalikan hasil banyak baris. Fungsi hanya bisa mengembalikan satu nilai (scalar), bukan satu set hasil (result set). Jika kamu ingin mengembalikan banyak baris dari query join, kamu perlu memakai Stored Procedure atau melakukan query langsung di aplikasi kamu (PHP, [&hellip;]<\/p>\n<\/p><div class=\"more-link\"><a href=\"https:\/\/teknovista.id\/en\/membuat-storeprocedure-di-mysql-dan-memanggil-storeprocedure-dengan-codeigniter-4-untuk-memanggil-data-join-table\/\" class=\"btn btn-small btn--dark btn-hover-shadow\"><span class=\"text\">Continue Reading<\/span><i class=\"seoicon-right-arrow\"><\/i><\/a><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,5],"tags":[],"class_list":["post-212","post","type-post","status-publish","format-standard","hentry","category-blog","category-mysql-php-tips"],"_links":{"self":[{"href":"https:\/\/teknovista.id\/en\/wp-json\/wp\/v2\/posts\/212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teknovista.id\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teknovista.id\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teknovista.id\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/teknovista.id\/en\/wp-json\/wp\/v2\/comments?post=212"}],"version-history":[{"count":4,"href":"https:\/\/teknovista.id\/en\/wp-json\/wp\/v2\/posts\/212\/revisions"}],"predecessor-version":[{"id":219,"href":"https:\/\/teknovista.id\/en\/wp-json\/wp\/v2\/posts\/212\/revisions\/219"}],"wp:attachment":[{"href":"https:\/\/teknovista.id\/en\/wp-json\/wp\/v2\/media?parent=212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teknovista.id\/en\/wp-json\/wp\/v2\/categories?post=212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teknovista.id\/en\/wp-json\/wp\/v2\/tags?post=212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}