Lab 06

Web Design

Task : Based on previous sample of small system. Develop your own database + sql commands + php in one folder.

Home.php

<html>
<head>
<body style="background-color:powderblue;">
<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="5" align="center" valign="top" bordercolor="#000000"><img src="organik.jpg" 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 FRUITS</a>
:: <a href="register.php">REGISTER FRUITS</a>
:: <a href="deleteList.php">DELETE FRUITS</a>
:: <a href="editList.php">EDIT FRUITS</a>
:: <a href="searching.php">SEARCH FRUITS</a>
::</font></div></td>
</tr>
<tr>
<td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">
<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Welcome to SAMPLE </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>
<body style="background-color:powderblue;">
<title>List of Fruits</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="5" align="center" valign="top" bordercolor="#000000"><img src="organik.jpg" 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 FRUITS</a>
:: <a href="register.php">REGISTER FRUITS</a>
:: <a href="deleteList.php">DELETE FRUITS</a>
:: <a href="editList.php">EDIT FRUITS</a>
:: <a href="searching.php">SEARCH FRUITS</a>
::</font></div></td>
</tr>
<tr>
<td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">
<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>List of Registered Fruits </strong></font></p>
<p>
<?php
// error_reporting(E_ALL ^ E_DEPRECATED);

$connect=mysql_connect('localhost','root','');
mysql_select_db('labsix');
$SQLcommand = "SELECT * FROM labsix";

$result = mysql_query($SQLcommand, $connect);

print "<table width=\"500\">";
print "<tr bgcolor=\"#DDDDDD\">";
print "<td>ID</td>";
print "<td>Fruit_Name</td>";
print "<td>Quantity_kg</td>";
print "<td>Price_kg</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>

<html>

<head>

<title>Data Saved</title>

</head>

<body>

</tr>

<tr>

:: <a href="home.php">HOME</a>

:: <a href="listAll.php">LIST OF FRUITS</a>

:: <a href="register.php">REGISTER FRUITS</a>

:: <a href="deleteList.php">DELETE FRUITS</a>

:: <a href="editList.php">EDIT FRUITS</a>

:: <a href="searching.php">SEARCH FRUITS</a>

::</font></div></td>

</tr>

<tr>

<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Your details have been saved. TQ.</strong></font></p>

<p>

<?php

$ID= $_POST['id'];

$Fruit_Name= $_POST['Fruit_Name'];

$Quantity_kg= $_POST['Quantity_kg'];

$Price_kg= $_POST['Price_kg'];

$connect=mysql_connect('localhost','root','');

mysql_select_db('labsix');

$SQLcommand = "INSERT INTO labsix (ID, Fruit_Name, Quantity_kg, Price_kg)

VALUES ('$ID','$Fruit_Name', '$Quantity_kg', '$Price_kg') ";

$result = mysql_query($SQLcommand, $connect);

mysql_close($connect);

</p></td>

</tr>

</table>

</body>

</html>

DeleteList.php

<html>

<head>

<title>List of Users</title>

</head>

<body>

</tr>

<tr>

:: <a href="home.php">HOME</a>

:: <a href="listAll.php">LIST OF FRUITS</a>

:: <a href="register.php">REGISTER FRUITS</a>

:: <a href="deleteList.php">DELETE FRUITS</a>

:: <a href="editList.php">EDIT FRUITS</a>

:: <a href="searching.php">SEARCH FRUITS</a>

::</font></div></td>

</tr>

<tr>

<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>List of Registered Users </strong></font></p>

<p>

<?php

$connect=mysql_connect('localhost','root','');

mysql_select_db('labsix');

$SQLcommand = "SELECT * FROM labsix";

$result = mysql_query($SQLcommand, $connect);

print "<table width=\"500\">";

print "<tr bgcolor=\"#DDDDDD\">";

print "<td>ID</td>";

print "<td>Fruit_Name</td>";

print "<td>Quantity_kg</td>";

print "<td>Price_kg</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>

</body>

</html>

Edit.php

<html>

<head>

<title>List of Users</title>

</head>

<body>

</tr>

<tr>

:: <a href="home.php">HOME</a>

:: <a href="listAll.php">LIST OF USERS</a>

:: <a href="register.php">REGISTER OF FRUITS</a>

:: <a href="deleteList.php">DELETE FRUITS</a>

:: <a href="editList.php">EDIT FRUITS</a>

:: <a href="searching.php">SEARCH FRUITS</a>

::</font></div></td>

</tr>

<tr>

<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>List of Fruits </strong></font></p>

<p>

<?php

$connect=mysql_connect('localhost','root','');

mysql_select_db('labsix');

$SQLcommand = "SELECT * FROM labsix";

$result = mysql_query($SQLcommand, $connect);

print "<table width=\"500\">";

print "<tr bgcolor=\"#DDDDDD\">";

print "<td>ID</td>";

print "<td>Fruit_Name</td>";

print "<td>Quantity_kg</td>";

print "<td>Price_kg</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 =\"editUser.php?ID=";

print $row[0] ;

print "\">";

print "[edit]";

print"</a>";

print "</td>";

print "</tr>";

}

print "</table>";

mysql_close($connect);

</p></td>

</tr>

</table>

</body>

</html>

search.php

<html>

<head>

<title>Searching</title>

</head>

<body>

</tr>

<tr>

:: <a href="home.php">HOME</a>

:: <a href="listAll.php">LIST OF FRUITS</a>

:: <a href="register.php">REGISTER FRUITS</a>

:: <a href="deleteList.php">DELETE FRUITS</a>

:: <a href="editList.php">EDIT FRUITS</a>

:: <a href="searching.php">SEARCH FRUITS</a>

::</font></div></td>

</tr>

<tr>

<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Search </strong></font></p>

<p>

<?php

$keyword= $_POST['keyword'];

$connect=mysql_connect('localhost','root','');

mysql_select_db('labsix');

$SQLcommand = "SELECT * FROM labsix WHERE ID like '%$keyword%' order by ID asc";

$result = mysql_query($SQLcommand, $connect);

print "<table width=\"500\">";

print "<tr bgcolor=\"#DDDDDD\">";

print "<td>ID</td>";

print "<td>Fruit_Name</td>";

print "<td>Quantity_kg</td>";

print "<td>Price_kg</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 "</tr>";

}

print "</table>";

mysql_close($connect);

</p></td>

</tr>

</table>

</body>

</html>

Search This Blog

WWW Programming

Lab 06

Comments

Post a Comment