[RESOLVED] Pass data to the database

[Lucky_Day]

I have a quote request form that I'm trying to build.

What happens is that when you submit the form, it creates another row in the database but it's ALL blank!!!

I didn't want to paste my WHOLE code in this thread. I would rather ask what would cause this and what specific part of this general process actually "passes" the data onto the database.

Here are a couple parts of the beast:

<?php 
<form name="customers" method="POST" action="QUOTEcustomer.php" >
?>

And then the process peice:

<?php 
  if (@$_POST['continue'] == "Cancel")
  {
     header("Location: quote_pt1.php");
  }
  $Name = $_POST['Name'];
  $Address = $_POST['Address'];
  $Address2 = $_POST['Address2'];
  $City = $_POST['City'];
  $Zip = $_POST['Zip'];
  $Phone = $_POST['Phone'];
  $Fax = $_POST['Fax'];

require("access.php"); 
$connection = mysql_connect($host,$user,$password) 
or die (mysql_error()); 
$db = mysql_select_db($database,$connection) 
or die (mysql_error()); 

  $Name = strip_tags(trim($Name));
  $Address = strip_tags(trim($Address));
  $Address2 = strip_tags(trim($Address2));
  $City = strip_tags(trim($City));

$query = "INSERT INTO customers(Name,Address,Address2,City,Zip,Phone,Fax) 
VALUES ('$Name','$Address','$Address2','$City','$Zip','$Phone','$Fax')"; 
$result = mysql_query($query, $connection) 
or die (mysql_error()); 
$customerid = mysql_insert_id(); 
?>

That's pretty much the bulk of the PHP involved. Am I missing something?

Thanks for reading this far!

Lucky

[devinemke]

<?php
if (!isset($_POST['submit']))
{
	echo '
	<form action="" method="POST">
	Name: <input type="text" name="Name"><br>
	Address: <input type="text" name="Address"><br>
	Address2: <input type="text" name="Address2"><br>
	City: <input type="text" name="City"><br>
	Zip: <input type="text" name="Zip"><br>
	Phone: <input type="text" name="Phone"><br>
	Fax: <input type="text" name="Fax"><br>
	<input type="submit" name="submit" value="submit">
	</form>
	';
}
else
{
	require('access.php'); 
	$connection = mysql_connect($host,$user,$password) or exit(mysql_error());
	$db = mysql_select_db($database,$connection) or exit(mysql_error());

foreach ($_POST as $key => $value)
{
	$value = trim($value);
	$value = strip_tags($value);
	$$key = $value;
}

$sql = "INSERT INTO customers SET 
Name = '$Name',
Address = '$Address',
Address2 = '$Address2',
City = '$City',
Zip = '$Zip',
Phone = '$Phone',
Fax = '$Fax'";

$result = mysql_query($sql) or exit(mysql_error());
echo 'insert ok';
}
?>

you may have to [man]addslashes[/man] (if PHP isn't doing it for you)

[jeepin81]

Sorry Devine! Did not see your post.

Anyways - this what i had.

<?php 
if (@$_POST['continue'] == "Cancel") 
{ 
header("Location: quote_pt1.php"); 
} 
$Name = $_POST['Name']; 
$Address = $_POST['Address']; 
$Address2 = $_POST['Address2']; 
$City = $_POST['City']; 
$Zip = $_POST['Zip']; 
$Phone = $_POST['Phone']; 
$Fax = $_POST['Fax']; 

require("access.php"); 
 $connection = mysql_connect($host,$user,$password) 
 or die (mysql_error()); 
 $db = mysql_select_db($database,$connection) 
 or die (mysql_error()); 

$Name = trim($Name); 
$Address = trim($Address); 
$Address2 = trim($Address2); 
$City = trim($City); 

$query = "INSERT INTO customers(id,Name,Address,Address2,City,Zip,Phone,Fax) 
 VALUES ('','$Name','$Address','$Address2','$City','$Zip','$Phone','$Fax')"; 
 $result = mysql_query($query, $connection) 
 or die (mysql_error()); 
 $customerid = mysql_insert_id(); 
 ?>  

Best.
J.

[dalecosp]

Just a note. Sometimes I find it helpful to include the query with the mysql_error().

mysql_query($foo) or die("query was $foo, error was: ".mysql_error());

Of course, you're saying it's adding blank lines to the database. You probably need to do some value checking of POST vars with print_r() ......

[Lucky_Day]

You guys are freaking awesome!!!

Thanks so much. . .!!!

Lucky

[dalecosp]

You're quite welcome, of course.

Welcome to PHPBuilder! 🙂