Menampilkan Database Tabel Guru di Web

Pemrograman Web

 1. Buat tabel tb_guru di mysql

=> CREATE TABLE tb_guru(
=> nip int(25) not null,

=> nama_guru varchar(200) 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(nip));

2. Tambahkan Data Guru

• INSERT INTO tb_guru VALUES('1001','Agri','Laki-laki','Sumedang','1994-08-17','Anah');
• INSERT INTO tb_guru VALUES('1002','Fahrul','Laki-laki','Pandeglang','1990-02-25','Anis');
• INSERT INTO tb_guru VALUES('1003','Abyan','Laki-laki','Wonogiri','2009-02-20','Susi');

localhost/Abyan.id/data_guru.php :

Sintak :

<h1>Data Guru</h1>

<table border=1 width=700 height=150 cellspading=7 cellspacing=0>

    <tr>    

        <th>NIP</th><th>Nama Guru</th>

        <th>Jenis Kelamin</th><th>Tempat Lahir</th>

        <th>Tanggal Lahir</th><th>Nama Ibu Kandung</th>

    </tr>

<?php

include"conn/config.php";

$perintah = "select * from tb_guru";

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

while ($data = mysqli_fetch_array($query))

    {

        echo"

        <tr>

            <td>$data[nip]</td>

            <td>$data[nama_guru]</td>

            <td>$data[jenis_kelamin]</td>

            <td>$data[tempat_lahir]</td>

            <td>$data[tanggal_lahir]</td>

            <td>$data[nama_ibukandung]</td>

        </tr>

        ";

    }

?>

Output :

Hasil Output di Localhost