Lab 07 (Adding Picture)
Adding Picture Through Embed Code
Task : Based on previous Lab06, you need to :
-> add ONE field in the table for image/pic/photo normally PNG/JPG-formatted.
-> add record for more than 5 records, 10 would be nice :D
->make sure the images can be added, deleted, updated and displayed.
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>
:: <a href="index.php">IMAGES</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 "<td>Picture</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>
All highlighted php coding need to be inserted into all php file
Comments
Post a Comment