felix's blog

Leaning Reflection

2009-06-01T21:48:00.000-07:00

From studying of this semester's DMT subject, I really learned a lot, not only technologies, but working ethics. And I relaized that it's not easy to do anything. Before, I have some woking experince, but only focus on the Oracle, and I thought it was very easy to build a website. When I made up my mind to build a vitural online book store, I met a lot of problems, some are really headache, cost me a lot of time. Anyway, I've learned a lot and really enjoy it.

• what did you learn
Although my virtual online book store is a very small system, when i finished it and reviewed it , I found I really learned a lot. From following aspects:

1. HTML,XHTML,CSS

Just using some basic HTML tag you can build your website on the internet, And then add the CSS, it can present a pefect layout, colors and fonts.

2.PHP

Before this subject, programming is my weak point, I never write a whole project programming. Now, I can write PHP embed in HTML, and using PHP to storing and retrieve data from file or database, using array write functions, and even some advance PHP features like Object-Oriented PHP.

3.MySQL

Beofe I have some experience with Oralce, So, leaning MySQL is not hard to me, but It still cost me some time to master it, because compare with ORACLE, MySQL is very inconvenience and it is open source as well , so not many powerful commerical software support it. However, mysql is common used, it's very good to learned it, when you build some small or medium system, it's the best choice. ohters database like SQLSever, Oralce and DB2 is so expenice.

4.Apahce

Because I tried to building running environment in my own laptop, so I download the Apache from official website and installed. Now I've Learned how to configue apache to support PHP and mysql. It looks very easy, but also cost me some time, because when I first try to run it , I met lots of problems and cannot fully set up, you should be very carful when you add or delete or modify any item in the configure files.

5.phpMyAdmin + Navicat 8

Before I learned Oracle, I used pl/sql developer, it's so powerful. But in terms of MySQL, there are not powerful commercial tools support it. The first I downloaded phpMyAdmin and extract to the apahce web service directory, but it didn't work , and then i spend a lot of time to read manual and tried to set it up. When it worked, i was very disappointed, it's not converince to use this admin system to operate database. After that, I searched the Google and found "Navicat 8", it's much better,it is said that the most powerful graphical database management and development software for MySQL, yes, it is, compare with phpMyAdmin.

6 powerdesign, visio

Although it is very small size system, I thing I should face it serious and I chose powerdesign to draw ER diagram and designed the database, after that, generated SQL file to directly run on MySQL database. What's more, I used Microsoft Visio to design the system structure and flow chart.

7 Dreamweaver + UltraEdit + Photoshop + HyperSnap

During the whole website developing time, I always use Dreamweaver, it's a so powerful tools and I love it very much. It help me reduce a lot of time to write code, because most of time it can generate code by itself. But you don't need to run Dreamweaver all the time, sometimes especially when you are testing system, you should use some light software, I chose UltraEdit. Another one , before I know I don't have any talent in photoshop, it makes me headache, but in order to draw some pictures for the webiste, I leaned a little bit about Photoshop, now i can eaily draw some basic pictures such as some icons, buttons and so on. The last one is HyperSnap, it's for the report, it's the best tool to cut the screenshots. It can make your work more effeciently if you learned how to use it, because if you use 'Print Screen' button from the keyborad, making one shotsreens should at least take half a minute, if you use HyperSnap, just one second, and it has more than tens cutting screenshot method.

Of couse, the above are some technologies and tools which are used during building website, I also leaned some program developing method, reseach method and making plans and so on.Abover all, a small system, and it can make big, you can learn a lot from them. I did it.

• how did you learn

When I made up my mind that this semester I should learn to build an online shopping website. Fistly, I downloaded and learned all the slides video from the lecturer who upload to online.uts.edu.au. And then, I borrowed some PHP,MYSQL books from the library, I'll recommend one book which is wrote by Luck Welling&Laura Thomson, and the book name is "PHP and MySQL Web Development", I think it's the best. I nealy spend the whole momth and follow the books' expmples. During studying it , I also tried to build the running environment in my laptop, and it's very easy to test the system codes and system results. and then I downled some open source PHP code and tried to run it and learn it. After learned PHP basic knowledge, I started to build my website, put theory into practise, during these time, I met a lot of problems, When I resolved them all, I found my programming skill and knowledge have up a level. Most of time, when I met the hard problems, I searched it from GOOLE, I can always find the artiles telling you how to deal with. Because using PHP and MySQL is not a cutting edge technologies, there are huge amount of artiles about them in the Internet if you 'GOOLE' them, some are excellent quailities, from them, you can advance quickly.

