Question

I m having an issue with my IPN script. Its fine for verifying payment etc but im trying to get it to input the data into a database. The user email and password entry prior to works fine but not the second one..

$item_name = $_POST[ item_name ];
$item_number = $_POST[ item_number ];
$payment_status = $_POST[ payment_status ];
$payment_amount = $_POST[ mc_gross ];
$payment_currency = $_POST[ mc_currency ];
$txn_id = $_POST[ txn_id ];
$receiver_email = $_POST[ receiver_email ];
$payer_email = $_POST[ payer_email ];

$email = $_POST[ item_name ];
$password = mt_rand(1000, 9999);
$Random = print_r($_POST);


mysql_query("INSERT INTO users (email, password) VALUES( ". mysql_escape_string($email)     ." ,  ".md5($password)." ) ") or die(mysql_error()); 

mysql_query("INSERT INTO LNCH_Sales SET
                                                            item_name =  %s ,
                                                            item_number =  %s ,
                                                            payment_status =  %s ,
                                                            payment_amount =  %s ,
                                                            payment_currency =  %s ,
                                                                txn_id =  %s ,
                                                            receiver_email =  %s ,
                                                            payer_email =  %s ",
                                                            mysql_real_escape_string($item[ name ]),
                                                            mysql_real_escape_string($item[ number ]),
                                                            mysql_real_escape_string($payment[ status ]),
                                                            mysql_real_escape_string($payment[ amount ]),
                                                            mysql_real_escape_string($payment[ currency ]),       
                                                            mysql_real_escape_string($txn[ id ]),
                                                            mysql_real_escape_string($receiver[ email ]),
                                                            mysql_real_escape_string($payer[ email ])

                                                                      );

有什么想法吗? 这里有什么问题?

Answer 1

您的语法错误 - 而不是

INSERT INTO LNCH_SALES SET

(这看起来像 INSERT 和 UDATE 之间的混合混合物),您需要

INSERT INTO LNCH_SALES(<column_list>) VALUES (...

Answer 2

@FrankSchmitt说,

您可以跳过列列表的唯一方法是,如果插入列的数 = 与表格列的数相同,则一.E:

jcho360> create table test (id int,name varchar(20));
Query OK, 0 rows affected (0.05 sec)

jcho360> insert into test values (1, Jcho360 );
Query OK, 1 row affected (0.00 sec)

jcho360> insert into test values (1);
ERROR 1136 (21S01): Column count doesn t match value count at row 1

jcho360> insert into test(id) values (1);
Query OK, 1 row affected (0.01 sec)

正如你所见,只有我准备去填充“插入”中的所有列, 你才能跳过列列表。

友情链接