Inserting Data in 4 tables from 1 html form.

m1k3

Hi i've been trying to get this working with no joy, and after 2 hours reading the forums and other websites and getting no where i thought best to ask you guys.

Im trying to insert the following from a html form into 4 tables

mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());


// add the new information into the database
$query="INSERT INTO auto (make,model,year) VALUES ('$_POST[make]','$_POST[model]','$_POST[year]')";
$query="INSERT INTO dimensions (length,width,height,wheelBase,weight,bodystyle,seatingCap) VALUES ('$_POST[length]','$_POST[width]','$_POST[Height]','$_POST[wheelBase]','$_POST[Weight]','$_POST[bodystyle]','$_POST[seatingCap]')";
$query="INSERT INTO ratios (maxspeed,secToSixty,mpg,co2Emes,insurGroup,ncapCrashRat,nhtsaaCrashRat) VALUES ('$_POST[maxspeed]','$_POST[secToSixty]','$_POST[mpg]','$_POST[co2Emes]','$_POST[insurGroup]','$_POST[ncapCrashRat]','$_POST[nhtsaaCrashRat]')";
$query="INSERT INTO specs (feulType,engineCap,cylinders,valves,horsePower,torque,wheelDrive,trans,opttranse) VALUES ('$_POST[feulType]','$_POST[engineCap]','$_POST[cylinders]','$_POST[valves]','$_POST[horsePower]','$_POST[torque]','$_POST[wheelDrive]','$_POST[trans]','$_POST[opttranse]')";


echo "<br />";
echo "<a href=\"form.html\">Click here to return to the form page.</a>";

just keep getting an error with somthing like error on line 23

error is
Parse error: syntax error, unexpected T_LOGICAL_OR in /xx/xx/form.php on line 22

dougal85

there isnt 22 lines there. can you tell us what line 22 is??

I can't actually see where ypu run these queries and each time you are declaring a query you are writing over the previous one. What you are doing is just putting them into variables. Look up the function: mysql_query()

m1k3

ahh ok i see what you was talking about

okay this is what i have now, and i get the following error

$con= mysql_connect($host,$user,$pass);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db($db,$con);



// add the new information into the database
$q1= "INSERT INTO auto (make,model,year) VALUES ('$_POST[make]','$_POST[model]','$_POST[year]')";

$q2= "INSERT INTO dimensions (length,width,height,wheelBase,weight,bodystyle,seatingCap) VALUES ('$_POST[length]','$_POST[width]','$_POST[Height]','$_POST[wheelBase]','$_POST[Weight]','$_POST[bodystyle]','$_POST[seatingCap]')";

$q3= "INSERT INTO ratios (maxspeed,secToSixty,mpg,co2Emes,insurGroup,ncapCrashRat,nhtsaaCrashRat) VALUES ('$_POST[maxspeed]','$_POST[secToSixty]','$_POST[mpg]','$_POST[co2Emes]','$_POST[insurGroup]','$_POST[ncapCrashRat]','$_POST[nhtsaaCrashRat]')";

$q4= "INSERT INTO specs (feulType,engineCap,cylinders,valves,horsePower,torque,wheelDrive,trans,opttranse) VALUES ('$_POST[feulType]','$_POST[engineCap]','$_POST[cylinders]','$_POST[valves]','$_POST[horsePower]','$_POST[torque]','$_POST[wheelDrive]','$_POST[trans]','$_POST[opttranse]')";

if (!mysql_query($q1,$q2,q3,$q4,$con)

{ 
die('Error: ' . mysql_error());
}
echo "Success!";

?>

Im getting an error on this bit
{
die('Error: ' . mysql_error());
}
echo "Success!";

Warning: Wrong parameter count for mysql_query() in /xx/xx//form.php on line 32
Error:

tomhath

You might want to read the manual. The error message is very clear on what's wrong.

$q1= "INSERT INTO auto (make,model,year) VALUES ('$_POST[make]','$_POST[model]','$_POST[year]')";
if (!mysql_query($q1,$con)
{ 
die('Error: ' . mysql_error());
}
$q2= "INSERT INTO dimensions (length,width,height,wheelBase,weight,bodystyle,seatingCap) VALUES ('$_POST[length]','$_POST[width]','$_POST[Height]','$_POST[wheelBase]','$_POST[Weight]','$_POST[bodystyle]','$_POST[seatingCap]')";
if (!mysql_query($q2,$con)
{ 
die('Error: ' . mysql_error());
}
...

jignesh1

m1k3 wrote:
// add the new information into the database
$q1= "INSERT INTO auto (make,model,year) VALUES ('$POST[make]','$POST[model]','$_POST[year]')";

$q2= "INSERT INTO dimensions (length,width,height,wheelBase,weight,bodystyle,seatingCap) VALUES ('$POST[length]','$POST[width]','$POST[Height]','$POST[wheelBase]','$POST[Weight]','$POST[bodystyle]','$_POST[seatingCap]')";

$q3= "INSERT INTO ratios (maxspeed,secToSixty,mpg,co2Emes,insurGroup,ncapCrashRat,nhtsaaCrashRat) VALUES ('$POST[maxspeed]','$POST[secToSixty]','$POST[mpg]','$POST[co2Emes]','$POST[insurGroup]','$POST[ncapCrashRat]','$_POST[nhtsaaCrashRat]')";

$q4= "INSERT INTO specs (feulType,engineCap,cylinders,valves,horsePower,torque,wheelDrive,trans,opttranse) VALUES ('$POST[feulType]','$POST[engineCap]','$POST[cylinders]','$POST[valves]','$POST[horsePower]','$POST[torque]','$POST[wheelDrive]','$POST[trans]','$_POST[opttranse]')";

?>
[/code]

doesnt the superglobal variable and varible suppose to be in the double quoted in the php

leatherback

you need to make sure the number of colums and variables in the query match up

m1k3

tomhath wrote:

You might want to read the manual. The error message is very clear on what's wrong.

$q1= "INSERT INTO auto (make,model,year) VALUES ('$_POST[make]','$_POST[model]','$_POST[year]')";
if (!mysql_query($q1,$con)
{ 
die('Error: ' . mysql_error());
}
$q2= "INSERT INTO dimensions (length,width,height,wheelBase,weight,bodystyle,seatingCap) VALUES ('$_POST[length]','$_POST[width]','$_POST[Height]','$_POST[wheelBase]','$_POST[Weight]','$_POST[bodystyle]','$_POST[seatingCap]')";
if (!mysql_query($q2,$con)
{ 
die('Error: ' . mysql_error());
}
...

HI Tom
I added those to each of the variables and now i get this

Parse error: syntax error, unexpected '{' in /xx/xx/form.php on line 26

the code at line 26 is

$q1= "INSERT INTO auto (make,model,year) VALUES ('$_POST[make]','$_POST[model]','$_POST[year]')";
if (!mysql_query($q1,$con) 
{[COLOR=Red](Line26 here)[/COLOR] 
die('Error: ' . mysql_error()); 
}

ahundiak

if (!mysql_query($q1,$con) is missing the closing paren
if (!mysql_query($q1,$con))

Take your time. And maybe get a syntax aware editor.