Iterating through multiple querystrings

furious5

I am currently working on a form which has 52 date fields.

Basically I want to reformat the date and place this in a string to insert in to a table.

I am using the following code, which does exactly what I need:

$date = "10/11/2003";

$datearray = split( "/", $date); // Split the date

$newdate = $datearray[2]."-".$datearray[1]."-".$datearray[0]; // Reformat to mySQL date format

My problem is how can I take each of the date values from the posted form and iterate through the most efficient way?

HalfaBee

If you only have date fields this will do

Something like this

$dateArray[] = preg_replace( '#([0-9]+?)/([0-9]+?)/([0-9]{4})#','\3-\1-\2',$_POST );

HalfaBee

furious5

That looks spot on.

However how do I then access the array?

The array returned looks something like this:

Array ( [0] => Array ( [date1] => 10/11/03 [price1] => [change_day1]  ) )

I have tried to access the array using:

echo "DATE TEST".$dateArray['date1'];

HalfaBee

You will have to do each one seperately

use a foreach loop on $_POST and keep the keys.

Halfabee ( not going to write it all for you 😃 )

furious5

Right ok, I've made a little more progress.


$dateArray[] = preg_replace( '#([0-9]+?)/([0-9]+?)/([0-9]{4})#','3-1-2',$_POST);

foreach($dateArray as $val){
	foreach($val as $key=>$final_val){
		print "$key: $final_val<br>";
	}

}

But I still can't access the individual parts of the array, can anyone help me with this next bit of code? Once I've got that I should be home and dry.

HalfaBee

Did I say do a foreach on $dateArray ?

HalfaBee

furious5

Ok I've used the For Each on the Post

Like so:

foreach($_POST as $val){
	print $val."<br>";
}

How do I then reference the date items I want to amend?

HalfaBee

Oh damm, I give in.

foreach($_POSTl as $key=>$final_val){
     $dateArray[$key] = preg_replace( '#([0-9]+?)/([0-9]+?)/([0-9]{4})#','3-1-2',$final_val);
}

furious5

Thank you, I had actually worked it out this afternoon once I looked over what you had said again and referred to php.net.

Sorry if I was a little dim, I'd never used a for each loop to return a key before, as they say you learn something new everyday!

HalfaBee

You were pretty close.

www.php.net is your best friend.

HalfaBee

furious5

Indeed, thanks for not giving me the answer straight off, that way I would have never been forced to learn about obtaining keys.

HalfaBee

Something researched is something remembered.

furious5

Never a truer word spoken!