INSERT IMAGE USING BLOB DATA TYPES
Assalamualaikum and hello everybody!!!!
Untuk lab 09 ini kami diarahkan untuk menayambung semula lab 08 dengan memasukkan "images" ke dalamnya menggunakan "BLOB" sebagai jenis datanya.
Ini merupakan data yang saya masukkan dalam lab 09
Cara-cara nak masukkan image menggunakan "BLOB" adalah seperti berikut:
- Masukkan column baru selepas column video.
- Namakan column tersebut "PHOTO" dengan menggunakan jenis data "BLOB/LONGBLOB".
- Pilih mana-mana gambar dalam google dan masukkan ke dalam database.
Contoh coding bagi "ListAllUsers" :
<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="300" border="1" align="center" bordercolor="#4B5320">
<tr bordercolor="#FFFFFF">
<td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF"> </td>
<td height="90" colspan="5" align="center" valign="top" bordercolor="#4B5320"><img src="2.png" width="200" height="150"></td>
<td width="80" rowspan="3" align="center" bgcolor="#FFFFFF"> </td>
</tr>
<tr>
<td height="23" colspan="5" align="center" valign="top" bordercolor="#4B5320" 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 users</a>
:: <a href="register.php">register</a>
:: <a href="deleteList.php">delete user</a>
:: <a href="editList.php">edit user</a>
:: <a href="searching.php">search user</a>
::</font></div></td>
</tr>
<tr>
<td height="202" colspan="5" align="center" valign="top" bordercolor="#4B5320" bgcolor="#FFCC66">
<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>List of Registered Users </strong></font></p>
<p>
<?php
// error_reporting(E_ALL ^ E_DEPRECATED);
$connect=mysql_connect('localhost','root','');
mysql_select_db('food');
$SQLcommand = "SELECT * FROM studentinfo";
$result = mysql_query($SQLcommand, $connect);
print "<table width=\"500\">";
print "<tr bgcolor=\"#DDDDDD\">";
print "<td>ID</td>";
print "<td>NAME</td>";
print "<td>SUBJECT</td>";
print "<td>GROUP</td>";
print "<td>IMAGE</td>";
print "<td>VIDEO</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> $row[4] </td>";
print "<td> $row[5] </td>";
print "<td> $row[6] </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>
