{"id":711,"date":"2014-06-09T12:47:19","date_gmt":"2014-06-09T12:47:19","guid":{"rendered":"http:\/\/www.webhozz.com\/blog\/?p=711"},"modified":"2019-07-03T13:48:44","modified_gmt":"2019-07-03T13:48:44","slug":"insert-data-ke-dalam-2-table-dalam-satu-waktu","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/","title":{"rendered":"Insert data ke dalam 2 table dengan PHP"},"content":{"rendered":"<p><a href=\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/06\/Php-Development.gif\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-712\" src=\"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/06\/Php-Development.gif\" alt=\"Php-Development\" width=\"920\" height=\"350\" \/><\/a><br \/>\nAda banyak cara untuk menyimpan data kedalam dua tabel atau lebih dalam sekali proses atau hanya dengan satu statement.\u00a0 biasanya para programmer mencari solusinya dengan menggunakan cara trigger, yaitu trigger bersamaan dengan perintah insert akan melakukan query ke tabel lain dan mengembalikan nilai logik yang membantu membatasi data yang diberikan kepada kolom tertentu.<!--more--><\/p>\n<p>Namun dalam perkembangannya, Insert Statement saat ini memiliki sub-klausa OUTPUT. dengan memanfaatkan sub-klausa OUTPUT tersebut kita dapat membuat 1 buah statement insert yang dapat melakukan insert data ke 2 buah tabel sekaligus.<br \/>\n<span id=\"more-328\"><\/span><\/p>\n<p>Misalkan kita mempunyai 2 tabel yaitu tabel pendaftaran dengan nama <strong>TPendaftaran <\/strong>dan tabel detail pendaftaran dengan nama <strong>TDetailPendaftaran<\/strong>. Tabel TPendaftaran memiliki field No_Pendaftaran, Tgl_Pendaftaran, Nama_Calon dan tabel detail pendaftaran memiliki field No_Pendaftaran,Kode_Jurusan,rata_nilai_un.<\/p>\n<p>Dengan 1 statement dibawah ini kita bisa memasukkan (insert) data kedalam tabel TPendaftaran dan TDetailPendaftaran sekaligus tanpa harus membuat trigger. Berikut contohnya:<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\nINSERT INTO TPendaftaran (No_Pendaftaran, Tgl_Pendaftaran, Nama_Calon)\r\nOUTPUT INSERTED.'201406001', '121','8.0'\r\nINTO TDetailPendaftaran (No_Pendaftaran, Kode_Jurusan, rata_nilai_un)\r\nVALUES  ('201406001','24-05-2014','Siti');\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Ada banyak cara untuk menyimpan data kedalam dua tabel atau lebih dalam sekali proses atau hanya dengan satu statement.\u00a0 biasanya para programmer mencari solusinya dengan<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[387,124,15,388,126,125],"class_list":["post-711","post","type-post","status-publish","format-standard","hentry","category-belajar-web-programming","tag-insert-data-ke-dalam-2-table-dalam-satu-waktu","tag-insert-into-2-table","tag-kursus-php","tag-kursus-web-progamming","tag-php","tag-web-progamming"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Insert data ke dalam 2 table dengan PHP - WebHozz Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Insert data ke dalam 2 table dengan PHP - WebHozz Blog\" \/>\n<meta property=\"og:description\" content=\"Ada banyak cara untuk menyimpan data kedalam dua tabel atau lebih dalam sekali proses atau hanya dengan satu statement.\u00a0 biasanya para programmer mencari solusinya dengan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-06-09T12:47:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-03T13:48:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/06\/Php-Development.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"920\" \/>\n\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/insert-data-ke-dalam-2-table-dalam-satu-waktu\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/insert-data-ke-dalam-2-table-dalam-satu-waktu\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/ad1c5822a60b5b228c5ceda20e439fea\"},\"headline\":\"Insert data ke dalam 2 table dengan PHP\",\"datePublished\":\"2014-06-09T12:47:19+00:00\",\"dateModified\":\"2019-07-03T13:48:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/insert-data-ke-dalam-2-table-dalam-satu-waktu\\\/\"},\"wordCount\":178,\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/insert-data-ke-dalam-2-table-dalam-satu-waktu\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/Php-Development.gif\",\"keywords\":[\"Insert data ke dalam 2 table dalam satu waktu\",\"insert into 2 table\",\"kursus php\",\"kursus web progamming\",\"php\",\"web progamming\"],\"articleSection\":[\"Belajar Web Programming\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/insert-data-ke-dalam-2-table-dalam-satu-waktu\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/insert-data-ke-dalam-2-table-dalam-satu-waktu\\\/\",\"name\":\"Insert data ke dalam 2 table dengan PHP - WebHozz Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/insert-data-ke-dalam-2-table-dalam-satu-waktu\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/insert-data-ke-dalam-2-table-dalam-satu-waktu\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/Php-Development.gif\",\"datePublished\":\"2014-06-09T12:47:19+00:00\",\"dateModified\":\"2019-07-03T13:48:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/insert-data-ke-dalam-2-table-dalam-satu-waktu\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/insert-data-ke-dalam-2-table-dalam-satu-waktu\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/insert-data-ke-dalam-2-table-dalam-satu-waktu\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/Php-Development.gif\",\"contentUrl\":\"http:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2014\\\/06\\\/Php-Development.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/insert-data-ke-dalam-2-table-dalam-satu-waktu\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Insert data ke dalam 2 table dengan PHP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\",\"name\":\"WebHozz Blog\",\"description\":\"Kursus Web &amp; Android di Jakarta Bandung\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\",\"name\":\"WebHozz\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/logo-persegi.jpg\",\"contentUrl\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/logo-persegi.jpg\",\"width\":442,\"height\":442,\"caption\":\"WebHozz\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#\\\/schema\\\/person\\\/ad1c5822a60b5b228c5ceda20e439fea\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/author\\\/putralucio\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Insert data ke dalam 2 table dengan PHP - WebHozz Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/","og_locale":"en_US","og_type":"article","og_title":"Insert data ke dalam 2 table dengan PHP - WebHozz Blog","og_description":"Ada banyak cara untuk menyimpan data kedalam dua tabel atau lebih dalam sekali proses atau hanya dengan satu statement.\u00a0 biasanya para programmer mencari solusinya dengan","og_url":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/","og_site_name":"WebHozz Blog","article_published_time":"2014-06-09T12:47:19+00:00","article_modified_time":"2019-07-03T13:48:44+00:00","og_image":[{"width":920,"height":350,"url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/06\/Php-Development.gif","type":"image\/gif"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/"},"author":{"name":"admin","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/ad1c5822a60b5b228c5ceda20e439fea"},"headline":"Insert data ke dalam 2 table dengan PHP","datePublished":"2014-06-09T12:47:19+00:00","dateModified":"2019-07-03T13:48:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/"},"wordCount":178,"publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/#primaryimage"},"thumbnailUrl":"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/06\/Php-Development.gif","keywords":["Insert data ke dalam 2 table dalam satu waktu","insert into 2 table","kursus php","kursus web progamming","php","web progamming"],"articleSection":["Belajar Web Programming"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/","url":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/","name":"Insert data ke dalam 2 table dengan PHP - WebHozz Blog","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/#primaryimage"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/#primaryimage"},"thumbnailUrl":"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/06\/Php-Development.gif","datePublished":"2014-06-09T12:47:19+00:00","dateModified":"2019-07-03T13:48:44+00:00","breadcrumb":{"@id":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/#primaryimage","url":"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/06\/Php-Development.gif","contentUrl":"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/06\/Php-Development.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhozz.com\/blog\/insert-data-ke-dalam-2-table-dalam-satu-waktu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Insert data ke dalam 2 table dengan PHP"}]},{"@type":"WebSite","@id":"https:\/\/www.webhozz.com\/blog\/#website","url":"https:\/\/www.webhozz.com\/blog\/","name":"WebHozz Blog","description":"Kursus Web &amp; Android di Jakarta Bandung","publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhozz.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.webhozz.com\/blog\/#organization","name":"WebHozz","url":"https:\/\/www.webhozz.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/04\/logo-persegi.jpg","contentUrl":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2018\/04\/logo-persegi.jpg","width":442,"height":442,"caption":"WebHozz"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.webhozz.com\/blog\/#\/schema\/person\/ad1c5822a60b5b228c5ceda20e439fea","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/bff35e4083f3870e2f911c4437e788147d340f274268d361dd7e1cf20bebb156?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.webhozz.com\/blog\/author\/putralucio\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/comments?post=711"}],"version-history":[{"count":5,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/711\/revisions"}],"predecessor-version":[{"id":8787,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/711\/revisions\/8787"}],"wp:attachment":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media?parent=711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/categories?post=711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/tags?post=711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}