Here is the way to change the MySQL root user password & You can use mysqladmin command for this. # mysqladmin -u root -ptmppassword password ‘newpassword’ # mysql -u root -pnewpassword Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.1.25-rc-community MySQL Community Server (GPL) […]
Continue Reading →You can get currency conversions in a simple format from yahoo: For example, to convert from GBP to EUR: http://download.finance.yahoo.com/d/quotes.csv?s=GBPEUR=X&f=sl1d1t1ba&e=.csv
Continue Reading →As of PHP 5.3 there are two ways to define constants: Either using the const keyword or using the define() function: const CONST_VAL = ‘CONST’; define(‘CONST_VAL’, ‘CONST’); The fundamental difference between those two ways is that const defines constants at compile time, whereas define defines them at run time. What does that mean for you? […]
Continue Reading →This is probably wrong as this does not work: $mysqldate = date(“m/d/y g:i A”, $datetime); And This will works: $phpdate = strtotime( $mysqldate ); $mysqldate = date( ‘Y-m-d H:i:s’, $phpdate );
Continue Reading →Introduction Represents a date period. A date period allows iteration over a set of dates and times, recurring at regular intervals, over a given period. Just an example to include the end date using the DateTime method. <?php $begin = new DateTime( ‘2012-11-01’ ); $end = new DateTime( ‘2012-11-11’ ); $end = $end->modify( ‘+1 day’ […]
Continue Reading →Here is the php timezone array. You can use this as a dropdown and set current timezone using date_default_timezone_set(‘Europe/London’); <?php $tz = array ( ‘Pacific/Apia’ => ‘[GMT-11:00] West Samoa Time (MIT)’, ‘Pacific/Niue’ => ‘[GMT-11:00] Niue Time (Pacific/ Niue)’, ‘Pacific/Tahiti’ => ‘[GMT-10:00] Tahiti Time (Pacific/ Tahiti)’, ‘HST’ => ‘[GMT-10:00] Hawaii Standard Time (HST)’, ‘America/Adak’ => ‘[GMT-10:00] […]
Continue Reading →If you want to allow sessions on all the subdomains then here are 3 options. Place this in your php.ini: session.cookie_domain = “.example.com” In your .htaccess: php_value session.cookie_domain .example.com As the first thing in your script: ini_set(‘session.cookie_domain’, ‘.example.com’ );
Continue Reading →All Selector (“*”) This will select all elements. Caution: The all, or universal, selector is extremely slow, except when used by itself. Example 01: Find every element (including head, body, etc) in the document. Note that if your browser has an extension/add-on enabled that inserts a script or link element into the DOM, that element […]
Continue Reading →If you want only input 0-9 and only once “.” then you can use following regex. /^-?(?:\d+|\d*\.\d+)$/ This matches normal floats e.g. 3.14, shorthands for decimal part only e.g. .5 and integers e.g. 9 as well as negative numbers. echo preg_match(‘/^-?(?:\d+|\d*\.\d+)$/’, ‘123.12’); // return 1 echo preg_match(‘/^-?(?:\d+|\d*\.\d+)$/’, ‘123.12.2’); // return 0
Continue Reading →The match() method searches a string for a match against a regular expression, and returns the matches, as an Array object. Note: If the regular expression does not include the g modifier (to perform a global search), the match() method will return only the first match in the string. This method returns null if no […]
Continue Reading →