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!
Monday, 11 April 2011
Tuesday, 14 December 2010
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!
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:
So, should TM upgrade the system again?
***
Update: Enjoying movie at Ipoh Train Station, no buffering time!
Saturday, 14 August 2010
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?
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?
Thursday, 12 August 2010
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.
Friday, 19 March 2010
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?
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?
Wednesday, 9 December 2009
How Different Web Browsers Handle history.go Function
I am using php and html to do the case.
Step 1:
Create a search page using form which the action of the form will be the search page itself, e.g. pageA.html.
Step 2:
In pageA.html, create a link to a new page, e.g. pageB.html that will be shown after submission of form.
Step 3:
In pageB.html, create a button that use history.go(-1) to move backward to the previous page.
Step 4:
Now let's try it.
a. Go to pageA.html
b. Click on the "submit" button.
c. You should be brought to pageA.html with a link to pageB.html now.
d. Click on the link.
e. You should be brought to pageB.html
f. Now click on the "back" button
g. You should have the following the following result
Opera 10.10: pageA.html after form submission is still there
Google Chrome 4.0.249.30: error page with title "Confirm Form Resubmission"
IE 7.0.6000.16890: error page with title "Webpage has expired"
Safari 4.0.4(531.21.10 ): a confirmation prompt to ask you to resend the form
Mozilla Firefox 3.5.5: a confirmation prompt to ask you to resend the form
Step 5:
However, if you access pageA.html by parsing variables using URL and not by submitting the form, and then click on the link to pageB.html and click "back" button in pageB.html, you will see that you will be at the pageA.html where it has the variables parsed using URL already.
E.g. in pageA.html
So you will need to consider the structure of the website before using history.go(-1).
Step 1:
Create a search page using form which the action of the form will be the search page itself, e.g. pageA.html.
Step 2:
In pageA.html, create a link to a new page, e.g. pageB.html that will be shown after submission of form.
Step 3:
In pageB.html, create a button that use history.go(-1) to move backward to the previous page.
Step 4:
Now let's try it.
a. Go to pageA.html
b. Click on the "submit" button.
c. You should be brought to pageA.html with a link to pageB.html now.
d. Click on the link.
e. You should be brought to pageB.html
f. Now click on the "back" button
g. You should have the following the following result
Opera 10.10: pageA.html after form submission is still there
Google Chrome 4.0.249.30: error page with title "Confirm Form Resubmission"
IE 7.0.6000.16890: error page with title "Webpage has expired"
Safari 4.0.4(531.21.10 ): a confirmation prompt to ask you to resend the form
Mozilla Firefox 3.5.5: a confirmation prompt to ask you to resend the form
Step 5:
However, if you access pageA.html by parsing variables using URL and not by submitting the form, and then click on the link to pageB.html and click "back" button in pageB.html, you will see that you will be at the pageA.html where it has the variables parsed using URL already.
E.g. in pageA.html
So you will need to consider the structure of the website before using history.go(-1).
Tuesday, 3 November 2009
Anxiety
To talk, you may not like it and not accept it.
Not to talk, but i cant stop to tell the facts to the others.
Should i talk or not?
Being open-minded to myself save me a lot of problems.
Being open-minded to others may cause problems to the others.
Should i be open-minded to all people?
I have a feeling of anxiety recently. It seems that i am going to lost my direction again. To uphold my principles of living, i feel it is not easy.
I want to be frank on everything i want to talk, but it seems difficult (? ) as i want to take care of others' feelings. Should i not consider others' feelings? Am i selfish if i want to be frank to the others?
Not to talk, but i cant stop to tell the facts to the others.
Should i talk or not?
Being open-minded to myself save me a lot of problems.
Being open-minded to others may cause problems to the others.
Should i be open-minded to all people?
I have a feeling of anxiety recently. It seems that i am going to lost my direction again. To uphold my principles of living, i feel it is not easy.
I want to be frank on everything i want to talk, but it seems difficult (? ) as i want to take care of others' feelings. Should i not consider others' feelings? Am i selfish if i want to be frank to the others?
Subscribe to:
Posts (Atom)