Posts tagged mySQL

Test if MySQL table exists with PHP

Nov 26th

Posted by admin in web

2 comments

I was building up the prototype of my thesis, and wondered how to test if a table exists in database. so I googled.

[php] function table_exists ( $table , $db ) { $tables = mysql<em>list</em>tables ( $db ); while ( list ( $temp ) = mysql<em>fetch</em>array ( $tables )) { if More >

Output mySQL data as XML with PHP

Nov 4th

Posted by admin in web

No comments

Good read about XML traveling

http://www.kirupa.com/web/mysql_xml_php.htm

Dates in PHP and MySQL

Oct 14th

Posted by admin in web

No comments

There are so many ways to format and store the date and time between PHP & mySQL.

This article give a good tutorial.

http://www.bigroom.co.uk/blog/dates-in-php-and-mysql

Choosing Optimal MySQL Data Types

Sep 15th

Posted by admin in web

No comments

This post is for people who are interested in data visualization.

or who just want to read some extended info on Data types.

Check out this post . and hope this is helpful.

http://making-the-web.com/2008/04/27/choosing-optimal-mysql-data-types/