Date formatting

[UnitedWeFall]

Hey guys quick question.

I have the following code:

$count = count($_POST['estimatedDelivery']);
for ($i = 0; $i < $count; $i++) {
   $sql2 = "UPDATE `smail` SET `estimatedDelivery` = '" . $_POST['estimatedDelivery'][$i] . "' WHERE `psNumber` = '" . mysql_real_escape_string($_POST['id'][$i]) . "'";
   mysql_query($sql2);
}

$_POST['estimatedDelivery'] contains dates in the DD-MM-YYYY format. MySQL won't accept this format. Could anyone tell me what code I will need to format the date as YYYY-MM-DD?

Thanks in advance.

[johanafm]

$arr = explode("-", $_POST['estimatedDelivery']);

$date = $arr[2] . '-' . $arr[1] . '-' . $arr[0];

[UnitedWeFall]

johanafm;10924697 wrote:

$arr = explode("-", $_POST['estimatedDelivery']);

$date = $arr[2] . '-' . $arr[1] . '-' . $arr[0];

Thanks for that..

When I put $date into my update query I just get 0000-00-00 being sent to the database. I think that means there's an error?

[Bjom]

show us the query.

is 0000-00-00 really being sent, or being stored?

[UnitedWeFall]

Bjom;10924755 wrote:

show us the query.

is 0000-00-00 really being sent, or being stored?

When I echo $date I get: --ArrayError

So if the date row in the DB is varchar, it gets inserted like this:

-

A
r
r
a
y
etc... row by row. Weird.

[Weedpacket]

First, the date column in the database shouldn't be a varchar, it should be a date.

Second, it would appear that $_POST['estimatedDelivery'] is an array, not a string.

[UnitedWeFall]

Weedpacket;10924789 wrote:

First, the date column in the database shouldn't be a varchar, it should be a date.

Second, it would appear that $_POST['estimatedDelivery'] is an array, not a string.

Yep I just changed it to varchar to see what was actually being written to the database.

As for the second problem, how do I modify the date format code to work with the $_POST array? I'm still a bit of a newb 😛

$arr = explode("-", $_POST['estimatedDelivery']); 

$date = $arr[2] . '-' . $arr[1] . '-' . $arr[0]; 

[johanafm]

The little explode-snippet I provided didn't go along the lines of the code previously presented due to pure laziness. I just wanted to provide the general idea, and Weedpacket is spot on from looking at the code in your first post.
Keep the loop and explode($_POST['estimatedDelivery'][$i])

[UnitedWeFall]

Got it sorted by putting it in the while loop.

Thanks guys, much appreciated 🙂