insert multple records in a table at one time!

[flforlife]

Hi i'm trying to develop an application where I can add records using one php script and one form. Form that add multiple records to a database. I've been searching but i cant find a solution.

Majors scoreboard

Place Team WL GB %AGE etc....
1 cards 5-0 7 1
2 jays 9-0 7 3
3 yanks 5-0 7 3
4 soxs 9-0 7 2



here is the database setup from ^....

CREATE TABLE major (
id INT NOT NULL AUTO_INCREMENT,
place VARCHAR(65) NOT NULL DEFAULT '',
team VARCHAR(65) NOT NULL DEFAULT '',
wl VARCHAR(65) NOT NULL DEFAULT '',
gb VARCHAR(65) NOT NULL DEFAULT '',
pcage VARCHAR(65) NOT NULL DEFAULT '',
rs VARCHAR(65) NOT NULL DEFAULT '',
ra VARCHAR(65) NOT NULL DEFAULT '',
ags VARCHAR(65) NOT NULL DEFAULT '',
PRIMARY KEY(id)
);




here is the form...


<form method="post" action="add.php">
<h1>Major</h1>
<table border="1">

<tr>
<td>PLACE</td>
<td>TEAM</td>
<td>WIN-LOSE</td>
<td>GB</td>
<td>%AGE</td>
<td>RUNS SCORED</td>
<td>RUNS ALLOWED</td>
<td>AVERAGE GAME SCORE</td>
</tr>

<tr>
<td><input name="place" type="text" id="place" /></td>
<td><input name="team" type="text" id="team" /></td>
<td><input name="wl" type="text" id="wl" /></td>
<td><input name="gb" type="text" id="gb" /></td>
<td><input name="pcage" type="text" id="pcage" /></td>
<td><input name="rs" type="text" id="rs" /></td>
<td><input name="ra" type="text" id="ra" /></td>
<td><input name="ags" type="text" id="ags" /></td>
</tr>

<tr>
<td><input name="place" type="text" id="place" /></td>
<td><input name="team" type="text" id="team" /></td>
<td><input name="wl" type="text" id="wl" /></td>
<td><input name="gb" type="text" id="gb" /></td>
<td><input name="pcage" type="text" id="pcage" /></td>
<td><input name="rs" type="text" id="rs" /></td>
<td><input name="ra" type="text" id="ra" /></td>
<td><input name="ags" type="text" id="ags" /></td>
</tr>


</table>
<input type="submit" />

</form>


I want to add more records using php. here is my add.php code


<?php

//add fourteam data

$hostname = 'localhost';
$username = 'root';
$password = ''; //add later
$database = 'test';

$mysql = mysql_connect($hostname, $username, $password);
mysql_select_db($database);



$sql="INSERT INTO major (place, team, wl, gb, pcage, rs, ra, ags)
VALUES
('$_POST[place]','$_POST[team]','$_POST[wl]','$_POST[gb]','$_POST[pcage]','$_POST[rs]','$_POST[ra]','$_POST[ags]')";

if (!mysql_query($sql,$mysql))
{

die('Error: ' . mysql_error());

}
header("location:ftadmin.php");
echo "1 record added";

mysql_close($mysql)






?>

[hoopyfrood]

Hi,

If I got it right you want to enter each entered value into db. This could get ugly, but it might be easier than you think.

First of all: if you have two inputs of the same name (although the ID might differ), unless you store the values in an array PHP will only work with the last one submitted (e.g.:

<input class="" type="text" name="place" id="place" value="" /> (say you enter "5"
...
<input class="" type="text" name="place" id="place" value="" /> (and here "1")

First of all: clash of IDs, page wouldn't validate. And if you get PHP to print the value of $_POST['place'] you'd get "1", not "5, 1".

Fix:

<input class="" type="text" name="place[]" id="ditch this" value="" /> (say you enter "5"
...
<input class="" type="text" name="place[]" id="ditch this" value="" /> (and here "1")

Once submitted use something like

PHP Code:

foreach($_POST['place'] as $place => $value)
{
  // insert into db here
}

or

for($i=0; $i<count($_POST['place']); ++$i)
{
  // do your operations here
}

or finally while() 


Hope that puts you on track, I've done this for my CRM in the past (multiple telephone numbers of different type (mobile, landline, work...) for each contact using a bit of a mixture of javascript and PHP to dynamically extend the form for more/less records and insert into DB.

If you get stuck (or it isn't clear enough) please give us a shout again.

Cheers,
hoopyfrood

[flforlife]

ok I have it set up this way but i'm stuck!!!

input form code.....
<tr>
<td><input name="entry[0][place]" type="text" /></td>
<td><input name="entry[0][team]" type="text" /></td>
<td><input name="entry[0][wl]" type="text" /></td>
<td><input name="entry[0][gb]" type="text" /></td>
<td><input name="entry[0][pcage]" type="text" /></td>
<td><input name="entry[0][rs]" type="text" /></td>
<td><input name="entry[0][ra]" type="text" /></td>
<td><input name="entry[0][ags]" type="text" /></td>
</tr>

<tr>
<td><input name="entry[1][place]" type="text" /></td>
<td><input name="entry[1][team]" type="text" /></td>
<td><input name="entry[1][wl]" type="text" /></td>
<td><input name="entry[1][gb]" type="text" /></td>
<td><input name="entry[1][pcage]" type="text" /></td>
<td><input name="entry[1][rs]" type="text" /></td>
<td><input name="entry[1][ra]" type="text" /></td>
<td><input name="entry[1][ags]" type="text" /></td>
</tr>


add.php code........

foreach($_POST['sql']){

sql = $_POST["entry"][0] = array("place"=>"...", "team"=>"...");

sql = $_POST["entry"][1] = array("place"=>"...", "team"=>"...");
$result = mysql_query($sql);
}


I get an error message!!!