Posted by Shek on April 12, 2011 under MySQL | 
MySQL’s date field type default is in yyyy-mm-dd format, and it is not practical in some cases when we want to use another formating representation such as dd/mm/yyyy. Of course we could use PHP to convert it but the best way I find is to convert it through SQL before any php operation, here is an example which I which like to show you:
Posted by Shek on March 17, 2011 under Misc, MySQL |
If you are a PHP programmer, phpMyAdmin should be a familiar tool for you. But to deploy phpMyAdmin takes a lot of steps and setting. Therefore I recommend Adminer as an alternative to phpMyAdmin.
Posted by Shek on March 16, 2011 under MySQL |
In this post, I am going to talk about how to get data from 2 mysql tables instead of 1 table with a sql.
Here are 2 mysql tables (The field types are ignored in this examples): Read more of this article »
Posted by Shek on October 4, 2009 under MySQL, PHP |
Editor’s note: In cases, we have to include PHP variables within a MySQL query, here is how it is done:
Read more of this article »
Posted by Shek on August 20, 2008 under MySQL |
To import Excel data into the MySQL database’s table is easy. All you have to do is to save the Excel file as “CSV” Format, and use phpmyadmin to complete the job for you. Here I have create an example to show you how to do so:
Posted by Shek on June 12, 2008 under MySQL |
If you website is not host in home computer but in an external public company and sometimes you might like to test some PHP and MySQL applications, it is not necessary to upload the files there for testing before it actually goes live. We could install a PHP, MySQL and Apache environment in windows for testing. The package is called “AppServ”, and here is how you do it:
