week 6

As salam

This week class was handle by Dr Norasykin. Our class start with revision from previous class lesson.

This week i learn about on how to set up pages for the admin to manage

• level of authentication for admin
• update record
• delete record
• view details

 Level Of Authentication

The main admin can set the level of it based on level assign. The advantages of assigning each admin with different authentication is very important especially if it involved many pages to check and update especially for big company.Each admin will have their own focus pages and no redundancy among the administrator.

Update record and delete record

The function of update  and delete record is for the admin to keep track of the users.The authority of deleting or any updating related to user can be done by the admin.

View details
 
The complete detail of a user can be view by the admin by clicking on the id of a user.


I also learn about the function of :

Check new username - For me this is a very cool function, it doesn't allow same username being use if it's already exist.

Restrict access to page - This is where the main admin can assign admin based on their level of authentication.
________________________________________________________________________

For this week class, i have problem on understanding on creating update and delete function. Thanks to the apps from the ipad , Thanks to Vicki.... I manage to understand the steps on creating both functions. In my opinion, delete function is a little bit tricky - as i cannot use button for this function  .Been stuck with this delete function , until i create one  new page for it (credit to Amir for his tutorial).

Summary of this week : Server behaviors and binding are very important for  web pages development.

Week 5

As salam..this week class..i come to class with heavy heart..for not able to achieved my ASP objectives..but then..live must go on...

This week class , start with revision from previous class..about the checklist ...and discussion about all the problem arise from last week class..

 checklist

This segment really help all of us, because we shared the problem that have been arise as a team with advice from Prof Zaidatun..this session help the spirit up..:).

                                                         
Troubleshoot session




__________________________________________________________

This  2nd session  we learn about PHP (PreProcessor Hypertext)

From theory part - i do remember that PHP - using SQL as the database, apache as the testing server  and using open source (Linux) as the platform.

1stly , we need to install Xampp - Xampp act as a cross platform for installing apache using Windows environment.It is free to download..

xampp installation

For PHP- The important folder is htdocs..and we can check it under c: xampp directory..

interface of xampp

For PHP we need to set the password for database security..please remember  the username is root. For the password better we use something that is easy for us to remember .
One thing about Xampp - Xampp can help us save our password in text file.




Now  start the developing dynamic webpage.. the same procedure as the checklist .. we have to create the database..An advice from Prof Zaidatun- use lowercase for all the field when creating the database.

interface for create dbase

 For SQL database, if we don't close the database file, no error will occur. This is very different from Access, an error will occur if we don't close the file. In my opinion, creating database using SQL is much more convenience and easy.

For creating testing server..this part is most critical part..if we wrongly give path we will never make a connection - gonna  stuck here..so we must be alert n know the correct path.During this stage also,need to create new folder with the site name .
(Note: Change the security property for this folder -"Everyone" with full access.

Next- need to configure the database connection .

For the next stage- creating form with php extension.. this stage is for the designing  of the layout form.The page will act as virtual communication  interaction . This is the most important part when developing dynamic pages. We need to think about the logic flow of the pages  along with user-friendly instructions for the user.

For the interaction, the use of form and text field for the input from user, along with suitable fields.Once we have created form for user , we need to create one more form for the admin to view.
During this process, the summary is as below :

Example : Register form - use insert record function
                View form - use recordset and repeat region
(Note: Refer to previous handouts - same process as in ASP & PHP for this stage)

One thing to highlight using PHP- we can assign user authentication - to control user access .

user authentication

Last but not least - test the pages  using the browser :)..to make sure all the link path correctly assign.

Reflection / Summary  for this week :

• PHP is more easy to configure and easy to understand. 
• I am happy because now i have the  knowledge to create pages using ASP and PHP. 

Tutorial on Exercise 1 using ASP

A very Simple Tutorial  for exercise 1.

 From seven steps..i narrow it down and combine some of the steps


1st - create database using Microsoft Access, and please make sure you save as  it at lower version of Access..For example : Save as Microsoft Access 2000-2003 version.
Note: Make sure save it to c : inetpub/wwwroot directory

2nd part 1 - Create site

Follow all the steps from the hands out given..
note:

