w3resource

PHP Date Exercises : Get the current date/time of 'Australia/Melbourne'

PHP date: Exercise-14 with Solution

Write a PHP script to get the current date/time of 'Australia/Melbourne'.

Sample Solution:

PHP Code:

<?php
date_default_timezone_set('America/Los_Angeles');
$date = date('m/d/Y h:i:s a', time());
echo $date;
?>

Sample Output:

07/11/2017 12:52:31 am 

N.B.: The result may varry for your system date and time.

Flowchart :

Flowchart: Get the current date/time of 'Australia/Melbourne'

PHP Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a PHP script to get yesterday's date.
Next: Write a PHP script to check if a date is a weekend or not.

What is the difficulty level of this exercise?



PHP: Tips of the Day

SQL injection that gets around mysql_real_escape_string()

Consider the following query:

$iId = mysql_real_escape_string("1 OR 1=1");    
$sSql = "SELECT * FROM table WHERE id = $iId";

mysql_real_escape_string() will not protect you against this. The fact that you use single quotes (' ') around your variables inside your query is what protects you against this. The following is also an option:

$iId = (int)"1 OR 1=1";
$sSql = "SELECT * FROM table WHERE id = $iId";

Ref : https://bit.ly/32q3bJ7