php error query was empty

Question

You can see I can successfully redirect values from one to this page.

$shipping_first_name = $_POST['shipping_first_name'];
$shipping_address= $_POST['shipping_address'];
$shipping_city = $_POST['shipping_city'];
$shipping_state = $_POST['shipping_state'];
$shipping_zip_code = $_POST['shipping_zip_code'];
$shipping_phone = $_POST['shipping_phone'];
$shipping_mobile =$_POST['shipping_mobile'];
$Shipping_email = $_POST['shipping_email'];

echo $shipping_address,$Shipping_email; // now this line shows contains but

Order entry: this query returns nothing.
Error is query was empty. What do I do?

$qurey1 = 'INSERT INTO ecomm_orders
(order_id,order_date, customer_id, cost_subtotal,
cost_total, shipping_first_name, shipping_address, shipping_city, shipping_state,
shipping_zipcode, shipping_phone, shipping_mobile, shipping_email)
VALUES
(NULL,"'.$now.'",'.$customer_id.',0.00,0.00,"'.mysql_real_escape_string($shipping_first_name,$db).'",
"'.mysql_real_escape_string($shipping_address, $db).'",
"'.mysql_real_escape_string($shipping_city, $db).'",
"'.mysql_real_escape_string($shipping_state, $db).'",
"'.mysql_real_escape_string($shipping_zip_code, $db).'",
"'.mysql_real_escape_string($shipping_phone, $db).'",
"'.mysql_real_escape_string($shipping_mobile, $db).'",
"'.mysql_real_escape_string($Shipping_email, $db).'")';
mysql_query($query1,$db) or die (mysql_error($db));
$order_id=mysql_insert_id();

Prior to this query I run query to populate customer table successfully, using same method.
But what could be wrong?

May be just a typo, but you have inconsistent spelling of: qurey1, and later query1... — mechanical_meat
– mechanical_meat, Commented Jul 24, 2010 at 2:29
As a side note, if you use prepared statements, you can avoid all the mysql_real_escape_string and clean up the VALUES portion of the query. — Paul Hoffer
– Paul Hoffer, Commented Jul 24, 2010 at 4:23
what is prepared statments? i m kind of fresher in php field. may b i m using this thing what it is? [:)] — p singh
– p singh, Commented Jul 24, 2010 at 9:19

user400850 · Accepted Answer · 2010-07-24 04:14:41Z

2

Well, assuming all the variables placed into your MySQL query are not empty... Change the "$qurey1 =" (variable you put your query into) to "$query1 =". I believe you simply have a typo.

answered Jul 24, 2010 at 4:14

user400850

1765 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user397876 · Accepted Answer · 2010-07-24 08:53:24Z

1

Try using single quote rather than double quote to wrap values.

\''.mysql_real_escape_string($shipping_address, $db).'\',

Instead of

"'.mysql_real_escape_string($shipping_address, $db).'",

answered Jul 24, 2010 at 8:53

user397876

462 bronze badges

1 Comment

p singh Over a year ago

thanks for help and i wil try using single quote .its just that i am used to double quotes.

Collectives™ on Stack Overflow

php error query was empty

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related