双插入MYSQLI的问题

Question

你可以用mysqli做这样的事情吗？我什么都没进。

// Place the transaction into the database   
   $sql = "INSERT INTO transactions (product_id_array, email, first_name, last_name, payment_date, mc_gross, payment_currency, txn_id, receiver_email, payment_type, payment_status, txn_type, payer_status, address_street, address_city, address_state, address_zip, address_country, address_status, notify_version, verify_sign, payer_id, mc_currency, mc_fee, ip, username)       
       VALUES('$custom','$payer_email','$first_name','$last_name','$payment_date','$mc_gross','$payment_currency','$txn_id','$receiver_email','$payment_type','$payment_status','$txn_type','$payer_status','$address_street','$address_city','$address_state','$address_zip','$address_country','$address_status','$notify_version','$verify_sign','$payer_id','$mc_currency','$mc_fee','$ip','$user_name')";
       $uid = mysqli_insert_id($db_conx); 
            $sql .= "INSERT INTO courseprogress (id, product_id_array, email, username) VALUES ('$uid','$custom','$payer_email','$username')";
            $query = mysqli_query($db_conx, $sql);
   //

我试着使用两个单独的语句，比如这个

$sql = "INSERT INTO transactions (product_id_array, email, first_name, last_name, payment_date, mc_gross, payment_currency, txn_id, receiver_email, payment_type, payment_status, txn_type, payer_status, address_street, address_city, address_state, address_zip, address_country, address_status, notify_version, verify_sign, payer_id, mc_currency, mc_fee, ip, username)       
       VALUES('$custom','$payer_email','$first_name','$last_name','$payment_date','$mc_gross','$payment_currency','$txn_id','$receiver_email','$payment_type','$payment_status','$txn_type','$payer_status','$address_street','$address_city','$address_state','$address_zip','$address_country','$address_status','$notify_version','$verify_sign','$payer_id','$mc_currency','$mc_fee','$ip','$user_name')";
$query = mysqli_query($db_conx, $sql);
//added as addition for newsletter signup below
            $uid = mysqli_insert_id($db_conx); 
            $sqlemail = "INSERT INTO courseprogress (id, product_id_array, email,username) VALUES ('$uid','$custom','$payer_email','$username')";
            $query = mysqli_query($db_conx, $sqlemail);
   //

我只能在较低的尝试中获得第一个通过。。。有什么建议吗？

Answer 1

如果$db_conx数据放错了位置，它需要在同一条语句中。你升级sql了吗？。。。我做到了，我不得不重新设计我创建的整个项目。创建一个保存数据或全局数据的函数，每次在语句或函数中时重新声明$db_conx。