Apart from giving the ‘Server version’, this command also displays the current status of the mysql server. mysqladmin -u root -p version Enter password: /Applications/MAMP/Library/bin/mysqladmin Ver 8.42 Distrib 5.5.9, for osx10.6 on i386 Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. […]
Continue Reading →You can use mysqladmin ping for this. Type following command on your terminal and give your password. It will show you the status of mysql server. # mysqladmin -u root -p ping Enter password: mysqld is alive
Continue Reading →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 →