Sebelumnya "Apache" dan "MySQL" dalam keadaan START lalu...
Klik “Start”-“Run” lalu
ketik “cmd”[Enter]
Ikuti langkah berikut :
Membuka Database MySQL
Cd/xampp/mysql/bin
[Enter]
Mysql
–u root [Enter]
Membuat Database
Create
database data; [Enter]
Melihat Database
Show
databases; [Enter]
Memakai Database
Use
database data; [Enter]
Membuat table
Create
table mhs([Enter]
Nim
varchar (8) not null, [Enter]
Nama
varchar (25) not null, [Enter]
Prodi
varchar (15) not null[Enter]
); [Enter]
Memasukkan data kedalam table
Insert
into mhs (nim,nama,prodi) values (‘13110427’,’Ade Hidayat’,’Sistem informasi’); [Enter]
Menampilkan isi table
Select *
from mhs; [Enter]
Selanjutnya....
Berikut source PHP nya, silahkan di copas :)
<html>
<title>Tampil Data</title>
<?php
$conn = mysql_connect("localhost","root","");
mysql_select_db("ade",$conn);
$hasil = mysql_query("select * from mhs",$conn);
$jumlah = mysql_num_rows($hasil);
echo "<right><b><u><i>DAFTAR PENGUNJUNG</b></u></i></right>";
echo "<br>";
echo "Jumlah Pengunjung : $jumlah";
$a=1;
echo "<br>";
?>
<table border="3">
<tr bgcolor="#33cccc">
<td colspan="4"><b>TAMPIL DATA MAHASISWA</b></td></tr>
</tr><tr bgcolor="#00ffff"><th>No.</th><th>NIM</th><th>Nama</th><th>Prodi</th></tr>
<?PHP
while ($baris = mysql_fetch_array($hasil))
{
echo "<tr>";
echo "<td>";
echo $a;
echo "</td>";
echo "<td>";
echo $baris[0];
echo "</td>";
echo "<td>";
echo $baris[1];
echo "</td>";
echo "<td>";
echo $baris[2];
echo "</td>";
echo "</tr>";
$a++;
}
echo "</table>";
?>
ini hasilnya....
<title>Tampil Data</title>
<?php
$conn = mysql_connect("localhost","root","");
mysql_select_db("ade",$conn);
$hasil = mysql_query("select * from mhs",$conn);
$jumlah = mysql_num_rows($hasil);
echo "<right><b><u><i>DAFTAR PENGUNJUNG</b></u></i></right>";
echo "<br>";
echo "Jumlah Pengunjung : $jumlah";
$a=1;
echo "<br>";
?>
<table border="3">
<tr bgcolor="#33cccc">
<td colspan="4"><b>TAMPIL DATA MAHASISWA</b></td></tr>
</tr><tr bgcolor="#00ffff"><th>No.</th><th>NIM</th><th>Nama</th><th>Prodi</th></tr>
<?PHP
while ($baris = mysql_fetch_array($hasil))
{
echo "<tr>";
echo "<td>";
echo $a;
echo "</td>";
echo "<td>";
echo $baris[0];
echo "</td>";
echo "<td>";
echo $baris[1];
echo "</td>";
echo "<td>";
echo $baris[2];
echo "</td>";
echo "</tr>";
$a++;
}
echo "</table>";
?>
ini hasilnya....