我想為我的搜索找到正確的解決方案。我使用 Woocommerce，我創建了 5 個產品，包括 3 個專用虛擬產品。這里是這些產品的 id "Product 1" = #id23, "Product 2" = #id24 and "Product 3" = #id26 我想當訂單支付成功后，腳本（要包括在我的子主題的functions.php中）分析我的訂單，如下所示：
例如，如果買家購買了數量為 x2 的“產品 1”，腳本將運行腳本兩次，就像在資料庫中添加一些東西（比如自動生成的密碼、隨機序列號、日期、產品名稱、元資訊...）。 請注意：然而，回圈兩次的資訊必須不同，尤其是密碼，序列號，例如）并且買家必須購買“產品 2”，腳本將不得不再次運行......
因此，如果您理解我的意思，這個腳本必須運行 n 次，包括帶有 ID（id#23、id#24、id#26）和數量的產品。
這是一段合乎邏輯的代碼（不起作用），因為我在尋求幫助；）
代碼更改/更新但不起作用:(
<?php
// When payment is OK
function so_32512552_payment_complete( $order_id )
{
// Connecting to external DB credentials
// the file 'connect_sql.inc.php' is in the same directory than functions.php on your child theme?
include ('connect.inc.php');
// Create connection, try to avoid this, use wpdb class
//$conn = new mysqli($DBHost, $DBLogin, $DBPass, $DBName);
$conn = mysqli_connect($DBHost, $DBLogin, $DBPass, $DBName);
// Check all specific products IDs (#23, #24 and #26) to be treat --- Possibility to add new products IDs later...
// this must implement in other way, but depend on your process
//$productsIds = array(18, 19, 20, 21, 22, 23);
$productsIds = array(18, 19, 20, 21, 22, 23);
// Check if the connection has no errors
if (!$conn->connect_error)
{
$order = wc_get_order( $order_id );
// remember $item is an instance of WC_Order_item
foreach ( $order->get_items() as $item )
{
// no use $item['product_id']
if ( in_array($item->get_id(), $productsIds) )
{
//$qty = $order->get_quantity_from_item( $item );
// the correct way for get the quantity is this, but not necesary here, there will not be reuse
// $qty = $item->get_quantity();
// this is an infinite loop
// while ($qty):
for ($i=0; $i < $item->get_quantity(); $i )
{
// Get datas into variables
// this will not work
// $customer_name = $order->get_customer_name();
// use instead billing or shippings fields
$customer_name = $order->get_billing_first_name().' '.$order->get_billing_last_name();
// this will not work
// $customer_email = $order->get_customer_email();
$customer_email = $order->get_billing_email();
// this will not work
// use
$product = wc_get_product($item->get_id());
//$product_name = $order->get_product_from_item($item);
$product_name = $product->get_name();
// no use this, no good
// $password = rand(9999,9999999);
$password = wp_generate_password( 10, false );
// neither this
// $serial_number = rand(9999,9999999);
// this implementation depend on your project
$serial_number = rand(9999,9999999);
// Add a new entry in DB thru SQL command
// where the sql is executed?
//$sql = "INSERT INTO tableTest_v5 (user_fullname, user_email, software_product, user_passwd, user_licensenumber, val1) VALUES ('$customer_name', '$customer_email', '$product_name', '$password', '$serial_number')";
mysqli_query("INSERT INTO `tableTest_v5` (`id`, `state_account`, `user_email`, `user_passwd`, `user_fullname`, `user_corporate`, `user_licensenumber`, `software_product`, `software_license`, `activation_date`, `software_expiredate`, `wcid`, `user_computerinfos`, `activation_cpuname`, `activation_id`, `activation_cpt`, `superaccess`) VALUES (NULL, -1, 'email', NULL, 'Nick POHENIS', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, 0)");
//$conn->query($sql);
// Then entry added, prepare and send the mail to customer
// this not good, use other implementation if can
$message = 'Hi,'.$customer_name;
$message .= 'Your product: '.$product_name;
$message .= 'Name: '.$customer_name;
$message .= 'ID: '.$customer_email;
$message .= 'Password: '.$password;
$message .= 'Serial number: '.$serial_number;
wp_mail('[email protected]', 'Email: Additionnal Info', $message);
}
//endwhile;
}
}
// Close DB
//$conn->close();
mysqli_close($conn);
} else {
// no die, because we are in woocommerce task 'payment_complete'
// register as other way for inform to you
// die("Connection failed: " . $conn->connect_error);
}
}
add_action( 'woocommerce_payment_complete', 'so_32512552_payment_complete' );
?>
希望您理解，無論如何，非常感謝您的幫助。因為我已經做了幾個星期的研究沒有成功。歡迎您的幫助！！！！
問候， 尼科
uj5u.com熱心網友回復：
<?php
// When payment is OK
// remove this, it is not in use
// global $woocommerce;
function so_32512552_payment_complete( $order_id )
{
// Connecting to external DB credentials
// the file 'connect_sql.inc.php' is in the same directory than functions.php on your child theme?
include ('connect_sql.inc.php');
// Create connection, try to avoid this, use wpdb class
$conn = new mysqli($servername, $username, $password, $dbname);
// Check all specific products IDs (#23, #24 and #26) to be treat --- Possibility to add new products IDs later...
// this must implement in other way, but depend on your process
$productsIds = array(23, 24, 26);
// Check if the connection has no errors
if (!$conn->connect_error)
{
$order = wc_get_order( $order_id );
// remember $item is an instance of WC_Order_item
foreach ( $order->get_items() as $item )
{
// no use $item['product_id']
if ( in_array($item->get_id(), $productsIds) )
{
//$qty = $order->get_quantity_from_item( $item );
// the correct way for get the quantity is this, but not necesary here, there will not be reuse
// $qty = $item->get_quantity();
// this is an infinite loop
// while ($qty):
for ($i=0; $i < $item->get_quantity(); $i )
{
// Get datas into variables
// this will not work
// $customer_name = $order->get_customer_name();
// use instead billing or shippings fields
$customer_name = $order->get_billing_first_name().' '.$order->get_billing_last_name();
// this will not work
// $customer_email = $order->get_customer_email();
$customer_email = $order->get_billing_email();
// this will not work
// use
$product = wc_get_product($item->get_id());
//$product_name = $order->get_product_from_item($item);
$product_name = $product->get_name();
// no use this, no good
// $password = rand(9999,9999999);
$password = wp_generate_password( 16, false );
// neither this
// $serial_number = rand(9999,9999999);
// this implementation depend on your project
$serial_number = rand(9999,9999999);
// Add a new entry in DB thru SQL command
// where the sql is executed?
$sql = "INSERT INTO MyData_v5 (fullname, email, productname, password, serialnumber, val1) VALUES ('$customer_name', '$customer_email', '$product_name', '$password', '$serial_number')";
// maybe $conn->query($sql);
// Then entry added, prepare and send the mail to customer
// this not good, use other implementation if can
// $message = 'Hi,'.$cumstomer_name;
// has an extra 'm'
$message = 'Hi,'.$customer_name;
// need '_'
$message .= 'Your product: '.$product_name;
// has an extra 'm'
// $message .= 'Name: '.$cumstomer_name;
$message .= 'Name: '.$customer_name;
$message .= 'ID: '.$customer_email;
$message .= 'Password: '.$password;
$message .= 'Serial number: '.$serial_number;
wp_mail($customer_email, 'Email: Additionnal Info', $message);
}
//endwhile;
}
}
// Close DB
$conn->close();
} else {
// no die, because we are in woocommerce task 'payment_complete'
// register as other way for inform to you
// die("Connection failed: " . $conn->connect_error);
}
}
add_action( 'woocommerce_payment_complete', 'so_32512552_payment_complete' );
uj5u.com熱心網友回復：
我更新了下面的代碼：
<?php
// When payment is OK
function so_32512552_payment_complete( $order_id ) {
// Connecting DB
require_once('connect.inc.php');
$conn = new PDO('mysql:host='.$DBHost.';dbname='.$DBName.';charset=utf8', $DBLogin, $DBPass);
if (!$conn->connect_error) {
$order = wc_get_order( $order_id );
foreach ( $order->get_items() as $item ) {
// Init.
$product_ids = array($item->get_product_id(), $item->get_variation_id());
// Declare all IDs products
$items_ids = array(18, 19, 20, 21, 22, 23, 92);
// Variables
$customer_name = $order->get_billing_first_name().' '.$order->get_billing_last_name();
$customer_email = $order->get_billing_email();
$product = wc_get_product($item->get_id());
//$product_name = $product->get_name();
$password = wp_generate_password( 10, false );
$serial_number = rand(9999,9999999);
$wcid = get_current_user_id();
// Here SQL command and send email
for ( $i = 0; $i <= $item->get_quantity(); $i ) {
// SQL Command
$req = $conn->prepare('INSERT INTO `tabletest_v5` (state_account, user_fullname, user_email, user_passwd, user_corporate, user_licensenumber, software_product, software_license, software_expiredate, activation_cpt, superaccess, wcid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)');
$req->execute(array(
1,
$customer_name,
$customer_email,
$password,
"CORP INC.",
$serial_number,
1,
1,
date('Y-m-d', strtotime()),
3,
0,
$wcid
));
// Compose message email
$message = 'Hi,'.$customer_name;
$message .= 'Your product: '.$product_name;
$message .= 'Name: '.$customer_name;
$message .= 'ID: '.$customer_email;
$message .= 'Password: '.$password;
$message .= 'Serial number: '.$serial_number;
$message .= 'WCID: '.$wcid;
wp_mail($customer_email, 'Credentials', $message);
}
}
} else {}
}
add_action( 'woocommerce_payment_complete', 'so_32512552_payment_complete' );
?>
EDT ：它有效，但是，如果我將一個專案的數量設定為 3 (x3)... 問題，我收到 3 封電子郵件，但資料相同，并且資料庫中有 3 個新條目，但資料相同（例如相同的密碼、相同的序列號。 ..)
如何解決這個問題？
干杯，尼科。
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/358717.html
標籤：php WordPress的 功能 求购 支付
上一篇：洗掉某些WooCommerce電子郵件通知中的產品購買說明
下一篇：波形可訪問性檢查中的空按鈕錯誤