PHPMySql help

[maestro]

Ok...

I I want to convert date coming from my mysql database i.e 2008-02-01, lets say to date in plane english i.e Feb 2nd, 2008.
I have tried all the dateTime functions I could find, but all they do is return the current date for all the entries, even though they are different.

What is the solution?
Thanks

[Bubus]

This is for date format like March 10, 2008

// Assuming today is: March 10th, 2001, 5:16:18 pm

$today = date("F j, Y, g:i a");                 // March 10, 2001, 5:16 pm
$today = date("m.d.y");                         // 03.10.01
$today = date("j, n, Y");                       // 10, 3, 2001
$today = date("Ymd");                           // 20010310
$today = date('h-i-s, j-M-y, it is w Day z ');  // 05-16-17, 10-Mar-01, 1631 1618 6 Fripm01
$today = date('\i\t \i\s \t\h\e jS \d\a\y.');   // It is the 10th day.
$today = date("D M j G:i:s T Y");               // Sat Mar 10 15:16:08 MST 2001
$today = date('H:m:s \m \i\s\ \m\o\n\t\h');     // 17:03:17 m is month
$today = date("H:i:s");                         // 17:16:17
?> 

[maestro]

Originally Posted by Bubus

This is for date format like March 10, 2008

// Assuming today is: March 10th, 2001, 5:16:18 pm

$today = date("F j, Y, g:i a");                 // March 10, 2001, 5:16 pm
$today = date("m.d.y");                         // 03.10.01
$today = date("j, n, Y");                       // 10, 3, 2001
$today = date("Ymd");                           // 20010310
$today = date('h-i-s, j-M-y, it is w Day z ');  // 05-16-17, 10-Mar-01, 1631 1618 6 Fripm01
$today = date('\i\t \i\s \t\h\e jS \d\a\y.');   // It is the 10th day.
$today = date("D M j G:i:s T Y");               // Sat Mar 10 15:16:08 MST 2001
$today = date('H:m:s \m \i\s\ \m\o\n\t\h');     // 17:03:17 m is month
$today = date("H:i:s");                         // 17:16:17
?> 

Appreciate the help...but problem is, as U can see, that code returns the current date for that day...I dnt want that, just want to format the date in "d-m-y" to english

[Bubus]

So heres your function...
Lets say your database stores your date "2008-02-01" in the string $date

heres what you do:

PHP Code:

<?php
    list($year, $month, $day) = split("-", $date);
    $date = date('j-M-y', mktime(0, 0, 0, $month, $day, $year));
    echo $date;
?>

[maestro]

Originally Posted by Bubus

So heres your function...
Lets say your database stores your date "2008-02-01" in the string $date

heres what you do:

PHP Code:

<?php
    list($year, $month, $day) = split("-", $date);
    $date = date('j-M-y', mktime(0, 0, 0, $month, $day, $year));
    echo $date;
?>

why are we splitting the original date strings?

[maestro]

This isnt a solution

[Bubus]

Originally Posted by maestro

why are we splitting the original date strings?

You want to convert 2008-02-01 to the format 01-Feb-08
First you split (using the "-" as separator), so you get the composite date components in
$year, $month, and $day.

Then you call mktime() to convert those composites into time.
You call date() to format that time into the new format j-M-y.

[Bubus]

PHP Code:

 <?php
list($year, $month, $day) = split("-", $date);
$date = date('M d, Y', mktime(0, 0, 0, $month, $day, $year));
?>

This is for converting to format

Feb 01, 2008.

[maestro]

works not

[Uncle Sunday]

PHP is a little complicated as php deals with dates in the UNIXTIMESTAMP form so you have to convert to that before you can format it in php.

I have a couple solutions:
Sol 1: Here is are pure mysql solution.


If the column datatype is date try this:

PHP Code:

SELECT *, date_format(your_date_column, '%M %d, %Y, %l:%i%p') AS newdate FROM your_table; 


and in your loop print $yourrow['newdate'] where ever you want.

2. MySQL has a function to convert any time of timeand date or date datatype column into a unix timestamp for you.
Use SELECT * UNIX_TIMESTAMP(your_date_column) FROM `timeanddate`

and then use the php date function to convert the date to the desired format.
For neatness, i like to use aliases.
e.g.

PHP Code:

SELECT * UNIX_TIMESTAMP(your_date_column) AS newdate FROM `timeanddate` 


then in php, simply..

PHP Code:

$unixformateddate = $yourrow['newdate']

$prettydate= date("j-M-y",$unixformateddate);

print $prettydate; 


Oila!
Give this a shot. It should work. I tried the MySql part.

[maestro]

The mysql part is on point!!

[Uncle Sunday]

nice one

[edux2]

Bros can u pls help me with either AVG Latest edition or Avast antivirus with the crack. if u can help upload and send to edux2@yahoo.com. i need it badly