[SOLVED] How to send variable to MySQL?

[lockdownd7]

I'm trying to write string variables into a table.  Something like this:

 

$string = "random string";
$anotherstring = "random string";

mysql_query("INSERT INTO table (field1, field2) VALUES("$string", "$anotherstring") ") 
or die(mysql_error()); 

 

What am I missing?  When I run the code, I get an error about MySQL syntax being incorrect.

[MatthewJ]

You can't put double quotes inside double quotes without escaping them... or use single quotes like below

 

<?php
$string = "random string";
$anotherstring = "random string";

mysql_query("INSERT INTO table (field1, field2) VALUES('$string', '$anotherstring') ")
or die(mysql_error());
}
?>

[lockdownd7]

Yes, I initially used single quotes, but either way I still get an error.  I should probably mention that these strings are unrelated to the database... i.e., I didn't use any mysql query to retrieve them. 

[MatthewJ]

Well, the example I posted back inserts fine for me... so, are you sure the table name is correct.. and the field names are correct?

[jamesxg1]

Hello Mate,

 

mysql_query("INSERT INTO `table` (field1, field2) VALUES('$string', '$anotherstring')") or trigger_error('Query failed: ' . mysql_error(), E_USER_ERROR);

 

That will work. May i ask where are you connecting to mysql ?,

 

And what are the errors you get ?,

 

James.

[PFMaBiSmAd]

Posting the actual error message would allow someone to directly help with the problem.

[jamesxg1]

Here mate this should provide you with all the help you need.

 

http://www.tizag.com/mysqlTutorial/mysqlinsert.php

 

James.

[lockdownd7]

Here's what the relevant section of code looks like:

 

mysql_connect($hostname,$username,$password) or die(mysql_error());

mysql_select_db($database) or die(mysql_error());

$file = date("m.d.y") . ".txt";

if (file_exists($file)) {

$fh = fopen($file, 'r');
$string = fread($fh, filesize($file));
fclose($fh);

mysql_query("INSERT INTO table (field1) VALUES('$string') ") 
or die(mysql_error()); 

}

 

James, I tried your code and still got the following error:

 

Fatal error: Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use 

 

[PFMaBiSmAd]

That's not the complete error message, making it a little hard to help.

 

I'll guess that your data contains SQL special characters that is breaking the query. You need to use mysql_real_escape_string() on all string data put into a query to escape the data.

[jamesxg1]

Hiya mate,

 

Thats not the full error,

 

So here have a look here.

 

http://www.tizag.com/mysqlTutorial/

 

James.

[lockdownd7]

My apologies.  Here is the full error:

 

Fatal error: Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't you always thought about hitting upon a hot page about [Keyword]? Are you into' at line 1 in C:\xampp\htdocs\test2.php on line 32

[PFMaBiSmAd]

Reread this -

.. your data contains SQL special characters that is breaking the query. You need to use mysql_real_escape_string() on all string data put into a query to escape the data.

[lockdownd7]

Reread this -

.. your data contains SQL special characters that is breaking the query. You need to use mysql_real_escape_string() on all string data put into a query to escape the data.

 

Yep, that was it. 

 

Just shows how little I know about SQL.