[RESOLVED] multiple form input date time help

fishy

I am creating a scheduling system for my schools athletics. What I am trying to do is insert a season into a database from one form. This season will have multiple games each going into is own entry in a database.

I have read a few threads and they have used an array of inputs and use a foreach and implode to insert the values into a DB. That works fine for what I am doing except for the date time as I have to process them with mktime and I am just confused on how to get the array to mktime and then back to the array that I can insert into the Db.

Should I put the times in there own array and then process them into a timestamp

then append the timestamp to the array that contains the opponent location etc. or how. I can post some code or page if need be.

thanks

tom

bpat1434

Wow... that was confusing....

That works fine for what I am doing except for the date time as I have to process them with mktime and I am just confused on how to get the array to mktime and then back to the array that I can insert into the Db.

I'd say you can work with it in the array before you implode it into a string.

$arr = array(
        'season'=>'fall',
        'year' => '2006',
        'games' => array(
                0 => array( 'date' =>'August 1, 2006', 'time'=>'1:30 pm', 'place'=>'home', 'opponent'=>'team2'),
                1 => array( 'date' =>'August 8, 2006', 'time'=>'3:30 pm', 'place'=>'away', 'opponent'=>'team4')
        )
);

Given that array, just do something like:

<?php
// Given $arr....
foreach($arr['games'] as $id=>$game)
{
  // Each $game is now an array....
  $new = array('datetime'=>'', 'place'=>$game['place'], 'opponent'=>$game['opponent']);

  $datetime = strtotime($game['date'].' '.$game['time']);
  $new['datetime'] = $datetime;

  $arr['games'][$id] = $new;
}

var_dump($arr);
?>

Seems to get you what you want (or something like it):

array(3) {
  ["season"]=>
  string(4) "fall"
  ["year"]=>
  string(4) "2006"
  ["games"]=>
  array(2) {
    [0]=>
    array(3) {
      ["datetime"]=>
      int(1154453400)
      ["place"]=>
      string(4) "home"
      ["opponent"]=>
      string(5) "team2"
    }
    [1]=>
    array(3) {
      ["datetime"]=>
      int(1155065400)
      ["place"]=>
      string(4) "away"
      ["opponent"]=>
      string(5) "team4"
    }
  }
}

fishy

fishy wrote:
That works fine for what I am doing except for the date time as I have to process them with mktime and I am just confused on how to get the array to mktime and then back to the array that I can insert into the Db.

HAHA Yeah I guess that was a bit of a mess. Should have taken some time to figure out what I was saying before just blindly mashing keys. Thanks immensly for the help I am amazed at this site and how helpful you guys and girls are. I will try your code tommorow when I get back to work. I need to work through these things with the files "in hand" as trying to conceptualize arrays sometimes cause my head to spin.

BTW

Is strtotime the best function ever? I read the php manual on it a couple of times and i thought it was joking. when it said

strtotime -- Parse about any English textual datetime description into a Unix timestamp

Will it Parse the butt crack of dawn to a Unix timestamp?

thanks again

tom

bpat1434

Dunno... is the "butt crack of dawn" within the PHP date range (Jan 1, 1970 to like 2037 or something)? If so then YES!!

fishy

alright so I ended up looking around and found array_map which does what I want. this is what I have so far. bpat I tried what you had coded but I got somewhat confused. So I went this direction.

foreach($dater as $id=>$game)
{
// Each $game is now an array....
$datetime[] = strtotime($id['mon'].' '.$id['day'].' '.$id['year'] .' '.$id['hour'] .' '.$id['minute'] .' '.$id['am_pm'] );
}
print_r($datetime);
print_r($events);
echo" <p>";
$r = array_map(null, $datetime, $events);

print_r($r);

what I get is and nested array with my timestamp on the front of all the other game data. I am having trouble calling the data out of the inner array though.

I tried this but it is giving me an error.
foreach($r as $key => $value){
foreach($key as $val =>$stuff){ echo implode(",",array_values($stuff));}
}

