Advertisement
Guest User

php mysqli starbhak

a guest
Jan 26th, 2020
308
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.70 KB | None | 0 0
  1. <?php
  2.     //untuk koneksi ke database
  3.     // Buka koneksi
  4. function bukaKoneksi(){
  5.     // connect ke database
  6.     $DB_HOST = "192.168.64.2";
  7.     $DB_DATABASE = "sekolahku";
  8.     $DB_USERNAME = "affandy";
  9.     $DB_PASSWORD = "12345678";
  10.     $DB_PORT = "3306";
  11.     // create connection
  12.     $koneksi = new mysqli($DB_HOST, $DB_USERNAME, $DB_PASSWORD,  $DB_DATABASE, $DB_PORT);
  13.     // check connection
  14.     if($koneksi->connect_error) {
  15.         die('Koneksi Gagal :' .$koneksi->connect_error);
  16.     }
  17.     return $koneksi;
  18.  
  19. }
  20. //koneksi tutup
  21. // Jalankan Query
  22. function bacaSiswa(){
  23.     $kun=bukaKoneksi();
  24.     $data = mysqli_query($kun,"select * from students");
  25.     return mysqli_fetch_array($data);
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement