How to insert multiple rows into a table from a POST data array.

[annerhexian]

hi to all

i am confused right now.. im just new in php.. and i have syntax error in my codes.. pls take a look?

database name: ranking
table: form1
fields: form1academicbachelor
          form1academicschoolyear
 

form:

<input type="text" name="b[]" value="" /><input>
<input type="text" name="s[]" value="" /><input>
<input type="text" name="b[]" value="" /><input>
<input type="text" name="s[]" value="" /><input>
<input type="text" name="b[]" value="" /><input>
 

<?php
 
include 'dbConnect.php';
    mysql_select_db("ranking",$con);
 
 
foreach($_POST['b'] as &$value) {
    $value="'".$value."'";
}
$datos_uno=implode("<br>", $_POST['b']);
 
$sql="INSERT INTO form1(form1academicbachelor) VALUES ('$datos_uno')";
mysql_query($sql,$con) 
 
or die (mysql_error($con));
?>
 

thats my error when it was outpued:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'bsa'
'bsit'
'bb'')' at line 1
 

i want my out put have an out put form the textbox..

b[0]='variable    s[0]='variable
b[1]='variable    s[1]='variable
b[2]='variable    s[2]='variable
 

my problem here is the inserting this multiple fields in the database..
could you make suggestion how to insert an array having multiple records??

[enumula]

Hi, in the below code u hve used the same name for 2 input fields....which is worng...like b ,b n s,s.
form:

<input type="text" name="b[]" value="" /><input>
<input type="text" name="s[]" value="" /><input>
<input type="text" name="b[]" value="" /><input>
<input type="text" name="s[]" value="" /><input>
<input type="text" name="b[]" value="" /><input>
 
 

the other way to do it is...use b,b1 ans s,s1.

<input type="text" name="b[]" value="" /><input>
<input type="text" name="s[]" value="" /><input>
<input type="text" name="b1[]" value="" /><input>
<input type="text" name="s1[]" value="" /><input>
<input type="text" name="b2[]" value="" /><input>
 

take two arrays.

can u plzz paste d code wht exactly ur looking for.

[annerhexian]

Hi, in the below code u hve used the same name for 2 input fields....which is worng...like b ,b n s,s.
form:

<input type="text" name="b[]" value="" /><input>
<input type="text" name="s[]" value="" /><input>
<input type="text" name="b[]" value="" /><input>
<input type="text" name="s[]" value="" /><input>
<input type="text" name="b[]" value="" /><input>
 

the other way to do it is...use b,b1 ans s,s1.

<input type="text" name="b[]" value="" /><input>
<input type="text" name="s[]" value="" /><input>
<input type="text" name="b1[]" value="" /><input>
<input type="text" name="s1[]" value="" /><input>
<input type="text" name="b2[]" value="" /><input>
 

take two arrays.

can u plzz paste d code wht exactly ur looking for.

here's my problem..

<form name="" method="POST" action="">
<td>
                  Bachelor Degree
                      <input type="text" name="bachelordegree[]"  />          
</td>
 <td>
               School Name 
                          <input name="sschoolname[]" type="text" i/>
 </td>
                Year Graduated 
                     <input type="text" name="yeargraduated[]" />
</td>
<td>
                  Bachelor Degree
                      <input type="text" name="bachelordegree[]"  />          
</td>
 <td>
               School Name 
                          <input name="sschoolname[]" type="text" i/>
 </td>
                Year Graduated 
                     <input type="text" name="yeargraduated[]" />
</td>
<td>
                  Bachelor Degree
                      <input type="text" name="bachelordegree[]"  />          
</td>
 <td>
               School Name 
                          <input name="sschoolname[]" type="text" i/>
 </td>
                Year Graduated 
                     <input type="text" name="yeargraduated[]" />
</td>
 
 
</form>
 

this is my form.page.. like for example that they want to input in every textbox like textbox1 Bachelor degree is BSA, textbox in Bachelor Degree is BEED amd textbox2 Bachelor degree is BSIT..and like the other textbox as weso when i view it.. it will be like this

BACHELOR DEGREE  SCHOOL NAME             SCHOOL YEAR
BSAA             schoolname              1956
BEED             schoolnameyeha          1975
BEsa             usc                     2004
 

how to insert this kind of arrays in teh database.....ta nx

[Markus]

Hi, in the below code u hve used the same name for 2 input fields....which is worng...like b ,b n s,s.
form:

<input type="text" name="b[]" value="" /><input>
<input type="text" name="s[]" value="" /><input>
<input type="text" name="b[]" value="" /><input>
<input type="text" name="s[]" value="" /><input>
<input type="text" name="b[]" value="" /><input>
 

