php mysql insert 返回_php – MySQL – 在INSERT上返回生成的AUTO_IN...

希望是一个简单的 – 我无法找到一个强大的解决方案.

我正在构建一个生成id_cart AUTO_INCREMENT主键的购物车机制.购物车商品有另一张表,其中包含尺寸等购物车产品变量.我想在大小表中归因于相同的id_cart.

CREATE TABLE

-> id_size_cart NOT NULL PRIMARY KEY AUTO_INCREMENT,

-> id_cart //THIS WILL BE THE AI value from the product cart

-> size_name

我见过SELECT LAST_INSERT_ID().

这是多么可靠,以确保它是最后插入的ID？不希望客户的尺寸错误！

__编辑___

谢谢你的反馈.不过,我遇到了麻烦.见下面的实际代码;

//add product to cart table

$addtocart_sql = "INSERT INTO store_cart (id_cart, id_session) VALUES ('', '".$_COOKIE["PHPSESSID"]."')";

$addtocart_res = mysqli_query($dbConnect, $addtocart_sql) or die(mysqli_error($dbConnect));

$last_row_id = mysqli_query($dbConnect, "SELECT LAST_INSERT_ID()") or die(mysqli_error($dbConnect));

echo 'INSERT worked!
';

echo $last_row_id;

错误显示为

Parse error: syntax error, unexpected T_STRING in /websites/LinuxPackage05/4v/35/xy/4v35xy-55415.webfusion-hosting.co.uk/public_html/noff-group.com/dev/add_to_cart.php on line 27

提前致谢.