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
https://forums.phpfreaks.com/topic/23389-mysql-php-insert-problem/
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]

Archived

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

×
×
  • 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.