w3resource

PHP Class Exercises : Convert a string to Date and DateTime

PHP class: Exercise-7 with Solution

Write a PHP script to a convert string to Date and DateTime.

Sample Date : '12-08-2004'
Note : PHP considers '/' to mean m/d/Y format and '-' to mean d-m-Y format.

Sample Solution:

PHP Code:

<?php
$dt = DateTime::createFromFormat('m-d-Y', '12-08-2004')->format('Y-m-d');
echo $dt;
?>

Sample Output:

2004-12-08

Flowchart :

Flowchart: Convert a string to Date and DateTime

PHP Code Editor:

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

Previous: Write a PHP calculator class which will accept two values as arguments, then add them, subtract them, multiply them together, or divide them on request.
Next: PHP JSON Exercises Home.

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