[RESOLVED] Insert array data to mysql table

skm

Hi...All...
I need some advice regarding inserting data from a form to a mysql table. I am unable to get the data posted into the table.

Following are my two files :
First file generates dynamic input fields and stores in a array (i hope my syntax is correct). Then upon submit i want the values to be inserted into the table.

firstfile.php

<form name="items" method="get">
<input name="number" type="text" id="number" size="6">
</p>
<input type="submit" name="Submit" value="Submit"> 
 </form>
<?
	echo "<table>";
	echo "<tr>";
	echo "<td width=90> Item No </td>";
	echo "<td width=310> Description </td>";
	echo "</tr>";
	echo "</table>";

?>
<?
echo "<form name=insertitem method=post action='secondfile.php'>";
	echo "<table>";
$number=$_GET["number"];
if ($number>15)
	{
	$number=15;
	echo "<font color=red>You are allowed to enter maximum 15 items at a time </font>";
	}
	else 
	{
	$number=$_GET["number"];
	}

for ($i=1; $i<=$number; $i++)
{
	echo "<tr>";
	echo "<td> <input type=text name=itemno[$i] size=5> </td>" ;
	echo "<td> <input type=text name=description[$i] size=50> </td>" ;
	echo "</tr>";
}
	echo "</table>";
	echo "<input type=submit name=submit value=Submit>";
	echo "</form>";

?>

</body>

secondfile.php

<?
include("link.php");

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

  $itemnos = $_POST['itemno'];
  $descriptions = $_POST['description'];
$query = "INSERT INTO table_name VALUES('','$itemnos','$descriptions')";
mysql_query($query);

mysql_close();
?>

All suggestions are appreciated.
Thanks in advance.

tomhath

First, add the "or die(...)" to the connect and query.

Second, print the error message from mysql along with your own message, eg:
@mysql_select_db($database) or die( "Unable to select database " . mysql_error());

Third, without knowing the table's columns I can't guess if the INSERT is right, but I doubt it is. If you have an autoincrement column you don't pass that column as one of the values. Maybe this will work:

$query = "INSERT INTO table_name (itemno, description) VALUES('$itemno','$description')";
mysql_query($query) or die(mysql_error());

As far as $itemnos and $descriptions arrays, you'll need to loop through them with a for loop and execute a query for each.

skm

Hi... I tried your suggestion... but it is not doing what is needed. I get value "0" in the itemno field and "Array" in the Description field.

The other thing I want to clarify is does the
$_Post['itemno'] ;
etc . also to be inside a "for loop" ...?

I tried to put it in a for loop like below and it does not add anything to the table :

<?
include("link.php");

mysql_connect(localhost,$username,$password) or die("Unable to connect".mysql_error());
@mysql_select_db($database) or die( "Unable to select database".mysql_error());

$number=$_GET[number];
for($i=1; $i<=number; $i++)
{
  $itemnos = $_POST['itemno'];
  $descriptions = $_POST['description'];

$query = "INSERT INTO Schedule_of_Bid (ItemNo, Description) 
VALUES ('$itemnos','$descriptions')";
mysql_query($query) or die(mysql_error());
}
mysql_close();
?>

Thanks for your time and suggestion.
Rgds

tomhath

I simplified your script a little so you can see what's going on with the arrays.

First, display a form. Notice that the input elements named itemno and description have the [] brackets but do not have subscripts:

<body>
<form name=insertitem method=post action='secondfile.php'>
<table><th>Item</th><th>Description</th>
<?
$number = 3;
for ($i=1; $i<=$number; $i++)
{
	echo "<tr>";
	echo "<td> <input type=text name=itemno[] size=5> </td>" ;
	echo "<td> <input type=text name=description[] size=50> </td>" ;
	echo "</tr>";
}
?>
</table>
<input type=submit name=submit value=Submit>
</form>
</body>

Now display what was posted. The $POST variable will contain arrays for itemno and description:

<body>
<?
// store all posted intemnos and descriptions in local arrays
$itemnos = $_POST['itemno'];
$descriptions = $_POST['description'];

// loop through array
$number = count($itemnos);
for ($i=0; $i<=$number; $i++)
{
    // store a single item number and description in local variables
    $itno = $itemnos[$i];
    $desc = $descriptions[$i];

// this is where your insert should be (instead of the echo),
// insert the single values in $itnm and $desc

if ($itemnos[$i] <> '') {
echo "Item: " . $itno . "   Description: " . $desc . "<p>";
}
}
?>
</body>

skm

Thanks a LOOOOOOOOOOTTTTTTTTTT...
IT works....

Just one question...why is that there is one more row is inserted with NULL values? Any clues...

I overcame it by assigning another variable name

// loop through array 
$num = count($itemnos); 
$numb = $num-1;
for ($i=0; $i<=$numb; $i++) 
{ 
....etc..

}

Regards....and Happy New Year to you....

tomhath

for ($i=0; $i<=$numb; $i++)

should probably be

for ($i=0; $i<$num; $i++)

But your fix works too.