<?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?>
Scenario You are given a task to develop a simple web database application for a movies rental shop. The system will store the information of all the movies available in the shop. Below are the information needed for the database. Database server information : server address= localhost , username= root , no password Database name: MOVIEDB This is the database source Table name : Movies Fields in table Movies : MovieID , MovieTitle , Category , Director , YearProduced , RentalPrice . Tasks 1. Create the database and table as stated above (using MySQL through phpMyAdmin). Populate the database by entering at least 5 movie titles. 2. Develop the web pages (combination of HTML and PHP scripts) to search and display the movies information by MovieTitle and YearProduced . 3. Develop a HTML form for the user to insert a new record of a new movie. Prepare the input for Category and YearProduced using the select option list. The categories are fiction , horror , comedy , ...
Comments
Post a Comment