how to run sql query when !empty($_POST[' ']) is true?

Question

The result of the block of code below is always "d=0".I dont understand why?

 if (!empty($_POST["transactionid"])) {

     $sql_set = "SET timestamp = '$timestamp',";
     $sql = "INSERT INTO phpclassifieds_payments
                $sql_set
                txnid = '$trnxid',
                adid  = '$adid',
                adtype = 'A',
                amountpaid ='$amount_paid'";

     $tx = mysql_query($sql);
     if ($tx) {
         $d = 1;
     } else {
         $d = 0;
     }
 }

Just go backwards. See where `$d` gets its value and look up in the manual why. — Álvaro González, Jul 28 '14 at 07:27
@Nitin and Logan thats wrong, you can use `SET` with `INSERT` for `MySQL` — Hanky Panky, Jul 28 '14 at 07:28
But syntactically his query is wrong. He should use VALUES in INSERT query. — Talk2Nit, Jul 28 '14 at 07:30
No thats another invalid command. Thats fine syntax. That query is not wrong due to that reason. — Hanky Panky, Jul 28 '14 at 07:30
I am using this block of code in making REST API. I have to pass data in json(one of which is transactionid) and see its output. I am using Advanced Rest CLient Apllication and Postman to do so. How can i check for mysql_error()?? — rdkrosan, Jul 28 '14 at 07:53
All that Rest and Client stuff is irrelevant to this question. Simply do this `$tx = mysql_query($sql) or die(mysql_error());` and you will get your answer. — Hanky Panky, Jul 28 '14 at 07:55

score 0 · Answer 1 · edited May 23 '17 at 11:57

0

See : MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET

Are you sure that your DBMS allow the INSERT INTO ... SET syntax ?

Maybe change it to :

INSERT INTO phpclassifieds_payments VALUES ('val 1', 'val 2', ...);

Try to debug it with :

$d = 0;
die('error sql : ' . mysql_error());

If mysql_error, it doesn't return any value try echo $sql; to see your sql query.

edited May 23 '17 at 11:57

Community

1
1

answered Jul 28 '14 at 07:41

user2226755

12,494
5
50
73

Their DBMS, as stated, is MySQL, which clearly allows for both those. – Hanky Panky Jul 28 '14 at 07:53
I am using this block of code in making REST API. I have to pass data in json(one of which is transactionid) and see its output. I am using Advanced Rest CLient Apllication and Postman to do so. How can i check for mysql_error()?? – rdkrosan Jul 28 '14 at 07:55

score 0 · Answer 2 · answered Jul 28 '14 at 07:56

You must check have any bugs in your queries by using

echo "<pre>".mysql_error()."</pre>"

It'll returns the mysql error information of query just before processed.

You must also ensure that their is a space between your table name and SET statement,

just rewrite $sql_set = " SET timestamp = '$timestamp', ";

Otherwise your joined query string is

INSERT INTO phpclassifieds_paymentsSET timestamp = '$timestamp',
                txnid = '$trnxid',
                adid  = '$adid',
                adtype = 'A',
                amountpaid ='$amount_paid'

how to run sql query when !empty($_POST[' ']) is true?

2 Answers2