Skip to content

Instantly share code, notes, and snippets.

@susantokun
Last active May 10, 2020 06:34
Show Gist options
  • Save susantokun/c5f0e064335c9739ac348bf87f539da4 to your computer and use it in GitHub Desktop.
Save susantokun/c5f0e064335c9739ac348bf87f539da4 to your computer and use it in GitHub Desktop.
Koneksi Webiste PHP Dengan Database MySQL
<?php
define('DB_NAME', 'susantokun_db_website_1'); // nama database
define('DB_USER', 'susantokun'); // nama user (default: root)
define('DB_PASSWORD', 'susantokun'); // password (default: )
define('DB_HOST', 'localhost'); // host server
// koneksikan dengan localhost serta sesuaikan username dan password
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD);
// jika tidak dapat terkoneksi tampilkan pesan error
if (!$link) {
die('Could not connect: ' . mysqli_error($link));
}
// pilih database yang akan digunakan sesuai dengan DB_NAME
$db_selected = mysqli_select_db($link, DB_NAME);
// jika tidak dapat menemukan database tampilkan pesan error
if (!$db_selected) {
die('Cannot access ' . DB_NAME . ': ' . mysqli_error($link));
}
// // pesan jika koneksi berhasil
// if($link && $db_selected) {
// echo 'Koneksi ke database berhasil';
// }
// mysqli_close($link);
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment