FixDate

[furious5]

I am having a bit of a problem with formatting dates.

My first problem is that although my db has a value of: 2003-07-14

Once I apply my FixDate fix it returns a date like this: 14 Jul 2000
I can't understand why this is happening. Any ideas?

Here is the code I am using:

//Function to fix mySQL date format
function fixDate($val)
{
//Split up in to components
$arr = explode(" ",$val);
$datearr = explode("-", $arr[0]);

//Create timestamp with mktime(), format it with date()
return date("d M Y", mktime(0,0,0, $datearr[1], $datearr[2], $datearr[3]));
}

My second problem occurs when I try to return this value in an input field, where only the day part of the date is returned. Here is the code I am using for this:

print "<td class=general><input type=text name=date value=";
print fixDate($date); 
print "></td>"; 

Any ideas on these problems would be greatly appreciated.

[tbach2]

Assuming you are using a timestamp (14) field:

SELECT UNIX_TIMESTAMP(date) AS udate FROM your_table ...

Now you have the unix timestamp you need for date().

when accepting an input from a form, you can use strtotime(), which accepts all kinds of input and changes it into a unix timestamp.

hth

[furious5]

I didn't have timestamp set up, but have amended the date field to incorporate this.

I've set up a quick query to see it work, before incorporating it in to the rest of my code, but I'm not getting anything back.

As a side not I am running Win2K to test all my work before uploading it to the web server, would this be causing any problems:

<?php
include("config.php");

mysql_connect($server, $username, $password) or die("Couldn't Connect to Database");

// Select Database
mysql_select_db($database) or die("Couldn't Select Database");

$sql = "SELECT UNIX_TIMESTAMP(date) AS udate FROM job WHERE jobid = '25'";
$sql_result = mysql_query($sql) or die('SQL Error - died at SQLQuery1'); 
//$num_rows = mysql_num_rows($sql_result);

$date = $row["date"];
//echo $sql;

while($row = mysql_fetch_array($sql_result)){
echo "DATE:$date";

}	

?>

[tbach2]

$date = $row["date"];
//echo $sql;

while($row = mysql_fetch_array($sql_result)){
echo "DATE:$date";

}

woops, should be $date = $row["udate"]

and don't you have the cart ($row) before the horse (fetch)? 😕

while($row = mysql_fetch_array($sql_result) ) {
   $date = $row['udate'];
   echo "DATE: " . data("m/d/Y",$date) . '<br>'
}

[furious5]

Yep ok missed that glaringly obvious bit.

I'm now getting the following error:

Fatal error: Call to undefined function: data() in d:\web dev\jobclever\test.php on line 17

Which would be this line:

echo "DATE: " . data("m/d/Y",$date) . "<br>" ;

Any ideas why?

[tbach2]

:rolleyes:
ROFL

I guess we all do it :p

date() would work a little better, huh...

[furious5]

LOL

Thats a great help though, thank you.

[Weedpacket]

Of course, the problem with the original code is that it's using $datearr[1], $datearr[2] and $datearr[3] instead of $datearr[1] (for the month), $datearr[2] (for the day) and $datearr[0] (for the year). Remember, PHP follows the standard convention of indexing arrays starting at 0.

Then again, "2003-07-14" is in a format that can be passed straight to strtotime() to format into a timestamp.