{"id":1113,"date":"2019-02-15T13:12:42","date_gmt":"2019-02-15T06:12:42","guid":{"rendered":"https:\/\/www.yellowweb.id\/blog\/?p=1113"},"modified":"2019-02-15T13:12:42","modified_gmt":"2019-02-15T06:12:42","slug":"konfigurasi-phpmyadmin-dan-sql-server","status":"publish","type":"post","link":"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/","title":{"rendered":"Konfigurasi phpMyAdmin dan SQL Server"},"content":{"rendered":"<p>Pada tulisan kali ini kita akan mencoba melakukan konfigurasi phpMyAdmin dengan <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-downloads\" rel=\"noopener\" target=\"_blank\">SQL Server<\/a>, untuk web servernya disini tetap menggunakan phpMyAdmin, bahasa pemrograman yang akan digunakan adalah PHP dan untuk databasenya menggunakan SQL Server. Mungkin sudah biasa jika dalam pembuatan sebuah web aplikasi menggunakan MySQL sebagai databasenya, untuk artikel kali ini kita akan mencoba bagaimana caranya menghubungkan SQL Server dengan phpMyAdmin.<br \/>\n<!--more--><\/p>\n<p>Ada beberapa tahapan yang perlu teman-teman persiapkan ketika akan melakukan konfigurasi antara phpMyAdmin dan SQL Server, adapun tahapannya adalah sebagai berikut:<\/p>\n<p>1. Periksa versi PHP yang digunakan dengan melakukan cek phpinfo();<br \/>\n2. Download Driver PHP for SQL Server<br \/>\n3. Tambahkan file PHP driver ke folder ext, yang terdapat didalam folder php yang ada di xampp<br \/>\n4. Modifikasi file php.ini, dengan melakukan penambahan ekstensi<br \/>\n5. Download ODBC Driver 11 SQL Server<br \/>\n6. Buat file koneksi<\/p>\n<p>Untuk langkah-langkahnya teman-teman bisa lihat pada gambar dibawah ini:<br \/>\n1. Periksa versi PHP yang sedang dipakai<br \/>\n<div id=\"attachment_1116\" style=\"width: 310px\" class=\"wp-caption alignleft\"><a href=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql1.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1116\" src=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql1-300x166.jpg\" alt=\"sql-server\" width=\"300\" height=\"166\" class=\"size-medium wp-image-1116\" srcset=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql1-300x166.jpg 300w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql1-768x425.jpg 768w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql1-1024x567.jpg 1024w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql1.jpg 1281w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-1116\" class=\"wp-caption-text\">Versi PHP<\/p><\/div><\/p>\n<p>2. Download Driver PHP for SQL Server<br \/>\nDisini teman-teman harus coba sesuaikan dengan versi PHP yang sedang digunakan, karena terdapat beberpa versi Driver yang memang berbeda-beda untuk setiap versi.<\/p>\n<div id=\"attachment_1118\" style=\"width: 310px\" class=\"wp-caption alignleft\"><a href=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql3.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1118\" src=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql3-300x145.jpg\" alt=\"driver-php\" width=\"300\" height=\"145\" class=\"size-medium wp-image-1118\" srcset=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql3-300x145.jpg 300w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql3-768x371.jpg 768w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql3-1024x494.jpg 1024w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql3.jpg 1225w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-1118\" class=\"wp-caption-text\">Driver PHP<\/p><\/div>\n<p>3. Tambahkan file Driver PHP<br \/>\nTambahkan beberapa file driver PHP ke dalam folder ext, yang berada didalam folder PHP yang terdapat didalam folder XAMPP\/php\/ext<\/p>\n<div id=\"attachment_1119\" style=\"width: 310px\" class=\"wp-caption alignleft\"><a href=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql4.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1119\" src=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql4-300x157.jpg\" alt=\"extension-driver-php\" width=\"300\" height=\"157\" class=\"size-medium wp-image-1119\" srcset=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql4-300x157.jpg 300w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql4-768x401.jpg 768w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql4.jpg 925w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-1119\" class=\"wp-caption-text\">extension-driver-php<\/p><\/div>\n<p>4. Modifikasi file php.ini<br \/>\nLakukan penambahan extensi pada baris file php.ini<\/p>\n<div id=\"attachment_1120\" style=\"width: 310px\" class=\"wp-caption alignleft\"><a href=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql5.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1120\" src=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql5-300x199.jpg\" alt=\"extention-sql-server\" width=\"300\" height=\"199\" class=\"size-medium wp-image-1120\" srcset=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql5-300x199.jpg 300w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql5-768x511.jpg 768w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql5.jpg 985w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-1120\" class=\"wp-caption-text\">extention-sql-server<\/p><\/div>\n<p>5. Download ODBC Driver ver. 11 SQL Server<\/p>\n<div id=\"attachment_1121\" style=\"width: 310px\" class=\"wp-caption alignleft\"><a href=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql6.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1121\" src=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql6-300x155.jpg\" alt=\"odbc-driver\" width=\"300\" height=\"155\" class=\"size-medium wp-image-1121\" srcset=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql6-300x155.jpg 300w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql6-768x397.jpg 768w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql6-1024x529.jpg 1024w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql6.jpg 1237w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-1121\" class=\"wp-caption-text\">ODBC Driver<\/p><\/div>\n<p>Jangan lupa disini kalian dapat memeriksa apakah SQL Server sudah aktif, dengan membuka phpinfo(). Untuk gambarnya akan terlihat sebagai berikut:<\/p>\n<div id=\"attachment_1122\" style=\"width: 310px\" class=\"wp-caption alignleft\"><a href=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql7.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-1122\" src=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql7-300x182.jpg\" alt=\"sql-server\" width=\"300\" height=\"182\" class=\"size-medium wp-image-1122\" srcset=\"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql7-300x182.jpg 300w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql7-768x465.jpg 768w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql7-1024x620.jpg 1024w, https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql7.jpg 1167w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><p id=\"caption-attachment-1122\" class=\"wp-caption-text\">Sql Server<\/p><\/div>\n<p>6. Buat file koneksi<\/p>\n<p>Untuk tahapan paling akhir teman-teman dapat membuat file <a href=\"http:\/\/php.net\/manual\/en\/function.sqlsrv-connect.php\" rel=\"noopener\" target=\"_blank\">koneksi.php<\/a>, hanya skripnya disini agak sedikit berbeda karena disini menggunakan SQL Server.<\/p>\n<pre class=\"lang:default decode:true \" >&lt;?php\r\n\t$serverName = \"MIFTAH\\YELLOWWEBSQL\";\r\n\t$connectionInfo = array(\"Database\"=&gt;\"db_pegawai\", \"UID\"=&gt;\"sa\", \"PWD\"=&gt;\"Sandisk46\");\r\n\t$conn = sqlsrv_connect($serverName, $connectionInfo);\r\n\r\n\tif($conn){\r\n\t\techo \"Koneksi Ok!\";\r\n\t} else {\r\n\t\techo \"Koneksi Gagal\";\r\n\t\tdie(print_r(sqlsrv_errors(), true));\r\n\t}\r\n?&gt;<\/pre>\n<p>Sekian untuk tutorial yang singkat ini, sebelumnya teman-teman harus terlebih dahulu menginstal SQL Server, lalu buat databasenya. Untuk sumbernya dalam pembuatan tutorial ini diambil dari beberapa sumber, diantaranya sebagai berikut:<br \/>\nDriver PHP for SQL<br \/>\n<a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=20098\" rel=\"noopener\" target=\"_blank\">https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=20098<\/a><br \/>\nODBC Driver 11 SQL Server<br \/>\n<a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=36434\" rel=\"noopener\" target=\"_blank\">https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=36434<\/a><br \/>\nPHP Manuals SQL Server<br \/>\n<a href=\"http:\/\/php.net\/manual\/en\/book.sqlsrv.php\" rel=\"noopener\" target=\"_blank\">http:\/\/php.net\/manual\/en\/book.sqlsrv.php<\/a><\/p>\n<p><em>CATATAN:<br \/>\npada saat artikel ini ditulis menggunakan PHP versi 5.6.x.x, untuk Drivernya bisa disesuaikan dengan versi PHP yang sedang digunakan.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pada tulisan kali ini kita akan mencoba melakukan konfigurasi phpMyAdmin dengan SQL Server, untuk web servernya disini tetap menggunakan phpMyAdmin, bahasa pemrograman yang akan digunakan adalah PHP dan untuk databasenya menggunakan SQL Server. Mungkin sudah biasa jika dalam pembuatan sebuah web aplikasi menggunakan MySQL sebagai databasenya, untuk artikel kali ini kita akan mencoba bagaimana caranya [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1124,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[110,488],"tags":[490,88,408,489],"class_list":["post-1113","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","category-sql-server","tag-mssql","tag-php","tag-phpmyadmin","tag-sqlserver"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Konfigurasi phpMyAdmin dan SQL Server - YELLOWWEB.ID<\/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.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Konfigurasi phpMyAdmin dan SQL Server - YELLOWWEB.ID\" \/>\n<meta property=\"og:description\" content=\"Pada tulisan kali ini kita akan mencoba melakukan konfigurasi phpMyAdmin dengan SQL Server, untuk web servernya disini tetap menggunakan phpMyAdmin, bahasa pemrograman yang akan digunakan adalah PHP dan untuk databasenya menggunakan SQL Server. Mungkin sudah biasa jika dalam pembuatan sebuah web aplikasi menggunakan MySQL sebagai databasenya, untuk artikel kali ini kita akan mencoba bagaimana caranya [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"YELLOWWEB.ID\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-15T06:12:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql-server-php-myadmin.jpg?fit=600%2C290&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"290\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"yellowweb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"yellowweb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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.yellowweb.id\\\/blog\\\/konfigurasi-phpmyadmin-dan-sql-server\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/konfigurasi-phpmyadmin-dan-sql-server\\\/\"},\"author\":{\"name\":\"yellowweb\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"headline\":\"Konfigurasi phpMyAdmin dan SQL Server\",\"datePublished\":\"2019-02-15T06:12:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/konfigurasi-phpmyadmin-dan-sql-server\\\/\"},\"wordCount\":404,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/konfigurasi-phpmyadmin-dan-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/sql-server-php-myadmin.jpg\",\"keywords\":[\"mssql\",\"php\",\"phpmyadmin\",\"sqlserver\"],\"articleSection\":[\"PHP\",\"SQL Server\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/konfigurasi-phpmyadmin-dan-sql-server\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/konfigurasi-phpmyadmin-dan-sql-server\\\/\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/konfigurasi-phpmyadmin-dan-sql-server\\\/\",\"name\":\"Konfigurasi phpMyAdmin dan SQL Server - YELLOWWEB.ID\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/konfigurasi-phpmyadmin-dan-sql-server\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/konfigurasi-phpmyadmin-dan-sql-server\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/sql-server-php-myadmin.jpg\",\"datePublished\":\"2019-02-15T06:12:42+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/konfigurasi-phpmyadmin-dan-sql-server\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/konfigurasi-phpmyadmin-dan-sql-server\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/konfigurasi-phpmyadmin-dan-sql-server\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/sql-server-php-myadmin.jpg\",\"contentUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/02\\\/sql-server-php-myadmin.jpg\",\"width\":600,\"height\":290,\"caption\":\"sql-server-php-myadmin\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/konfigurasi-phpmyadmin-dan-sql-server\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Konfigurasi phpMyAdmin dan SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\",\"name\":\"YELLOWWEB.ID\",\"description\":\"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\",\"name\":\"yellowweb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"caption\":\"yellowweb\"},\"sameAs\":[\"https:\\\/\\\/www.yellowweb.id\"],\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/author\\\/yellowweb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Konfigurasi phpMyAdmin dan SQL Server - YELLOWWEB.ID","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.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/","og_locale":"en_GB","og_type":"article","og_title":"Konfigurasi phpMyAdmin dan SQL Server - YELLOWWEB.ID","og_description":"Pada tulisan kali ini kita akan mencoba melakukan konfigurasi phpMyAdmin dengan SQL Server, untuk web servernya disini tetap menggunakan phpMyAdmin, bahasa pemrograman yang akan digunakan adalah PHP dan untuk databasenya menggunakan SQL Server. Mungkin sudah biasa jika dalam pembuatan sebuah web aplikasi menggunakan MySQL sebagai databasenya, untuk artikel kali ini kita akan mencoba bagaimana caranya [&hellip;]","og_url":"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/","og_site_name":"YELLOWWEB.ID","article_published_time":"2019-02-15T06:12:42+00:00","og_image":[{"width":600,"height":290,"url":"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql-server-php-myadmin.jpg?fit=600%2C290&ssl=1","type":"image\/jpeg"}],"author":"yellowweb","twitter_card":"summary_large_image","twitter_misc":{"Written by":"yellowweb","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/"},"author":{"name":"yellowweb","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"headline":"Konfigurasi phpMyAdmin dan SQL Server","datePublished":"2019-02-15T06:12:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/"},"wordCount":404,"commentCount":0,"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql-server-php-myadmin.jpg","keywords":["mssql","php","phpmyadmin","sqlserver"],"articleSection":["PHP","SQL Server"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/","url":"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/","name":"Konfigurasi phpMyAdmin dan SQL Server - YELLOWWEB.ID","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql-server-php-myadmin.jpg","datePublished":"2019-02-15T06:12:42+00:00","author":{"@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"breadcrumb":{"@id":"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/#primaryimage","url":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql-server-php-myadmin.jpg","contentUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2019\/02\/sql-server-php-myadmin.jpg","width":600,"height":290,"caption":"sql-server-php-myadmin"},{"@type":"BreadcrumbList","@id":"https:\/\/www.yellowweb.id\/blog\/konfigurasi-phpmyadmin-dan-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yellowweb.id\/blog\/"},{"@type":"ListItem","position":2,"name":"Konfigurasi phpMyAdmin dan SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/www.yellowweb.id\/blog\/#website","url":"https:\/\/www.yellowweb.id\/blog\/","name":"YELLOWWEB.ID","description":"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yellowweb.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829","name":"yellowweb","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","caption":"yellowweb"},"sameAs":["https:\/\/www.yellowweb.id"],"url":"https:\/\/www.yellowweb.id\/blog\/author\/yellowweb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/1113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/comments?post=1113"}],"version-history":[{"count":4,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/1113\/revisions"}],"predecessor-version":[{"id":1123,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/1113\/revisions\/1123"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media\/1124"}],"wp:attachment":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media?parent=1113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/categories?post=1113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/tags?post=1113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}