Undefined Variable Error!

jennifer_ann

I had the following code, and I keep getting an undefined variable error in the

mysql_query($query) or die;
('Error, insert query failed');
//echo('Data inserted successfully' );

Could anyone suggest something???

[code=php]<?php
// open connection to database
$db = mysql_connect("localhost", "root", "");
if (!$db)
{
 	print "unable to connect!";
	exit;
}

// set server access variables
extract($_POST);

//select database to use
$db= mysql_select_db ("mapleside");
if (!$db)
{
	print "could not select database";
	exit;
}

// create SQL query string
//$query = "INSERT INTO customer VALUES ('$customer_Lname', '$customer_Fname', '$Customer_address', '$Customer_city', '$Customer_state', '$Customer_zipcode', 'Customer_Email', 'Customer_UserName', 'Customer_Password')";


mysql_query($query) or die;
	('Error, insert query failed');
//echo('Data inserted successfully' );

//close connection
mysql_close();

// This will have to be adjusted once the pages are completed. 
header("Location: http://localhost/???????????.php")
?>

obsidian

well, in your mysql_query($query) line, you are referencing the variable $query, right? well, you have the line where you assign a value to $query commented out, so the variable is never being. set. if you un-comment that line or set $query equal to something, you shouldn't get the parse error any more.

jennifer_ann

Ok I have all the undefined variables working now, thank you very much, but when I run it from my local host, it only says "Insert Query Failed".

Houdini

<?php
// open connection to database
//lets start here
$connect = mysql_connect("localhost", "root", "")
  or die("Could not connect to server".mysql_error());
//if (!$db) take this out the above query does all that
//{
//    print "unable to connect!";
//    exit;
//}
// set server access variables
extract($_POST);
//select database to use
$db= mysql_select_db ("mapleside",$connect)
  or die("Could not select database".mysql_error());
//if (!$db) take all this out too as the above code does all that
//{
//    print "could not select database";
//    exit;
//}
// create SQL query string so now uncomment your query and try it
//$query = "INSERT INTO customer VALUES ('$customer_Lname', '$customer_Fname', '$Customer_address', '$Customer_city', '$Customer_state', '$Customer_zipcode', 'Customer_Email', 'Customer_UserName', 'Customer_Password')";
mysql_query($query) or die;// not sure what this is
    ('Error, insert query failed');
//echo('Data inserted successfully' );
//close connection
mysql_close();
// This will have to be adjusted once the pages are completed.
header("Location: http://localhost/???????????.php")
?>

jennifer_ann

Houdini, all that works fine thank you. And it makes sense....but when I run that, I still get insert query failed. Is that because I am not inserting information into the text boxes from my web page????

obsidian

jennifer_ann wrote:
Ok I have all the undefined variables working now, thank you very much, but when I run it from my local host, it only says "Insert Query Failed".

my guess is that there may be a problem with escaping some of your values for inserting into the DB, but to be on the safe side, you can modify your error report to tell you exactly what the problem is... where you are running your mysql_query(), change the line to this:

mysql_query($query) or die('Error, insert query failed!<br />Error returned: "' . mysql_error() . '"<br /><br />SQL: "' . $query . '"');

this will print out not only "Error, insert query failed!", but also what the error returned was as well as printing out your actual query so you can verify that all your variables are intact.

samudasu

Look at your query. The way you change from caps to lowercase in your variable names is confusing and most likely is going to cause you problems since variables are case sensitive. For your own sanity, keep to a uniform method of declaring variable names. Here's what you have:

$customer_Fname
$Customer_address

Houdini

Probably that is the case could you post the form? You might also want to echo those post variables which should be $customer_Lname', '$customer_Fname', '$Customer_address', '$Customer_city', '$Customer_state', '$Customer_zipcode', 'Customer_Email', 'Customer_UserName', 'Customer_Password' after the extract($_POST); and be sure those values are all there.

jennifer_ann

You People Are Amazing!!! It Worked!!! Thank You So Much!