问获取上次插入记录的ID

EN

function report() {



if(isset($_GET['tx'])) {  

$amount = $_GET['amt']; 
$currency = $_GET['cc'];
$transaction = $_GET['tx']; 
$status = $_GET['st']; 
$total = 0;  
$item_quantity = 0; 




$send_order = query(" INSERT INTO orders (order_amount, order_transaction, order_status, order_currency) VALUES('{$amount}','{$currency}','{$transaction}','{$status}')");


$last_id = last_id(); // this calls last_id in functions.php


confirm($send_order);  




foreach ($_SESSION as $name => $value) { 


if($value > 0 ) { 


if(substr($name, 0, 8) == "product_") { 


$length = strlen($name - 8); 

$id = substr($name, 8 , $length);




$query = query(" SELECT * FROM products WHERE product_id = " . escape_string($id). " " );

confirm($query);



while ($row = fetch_array($query)) {

$product_price = $row['product_price'];
$sub = $row['product_price']*$value;
$item_quantity +=$value;



$insert_report = query(" INSERT INTO reports (product_id, order_id, product_price, product_quantity) VALUES('{$id}','{$last_id}','{$product_price}','{$value}')");
confirm($insert_report); //runs the confirm helper method  




} // end of while loop


$total += $sub; 
echo $item_quantity; 


} // end of substring if statement




}// end of if value




} // end of foreach loop


session_destroy();

} else {


redirect("index.php");


} //end of if isset GET tx




} // end of report function /////////////////

function last_id() {

global $connection;

return mysqli_insert_id($connection);



}