• what didn’t you learn

Although I learned a lot from building this website, I still feeling I have lots of things which I didn't learn. The technologies and tools which I mentioned in detail before, I just a newbie, and learned a in a shallow level, and still have a long long way to go. When you lean more , you feel you have more to lean. For example , how to use advance PHP features such as classes, functions to build reusable code PHP codes. Anyway, it's a good start.

• did you achieve your objectives?

Sure I did. I learned a lot and It's a very good start, I think based on these knowledge, I'll go further in the programming career.

• was any deviation justified?
Yes, it was.I complain time is short and it really flies, and I don't have enought time to fully stuy. From begin to the end, only three and a little more months, and I was busy all the time, because I have four subjects and I was working somethimes, also I spent a lot of time in IELTS(an english examination). Originally, I plan to build a more functional website, which would be like a real system , but I felt I don't have enough time to do this and then I cut some functions and only fulfilled some simple and basic features.

charlie server cannot support mysqli connection

2009-06-01T21:46:00.000-07:00

So, yesterday evening, when i upload the whole website and found the carlie service cannot support mysqli connection, but i don't have enought time to modify the code, so i upload the souceCode to the ooowebsite, address is following:
http://felix.netau.net/

recap how to configure phpmyadmin to administrate mysql in my laptop

2009-05-31T18:27:00.000-07:00

first step: download zip file from the offical website and then extract to the apahce's htdocs' publish directory

secondly: 1.rename config.sample.inc.php from the phpmyadmin's main directory to config.inc.php and rewrite it,

the following is the config from my own:
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use setup/
*
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki .
*
* @version $Id: config.sample.inc.php 12304 2009-03-24 12:56:58Z nijel $
*/

/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'www.localhost.com'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'aaaa'
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';

/* rajk - for blobstreaming */
$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;
$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';
$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;
$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';

/*
* End of servers configuration
*/

/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

?>

copy libmySQL.dll and php_mysql.dll these two files from php's directory to windows/system32 directory and then restart apache.

then run http://localhost/phpmyadmin to see the reuslt.

recap how to build Apach+php+mysql develop environment

2009-05-31T18:14:00.000-07:00

This day, from DMT studying , i have learned how to build apach, php and mysql to running my own website.

this is a breif description for how to configure them.

first of all , download these three software from their website.

PHP:

copy php.ini-dist and rename to php.ini
looking for extension=php_mysql.dll then delete ";"
looking for extension_dir = “./” changed to your php's ext direction.
take my computer for example: extension_dir = "D:/project/PHP/ext"
add "D:\project\PHP\" to your environment variable's PATH

Then configure apache+php

looking for httpd.conf in Conf directory of apache

add these two line
LoadModule php5_module D:/PHP/php5apache2_2.dll
PHPIniDir “D:/PHP”

note: don't add "" to your php5_module, for example, i used
LoadModule php5_module “D:/PHP/php5apache2_2.dll” then my apache cannot start

looking for DirectoryIndex index.html, and then add index.php
looking for AddType application/x-gzip .gz .tgz
and then add these two lines:
AddType application/x-httpd-php .php
AddType application/x-httpd-php .html

Save httpd.conf.

In your publish directory, create a index.php with the following simple content
phpinfo();
?>

then resart apahce server, use address http://localhost/index.php to see the reuslt.

recap mysql commands which i've learned in DMT

2009-05-31T15:23:00.000-07:00

To login (from unix shell) use -h only if needed.
# [mysql dir]/bin/mysql -h hostname -u root -p

$ mysql -h localhost -u user_name -ppassword
$ mysql -h localhost -u user_name -p
$ ******
$ mysql -h193.0.0.13 -u user_name -p db_name
$ ******

