Date Function

durahman

I had this problem:

my page contain a date input which I use the following script to convert into YYYY-MM-DD format before inserting into the table:

$date_elem = explode('-',$indate);
$tj = date('Y-m-d', mktime( 0,0,0,$date_elem[1],$date_elem[0],$date_elem[2]) );

The date was inserted successfully

Problem is when I retrieve the date and make a change to the date and use the the same script before updating the table I had this message:

"PHP Notice: A non well formed numeric value encountered in c:\Inetpub\wwwroot\dakwa\edit_page.php on line 23"

Line 23 is :
$tj = date('Y-m-d', mktime( 0,0,0,$date_elem[1],$date_elem[0],$date_elem[2]) );

Can anyone tell me what is wrong.

rincewind456

Have you tried echoing out $tj to see what it looks like? It sounds like your not forming the date as you may think you are.

durahman

Sorry I forgot to mention the Problem arises when I update the table without changing the date.

The proses is like this

Retrieve from db using :

DATE_FORMAT(tarikh_jenayah_dilakukan,'%d-%m-%Y') as indate,

Update the table using:

$date_elem = explode('-',$indate);
$tj = date('Y-m-d', mktime( 0,0,0,$date_elem[1],$date_elem[0],$date_elem[2]) );

I did echo the date before updating:

echo $indate gives 14-03-2006
echo $tj gives 2006-03-14

If I change $indate say to 15-03-2006 there is no warning message.

I used a javascript date picker to select the date using dd-mm-yyyy format.

TALU

Change this

durahman wrote:
Update the table using:

$date_elem = explode('-',$indate);
$tj = date('Y-m-d', mktime( 0,0,0,$date_elem[1],$date_elem[0],$date_elem[2]) );

to:

$tj = date('Y-m-d', strtotime(mktime( 0,0,0,$date_elem[1],$date_elem[0],$date_elem[2])));

Make time creates a string, date requires a timestamp, it does work otherwise but will throw an error.

Weedpacket

[man]mktime[/man] returns a timestamp.

shu

TALU wrote:
Make time creates a string, date requires a timestamp, it does work otherwise but will throw an error.

No, mktime returns a integer timestamp! Try forcing the values to integers:

$tj = date('Y-m-d', mktime(0, 0, 0, (int)$date_elem[1], (int)$date_elem[0], (int)$date_elem[2]);

Installer

$indate = '10-05-2007';
$date_elem = explode('-', $indate); 
$tj = date('Y-m-d', strtotime($date_elem[2] . $date_elem[1] . $date_elem[0]));
echo $tj;  // 2007-05-10

$indate = '10-05-2007';
$date_elem = explode('-', $indate); 
$tj = implode('-', array_reverse($date_elem));
echo $tj;  // 2007-05-10

or (Edit: Ignore this one. It's wrong.)

$indate = '10-05-2007';
$indate = str_replace('-', '/', $indate);
$tj = date('Y-m-d', strtotime($indate));
echo $tj;  // 2007-10-05