Advertisement
PlajariKode

Membuat Database MySQL

Sep 13th, 2018
814
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.61 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "username"; // pada defaultnya username adalah "root"
  4. $password = "password"; // pada defaultnya password adalah ""
  5.  
  6. try {
  7.     $conn = new PDO("mysql:host=$servername", $username, $password);
  8.     // set PDO error mode ke exception
  9.     $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  10.     $sql = "CREATE DATABASE myDB";
  11.     // gunakan exec() karena tidak ada hasil yg dikembalikan
  12.     $conn->exec($sql);
  13.     echo "Database berhasil dibuat<br>";
  14.     }
  15. catch(PDOException $e)
  16.     {
  17.     echo $sql . "<br>" . $e->getMessage();
  18.     }
  19.  
  20. $conn = null;
  21. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement