<?php
//database connect
$db=mysqli_connect("localhost","root","","mycompanyhr");
//checking database connection
if ($db==false) {
echo "Connect failed: ";
echo 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 {
while($rekod=mysqli_fetch_array($rs)){
echo $rekod['EMPNO']."<br>";
echo $rekod['FIRSTNAME']."<br>";
echo $rekod['LASTNAME']."<br>";
echo $rekod['WORKDEPT']."<br>";
echo $rekod['PHONENO']."<hr>";
}
}
?>
This PHP code is a simple search example. It needs the user to enter a name and the PHP script will to the searching by the name provided by the user in the text box. <form name='search' method='get' action=''> Insert the firstname <input type='text' name='txtname'> <input type='submit' value='search name'> </form> <?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"; } $n=$_GET['txtname']; $sql="select EMPNO, FIRSTNAME, LASTNAME, WORKDEPT, PHONENO from employee where FIRSTNAME like '%$n%' "; $rs=mysqli_query($db,$sql); if($rs==false){ echo ("Query cannot be executed!<br>"); echo ("SQL Error : ".mysqli_error($db)); } else...
Comments
Post a Comment