<?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>";
}
}
?>
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