Web design
Task : Based on previous sample of small system. Develop your own database + sql commands + php in one folder.
Home.php
<html>
<head>
<title>List of Users</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
<tr bordercolor="#FFFFFF">
<td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> </td>
<td height="104" colspan="3" align="center" valign="top" bordercolor="#000000"><img src="cake.png" width="900" height="350"></td>
<td width="80" rowspan="3" align="center" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="25" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#F8994B"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="home.php">HOME</a>
:: <a href="listAll.php">LIST OF CAKE</a>
:: <a href="register.php">REGISTER</a>
:: <a href="deleteList.php">DELETE CAKE</a>
:: <a href="editList.php">EDIT</a>
:: <a href="searching.php">SEARCH CAKE</a>
::</font></div></td>
</tr>
<tr>
<td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#F3936D">
<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Welcome ! </strong></font></p>
<p>
<?php
$connect=mysql_connect('localhost','root','');
if ($connect)
{ echo "Successfully connected to MySQL server -localhost-<p>"; }
else
{ die ( "Could not connect to MySQL " .mysql_error() ); }
$select=mysql_select_db("mydomain");
if ($select)
{ echo "Successfully selected database -mydomain-<p>"; }
else
{ die("Unable to select database. ".mysql_error() ); }
?>
</p></td>
</tr>
</table>
<font color="#FFFFFF"></font>
</body>
</html>
ListAll.php
<html>
<head>
<title>List of Cakes</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
<tr bordercolor="#FFFFFF">
<td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> </td>
<td height="104" colspan="3" align="center" valign="top" bordercolor="#000000"><img src="cake.png" width="900" height="350"></td>
<td width="80" rowspan="3" align="center" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="home.php">HOME</a>
:: <a href="listAll.php">LIST OF CAKE</a>
:: <a href="register.php">REGISTER</a>
:: <a href="deleteList.php">DELETE CAKE</a>
:: <a href="editList.php">EDIT</a>
:: <a href="searching.php">SEARCH CAKE</a>
::</font></div></td>
</tr>
<tr>
<td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#F3936D">
<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>List of Cakes </strong></font></p>
<p>
<?php
// error_reporting(E_ALL ^ E_DEPRECATED);
$connect=mysql_connect('localhost','root','');
mysql_select_db('mydomain');
$SQLcommand = "SELECT * FROM cake";
$result = mysql_query($SQLcommand, $connect);
print "<table width=\"500\">";
print "<tr bgcolor=\"#DDDDDD\">";
print "<td>ID</td>";
print "<td>Name</td>";
print "<td>Price</td>";
print "<td>Weight</td>";
print "</tr>";
while($row = mysql_fetch_row($result))
{
print "<tr bgcolor=\"#EEEEEE\">";
print "<td> $row[0] </td>";
print "<td> $row[1] </td>";
print "<td> $row[2] </td>";
print "<td> $row[3] </td>";
print "<td>";
print "<a href =\"viewUser.php?ID=";
print $row[0] ;
print "\">";
print "[view]";
print"</a>";
print "</td>";
// print "<td> position: $row[6] </td>";
print "</tr>";
}
print "</table>";
mysql_close($connect);
?>
</p></td>
</tr>
</table>
<font color="#FFFFFF"></font>
</body>
</html>
Task : Based on previous sample of small system. Develop your own database + sql commands + php in one folder.
Home.php
<html>
<head>
<title>List of Users</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
<tr bordercolor="#FFFFFF">
<td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> </td>
<td height="104" colspan="3" align="center" valign="top" bordercolor="#000000"><img src="cake.png" width="900" height="350"></td>
<td width="80" rowspan="3" align="center" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="25" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#F8994B"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="home.php">HOME</a>
:: <a href="listAll.php">LIST OF CAKE</a>
:: <a href="register.php">REGISTER</a>
:: <a href="deleteList.php">DELETE CAKE</a>
:: <a href="editList.php">EDIT</a>
:: <a href="searching.php">SEARCH CAKE</a>
::</font></div></td>
</tr>
<tr>
<td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#F3936D">
<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Welcome ! </strong></font></p>
<p>
<?php
$connect=mysql_connect('localhost','root','');
if ($connect)
{ echo "Successfully connected to MySQL server -localhost-<p>"; }
else
{ die ( "Could not connect to MySQL " .mysql_error() ); }
$select=mysql_select_db("mydomain");
if ($select)
{ echo "Successfully selected database -mydomain-<p>"; }
else
{ die("Unable to select database. ".mysql_error() ); }
?>
</p></td>
</tr>
</table>
<font color="#FFFFFF"></font>
</body>
</html>
ListAll.php
<html>
<head>
<title>List of Cakes</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
<tr bordercolor="#FFFFFF">
<td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> </td>
<td height="104" colspan="3" align="center" valign="top" bordercolor="#000000"><img src="cake.png" width="900" height="350"></td>
<td width="80" rowspan="3" align="center" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="home.php">HOME</a>
:: <a href="listAll.php">LIST OF CAKE</a>
:: <a href="register.php">REGISTER</a>
:: <a href="deleteList.php">DELETE CAKE</a>
:: <a href="editList.php">EDIT</a>
:: <a href="searching.php">SEARCH CAKE</a>
::</font></div></td>
</tr>
<tr>
<td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#F3936D">
<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>List of Cakes </strong></font></p>
<p>
<?php
// error_reporting(E_ALL ^ E_DEPRECATED);
$connect=mysql_connect('localhost','root','');
mysql_select_db('mydomain');
$SQLcommand = "SELECT * FROM cake";
$result = mysql_query($SQLcommand, $connect);
print "<table width=\"500\">";
print "<tr bgcolor=\"#DDDDDD\">";
print "<td>ID</td>";
print "<td>Name</td>";
print "<td>Price</td>";
print "<td>Weight</td>";
print "</tr>";
while($row = mysql_fetch_row($result))
{
print "<tr bgcolor=\"#EEEEEE\">";
print "<td> $row[0] </td>";
print "<td> $row[1] </td>";
print "<td> $row[2] </td>";
print "<td> $row[3] </td>";
print "<td>";
print "<a href =\"viewUser.php?ID=";
print $row[0] ;
print "\">";
print "[view]";
print"</a>";
print "</td>";
// print "<td> position: $row[6] </td>";
print "</tr>";
}
print "</table>";
mysql_close($connect);
?>
</p></td>
</tr>
</table>
<font color="#FFFFFF"></font>
</body>
</html>
Register.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Registration Form</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
<tr bordercolor="#FFFFFF">
<td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> </td>
<td height="104" colspan="3" align="center" valign="top" bordercolor="#000000"><img src="cake.png" width="900" height="350">></td>
<td width="80" rowspan="3" align="center" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="home.php">HOME</a>
:: <a href="listAll.php">LIST OF CAKE</a>
:: <a href="register.php">REGISTER</a>
:: <a href="deleteList.php">DELETE CAKE</a>
:: <a href="editList.php">EDIT</a>
:: <a href="searching.php">SEARCH CAKE</a>
::</font></div></td>
</tr>
<tr>
<td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#F3936D">
<h1><font face="Geneva, Arial, Helvetica, sans-serif">Registration Form </font></h1>
<p><font face="Geneva, Arial, Helvetica, sans-serif">Please enter cake details and click the submit button. </font></p>
<form method = "post" action = "register_process.php">
<div align="left"><span style = "color: blue"> </span>
<table align="center" border="1" cellspacing="0" cellpadding="3">
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">ID:</font></td>
<td><input name="id" type="int" id="id" size="40" maxlength="50"></td></tr>
<tr>
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Name:</font></td>
<td><input name="name" type="text" id="name" size="40" maxlength="50"></td></tr>
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Price:</font></td>
<td><input name="price" type="text" id=price" size="40" maxlength="50"></td></tr>
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Weight:</font></td>
<td><input name="weight" type="text" id="weight" size="40" maxlength="50"></td></tr>
<tr>
<tr>
<td colspan="2" align="right">
<input name="submit" type = "submit" value = "Register">
<input name="reset" type = "reset" value = "Reset">
<p></p></td>
</tr>
</table>
</div>
</form> </td>
</tr>
</table>
<font color="#FFFFFF"></font>
</body>
</html>
DeleteList.php
<html>
<head>
<title>List of Users</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
<tr bordercolor="#FFFFFF">
<td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> </td>
<td height="104" colspan="3" align="center" valign="top" bordercolor="#000000"><img src="cake.png" width="900" height="350"></td>
<td width="80" rowspan="3" align="center" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="home.php">HOME</a>
:: <a href="listAll.php">LIST OF CAKE</a>
:: <a href="register.php">REGISTER</a>
:: <a href="deleteList.php">DELETE CAKE</a>
:: <a href="editList.php">EDIT</a>
:: <a href="searching.php">SEARCH CAKE</a>
::</font></div></td>
</tr>
<tr>
<td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#F3936D">
<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>List of Registered Cakes </strong></font></p>
<p>
<?php
$connect=mysql_connect('localhost','root','');
mysql_select_db('mydomain');
$SQLcommand = "SELECT * FROM cake";
$result = mysql_query($SQLcommand, $connect);
print "<table width=\"500\">";
print "<tr bgcolor=\"#DDDDDD\">";
print "<td>ID</td>";
print "<td>Name</td>";
print "<td>Price</td>";
print "<td>Weight</td>";
print "</tr>";
while($row = mysql_fetch_row($result))
{
print "<tr bgcolor=\"#EEEEEE\">";
print "<td> $row[0] </td>";
print "<td> $row[1] </td>";
print "<td> $row[2] </td>";
print "<td> $row[3] </td>";
print "<td>";
print "<a href =\"deleteUser.php?ID=";
print $row[0] ;
print "\">";
print "[delete]";
print"</a>";
print "</td>";
print "</tr>";
}
print "</table>";
mysql_close($connect);
?>
</p></td>
</tr>
</table>
<font color="#FFFFFF"></font>
</body>
</html>
Edit.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Registration Form</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
<tr bordercolor="#FFFFFF">
<td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> </td>
<td height="104" colspan="3" align="center" valign="top" bordercolor="#000000"><img src="cake.png" width="900" height="350">></td>
<td width="80" rowspan="3" align="center" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="home.php">HOME</a>
:: <a href="listAll.php">LIST OF CAKE</a>
:: <a href="register.php">REGISTER</a>
:: <a href="deleteList.php">DELETE CAKE</a>
:: <a href="editList.php">EDIT</a>
:: <a href="searching.php">SEARCH CAKE</a>
::</font></div></td>
</tr>
<tr>
<td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#F3936D">
<h1><font face="Geneva, Arial, Helvetica, sans-serif">Registration Form </font></h1>
<p><font face="Geneva, Arial, Helvetica, sans-serif">Please enter cake details and click the submit button. </font></p>
<form method = "post" action = "register_process.php">
<div align="left"><span style = "color: blue"> </span>
<table align="center" border="1" cellspacing="0" cellpadding="3">
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">ID:</font></td>
<td><input name="id" type="int" id="id" size="40" maxlength="50"></td></tr>
<tr>
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Name:</font></td>
<td><input name="name" type="text" id="name" size="40" maxlength="50"></td></tr>
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Price:</font></td>
<td><input name="price" type="text" id=price" size="40" maxlength="50"></td></tr>
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Weight:</font></td>
<td><input name="weight" type="text" id="weight" size="40" maxlength="50"></td></tr>
<tr>
<tr>
<td colspan="2" align="right">
<input name="submit" type = "submit" value = "Register">
<input name="reset" type = "reset" value = "Reset">
<p></p></td>
</tr>
</table>
</div>
</form> </td>
</tr>
</table>
<font color="#FFFFFF"></font>
</body>
</html>
Searching.php
<html>
<head>
<title>Searching</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
<tr bordercolor="#FFFFFF">
<td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> </td>
<td height="104" colspan="3" align="center" valign="top" bordercolor="#000000"><img src="cake.png" width="900" height="350"></td>
<td width="80" rowspan="3" align="center" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="home.php">HOME</a>
:: <a href="listAll.php">LIST OF CAKE</a>
:: <a href="register.php">REGISTER</a>
:: <a href="deleteList.php">DELETE CAKE</a>
:: <a href="editList.php">EDIT</a>
:: <a href="searching.php"SEARCH CAKE</a>
::</font></div></td>
</tr>
<tr>
<td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#F3936D">
<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Search </strong></font></p>
<p>
<form name="form1" method="post" action="searching_process.php">
<br>
[ search by keyword]<br>
<input type="text" name="keyword">
<input type="submit" name="submit" value="Search">
</form>
</p></td>
</tr>
</table>
<font color="#FFFFFF"></font>
</body>
</html>
Comments
Post a Comment