Jump to content

Archived

This topic is now archived and is closed to further replies.

darvexwomp

Mysql / PHP Insert problem

Recommended Posts

I have a basic form that I am collecting data with and trying to pass the variables to a PHP script that will insert the values into a database.  It seems to work except none of the data is being inserted in the database - it gets filled with blank values and not the ones from the form.  I have been pulling my hair out with this and I am sure it is something simple.  Any help would be greatly appericated.  Here is a link to the form:  http://www.darvex.com/alt/alternator_form.php  Here is the PHP script:

<?php
include("dbconnect.php");
if ($submit = "Submit")
{
$query = "insert into alternator (name,driveline,email,transmission,ac,mounting_style,make,model,year,mandate,cylinders,displacement,displacement_type,requirments,original_engine,total_output,add_req,pulley_type,grooves,location,idle)
values ('$name', '$driveline', '$email', '$transmission', '$ac', '$mounting_style', '$make', '$model', '$year', '$mandate', '$cylinders', '$displacment', '$displacement_type', '$requirments', '$original_engine', '$total_output', '$add_req', '$pulley_type', '$grooves', '$location', '$idle')"
;
mysql_query($query) or
die (mysql_error());
?> Thanks
<?php
}
else
{
include("alternator_form.php");
}
?>

Share this post


Link to post
Share on other sites
i have an insert page just like yours, hope you find something here. the only difference that i see is that im using isset($_POST[]) in the "if statement"

[code]
<html>
<head>
<title>Add Mysql User</title>
<meta http-equiv = "Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?php
if(isset($_POST['add']))
{
  include 'library/config.php';
  include 'library/dbopen.php';
 
  $username = $_POST['username'];
  $password = $_POST['password'];
 
  $query = "INSERT INTO users (name, password) VALUES ('$username', PASSWORD
  ('$password'))";
  mysql_query($query) or die ('error! insert query failed!');
 
  $query = "FLUSH PRIVILEGES";
  mysql_query($query) or die ('error! insert query failed!');
 
  include 'library/close.php';
  echo 'New MySql added!';
}
else
{
?>
<form method="post">
<table width="400" border="0" cellspacing="1" cellpadding="2">
<tr>
<td width="100">Username</td>
<td><input name="username" type="text" id="username"></td>
</tr>
<tr>
<td width="100">Password</td>
<td><input name="password" type="password" id="password"></td>
</tr>
<tr>
<td width="100">&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td width="100">&nbsp;</td>
<td><input name="add" type="submit" id="add" value="Add New User"></td>
</tr>
</table>
</form>
<?php
}
?>
</body>
</html>
[/code]

Share this post


Link to post
Share on other sites
Where are these variables coming from?

Share this post


Link to post
Share on other sites
The variables are coming from a form - Here is a link to it:  http://www.darvex.com/alt/alternator_form.php

Share this post


Link to post
Share on other sites
Well, those would be in a POST hash... I'm not seeing that in your script.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.