Thursday, 26 May 2016

PHP - Display script memory usage

1 Byte = 8 Bit 1 Kilobyte = 1024 Bytes 1 Megabyte = 1048576 Bytes 1 Gigabyte = 1073741824 Bytes echo "Memory Usage: " . (memory_get_usage()/1048576) . " MB \n"; ...

Wednesday, 25 May 2016

MySqlDump export and MySQL import

To export data as a backup you can’t beat mysqldump.# mysqldump -u username database > database_2007-05-14.sqlThen to restore a database you would use:# mysql -u username -p database < database_2007-05-14.sql...

Getting differences between dates quickly in PHP or MySQL

Using PHP: <?php$expireDate = "2006-02-07"; $year = substr($expireDate, 0, 4);  $month = substr($expireDate, 5, 2); $day = substr($expireDate, 8, 2); $splitExpireDate = (mktime(0, 0, 0, $month, $day, $year)); $today = (mktime(0, 0, 0, date("m"), date("d"), date("Y")));  $difference = (($today) - ($splitExpireDate)); $convertToDays = ($difference/86400); echo $convertToDays; ?> Using MySQL: SELECT (TO_DAYS(expire_date) - TO_DAYS(CURDATE())) AS days_expired FROM tablenam...

Wednesday, 11 May 2016

Multiple Files Simultaneous Upload Array Programming Tutorial

Learn to program PHP multiple file upload applications. Which is the art of uploading many files as an array in a single form request, and moving them to your server all at once. At the end of the lesson we link you to an Ajax and PHP file upload application with HTML5 progress bar included that you can take to experiment with sending files through Ajax. We also discuss your server limits regarding how many files can your specific server can upload simultaneously and the size the files can be. Each server can be set differently by the server...

Wednesday, 4 May 2016

PHP - get all keys from a array that start with a certain string

Solution:$unprefixed_keys = preg_filter('/^foo-(.*)/', '$1', array_keys( $arr ));Example:<?php$arr_main_array = array('foo-test' => 123, 'other-test' => 456, 'foo-result' => 789);$unprefixed_keys = preg_filter('/^foo-(.*)/', '$1', array_keys( $arr_main_array ));print_r($unprefixed_keys);?>...