<?php
//database connect
$db=mysqli_connect("localhost","root","","mycompanyhr");
//checking database connection
if ($db==false) {
echo "Connect failed: ". mysqli_connect_error($db);
exit();
}
else {
echo "Connection successful";
}
$sql="select EMPNO, FIRSTNAME, LASTNAME, WORKDEPT, PHONENO
from employee";
$rs=mysqli_query($db,$sql);
if($rs==false){
echo ("Query cannot be executed!<br>");
echo ("SQL Error : ".mysqli_error($db));
}
else{
echo "<table border=1>";
echo "<tr>";
echo "<td>Employee no</td>";
echo "<td>Firstname</td>";
echo "<td>Lastname</td>";
echo "<td>Department</td>";
echo "<td>Extension</td>";
echo "</tr>";
echo "</table>";
while($rekod=mysqli_fetch_array($rs)){
echo " Employee no: ".$rekod['EMPNO']."<br>";
echo " First name: ".$rekod['FIRSTNAME']."<br>";
echo " Last name: ".$rekod['LASTNAME']."<br>";
echo " Department code: ".$rekod['WORKDEPT']."<br>";
echo " Phone no: ".$rekod['PHONENO']."<hr>";
}
}
?>
Or you could download here for the Malay proverbs app – https://play.google.com/store/apps/details?id=net.kerul.peribahasa English proverbs and the Malay pair Corpus Reference: Amir Muslim, 2009. Peribahasa dan ungkapan Inggeris-Melayu. DBP, Kuala Lumpur http://books.google.com.my/books/about/Peribahasa_dan_ungkapan_Inggeris_Melayu.html?id=bgwwQwAACAAJ CTRL+F to search Proverbs in English Definition in English Similar Malay Proverbs Definition in Malay 1 Where there is a country, there are people. A country must have people. Ada air adalah ikan. Ada negeri adalah rakyatnya. 2 Dry bread at home is better than roast meat home's the best hujan emas di negeri orang,hujan batu di negeri sendiri Betapa baik pun tempat orang, baik lagi tempat sendiri. 3 There's no accounting for tastes We can't assume that every people have a same feel Kepala sama hitam hati lain-lain. Dalam kehidupan ini, setiap insan berbeza cara, kesukaan, perangai, tabia
Comments
Post a Comment