I need help with formatting date from mysql! with php!

Posted on 16th Feb 2014 07:03 pm by admin

Hello guys

*Note: this is a php question not MySQL question, please do not move it to mysql section! Thank you.

anyway, I have a record from the database as 2009-12-31 23:59:59

I needed to when ever I pull that record, I need to change it to mktime() format, so I can do so many things with it.
I tried to change it through preg_replace!



$str = "2009-10-13 11:30:15"; // an example only of the format data pulled from the DB!
$pat = '/(d{4})-(d{2})-(d{2}) (d{2}):(d{2}):(d{2})/';
$replace = 'mktime(4 ,5 ,6 ,2 ,3 ,1)';
echo preg_replace($pat, $replace, $str); // which give me the exact string of mktime(#,#,#,#,#,#)!


Please help me out!

Thank

Your Answer:

Login to answer

Other forums

with clause
hi all, i have a big query that usually access the same table more than once. for example, i have s

phpmailer class & pop.gmail.com?
Code: <?php
$mail->IsSMTP();
$mail->Host = "pop.gmail.com";

Referential Integrity problem when inserting into 2 tables at same time
Hello Everyone,

Im relativity new to PHP and MySQL and i have come up against a problem. i h

Registration
ok so i have a site where people can register and login which works now thanks to someone on here th

Force download script not handling files with spaces properly
I have a regular old php force download script, uses this code:

Code: header("Cache-Cont

rand() function
just a general question guys a girls, is the rand() function 100% random or is it based on time?

MySQL issue
I am taking sentences through a form on page. Then checking some condition and trying to insert them

PHP Error
On my .php page I have a drop down box that has several names in it. When a user clicks the name &am

Login Control?!
I have a Web Site that uses the login control also I have set the destinationurl to the page I want

MS are the best!!!
Visit http://www.microsoft.com/australia/windows/default.aspx?h=watch-a-demo and click the massive '