Create a database on the sql server.
mysql> create database [databasename];

Create a database on the sql server.
mysql> create database [databasename];

List all databases on the sql server.
mysql> show databases;

Switch to a database.
mysql> use [db name];

To see all the tables in the db.
mysql> show tables;

To see database's field formats.
mysql> describe [table name];

To delete a db.
mysql> drop database [database name];

To delete a table.
mysql> drop table [table name];

Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
# mysql -u root -p
mysql> use mysql;
mysql> INSERT INTO user (Host,User,Password) VALUES('%','username',PASSWORD('password'));
mysql> flush privileges;

Change a users password from unix shell.
# [mysql dir]/bin/mysqladmin -u username -h hostname.blah.org -p password 'new-password'

Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
# mysql -u root -p
mysql> SET PASSWORD FOR 'user'@'hostname' = PASSWORD('passwordhere');
mysql> flush privileges;

update User set Password=PASSWORD('newpassword') where User='root';

Set a root password if there is no root password.
# mysqladmin -u root password newpassword

import .sql command
mysql>use database;
mysql>source d:/mysql.sql;

add a new user:
grant all on databaseName.* to NewUserName@HostName identified by "password" ;
(this command will add a newuser and password )

if you wish the user can login in every computer, use '%' replace 'localhost'

grant usage on *.* to NewUserName@HostName identified by "password";
grant select,insert,update on databaseName.* to NewUserName@HostName identified by "password";
grant update,delete on mydb.TestTable to NewUserName@HostName identified by "password";

if want to give to others ,using after grant add "WITH GRANT OPTION"

Begin test my website. step1. Building real running environment in my own laptop--MySQL

2009-05-31T06:14:00.000-07:00

This evening, i begin test website. I prepare to test it in my own laptop rather upload to others sevice, because using this way , can fully test my system.
Just now, I downloaded the "mysql-noinstall-5.1.32-win32.zip", it's the noinstall version, so, how to running this version and let it work, i should read the manual.
Follwing is the steps:

1.extract the archive to D:\project\mysql
2.start the server for the first time

D:\project\mysql\bin>mysqld --console
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
090531 23:41:23 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090531 23:41:23 InnoDB: Log file .\ib_logfile0 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090531 23:41:23 InnoDB: Log file .\ib_logfile1 did not exist: new to be created

InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090531 23:41:24 InnoDB: Started; log sequence number 0 0
090531 23:41:26 [Note] Event Scheduler: Loaded 0 events
090531 23:41:26 [Note] mysqld: ready for connections.
Version: '5.1.32-community' socket: '' port: 3306 MySQL Community Server (GPL
)

3.start mysql from the windows command line
...\bin\mysqld

but i can stop MySQL server by executing this command:
...\bin\mysqladmin -u root shutdown

4. start mysql as a windows server
install the server as a service using this command:
...\bin\mysqld --install
then you will see your windows service list has increase one service call "mysql"
then
To make it easier to invoke MySQL programs, you can add the pathname of the MySQL bin directory to your Windows system PATH environment variable
eg. add "D:\project\mysql\bin\;" to the "path" in "system variables"

of course , if you want to remove a server that is installed as a service. first stop it if it is running by executing net stop mysql. then use the --remove option to remove it.
...bin\mysqld" --remove

You can test whether the MySQL server is working by executing any of the following commands:

C:\> "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlshow"
C:\> "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlshow" -u root mysql
C:\> "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqladmin" version status proc
C:\> "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql" test

To permanently remove the old mysql service, execute the following command as a user with administrative privileges, on the command-line:

C:\> sc delete mysql
[SC] DeleteService SUCCESS

one very cool javascript menu

2009-05-31T05:39:00.000-07:00

Today , in order to looking for a beautiful menu for my website, i search the interent and find this one, prepare using it for my website.

step1:Insert the following code into the (head) section of your page:

Step 2: Finally, insert the following into the (body) section of your page, right after the (body) tag itself:

Apache friend: XAMPP

2009-05-12T19:26:00.000-07:00