• please create new folder with your site name at the  c : inetpub/wwwroot directory
• Change the security of the folder (right click and choose properties)

folder properties

• Click edit 
• Click add
• click advanced
• Find "everyone"

• Add up "everyone" and tick all the box - for full authority to modify anything

Step 2 part 2 -create connection to dbase

• Choose databases and click plus sign
• Choose Data Source Name

Need to click the User DSN, System DSN and File DSN tab
Generally you need to click as below..

• Click define
• Choose system DSN tab 
• Click add

Choose Microsft Access Driver (Note: choose carefully)

For File DSN - need to give the correct directory to your database

After make the connection, the connection will appear as well as the table1.This is a successful connection.

Step 3 -Create two asp pages as per requested by the exercise1 handout.

• register form - use text ,text field and button  
• view form-

Use table inside the form for both pages.

(Note: save it to the same directory  c : inetpub/wwwroot directory/yoursitename

For register form - need to use insert record function

For view form -need to use recordset and repeatregion function

(note: refer to your handouts from week 4)

Lastly: testing your page using browser

Good Luck :)

In between week 4 n 5

As salam...

All related to ASP...until yesterday ..i can't successfully complete the ASP objectives...although all the 7 steps have been made successfully...been troubleshooting it  with my colleague ..still have error when i want to view my page (view.asp) through browser...kindda of stressful with the failure .. but then ..when i think about the positive side...hmmm..well that is the process of learning and also in life.. :)..

Gear up..boost up...ready to go..up to any challenge ..yehaaa....week 5 reflection will be on the next entry...

Have a nice and good day ...

Week 4

As salam..this week class  have been quite of challenge for me..i didn't complete the objectives ...hohohoho..

checklist

Start this week class with the checklist from week 3 - alhamdulilah manage to do and  tick most of it except for items  no 9 and 10.
Well to begin with , Prof Zaidatun explained about Dreamweaver timeline, layers and frame function.







This week class , Prof Zaidatun guide us on  items no 9 and 10 from the checklist given.
The items are :

• Demo on dynamic website using ASP
• Installing IIS

Before move on to practical part, we need to understand the theories part. One thing to remember : not all server can support dynamic pages- we need to choose especially for free server.

New information for me related to Microsoft Frontpage - The new  version is called "web expression" and it's not included in Microsoft Package as it used to be before.

______________________________________________________________________

Hands on time! 

Installing IIS 

This week i started  using my own laptop and will continuously using it after this to make it easier for me to do all the works or revision  related to this subject at home.

 1st question we need to answer by checking the configuration - How to know IIS is on?

• Go to Control Panel
• Choose program
• Choose Turn Windows features on or off 
• Click at IIS

Note: The steps are differ based on the Operating System

Next we check at local drive ,usually c drive and try to find a folder name Inetpub. 

After that , open a browser and type in the word localhost at the address bar. It' s a successful if we see this screen.

the successful screen

Download page for Wamp

We also need to install the XAMP or WAMP ..It's an apache testing  server for PHP .

 

________________________________________________________________________

Using ASP pages in Dreamweaver

For this phase, there are many steps , we have to focus and follow the guides by Prof Zaidatun  or else need to refer the handouts given by Prof.

Setup site (Temporary) - Using Dreamweaver

• Click new site 
• name the side
• give the http address 
• Choose yes for server technology and select ASPVB Script
• Choose edit and test locally 
• find the proper path by browsing to the correct folder as below

  

  correct path
  
  
  
  
  
  
  

Create Database using Microsoft Access

• Create one new database 
• Save it at the : Inetpub/wwwroot/
• Create one folder name data and save the database inside the folder
• The proper path should be Inetpub/wwwroot/data/db1

access

Create connection to the database using Dreamweaver


Aha..this is the phase that i failed with error 405..while trying to make connection to the database..until the end of class..being trying again and again..same error occurred..not very happy with it..

405 error

Summary for today class: 

There are hidden things that we need to know and adjust , and it is all related to setup the testing server. Need to get the solution for creating connection to the database... 

I hope next week class..i will be able to complete the objectives of the class...chaiyok2..

Thank You

