HTML5 iframes line up horizontally

Feel troublesome when want to have several iframes lining-up horizontally? Because at least one of the iframes will move to the next row?

Solution: Make sure that the sum of iframes' "width" is less than 100%. (only applicable if you are using percentage for the width)

To Convert Microsoft Access Table Into MySQL Table - Part 2

There are some common practices to be done when doing this type of conversion:

1. Before converting Access file into CSV file, make sure
a) Data does not contain any backslash (\) and semicolon (;) -- programming common sense.
b) Be careful of the usage of any special characters, because utf8_bin will not recognize it.
c) In Access, when changing column of "Currency", it's better to change into "Text" but not "Number" because the decimal of the data will be removed when changing into "Number" whereas the decimal of data will still be kept if it is changed into "Text".

2. If using phpMyAdmin and MySQL, make sure
a) The format of date/datetime/timestamp and the number/currency/float/decimal in the Access file is compatible with the field formats in the MySQL table -- otherwise you will get something like 0000-00-00 00:00:00 for your datetime, or $123.00 in your price/amount field.
b) My suggestion is to set the date/time into text/varchar format for the conversion, and later change them into date/time format in MySQL using php, and so with the number/currency field.

3. Try to play with it, and you will know what i am talking about.

To Convert Microsoft Access Table Into MySQL Table

Currently using: Microsoft Access 2007, phpMyAdmin.

1. In Access, export into csv file.
a) export the table into text format, however in the file name, make sure the file extension is csv.
b) do not specify any export options.
c) choose 'delimited' format, my preference: delimiter - Semicolon, text qualifier - " -- to match with the options in phpMyAdmin later.
d) finish it.

2. In phpMyAdmin, import the csv file.
a) make sure that the database and tables are using collation of "utf8_unicode_ci", benefit: it will avoid the conversion of special characters when importing the csv file.
b) create a table where the field structure types are to be the same as in the Access table.
c) in the table, select 'import' and choose the csv file.
d) 'character set of the file' is 'utf8', 'Format of imported file' is 'CSV'.
d) finish it.

3. There it goes!

Wifi Outside UTP 2

Long long time not blogging. (again)

Am still feeling lucky to be a UTP student. Since i am going to Alor Setar soon, and it is still quite early from the departure, i therefore try my luck again, here at Ipoh Train Station.

And now, the reason i am writing here is truly an enjoyable experience. Still using my UTP student id to log into Streamyx Zone... :)

But then, when i connect to the Streamyx Zone:


The certificate is not trusted

So, should TM upgrade the system again?

***

Update: Enjoying movie at Ipoh Train Station, no buffering time!

Another Day Passed

After one day, still i am not doing much in homework and study.
What is my ambition?
Where is my ambition?
Should i just be an ordinary one?

Other topic, in the orchestra practice in the afternoon, i was told to "smile" more, and not only with a serious face. So, my old one remains unchanged. Time for me to change? Or shall i remains to be the old one?

Instant Messaging

If it is not to disturb/be disturbed by others, then what for to have IM like gtalk, msn or ym? So please feel free to disturb.

Wifi Outside UTP

Long long time not blogging.

This time really feel lucky to be UTP students.
Now i am at Kampar, using free wifi by logging into Streamyx Zone using my UTP id.
Where is the place? Somewhere near Kampar Pizza Hut.

What can i say?

However, the proxy server is still required to be enabled to surf internet.
But why? Isn't the proxy server just for LAN in UTP?