Week9: database

In this week's lecture, we get some basic knowledge about Database, including SQL language and MySql server.

This is the exercise of week 7 which is a guestbook implemented by php and mysql:
http://www-student.it.uts.edu.au/~jjliu/dmt/gb.php

JQuery

What is Jquery ?

"jQuery is a lightweight JavaScript library that emphasizes interaction between JavaScript and HTML. It was released in January 2006 at BarCamp NYC by John Resig" (Wikipedia).

Jquery Sandard

It's free, open source software (Wikipedia).

Is JQuery used widely?

Yes! Microsoft and Nokia have announced plans to bundle jQuery on their platforms, Microsoft adopting it initially within Visual Studio for use within Microsoft's ASP.NET AJAX framework and ASP.NET MVC Framework whilst Nokia will integrate it into their Web Run-Time platform (Wikipedia).

How to use JQuery?

Some amazing examples of JQuery can be found here: Tutorials:Live Examples of jQuery

References:

• http://jquery.com


• Wikipedia

week8: JavaScript

This week, we learned Javascript, a client side script, which is used to build dynamic website features. Because I planned to put a photo album in my own project, this week's practice, which is to create a photo gallery by JavaScript, seems quite useful for me.

Here is the page of this week's exercise: JavaScript photo gallery

Last week, I created a photo gallery by a free php script which I found from Internet. This photo album looks much fancier than the lab exercise. Therefore, maybe I will choose to use this photo gallery in my project.

Here is the page of PHP photo gallery: PHP photo gallery

An error of the guest book in week 7 practical exercises

Today, I tried to add the guest book which is in the week 7 practical exercises to my project. However, I found a problem that when I wanted to change the page of the guest book to see other messages, it did not work.

I read through the php script and found the bug which is the php program has not the syntax to get the value of the attribute "offset" passed by the URL.

If you add the following syntax into your php script, the problem will solve and then you can see the messages on different pages.

PHP photo album

According to my project plan, I m gonna add a photo album into my website. Thanks for google, I finally found a great free script which use both javascript and PHP to implement a quite fancy photo album. I have added this script into my project:


I have to say PHP and javascript really enable web design dynamic and full of magic.

php:lecture reflection

In this week's lecture, we learned a sever-side programming scripts: php. PHP is quite a magic technology because it allows website users dynamically interact with the web pages such as making comment and logging in the authenticated pages. I planed to try to use the Guestbook which was introduced in this lab in my own project.

My draft Micro&Macro analysis

Finally finish my Micro&Macro analysis draft. Through this assignment, I got a broad and specific view of the technologies which I want to learn and use in my project.

My Micro and Macro analysis

Now, it's time to start my project!

My project website css layout

I have used XHTML and CSS to build a template page of my project. I really feel css is quite efficient for setting layout of the page.

That's my template page: http://www-student.it.uts.edu.au/~jjliu/dmt/index.html

CSS: make unstrutured cite ordered

The lecture of this week is what I really want to learn: make the page layout using CSS.

Before this lecture, when I wanted to design a web-based interface, the first way coming into my mind was using tables. Actrually, tables are quite easy to control for me because the sturcture showed in the code is just the way when viewing in the web browsers. After this lecture, I have decided to give up tables and use CSS instead! Maybe it's a little hard for me to control the CSS code since all the layout codes are stored in the CSS style tags or other CSS files. However, it makes the main code quite clean and furthermore, it's reusable and with more other features.

I cannot waite to use CSS and XHTML to build my website right now.