Jump to content

Mysql / PHP Insert problem


darvexwomp

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");
}
?>
Link to comment
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]
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.