php variable in mysql query

Expand Post »

Hi everybody
I am very new to PHP and MYSQL
How can I implement :

PHP Syntax (Toggle Plain Text)
$q=$_GET["q"]; 
$CMY=$get["CMY"];
...
$query=("INSERT INTO the_array($CMY, model) 
                          VALUES('$q','dddd')");
$q=$_GET["q"]; 
$CMY=$get["CMY"];
...
$query=("INSERT INTO the_array($CMY, model) 
                          VALUES('$q','dddd')");

$q and $CMY are results I get from AJAX, and I think the only way to save the results
is using the DB.

Last edited by Ezzaral; Jul 2nd, 2010 at 4:55 pm. Reason: Added code tags. Please use them to format any code that you post.

Similar Threads

PHP Variable in MySQL Statement in PHP
Passing C++ Variable to MySQL query in MySQL
PHP Variable in mySQL query in PHP

kukie

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Jul 2010

Permalink

Jul 2nd, 2010

Re: php variable in mysql query

PHP Syntax (Toggle Plain Text)
$Name=$_GET["name"];
$Email=$_GET["email"];
...
$sql="INSERT INTO tablename(db_field1, db_field2)
                              VALUES('$Name','$Email');
 
mysql_qyery($sql)
 
$Name=$_GET["name"];
$Email=$_GET["email"];
...
$sql="INSERT INTO tablename(db_field1, db_field2)
                              VALUES('$Name','$Email');

mysql_qyery($sql)

This is the most simplest way to insert data into database.

Last edited by Ezzaral; Jul 2nd, 2010 at 4:55 pm. Reason: Added code tags. Please use them to format any code that you post.

kamran_FrizCon

Reputation Points: 10

Solved Threads: 4

Light Poster

Offline

33 posts
since Jul 2009

Permalink

Jul 3rd, 2010

Re: php variable in mysql query

Thank you Kamran.

kukie

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Jul 2010

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Going back from child to parent page

Next Thread in PHP Forum Timeline: Can't seem to get this If statement working...

DaniWeb Message

Cancel Changes

User Name
Password