<?php$db=mysqli_connect("localhost","root","","mycompanyhr");if($db==true){echo "Connection succeed!!!<br>";}else{echo "Connection fail!!!<br>";}//get the empno$empno=$_GET['id'];//develop the SQL command$q="select * from employeewhere EMPNO='$empno'";//execute SQL command$rs=mysqli_query($db,$q);if($rs==false){echo ("Query cannot be executed!<br>");echo ("SQL Error : ".mysqli_error($db));}//extract data from resultset$rekod=mysqli_fetch_array($rs);$fullname=$rekod['FULLNAME'];$dept=$rekod['DEPT'];$gender=$rekod['GENDER'];//populate old data in a form?>Update record<form name="frmupdate" method="get" action="">Employee No<input type="text" name="txtempno" maxlength=6value="<?=$empno?>"><br>Fullname<input type="text" name="txtname"value="<?=$fullname?>"><br>Department code<input type="text" name="txtdeptcode" maxlength=3value="<?=$dept?>"><br>Gender<input type="text" name="txtgender"value="<?=$gender?>"><br><input type="submit" value="Save Record"></form><?php$empno=$_GET['txtempno'];$fullname=$_GET['txtname'];$dept=$_GET['txtdeptcode'];$gender=$_GET['txtgender'];if ($empno!=NULL){$db2=mysqli_connect("localhost","root","","mycompanyhr");if($db2==true){echo "Connection succeed!!!<br>";}else{echo "Connection fail!!!<br>";}$sql2="update employeeset FULLNAME='$fullname', DEPT='$dept',GENDER='$gender'where EMPNO='$empno'";$rs2=mysqli_query($db2, $sql2);if ($rs2==true){echo "The update for $empno has been saved<br>";echo "Back to <a href='listingupdate.php'>listing</a>";}else{echo ("Query cannot be executed!<br>");echo ("SQL Error : ".mysqli_error($db2));}}//end if NULL?>
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