It isn't wrong, it's actually correct what he/she's done. you can use the same name= if you plan to put them into arrays, hence the brackets after the name.

To the OP: may i ask why you are putting them into arrays? Arrays are normally used for things such as checkboxes, etc. It seems pointless to use in your case..

[Atli]

Hi everybody.

Please use [code] tags when posting your code examples. (See How to ask a question)

[code=php] ...PHP code goes here... [/code]

I've also edited the title's thread to better describe it's contents.
Please do not use phrases like "help me" or "need help" as your title.

Thank you.

[Atli]

The problem is, like Marcus pointed out, not that you use arrays when getting the values.

The problem is how you try to put them into your database.

To insert multiple rows into a table, your query should look something like this:

INSERT INTO `Table1` (`Column1`)
VALUES ('Data1'), ('Data2'), ('Data3') /* etc. */
 

So, if you have an array of textboxed posted, you could do something like:

# Create the query
$query = "INSERT INTO `Table1` (`Column1`) VALUES";
 
# Add each text box value to the query
foreach($_POST['myTextboxArray'] as $text) {
  $query .= " ('". addslashes($text) ."'),";
}
 
# Remove the last comma from the query
$query[strlen($query)-1] = "";
 

I use the addslashes function there to make sure there are no single quote marks (') in the text to mess up the query.
(Which, btw, was the problem with the query in your first post)

[enumula]

Hey i think u hve posted a form titled have a problem in arrays that having multiple forms.

i hve posted a reply for it try to execute it 1's...then i hope u wont get any doubts on inserting the data.

anyways here is code for u ....check it out ..

Code:-[HTML]

form.html

<form name="" method="POST" action="insert. php">
<td>Bachelor Degree<input type="text" name="bachelord egree"/>
</td><br>
<td>School Name<input name="sschoolna me" type="text" />
</td><br>Year Graduated<input type="text" name="yeargradu ated" />
</td><br><input type="submit" name="submit" value="submit">
</form>
[/code]

CODE:-[PHP]

dbConnect.php

if ($connection_ty pe == "local")
{
$db_servername= "localhost" ;
$db_username="r oot";
$db_password="" ;
$db_name="form" ;
$db_link = mysql_connect($ db_servername, $db_username, $db_password) or die("could not connect to the local atebase server");
$db= mysql_select_db ($db_name,$db_l ink) or die("Not a valid database");

}
[/code]

change the database name accordingly...h ere it is "form".

CODE:-[PHP]

function.php

<?php


class execute_query
{
//getting the list of categorys
function get_result_deta ils($select_que ry)
{
require 'dbConnect.php' ;
$results=array( );
$select_query_r esult=mysql_que ry($select_quer y,$db_link) or die(" Not a valid Select Query Category ".mysql_error() );
if(mysql_num_ro ws($select_quer y_result) > 0)
{
while($get_deta ils=mysql_fetch _array($select_ query_result))
{
$array_count=co unt($get_detail s)/2;
for($i=0;$i<$ar ray_count;$i++)
{
$results[]=$get_details[$i];
}
}
}
//To Free the result set
mysql_free_resu lt($select_quer y_result);
//To Close the connection object
mysql_close($db _link);
return $results;
}


//Insert Query function ....
function insert_query($i nsert_query)
{
require 'dbConnect.php' ;
$insert_id="";
$insert_query_r esult=mysql_que ry($insert_quer y,$db_link) or die(" Not a valid Insert Query ".mysql_error() );
$insert_id=mysq l_insert_id();
mysql_close($db _link);
return $insert_id;
}


}
?>

[/code]

CODE:-[php]

insert.php



<?
session_Start() ;

require 'function.php';
$obj_query= new execute_query() ;
$bachelordegree =$_POST['bachelordegree '];
$sschoolname=$_ POST['sschoolname'];
$yeargraduated= $_POST['yeargraduated'];
$insert_name="i nsert into bachelor (bachelordegree ,sschoolname,ye argraduated) values ('$bachelordegr ee','$sschoolna me','$yeargradu ated')";
$insert_value= $obj_query->insert_query($ insert_name);
header("Locatio n:form.html");
exit;
?>

[/code]

CODE:- text.

database text.

-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 22, 2008 at 11:13 AM
-- Server version: 4.1.9
-- PHP Version: 4.3.10
--
-- Database: `form`
--
-- --------------------------------------------------------
--
-- Table structure for table `bachelor`
--
DROP TABLE IF EXISTS `bachelor`;
CREATE TABLE `bachelor` (
`bachelor_id` int(11) NOT NULL auto_increment,
`bachelordegree ` varchar(100) NOT NULL default '',
`sschoolname` varchar(100) NOT NULL default '',
`yeargraduated` varchar(100) NOT NULL default '',
PRIMARY KEY (`bachelor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT= 10 ;
--
-- Dumping data for table `bachelor`
--
INSERT INTO `bachelor` VALUES (1,'BSC', 'Keys high school', '2000');

[annerhexian]

Hey i think u hve posted a form titled have a problem in arrays that having multiple forms.

i hve posted a reply for it try to execute it 1's...then i hope u wont get any doubts on inserting the data.

anyways here is code for u ....check it out ..

Code:-[HTML]

form.html

<form name="" method="POST" action="insert. php">
<td>Bachelor Degree<input type="text" name="bachelord egree"/>
</td><br>
<td>School Name<input name="sschoolna me" type="text" />
</td><br>Year Graduated<input type="text" name="yeargradu ated" />
</td><br><input type="submit" name="submit" value="submit">
</form>
[/code]

CODE:-[PHP]

dbConnect.php

if ($connection_ty pe == "local")
{
$db_servername= "localhost" ;
$db_username="r oot";
$db_password="" ;
$db_name="form" ;
$db_link = mysql_connect($ db_servername, $db_username, $db_password) or die("could not connect to the local atebase server");
$db= mysql_select_db ($db_name,$db_l ink) or die("Not a valid database");

}
[/code]

change the database name accordingly...h ere it is "form".

CODE:-[PHP]

function.php

<?php


class execute_query
{
//getting the list of categorys
function get_result_deta ils($select_que ry)
{
require 'dbConnect.php' ;
$results=array( );
$select_query_r esult=mysql_que ry($select_quer y,$db_link) or die(" Not a valid Select Query Category ".mysql_error() );
if(mysql_num_ro ws($select_quer y_result) > 0)
{
while($get_deta ils=mysql_fetch _array($select_ query_result))
{
$array_count=co unt($get_detail s)/2;
for($i=0;$i<$ar ray_count;$i++)
{
$results[]=$get_details[$i];
}
}
}
//To Free the result set
mysql_free_resu lt($select_quer y_result);
//To Close the connection object
mysql_close($db _link);
return $results;
}


//Insert Query function ....
function insert_query($i nsert_query)
{
require 'dbConnect.php' ;
$insert_id="";
$insert_query_r esult=mysql_que ry($insert_quer y,$db_link) or die(" Not a valid Insert Query ".mysql_error() );
$insert_id=mysq l_insert_id();
mysql_close($db _link);
return $insert_id;
}


}
?>

[/code]

CODE:-[php]

insert.php



<?
session_Start() ;

require 'function.php';
$obj_query= new execute_query() ;
$bachelordegree =$_POST['bachelordegree '];
$sschoolname=$_ POST['sschoolname'];
$yeargraduated= $_POST['yeargraduated'];
$insert_name="i nsert into bachelor (bachelordegree ,sschoolname,ye argraduated) values ('$bachelordegr ee','$sschoolna me','$yeargradu ated')";
$insert_value= $obj_query->insert_query($ insert_name);
header("Locatio n:form.html");
exit;
?>

[/code]

CODE:- text.

database text.

-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 22, 2008 at 11:13 AM
-- Server version: 4.1.9
-- PHP Version: 4.3.10
--
-- Database: `form`
--
-- --------------------------------------------------------
--
-- Table structure for table `bachelor`
--
DROP TABLE IF EXISTS `bachelor`;
CREATE TABLE `bachelor` (
`bachelor_id` int(11) NOT NULL auto_increment,
`bachelordegree ` varchar(100) NOT NULL default '',
`sschoolname` varchar(100) NOT NULL default '',
`yeargraduated` varchar(100) NOT NULL default '',
PRIMARY KEY (`bachelor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT= 10 ;
--
-- Dumping data for table `bachelor`
--
INSERT INTO `bachelor` VALUES (1,'BSC', 'Keys high school', '2000');

=============== =============== ====
Tanx..I already know how to insert it to the database from the form - i declare tha variable as an array den after that i use the implode for its functionality is array become as a string.. so wen i input it in my textbox1=BSA textbox2=BSIT and textbox 3= BSCS... it was already inserted in the database..tanx for the help friend...
ite become like this..

in the database...
BachelorDgree
BSA
BSIT
BSCS

THANK YOU FOR THE HELP AND TIPS.....