this is what the $r array prints out plus more depending on the number of games.

Array (

     [INDENT] [0] => Array  [/INDENT]
                           [INDENT][0] => 1140727169
                           [1] => Array 
                                              [\'Opponents\'] => BFA St. Albans 
                                              [\'Notes\'] => 
                                              [\'Site\'] => Home [/INDENT]
      [1] => Array 
                             [0] => 1140727169 
                             [1] => Array 
                                                    [\'Opponents\'] => BFA St. Albans 
                                                    [\'Notes\'] => 
                                                    [\'Site\'] => Home

So do I need 3 foreach loops to pull the data out.

Thanks

Tom

sorry gotta go can't get the array formatting right. will try to fix later

bpat1434

try:

foreach($r as $key=>$value)
{
  foreach($value as $key2=>$value2)
  {
    // Your code here....
  }
}

fishy

I just can seem to get it right. I can pull all the variables out of the nested arryas but can't get them back together. tried to use array push to add on the the end but I think my order of operations is messed up. Is there any place where I can go to look up multidimesional arrays?

The books I have don't cover in enough depth

I am thinking I need a for loop instead of a foreach. because when I try to combine the values with the loop posted above since I have one array that is nested and the other that is just an array it ether errors me saying that the arugment is not an array or it combines the array with only one value or all the values all the time.

I tried pulling the values out of the nested loop and then push them on the end of the original array but that wasn't working.

bpat1434

well, multi-dimensional arrays are nothing more than singular arrays inside of an array. You're only making it as hard as you need to. You could try the manual for arrays....

fishy

bought some more books, read the manual again and with the help of a student that has done a buch of Java figured out the appending the datetime array to the other array. The idea of the array is not hard trying to do anything with them causes me trouble so that piece works

But I am still have problems with strtotime. I have this code

$items = $_POST[datea];

foreach ($items as $val){ 
print_r($val);
echo "$val[0]$val[1]$val[2]$val[3]$val[4]$val[5]";
$datetime = strtotime("val[0].''.$val[1].''.$val[2].''.$val[3].''.$val[4].''.$val[5]");
echo "<p>$datetime<p>";

}

It returns

Array ( [0] => 11 [1] => 1 [2] => 2006 [3] => 1 [4] => 00 [5] => PM ) 1112006100PM
-1

Array ( [0] => 11 [1] => 1 [2] => 2006 [3] => 1 [4] => 00 [5] => PM ) 1112006100PM

-1

Array ( [0] => 11 [1] => 1 [2] => 2006 [3] => 1 [4] => 00 [5] => PM ) 1112006100PM

-1

so the strtotime is not working but the string looks okay or does it have to have commas in it. will try that next.

Tried formatting date more but still returning -1

thanks

tom

bpat1434

$datetime = strtotime("val[0].''.$val[1].''.$val[2].''.$val[3].''.$val[4].''.$val[5]");

should be:

$datetime = strtotime($val[0].'/'.$val[1].'/'.$val[2].' '.$val[3].':'.$val[4].' '.$val[5]);

This works for me:

$arr = array(0=>array('11','1','2006','1','00','PM'), 1=>array('12','1','2006','3','30','PM'));

foreach($arr as $val)
{
	echo $val[0].'/'.$val[1].'/'.$val[2].' '.$val[3].':'.$val[4].' '.$val[5].' |=| ';
	// The easier longer way is commented out....
	// $str = $val[0].'/'.$val[1].'/'.$val[2].' '.$val[3].':'.$val[4].' '.$val[5];
	// $datetime = strtotime($str);
	$datetime = strtotime($val[0].'/'.$val[1].'/'.$val[2].' '.$val[3].':'.$val[4].' '.$val[5]);
	echo $datetime.'<br>';
}

11/1/2006 1:00 PM |=| 1162404000
12/1/2006 3:30 PM |=| 1165005000

fishy

perfect!

thanks

Tom