LAB 07 - ADD IMAGE

Assalamualaikum and hai!


Questions:

On this lab 07 tutorial, it will be based on previous Lab 06 which 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.

 Output:

 STEP TO DO LAB 07:

 1. Add new row for IMAGE in the previous lab 06.

2.  Insert an embed link into PHPMyAdmin database.

How to embed a link of image/video?


1. Choose any image/video in search engine.
2. Copy the image/video link.
3. Open "http://embed.ly/code" link and paste any image/video link.
4. Embed the image/video.
5. Copy the embed link and paste it into the PHPMyAdmin database.



3. Don't forget to change and add the coding in all PHP files in order to print out all the new database from image.


For example : - listAll.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">&nbsp;</td>
    <td height="104" colspan="5" align="center" valign="top" bordercolor="#000000"><img src="baner.jpg" width="800" height="100"></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 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="#000000" 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('mydomain');
$SQLcommand = "SELECT * FROM people";
  
$result = mysql_query($SQLcommand, $connect);

print "<table width=\"500\">";
print "<tr bgcolor=\"#DDDDDD\">";
print "<td>ID</td>";
print "<td>Name</td>";
print "<td>Telephone</td>";
print "<td>DOB</td>";
print "<td>Image</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>";
  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>
****The highlighted code are the coding that need to be added in all the php files.

 That all for this lab 07 tutorial session. We'll continue in the next lab 08 tutorial session. Enjoy your day and have fun in your own way!
Assalamualaikum W.B.T. :)

Comments

Post a Comment

Popular posts from this blog

LAB 06 - DATABASE, SQL COMMANDS & PHP

Image
Assalamualaikum and hai! For today lab session which is lab 6,  we have receive a task by our lecturer to develop our own database, sql commands and php. The Question::: Based on previous sample of small system. Develop your own database + sql commands + php in one folder. The Output::: 1. The Homepage This is the homepage of the system which shows all the functions which is include the list of the users, register user, delete user, edit user and search user information.  2. List of users This is the list of the registered users in the system. The users can view the details of another user by click the button " view ". 3. Register user This is the interface of registration form of user. The user need to insert their ID, name, phone number and date of birth before click the button " register ". The user also can " cancel" their registration if they wish to do it. If their registration are successful, it will ...
Read more

LAB 04 - JAVASCRIPT TUTORIAL

Image
Assalamualaikum and hai! For today lab session, we are given a task by our lecturer to do some exercises based on the JavaScript Tutorial. The Question::: Based on pdf file of JavaScript Tutorial. Starting page 10 "Hello World"  codes, write up the examples scripts given to you, test them and save. Every topic need to have one script such as Topic 5 till Topic 13. The Answer::: This is the outcomes lab 4 tutorial session: Thats all for this lab 04 tutorial session. See you soon in next lab 05 tutorial session! Enjoy your day! Assalamualaikum W.B.T. :) 
Read more