programmingcodeclass

Now I will explain how to read data with PHP below is complete code:

// database connection

$conn= mysql_connect ("localhost","root","") or
die ("sorry wrong username or password");

$db = "dataku";

mysql_select_db($db, $conn);

// judul table

echo "<table border='1'>";

echo "<tr>";

echo "<td>nama</td><td>nim</td><td>jurusan</td>";

echo "</tr>";

// baca recordset

$sql="select nim,nama,jurusan from mahasiswa";

$rs = mysql_query($sql,$conn) or die ("Kesalahan pada pembacaan recordset");

for($i=0;$i<mysql_num_rows($rs);$i++){

$row_array=mysql_fetch_row($rs);

echo "<tr>";

echo "<td>".$row_array[0]."</td><td>".$row_array[1]."</td><td>".$row_array[2]."</td>";

echo "</tr>";

}

echo "</table>";

If source code run well you may see like below:

Monday, February 1, 2016