Arrays into mysql

Anon

Hi all,

i have a big problem....
i'm to stupid to handle arrays.

I whant to make a page about icehockey games.
With the following form i want to add some detailed informations about the gameresults.
Exactly which player made a goal in which minute and his assists for both teams.
First the form gets the count of the goals of each team and presents the input fields.
Then i can add the informations and submit the form.
What i'm not able to do is getting the arrays and save the arraydata into a mysql database. How is it going?

<form action=$PHP_SELF method=post>
<INPUT TYPE=HIDDEN name=gameid value=$game>
<table border=0 cellpadding=0 cellspacing=0 width=460>
<tr>
<td>minute</td>
<td>goaly</td>
<td>assist1</td>
<td>assist2</td>
</tr>";

echo"<tr><td colspan=4><p><p>Goals $team1 (total $goals1):</td></tr>";

while($i < $goals1) {
echo"<INPUT TYPE=HIDDEN name=gteam[] value=$gteam1>
<tr>
<td><INPUT TYPE=TEXT name=time[]></td>
<td><INPUT TYPE=TEXT name=goaler[]></td>
<td><INPUT TYPE=TEXT name=goalerassist1[]></td>
<td><INPUT TYPE=TEXT name=goalerassist2[]></td>
<tr>";
$i++;
}
echo"<tr><td colspan=4><p><p>Goals $team2 (total $goals2):</td></tr>";
while($k < $goals2) {
echo" <INPUT TYPE=HIDDEN name=gteam[] value=$gteam2>
<tr>
<td><INPUT TYPE=TEXT name=time[]></td>
<td><INPUT TYPE=TEXT name=goaler[]></td>
<td><INPUT TYPE=TEXT name=goalerassist1[]></td>
<td><INPUT TYPE=TEXT name=goalerassist2[]></td>
</tr>";
$k++;
}
echo"</table>
<p><input type='submit' name='execute' value=Add Goals'> <input type='reset'>
</form>"

[deleted]

You don't put arrays into database tables.
That is what rows are for.

Create a new table and call it 'goals'.
That table contains a column for the id of the player, the id of the game, and the minute that the goal was scored.

Instead of storing the array, you put each goal into it's own record in the 'goals' table.
Now you can do

SELECT * FROM goals WHERE playerid=this AND gamesid = that;

to get all the goals by player 'this' in game 'that'.

Anon

Thats what i wanted to do... but how?

I tried it this way:

if ($execute == "Add Goals") {

$i = 0;
$number = count($time);

while ($i < $number) {
$gameid = $gameid;
$dtime = $time[$i];
$dteam = $team[$i];
$dgoaler = $goaler[$i];
$dgoalerassist1 = $goalerassist1[$i];
$dgoalerassist2 = $goalerassist2[$i];

dbsql="insert into goals (gameid,
team,
time,
goaler,
goalerassist1,
goalerassist2)" . "values (
'$gameid',
'$dteam',
'$dtime',
'$dgoaler',
'$dgoalerassist1',
'$dgoalerassist2')";
$result=db_query($dbsql);

$i++;
}
}

But it doesn't work...

;((((

Anon

Only the first goal is inserted to my database...

Anon

I tried it this way:

if ($execute == "Add Goals") {

$i = 0;
$number = count($time);

while ($i < $number) {
$gameid = $gameid;
$dtime = $time[$i];
$dteam = $team[$i];
$dgoaler = $goaler[$i];
$dgoalerassist1 = $goalerassist1[$i];
$dgoalerassist2 = $goalerassist2[$i];

$i++;
}
}

But it doesn't work...
Only the first arrayvars are stored into my database...
;((((