{"id":507,"date":"2019-09-16T12:22:30","date_gmt":"2019-09-16T12:22:30","guid":{"rendered":"https:\/\/www.webhozz.com\/code\/?p=507"},"modified":"2019-09-16T12:25:08","modified_gmt":"2019-09-16T12:25:08","slug":"php-query-mysql-insert","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/code\/php-query-mysql-insert\/","title":{"rendered":"PHP MySQL : Insert"},"content":{"rendered":"\n
Memasukkan Data ke Tabel Database MySQL<\/h5>\n\n\n\n

Sekarang kalian sudah mengerti cara membuat database dan\ntabel di MySQL. Dalam tutorial ini kalian akan belajar bagaimana cara\nmenjalankan query SQL untuk memasukkan catatan ke dalam tabel.<\/p>\n\n\n\n

Pernyataan INSERT INTO<\/em>\ndigunakan untuk menyisipkan baris baru dalam tabel database.<\/p>\n\n\n\n

Mari kita membuat query SQL menggunakan pernyataan INSERT INTO<\/em> dengan nilai-nilai yang sesuai, setelah itu kita akan menjalankan query insert ini dengan mengirimkannya ke fungsi PHP mysqli_query()<\/em><\/strong> untuk memasukkan data dalam tabel. Berikut ini contoh, yang menyisipkan baris baru ke tabel persons <\/em>dengan menentukan nilai untuk bidang first_name<\/em>, last_name<\/em>, dan email<\/em>.<\/p>\n\n\n

\n<?php\n\/* Attempt MySQL server connection. Assuming you are running MySQL\nserver with default setting (user 'root' with no password) *\/\n$link = mysqli_connect("localhost", "root", "", "demo");\n \n\/\/ Check connection\nif($link === false){\n    die("ERROR: Could not connect. " . mysqli_connect_error());\n}\n \n\/\/ Attempt insert query execution\n$sql = "INSERT INTO persons (first_name, last_name, email) VALUES ('Peter', 'Parker', 'peterparker@mail.com')";\nif(mysqli_query($link, $sql)){\n    echo "Records inserted successfully.";\n} else{\n    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);\n}\n \n\/\/ Close connection\nmysqli_close($link);\n?>\n<\/pre><\/div>\n\n\n
Jika kalian ingat dari bab sebelumnya, bidang id <\/em>ditandai dengan label AUTO_INCREMENT<\/em><\/strong>. Pengubah ini memberi tahu MySQL untuk secara otomatis memberikan nilai pada bidang ini jika nilai pada bidang ini belum kita tentukan, dengan menambah nilai sebelumnya sebesar 1.<\/p>\n\n\n\n
Memasukkan Banyak Baris ke dalam Tabel<\/h5>\n\n\n\n
Kalian juga bisa menyisipkan banyak baris ke tabel dengan\nhanya satu query saja untuk memasukkannya sekaligus. Untuk melakukan ini,\nsertakan beberapa daftar nilai kolom dalam pernyataan INSERT INTO<\/em><\/strong>, di mana\nnilai kolom untuk setiap baris harus dimasukkan dalam tanda kurung dan\ndipisahkan dengan koma.<\/p>\n\n\n\n
Mari kita masukkan beberapa baris lagi ke tabel persons<\/em>, seperti ini:<\/p>\n\n\n
\n<?php\n\/* Attempt MySQL server connection. Assuming you are running MySQL\nserver with default setting (user 'root' with no password) *\/\n$link = mysqli_connect("localhost", "root", "", "demo");\n \n\/\/ Check connection\nif($link === false){\n    die("ERROR: Could not connect. " . mysqli_connect_error());\n}\n \n\/\/ Attempt insert query execution\n$sql = "INSERT INTO persons (first_name, last_name, email) VALUES\n            ('John', 'Rambo', 'johnrambo@mail.com'),\n            ('Clark', 'Kent', 'clarkkent@mail.com'),\n            ('John', 'Carter', 'johncarter@mail.com'),\n            ('Harry', 'Potter', 'harrypotter@mail.com')";\nif(mysqli_query($link, $sql)){\n    echo "Records added successfully.";\n} else{\n    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);\n}\n \n\/\/ Close connection\nmysqli_close($link);\n?>\n<\/pre><\/div>\n\n\n
Sekarang, buka phpMyAdmin ( http:\/\/localhost\/phpmyadmin\/<\/a><\/em><\/strong> ) dan periksa data tabel persons<\/em> di dalam basis data demo<\/em>. kalian akan menemukan nilai untuk kolom id<\/em> ditugaskan secara otomatis dengan menambah nilai id<\/em> sebelumnya dengan 1.<\/p>\n\n\n\n
Catatan:<\/em><\/strong> Sejumlah jeda baris dapat terjadi dalam pernyataan SQL, asalkan setiap jeda baris tidak memutuskan kata kunci, nilai, expression, dll.<\/p>\n\n\n\n
Langkah 1: Membuat Form HTML <\/h5>\n\n\n\n
Berikut ini merupakan formulir HTML sederhana yang memiliki tiga bidang teks <input><\/em><\/strong> dan tombol submit.<\/p>\n\n\n
\n<!DOCTYPE html>\n<html lang="en">\n<head>\n<meta charset="UTF-8">\n<title>Add Record Form<\/title>\n<\/head>\n<body>\n<form action="insert.php" method="post">\n    <p>\n        <label for="firstName">First Name:<\/label>\n        <input type="text" name="first_name" id="firstName">\n    <\/p>\n    <p>\n        <label for="lastName">Last Name:<\/label>\n        <input type="text" name="last_name" id="lastName">\n    <\/p>\n    <p>\n        <label for="emailAddress">Email Address:<\/label>\n        <input type="text" name="email" id="emailAddress">\n    <\/p>\n    <input type="submit" value="Submit">\n<\/form>\n<\/body>\n<\/html>\n<\/pre><\/div>\n\n\n
Langkah 2: Mengambil dan Memasukkan Form Data<\/h5>\n\n\n\n
Ketika seorang pengguna mengklik tombol kirim (submit) dari form add record HTML, pada contoh di atas, form data dikirim ke file ‘insert.php’<\/em><\/strong>. File ‘insert.php’<\/em><\/strong> terhubung ke server database MySQL, mengambil bidang formulir menggunakan variabel PHP $_REQUEST<\/em><\/strong> dan akhirnya menjalankan permintaan memasukkan untuk menambahkan catatan. Berikut adalah kode lengkap file ‘insert.php’ <\/em><\/strong>kita:<\/p>\n\n\n
\n<?php\n\/* Attempt MySQL server connection. Assuming you are running MySQL\nserver with default setting (user 'root' with no password) *\/\n$link = mysqli_connect("localhost", "root", "", "demo");\n \n\/\/ Check connection\nif($link === false){\n    die("ERROR: Could not connect. " . mysqli_connect_error());\n}\n \n\/\/ Escape user inputs for security\n$first_name = mysqli_real_escape_string($link, $_REQUEST['first_name']);\n$last_name = mysqli_real_escape_string($link, $_REQUEST['last_name']);\n$email = mysqli_real_escape_string($link, $_REQUEST['email']);\n \n\/\/ Attempt insert query execution\n$sql = "INSERT INTO persons (first_name, last_name, email) VALUES ('$first_name', '$last_name', '$email')";\nif(mysqli_query($link, $sql)){\n    echo "Records added successfully.";\n} else{\n    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);\n}\n \n\/\/ Close connection\nmysqli_close($link);\n?>\n<\/pre><\/div>\n\n\n
Dalam bab selanjutnya, kita akan memperluas contoh insert query ini dan melangkah lebih jauh dengan mengimplementasikan pernyataan yang disiapkan untuk keamanan dan kinerja yang lebih baik.<\/p>\n\n\n\n
Catatan:<\/em><\/strong> Fungsi mysqli_real_escape_string()<\/em><\/strong> lolos dari karakter khusus dalam string dan membuat string SQL legal untuk memberikan keamanan terhadap injeksi SQL.<\/p>\n\n\n\n
Ini adalah contoh yang sangat mendasar dari memasukkan data\nformulir dalam tabel database MySQL. Kalian dapat memperluas contoh ini dan\nmembuatnya lebih interaktif dengan menambahkan validasi ke input pengguna\nsebelum memasukkannya ke tabel database. Silakan periksa tutorial tentang\nvalidasi formulir PHP untuk mempelajari lebih lanjut tentang sanitizing dan validating\nuser input menggunakan PHP.<\/p>\n","protected":false},"excerpt":{"rendered":"
Memasukkan Data ke Tabel Database MySQL Sekarang kalian sudah mengerti cara membuat database dan tabel di MySQL. Dalam tutorial ini kalian akan belajar bagaimana cara<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-507","post","type-post","status-publish","format-standard","hentry","category-php"],"yoast_head":"\nBelajar PHP MySQL : Insert - WebHozz Code<\/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\/code\/php-query-mysql-insert\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Belajar PHP MySQL : Insert - WebHozz Code\" \/>\n<meta property=\"og:description\" content=\"Memasukkan Data ke Tabel Database MySQL Sekarang kalian sudah mengerti cara membuat database dan tabel di MySQL. Dalam tutorial ini kalian akan belajar bagaimana cara\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/code\/php-query-mysql-insert\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Code\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-16T12:22:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-09-16T12:25:08+00:00\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-query-mysql-insert\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-query-mysql-insert\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#\\\/schema\\\/person\\\/3b2b79dc317236b0dde4b1fda37263e1\"},\"headline\":\"PHP MySQL : Insert\",\"datePublished\":\"2019-09-16T12:22:30+00:00\",\"dateModified\":\"2019-09-16T12:25:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-query-mysql-insert\\\/\"},\"wordCount\":437,\"articleSection\":[\"PHP\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-query-mysql-insert\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-query-mysql-insert\\\/\",\"name\":\"Belajar PHP MySQL : Insert - WebHozz Code\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#website\"},\"datePublished\":\"2019-09-16T12:22:30+00:00\",\"dateModified\":\"2019-09-16T12:25:08+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#\\\/schema\\\/person\\\/3b2b79dc317236b0dde4b1fda37263e1\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-query-mysql-insert\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-query-mysql-insert\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/php-query-mysql-insert\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP MySQL : Insert\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#website\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/\",\"name\":\"WebHozz Code\",\"description\":\"Tutorial Web & Pemrograman Indonesia\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/#\\\/schema\\\/person\\\/3b2b79dc317236b0dde4b1fda37263e1\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/www.webhozz.com\\\/code\\\/author\\\/dody\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Belajar PHP MySQL : Insert - WebHozz Code","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\/code\/php-query-mysql-insert\/","og_locale":"en_US","og_type":"article","og_title":"Belajar PHP MySQL : Insert - WebHozz Code","og_description":"Memasukkan Data ke Tabel Database MySQL Sekarang kalian sudah mengerti cara membuat database dan tabel di MySQL. Dalam tutorial ini kalian akan belajar bagaimana cara","og_url":"https:\/\/www.webhozz.com\/code\/php-query-mysql-insert\/","og_site_name":"WebHozz Code","article_published_time":"2019-09-16T12:22:30+00:00","article_modified_time":"2019-09-16T12:25:08+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhozz.com\/code\/php-query-mysql-insert\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/code\/php-query-mysql-insert\/"},"author":{"name":"admin","@id":"https:\/\/www.webhozz.com\/code\/#\/schema\/person\/3b2b79dc317236b0dde4b1fda37263e1"},"headline":"PHP MySQL : Insert","datePublished":"2019-09-16T12:22:30+00:00","dateModified":"2019-09-16T12:25:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/code\/php-query-mysql-insert\/"},"wordCount":437,"articleSection":["PHP"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/code\/php-query-mysql-insert\/","url":"https:\/\/www.webhozz.com\/code\/php-query-mysql-insert\/","name":"Belajar PHP MySQL : Insert - WebHozz Code","isPartOf":{"@id":"https:\/\/www.webhozz.com\/code\/#website"},"datePublished":"2019-09-16T12:22:30+00:00","dateModified":"2019-09-16T12:25:08+00:00","author":{"@id":"https:\/\/www.webhozz.com\/code\/#\/schema\/person\/3b2b79dc317236b0dde4b1fda37263e1"},"breadcrumb":{"@id":"https:\/\/www.webhozz.com\/code\/php-query-mysql-insert\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/code\/php-query-mysql-insert\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhozz.com\/code\/php-query-mysql-insert\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/code\/"},{"@type":"ListItem","position":2,"name":"PHP MySQL : Insert"}]},{"@type":"WebSite","@id":"https:\/\/www.webhozz.com\/code\/#website","url":"https:\/\/www.webhozz.com\/code\/","name":"WebHozz Code","description":"Tutorial Web & Pemrograman Indonesia","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhozz.com\/code\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.webhozz.com\/code\/#\/schema\/person\/3b2b79dc317236b0dde4b1fda37263e1","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f222cb0ed38f2100d666bb262fd38d4f0d8e5673698208e40ff83118f10a4e8e?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/www.webhozz.com\/code\/author\/dody\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts\/507","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/comments?post=507"}],"version-history":[{"count":2,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts\/507\/revisions"}],"predecessor-version":[{"id":510,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/posts\/507\/revisions\/510"}],"wp:attachment":[{"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/media?parent=507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/categories?post=507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/code\/wp-json\/wp\/v2\/tags?post=507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}