<?php
$date = date("d.m.Y G:i");
$servername = "localhost";
$database = "*";
$username = "*";
$password = "*";
$conn = mysqli_connect($servername, $username, $password, $database);
mysqli_set_charset($conn, 'utf8');
$sql = "insert into order_products( name, price, id_products, amount, image) select name, price, id_products, amount, image from order_products where id_order=1";
mysqli_query($conn, $sql);
$id = mysqli_insert_id($conn);
mysqli_close($conn);
header("Location: /");
?>