{"id":888,"date":"2014-07-22T15:22:04","date_gmt":"2014-07-22T15:22:04","guid":{"rendered":"http:\/\/www.webhozz.com\/blog\/?p=888"},"modified":"2014-07-22T15:23:27","modified_gmt":"2014-07-22T15:23:27","slug":"memanipulasi-database-menggunakan-kode-php-mysql","status":"publish","type":"post","link":"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/","title":{"rendered":"Memanipulasi Database Menggunakan Kode PHP MySQL"},"content":{"rendered":"

\"kursus<\/a><\/p>\n

MySQL\u00a0merupakan\u00a0sebuah perangkat lunak sistem manajemen basis data SQL (bahasa Inggris: database management system) atau DBMS yang multithread, multi-user, dengan sekitar 6 juta instalasi di seluruh dunia. MySQL AB membuat MySQL tersedia sebagai perangkat lunak gratis dibawah lisensi GNU General Public License (GPL), tetapi mereka juga menjual dibawah lisensi komersial untuk kasus-kasus dimana penggunaannya tidak cocok dengan penggunaan GPL.\u00a0Setiap pengguna dapat secara bebas menggunakan MySQL, namun dengan batasan perangkat lunak tersebut tidak boleh dijadikan produk turunan yang bersifat komersial. MySQL sebenarnya merupakan turunan salah satu konsep utama dalam basisdata yang telah ada sebelumnya; SQL (Structured Query Language). SQL adalah sebuah konsep pengoperasian basisdata, terutama untuk pemilihan atau seleksi dan pemasukan data, yang memungkinkan pengoperasian data dikerjakan dengan mudah secara otomatis.<\/p>\n

Untuk memanipulasi database, kita bisa menggunakan fungsi-fungsi PHP sebagai berikut:<\/p>\n

    \n
  1. mysql_connect()
    \nDigunakan untuk melakukan koneksi ke server database MySQL.<\/p>\n
    \r\n<?php\r\n$host = \u201clocalhost\u201d;\r\n$user = \u201croot\u201d;\r\n$pass = \u201ccoolabis\u201d;\r\n$connectDB = mysql_connect($host, $user, $pass);\r\necho ($connectDB) ? \u201cKoneksi Berhasil\u201d : \u201cKoneksi gagal\u201d;\r\n?>\r\n<\/pre>\n<\/li>\n
  2. \nmysql_pconnect()
    \nSama seperti mysql_connect(), Fungsi mysql_pconnect() sama-sama digunakan untuk
    \nmelakukan koneksi ke server database MySQL. Perbedaannya, fungsi
    \nmysql_pconnect(), tidak akan terputus meskipun program telah selesai dieksekusi.<\/p>\n
    \r\n<?php\r\n$host = \u201clocalhost\u201d;\r\n$user = \u201croot\u201d;\r\n$pass = \u201ccoolabis\u201d;\r\n$connectDB = mysql_pconnect($host, $user, $pass);\r\necho ($connectDB) ? \u201cKoneksi Berhasil\u201d : \u201cKoneksi gagal\u201d;\r\n?>\r\n<\/pre>\n<\/li>\n
  3. \nmysql_create_db()
    \nDatabase bisa dibuat langsung melalui PHP, fungsi yang digunakan adalah
    \nmysql_create_db().<\/p>\n
    \r\n<?\r\n$host = \u201clocalhost\u201d;\r\n$user = \u201croot\u201d;\r\n$pass = \u201ccoolabis\u201d;\r\nmysql_connect($host, $user, $pass);\r\n$buatDB = mysql_create_db(\u201cmydatabase\u201d);\r\necho ($buatDB) ? \u201cDatabase berhasil dibuat\u201d : \u201cDatabase gagal\r\ndibuat\u201d;\r\n?>\r\n<\/pre>\n<\/li>\n
  4. \nmysql_select_db()
    \nSebelum menggunakan database, anda harus mengaktifkan database tersebut.<\/p>\n
    \r\nmysql_select_db($nama_database, [$pengenal_hub]);\r\n<\/pre>\n<\/li>\n
  5. \nmysql_connect()
    \nDigunakan untuk mengoperasikan perintah-perintah SQL agar
    \ndapat memanipulasi database.<\/p>\n
    \r\n<?php\r\n$host = \u201clocalhost\u201d;\r\n$user = \u201croot\u201d;\r\n$pass = \u201ccoolabis\u201d;\r\n\/\/koneksi ke server\r\nmysql_connect($host, $user, $pass);\r\n\/\/koneksi ke database\r\nmysql_select_db(\u201cpelanggan\u201d);\r\n$query=\u201dCREATE TABLE data_pelanggan(\r\nno_id int(5) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,\r\nnama varchar(50) NOT NULL DEFAULT \u201d,\r\nalamat text\r\n)\u201d;\r\n$buat_tabel = mysql_query($query);\r\necho ($buat_tabel) ? \u201ctabel berhasil dibuat\u201d : \u201ctabel gagal\r\ndibuat\u201d;\r\n?>\r\n<\/pre>\n<\/li>\n
  6. \nmysql_fetch_array()
    \nSetelah data-data diambil dari database dengan menggunakan perintah SQL dalam
    \nfungsi mysql_query(), selanjutnya mengambil data itu dalam bentuk keluaran yang
    \ndiinginkan.<\/p>\n
    \r\n<?php\r\n$host = "localhost";\r\n$user = "root";\r\n$pass = "";\r\n$dbName = "jajal";\r\n \r\n\/\/koneksi ke server\r\n$conn = mysql_connect($host, $user, $pass) or die ("gagal koneksi");\r\n\/\/koneksi ke database\r\nmysql_select_db($dbName);\r\n \r\n$query = "SELECT * FROM data_pelanggan";\r\n$result = mysql_query($query) or die ("gagal");\r\n \r\nwhile ($data = mysql_fetch_array($result)) {\r\n    echo $data[0] . "<br>";\r\n    echo $data[1] . "<br>";\r\n    echo $data[2] . "<br><br>";\r\n}\r\n?>\r\n<\/pre>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
    MySQL\u00a0merupakan\u00a0sebuah perangkat lunak sistem manajemen basis data SQL (bahasa Inggris: database management system) atau DBMS yang multithread, multi-user, dengan sekitar 6 juta instalasi di seluruh<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[16,48,165],"class_list":["post-888","post","type-post","status-publish","format-standard","hentry","category-belajar-web-programming","tag-belajar-php","tag-kursus-php-mysql-jakarta","tag-mysql"],"yoast_head":"\nMemanipulasi Database Menggunakan Kode PHP MySQL - 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\/memanipulasi-database-menggunakan-kode-php-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Memanipulasi Database Menggunakan Kode PHP MySQL - WebHozz Blog\" \/>\n<meta property=\"og:description\" content=\"MySQL\u00a0merupakan\u00a0sebuah perangkat lunak sistem manajemen basis data SQL (bahasa Inggris: database management system) atau DBMS yang multithread, multi-user, dengan sekitar 6 juta instalasi di seluruh\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"WebHozz Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-22T15:22:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-07-22T15:23:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/01\/kursus-web-php-mysql-programming-banner2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"286\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanipulasi-database-menggunakan-kode-php-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanipulasi-database-menggunakan-kode-php-mysql\\\/\"},\"author\":{\"name\":\"\",\"@id\":\"\"},\"headline\":\"Memanipulasi Database Menggunakan Kode PHP MySQL\",\"datePublished\":\"2014-07-22T15:22:04+00:00\",\"dateModified\":\"2014-07-22T15:23:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanipulasi-database-menggunakan-kode-php-mysql\\\/\"},\"wordCount\":473,\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanipulasi-database-menggunakan-kode-php-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2014\\\/01\\\/kursus-web-php-mysql-programming-banner2-300x107.jpg\",\"keywords\":[\"Belajar PHP\",\"Kursus PHP MySql Jakarta\",\"MySQL\"],\"articleSection\":[\"Belajar Web Programming\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanipulasi-database-menggunakan-kode-php-mysql\\\/\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanipulasi-database-menggunakan-kode-php-mysql\\\/\",\"name\":\"Memanipulasi Database Menggunakan Kode PHP MySQL - WebHozz Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanipulasi-database-menggunakan-kode-php-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanipulasi-database-menggunakan-kode-php-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2014\\\/01\\\/kursus-web-php-mysql-programming-banner2-300x107.jpg\",\"datePublished\":\"2014-07-22T15:22:04+00:00\",\"dateModified\":\"2014-07-22T15:23:27+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanipulasi-database-menggunakan-kode-php-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanipulasi-database-menggunakan-kode-php-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanipulasi-database-menggunakan-kode-php-mysql\\\/#primaryimage\",\"url\":\"http:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2014\\\/01\\\/kursus-web-php-mysql-programming-banner2-300x107.jpg\",\"contentUrl\":\"http:\\\/\\\/www.webhozz.com\\\/blog\\\/wp-content\\\/uploads\\\/2014\\\/01\\\/kursus-web-php-mysql-programming-banner2-300x107.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/memanipulasi-database-menggunakan-kode-php-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Memanipulasi Database Menggunakan Kode PHP MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/\",\"name\":\"WebHozz Blog\",\"description\":\"Kursus Web & 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\":\"\",\"url\":\"https:\\\/\\\/www.webhozz.com\\\/blog\\\/author\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Memanipulasi Database Menggunakan Kode PHP MySQL - 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\/memanipulasi-database-menggunakan-kode-php-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Memanipulasi Database Menggunakan Kode PHP MySQL - WebHozz Blog","og_description":"MySQL\u00a0merupakan\u00a0sebuah perangkat lunak sistem manajemen basis data SQL (bahasa Inggris: database management system) atau DBMS yang multithread, multi-user, dengan sekitar 6 juta instalasi di seluruh","og_url":"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/","og_site_name":"WebHozz Blog","article_published_time":"2014-07-22T15:22:04+00:00","article_modified_time":"2014-07-22T15:23:27+00:00","og_image":[{"width":800,"height":286,"url":"https:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/01\/kursus-web-php-mysql-programming-banner2.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/#article","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/"},"author":{"name":"","@id":""},"headline":"Memanipulasi Database Menggunakan Kode PHP MySQL","datePublished":"2014-07-22T15:22:04+00:00","dateModified":"2014-07-22T15:23:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/"},"wordCount":473,"publisher":{"@id":"https:\/\/www.webhozz.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/#primaryimage"},"thumbnailUrl":"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/01\/kursus-web-php-mysql-programming-banner2-300x107.jpg","keywords":["Belajar PHP","Kursus PHP MySql Jakarta","MySQL"],"articleSection":["Belajar Web Programming"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/","url":"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/","name":"Memanipulasi Database Menggunakan Kode PHP MySQL - WebHozz Blog","isPartOf":{"@id":"https:\/\/www.webhozz.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/#primaryimage"},"thumbnailUrl":"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/01\/kursus-web-php-mysql-programming-banner2-300x107.jpg","datePublished":"2014-07-22T15:22:04+00:00","dateModified":"2014-07-22T15:23:27+00:00","breadcrumb":{"@id":"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/#primaryimage","url":"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/01\/kursus-web-php-mysql-programming-banner2-300x107.jpg","contentUrl":"http:\/\/www.webhozz.com\/blog\/wp-content\/uploads\/2014\/01\/kursus-web-php-mysql-programming-banner2-300x107.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhozz.com\/blog\/memanipulasi-database-menggunakan-kode-php-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhozz.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Memanipulasi Database Menggunakan Kode PHP MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.webhozz.com\/blog\/#website","url":"https:\/\/www.webhozz.com\/blog\/","name":"WebHozz Blog","description":"Kursus Web & 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":"","url":"https:\/\/www.webhozz.com\/blog\/author\/"}]}},"_links":{"self":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/888","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/comments?post=888"}],"version-history":[{"count":2,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/888\/revisions"}],"predecessor-version":[{"id":890,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/posts\/888\/revisions\/890"}],"wp:attachment":[{"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/media?parent=888"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/categories?post=888"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhozz.com\/blog\/wp-json\/wp\/v2\/tags?post=888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}