Lab 08 (Adding Video)

Based on the previous Lab 7, in this Lab 8 I add one more column for video
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">&nbsp;</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">&nbsp;</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>Image</td>";
print "<td>Video</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> $row[4] </td>";
  print "<td> $row[5] </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>


In the local host phpMyAdmin, add one column for video section, copy and paste embedded code for the particular video from Youtube. Refer video section in red rectangle in image below.



Comments

Post a Comment