KONEKSI DATABASE KE PHP
Sytaknya
<?php
$hostname = "localhost";
$username = "root";
$password = "";
$db_name = "db_smk";
$koneksi = mysqli_connect($hostname, $username, $password, $db_name);
if ($koneksi == true) {
echo "Database db_smk berhasil terhubung!";
} else {
echo "Database db_smk tidak terhubung!";
}
$perintah = "show tables";
$querry = mysqli_query($koneksi, $perintah);
while($data = mysqli_fetch_row($querry))
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)
)";
$querry2 = mysqli_query($koneksi, $perintah2);
?>
Outputnya

Komentar
Posting Komentar