<?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 employee
where 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 employee
set 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?>
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