KONEKSI DATABASE KE WEBSITE

<?php

$hostname = "localhost";

$username = "root";

$password = "";

$db_name = "db_SMK";

$koneksi = mysqli_connect($hostname, $username, $password, $db_name);

if ($koneksi == true) {

    echo "Database Berhasil Terhubung";

} else {

    echo "Database Tidak Terhubung";

}

$perintah = "SHOW TABLES";

$query = mysqli_query($koneksi, $perintah);

while ($data = mysqli_fetch_row($query)) {

    echo "<hr> $data[0] <hr>";

}

$perintah2 = "CREATE TABLE IF NOT EXISTS tb_siswa (

    nis int(10) not null,

    nama varchar(100) not null,

    jenis_kelamin varchar(15) not null,

    tempat_lahir varchar(50) not null,

    tanggal_lahir date,

    nama_ibukandung varchar(100) not null,

    primary key(nis)

)";

$query2 = mysqli_query($koneksi, $perintah2);

?>

             Hasilnya :