Saturday, 16 December 2017

FINAL PROJECT WWW PROGRAMMING

Assalamualaikum and hello everybody!!!!

Today i would like to share my final project for this subject which is "Tote Bags"

Interface Tote Bags

1) Home
2) List of Bags


3) View of Bags



4) Add New Bags

5) List of Users
6) Delete of Bags


7) Edit Bags Information
8) Register User
9) Search

I think that all from my lab. Before this, i would like to say thank you to my lecturer Tuan Zalizam Bin Tuan Muda and all my friend on how to teach my all about WWW Programming. All the best for examination and insyaAllah see you again !!!!!
























Sunday, 10 December 2017

LAB 08

Assalamualaikum and hello everybody!!!!

Question for lab 08:
# add ONE field in the table for a video clip
# add control buttons on the clip i.e play, pause, stop, etc
# make sure the images can be added, deleted, updated and displayed

Output:

1) Add new table for video after image table in lab07
2) Insert and embed link into PHPMyAdmin database

a) Homepage


b) List of  Users


c) Registration Form


d) Edit of Users


e) Search of Users



Saturday, 9 December 2017

LAB 09

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:
  1. Masukkan column baru selepas column video.
  2. Namakan column tersebut "PHOTO" dengan menggunakan jenis data "BLOB/LONGBLOB".
  3. 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">&nbsp;</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">&nbsp;</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>

Tuesday, 5 December 2017

LAB 07

Assalamualaikum and hello everyone!!!!!!!!


 Question
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.


 1) Homepage


2) List of Users


3) List of  Registration


4) Delete of Users


5) Edit of Users


6) Search of Users




Sunday, 26 November 2017

LAB 06

Assalamualaikum and hello everybody, nice to meet you again!

For lab 06 we have to develop our own database, sql command and php.
The question for lab 06 is:

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

OUTPUT

1) Homepage



2) List of Users


3) Register of Users


4) Delete of Users


5) Edit of Users


6) Search of Users

Wednesday, 11 October 2017

LAB 03- CASCADING STYLE SHEET

Assalamualaikum and hello everybody!!!!

Untuk toturial lab ke-3 ini, kami diarahkan untuk menyambung semula toturial lab ke-2 yang dibuat sebelum ini dengan memasukkan elemen cascading style sheet.



Berikut merupakan page source menggunakan cascading style sheet. Dalam toturial ke-3 ini saya hanya "add" and "update" background dan menukar warnanya sahaja dengan menggunakan CSS.


<html>
<body style="background-image:url('kapal terbang.jpg')">
<img src="logo.png" width="200" height="180">

<link rel="stylesheet" type="text/css" href="1stCSS.css">
<title>Text Box</title>

<b><em><h1 style="color:Tomato">Air Asia Flight Booking</b></em></h1>
<h3>*MEMBER LOGIN*</h3>
<form action="insert.asp"method="post">

User ID:<INPUT type="text" name="userID" size=30 maxlength=40 >
</form>


<title>Text Box</title>

<form action="insert.asp"method="post">

Password:<INPUT type="text" name="password" size=30 maxlength=40>
<hr>

<head>
<title>Radio Buttons</title>
</head>


<h3>LETS BOOKING NOW!!</h3>
<form action="insert.asp"method="post">

<P> <INPUT type="radio" name="os" value="re">Return<BR>
    <INPUT type="radio" name="os" value="way">One Way<BR>
</p>

<head>
<title>Select</title>
</head>

<form action="insert.asp" method="post">
<P>
<SELECT name="access">
       <OPTION>Departing
</SELECT>
</P>

<head>
<title>Select</title>
</head>

<form action="insert.asp" method="post">
<P>
<SELECT name="access">
       <OPTION>Arriving
</SELECT>
</P>

<head>
<title>Select</title>
</head>

<form action="insert.asp" method="post">
<P> From
<SELECT name="access">
       <OPTION>Kuala Lumpur(KUL)
