Copy row to new row in MySQLi database using PHP
January 24, 2024
$query = "
INSERT INTO items (
item_id,
title,
price
)
SELECT
id,
title,
price
FROM items
WHERE deleted != 'y'
AND id = ?
LIMIT 1
";
$stmt = $mysqli -> prepare($query);
$stmt -> bind_param("s", $item_id);
$stmt -> execute();
$insert_id = $mysqli -> insert_id;
if ( $insert_id > 0 ) {
echo $insert_id;
}