3rd week

As salam...

We meet up again on 3rd week..this week in class-  hands on practical skill on using the software Dreamweaver. This is a new experience for me using this software..

This week class was conducted by Dr Norasykin. Before move on to hands on skill , a little bit revision from previous class on static and dynamic website.
_____________________________________________________________________

Now it's time for Dreamweaver..
Introduction:
Dreamweaver is a web programming with the interface look alike Microsoft Word . This software have template and we can use this  to create our website.Dr Norasykin also highlighted on the windows explorer a.k.a windows tree .This is very important because we need to know the folder location that we use to make the web. Usually as a novice a.k.a beginner , we put it at the desktop.

Class session

This software is use to  create a website using PHP or ASP language.For this session , we make a website using html (Hypertext Markup Language) .

First page

We need to know the basic things of this software before we use it happily without any difficulties . The basic things are :- 

• Title Bar 
• Menu Bar
• Tool bar - icons
• Project Explorer on the right side 
• Properties 

We need to know the differences between working area.There are 3  types of  view of working area that we can choose based on our preference .Working area is a place for us to insert and edit our webpage content such as images, text ,links etc.

The three types are : 

• Code - suitable for those with the html coding knowledge
• Split - suitable for "curious"  programmer or "curious"  novice ( Have 2 different working area  : code and design)
• Design- suitable for novice (Recommended)

Another important thing to know is on how to preview the page. We can preview our page by click on the tool bar - Icon world image and choose the preference browser to view the page.

Last but not less..it is important for us to save our work . We can see the differences either we have save the file or have not save it by looking at the document tab area .It is a must to save our work in one folder. All the related file need to be in the folder .This folder is important because it needed to be link to the server.

document tab area

  Print screen of a document - Not yet been saved

Print screen of a saved document. The word htm appeared as the file extension.

This is the 1st hands on activity - working in the document area 

Then we need to choose the background for the website. I gain new knowledge from this activity..

• I learn on how to choose more specific image that is suitable for my searching by using advanced search

Apart from that , i also learn on how to get one nice background without turning it into tiles type. My mistake is saving the image in thumbnails view..so learn from the mistake , need to save it after i click the thumbnail and at last manage to get the background colour as i want it (Thanks to Amir)

thumbnails view

Note: Please don't do this - wrong technique of saving an image for the background

Proper technique of saving an image for the background

Next activity - using frame template . 

There are many templates for frames. Dr Norasykin ask us to choose the frame as Fixed Top, Nested Left. One thing that i need to know and remember  about frameset , each frame represent one respective page for each frame. For the frame Fixed Top, Nested Left, i need to save using four different name  based on each frame and for the whole frame .For example : 

• Frame 1 - Top frame
• Frame 2- Left frame
• Frame 3- Main frame
• Save all frames 

Last hands on- create a weblink to the main frame

For this activity, i need to know the logical flow of the target frame for the link to appear. Based on the frame image above, the link address is created on the left frame,once the user click the link address, the website will appear at the main frame (content). 

• Select the text that you want to become the link  (Left Frame)
•  In the Properties pane, in the Link text box, type the URL 

        ( NOTE: Be sure to include http:// in the URL. )

•  Press  Enter

 

or 

•  From the Insert menu, select Hyperlink 
•  click HYPERLINK 
• The Hyperlink dialog box appears

When a link is added, the URL should look similar for example: http://www.utm.my

Note:  If you see "file:///," the link will not work for your users. 

Additional info :we also can add up background color or change link color  by using the page properties pane.

Summary :

From the class session  :

• I manage to create  simple webpages for my website using blank /plain  document view 
• Using frameset for my webpage
• Using and insert background image to the page either using image or using colour background
• Create link to external site 
• Save all the webpages into one folder

___________________________________________________________________

Ipad Contract Aggreggment 

I am one of the candidate for Ipad contract with Prof Zaidatun...hohohohoh..my iphone doesn't have jailbreak . Insya -allah will take good care of it.Thanks for it..

contract

_____________________________________________________________

Next class will learn about installing IIS server to the computer. Need to read the handouts given by Prof Zaidatun.

~End of week 3~

Thank You