darvexwomp Posted October 9, 2006 Share Posted October 9, 2006 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 More sharing options...
trench coat man Posted October 9, 2006 Share Posted October 9, 2006 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><?phpif(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"> </td><td> </td></tr><tr><td width="100"> </td><td><input name="add" type="submit" id="add" value="Add New User"></td></tr></table></form><?php}?></body></html>[/code] Link to comment https://forums.phpfreaks.com/topic/23389-mysql-php-insert-problem/#findComment-106071 Share on other sites More sharing options...
fenway Posted October 9, 2006 Share Posted October 9, 2006 Where are these variables coming from? Link to comment https://forums.phpfreaks.com/topic/23389-mysql-php-insert-problem/#findComment-106111 Share on other sites More sharing options...
darvexwomp Posted October 9, 2006 Author Share Posted October 9, 2006 The variables are coming from a form - Here is a link to it: http://www.darvex.com/alt/alternator_form.php Link to comment https://forums.phpfreaks.com/topic/23389-mysql-php-insert-problem/#findComment-106241 Share on other sites More sharing options...
fenway Posted October 10, 2006 Share Posted October 10, 2006 Well, those would be in a POST hash... I'm not seeing that in your script. Link to comment https://forums.phpfreaks.com/topic/23389-mysql-php-insert-problem/#findComment-106877 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.