Today, I downloaded XAMPP, because I know it's a little boring to install apach and distribution with mysql and php, Now, XAMPP can solve all of these problems. Just download , extract and start. There are no changes to the Windows registry and it's not necessary to edit any configuration files.

here is the website address: http://www.apachefriends.org/en/xampp.html

I'll post some of the articles about my using experience later.

google: sort by date &as_qdr=d

2009-05-01T22:16:00.000-07:00

These days, I am writing a report regarding data mining. Because data mining is advancing several decades, but we only need artiles
which were published at most recent five years. So, if I search the data mining from the journals database from year of 2004, most
articles are very detailed technologies of data mining , about algorithms or something stuff let me feel dizzy,of couse I don't like them. I only need some general artiles about general idea of data mining. So, maybe search from google is a better ieda. The problem is arised
that sounds like google don't offer us the function of sort of articles by date. But it's not a difficult issue, EASY, just when you finish
search, append these words after the web address "&as_qdr=d", every articles have showed the date and sort of articles by date as well.

more details:
&as_qdr=all all the time
&as_qdr=d day
&as_qdr=w week
&as_qdr=m month
&as_qdr=m2 two months
&as_qdr=m3 three months
&as_qdr=m6 six months
&as_qdr=y year

How do I change my MySQL password?

2009-04-05T16:57:00.000-07:00

at the "mysql>" prompt, type:
set password = password("yournewpassword");

my final learning proposal

2009-03-30T19:59:00.000-07:00

very glad that I've finished my final learning proposal. This is just the begining, I think there must some challenge things are waiting for me:)

I have uploaded my learning proposal in two places, one is in charlie server ,the other one is 000bebhost:

http://www-student.it.uts.edu.au/~feizhang/LearningProposal-ZhangFeizhou.htm
or
http://felix.netau.net/LearningProposal-ZhangFeizhou.htm

my draft of learning proposal

2009-03-16T19:34:00.000-07:00

http://www-student.it.uts.edu.au/~feizhang/LearningProposal-ZhangFeizhou.htm

Comprehension Rules!

2009-03-15T16:12:00.000-07:00

􀀉 Make lots of connections to yourself, other texts, or the outside world
􀀉 Predict what is coming next
􀀉 Ask questions as you read
􀀉 Visualize by forming pictures in your mind as you read
􀀉 Determine what is important from what is not
􀀉 Clarify the author’s purpose
􀀉 Read between the lines
􀀉 Stop when you encounter a new word and find the meaning
􀀉 Discuss what you are reading with someone else
􀀉 When the text is confusing, stop reading and ask for help or reread
􀀉 Think about how individual ideas fit together to create a whole
􀀉 Be creative as you read. How will you use the information?
􀀉 Be aware of yourself as a reader. Know when you become frustrated or
you get it!
􀀉 Find something to read that you enjoy.
􀀉 Read something each day.

Thomas Jefferson’s Ten Rules for the Good Life

2009-03-15T16:07:00.000-07:00

1. Never put off till tomorrow what you can do today.
2. Never trouble another for what you can do yourself.
3. Never spend your money before you have it.
4. Never buy what you do not want because it is cheap; itwill never be dear to you.
5. Pride costs us more than hunger, thirst, and cold.
6. Never repent of having eaten too little.
7. Nothing is troublesome that we do willingly.
8. Don’t let the evils which have never happened cost youpain.
9. Always take things by their smooth handle.
10. When angry, count to ten before you speak; if very angry,count to one hundred.

some quotes

2009-03-02T14:47:00.000-08:00

1. Hard work is often the easy work you did not doat the proper time.
2.Without suffering there is no compassion
3.Reading without reflecting is like eating without digesting.
4.Men talk of killing time, while time quietly kills them. -- Dion Boucicault
5.Attitude is a little thing that makes a big difference. -- Winston Churchill
6.Today is the tomorrow we worried about yesterday.
7.If you want to make your dreams come true, the first thing you have to do is wake up.--J.M. Power
8.Nothing is worth more than this day. --Johann Wolfgang von Goethe
9.When I do good, I fell good. When I do bad, I feel bad. That's my religion.
10.There are no menial jobs, only menial attitudes. --William J.Bennett