</SELECT>
</P>

<head>
<title>Select</title>
</head>

<form action="insert.asp" method="post">
<P> To
<SELECT name="access">
       <OPTION>Alor Setar(AOR)
</SELECT>
</P>

<head>
<title>Select</title>
</head>

<form action="insert.asp" method="post">
<P> Departure Date
<SELECT name="access">
       <OPTION>2017-05-05(Fri)
</SELECT>
</P>

<head>
<title>Select</title>
</head>

<form action="insert.asp" method="post">
<P> Return Date
<SELECT name="access">
       <OPTION>2017-05-12(Fri)
</SELECT>
</P>

<p style="color:DarkBlue">Save RM5 per return trip online</p>


<i><h3>Search</i></h3><img src="search.png" width="50" height="80">

</form>
</body>
</html>


Ini adalah CSS yang saya gunakan.

h3 {color:green;}
p {color:#00F;}

h1 {
    color: orange;
    font-family: eras demi itc;
    font-size: 300%;
}
p  {
    color: dark purple;
    font-family: century;
    font-size: 150%;
}

h3 {
    border: 1px solid powderblue;
}

Terima kasih kerana sudi meluangkan masa di blog saya ini. InsyaAllah panjang umur kita bersua lagi .....

Wednesday, 4 October 2017

Air Asia (Lab 02)

Assalamualaikum and hello everybody!!!!


Sesi pembelajaran ke-2 iaitu menmbina laman sesawang dengan menggunakan HTML

Kami ditugaskan untuk membuat sebuah laman sesawang menggunakan HTML berkaitan sebuah syarikat penerbangan di mana saya menghasilkan laman sesawang bagi syarikat penerbangan"Air Asia".


Berikut adalah page source yang dibuat bagi laman sesawang ini:

<html>
<body style="background-image:url('kapal terbang.jpg')">
<img src="logo.png" width="200" height="180">


<title>Text Box</title>

<b><em><h1 style="color:Tomato">Air Asia Flight Booking</b></em></h1>
<h3>*MEMBER LOGIN*</h3>
<form action="insert.asp"method="post">

User ID:<INPUT type="text" name="userID" size=30 maxlength=40 >
</form>


<title>Text Box</title>

<form action="insert.asp"method="post">

Password:<INPUT type="text" name="password" size=30 maxlength=40>
<hr>

<head>
<title>Radio Buttons</title>
</head>


<h3>LETS BOOKING NOW!!</h3>
<form action="insert.asp"method="post">

<P> <INPUT type="radio" name="os" value="re">Return<BR>
    <INPUT type="radio" name="os" value="way">One Way<BR>
</p>

<head>
<title>Select</title>
</head>

<form action="insert.asp" method="post">
<P>
<SELECT name="access">
       <OPTION>Departing
</SELECT>
</P>

<head>
<title>Select</title>
</head>

<form action="insert.asp" method="post">
<P>
<SELECT name="access">
       <OPTION>Arriving
</SELECT>
</P>

<head>
<title>Select</title>
</head>

<form action="insert.asp" method="post">
<P> From
<SELECT name="access">
       <OPTION>Kuala Lumpur(KUL)
</SELECT>
</P>

<head>
<title>Select</title>
</head>

<form action="insert.asp" method="post">
<P> To
<SELECT name="access">
       <OPTION>Alor Setar(AOR)
</SELECT>
</P>

<head>
<title>Select</title>
</head>

<form action="insert.asp" method="post">
<P> Departure Date
<SELECT name="access">
       <OPTION>2017-05-05(Fri)
</SELECT>
</P>

<head>
<title>Select</title>
</head>

<form action="insert.asp" method="post">
<P> Return Date
<SELECT name="access">
       <OPTION>2017-05-12(Fri)
</SELECT>
</P>

<p style="color:DarkBlue">Save RM5 per return trip online</p>


<i><h3>Search</i></h3><img src="search.png" width="50" height="80">

</form>
</body>
</html>