Warning: preg_replace(): Compilation failed: invalid range in character class at offset 4 in /home/protonee/public_html/blog/wp-content/plugins/crayon-syntax-highlighter/crayon_langs.class.php on line 340
Database | Protoneer.co.nz

Category Archives: Database

Simple MySql data to XML with PHP

2013/01/10 10:33 am / 1 Comment /

PHP can be used to create dynamic XML files that get data from your MySql database. Things to consider with the code below: There should be no spaces or open lines before “ All values between ‘[]’ brackets need to be replaced by your own settings. The three header lines will make sure your browser … Read More →

Posted in: Database, Programming

MYSQL – Getting Your Local Time

2013/01/05 10:32 am / 1 Comment /

Time zones are always tricky. Luckily Coordinated Universal Time (UTC) makes it easy to get your local time even if your database is hosted on the other side of the world. The code below returns the local time in New Zealand.

Posted in: Database, Programming