Skip to main content

Posts

Showing posts from March, 2012

PHP get, set and convert Timezone

Set the timezone for the script: define('TIMEZONE', 'Asia/Calcutta'); // INDIA date_default_timezone_set(TIMEZONE); Get the default (script) timezone: date_default_timezone_get(); Get ini set timezone: ini_get('date.timezone'); Get timezone name: date("T"); Set timezone example: date_default_timezone_set('Europe/London'); // GMT GMT to IST conversion example: $event_length = 330; // IST is 5:30 ahead of GMT, so add 330 minutes $timestamp = strtotime(date("H:i:s")); $etime = strtotime("+$event_length minutes", $timestamp); $ist_time = date('H:i:s', $etime); echo '<br>'.'GMT - IST: '.$ist_time;
Post a Comment
Read more

Parsing json data

HTML code: <head> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js" type="text/javascript"></script> <script type="text/javascript"> function get_json() {     $.post('json.php', function(data) {       var resp = eval('(' + data + ')');       var msg = resp.fruits;       console.log(msg);          alert(msg.letter+': '+msg.name);     }); } </script> </head> <body> <div style="margin:10px;" align="left"> <a href="javascript:void(0);" onclick="get_json();">Get Json response</a> </div> </body> PHP code: <?php echo json_encode(array('fruits'=>array('letter'=>'a', 'name'=>'apple'))); ?>
Post a Comment
Read more

Mysql join examples

1. Inner join: Sample Fields in "person" table:  id, email, password, firstname, lastname Sample Fields in "personprofile" table: person_id, age, dob, city, country, phone, mobile Query: select * from person inner join `personprofile` on person.id=personprofile.person_id and person.id=9; 2.  Left join: Sample fields in "employee" table: emp_id (primary), name, active Sample fields in "online" table: id (primary), user_id (references emp_id), online Query: SELECT *  FROM employee e left join online o on e.emp_id = o.user_id where e.active=1; Note the use of "where" in the above query, instead of normal "and". It will give the accurate results.
1 comment
Read more

Different ways of parsing xml data

Here i show the example for parsing xml data, using jquery, javascript and php. Here is a sample xml file, we are using, msg.xml: <messages>     <message>     <name>Sam</name>        <msg>Hi Anna</msg>     </message>     <message>     <name>Kelly</name>     <msg>Hi Anna</msg>     </message>     <message>     <name>Sam</name>     <msg>Hi Anna</msg>     </message>     <message>     <name>Sam</name>     <msg>Hello Anna</msg>     </message>     <message>     <name>Kelly</name>     <msg>Anna</msg>     </message> </messages> The source code: <html> <head> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js" type="text/javascript"></script> <script type="text/javascript"> function loadXMLDoc(d
Post a Comment
Read more