Welcome to phpMyBackupPro Here on the offcial homepage you will find all informations about phpMyBackupPro (pMBP). phpMyBackup Pro is a very easy to use, free, web-based MySQL backup application, licensed under the GNU GPL. You can create scheduled backups, manage and restore them, download or email them and a lot more!
Category Archives: MySQL
Mysql utf-8 characters
mysql_query(“SET CHARACTER SET utf8”); mysql_query(“SET NAMES ‘utf8′”); mysql_query(“SET COLLATION_CONNECTION=utf8_general_ci”); mysql_query(“SET CHARACTER_SET_CLIENT=utf8”); mysql_query(“SET CHARACTER_SET_RESULTS=utf8”); [ad code=1]
Storing Hierarchical Data in a Database
Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own cms: there will be a moment that you’ll want to store hierarchical data in a database. And, unless you’re using a XML-like database, tables aren’t hierarchical; they’re just a flat list. You’ll have …
Mysql Concat + Join fields
SELECT CONCAT(last_name,’, ‘,first_name) full_name FROM mytable ORDER BY full_name; [ad code=1]
Dates in PHP and Mysql
$mysqldate = date( ‘Y-m-d H:i:s’, $phpdate ); $phpdate = strtotime( $mysqldate );
MySQL Tips and Functions
MySQL Tips and Functions • Comparison operators = Equals < Less than <= Less than or equal to > Greater than >= Greater than or equal to <> Not equal to != Not equal to LIKE Compare strings