问如何根据日期自动设置id

EN

$tgl_pesan = date("Ymd");

$cek = mysqli_query($conn, "SELECT max(kd_booking) AS kode FROM booking WHERE kd_booking LIKE '$tgl_pesan%'");
$row = mysqli_fetch_array($cek);
$kdMax = $row['kode'];

$nourut = substr($kdMax, 8, 4);
$nourut++;
$char = "BO";
$kd_transaksi = $char.$tgl_pesan.printf('%04s', $nourut);

$kd_booking = mysqli_insert_id($conn);

$book = "INSERT INTO detail_booking (kd_booking,kd_transaksi,total_bayar) VALUES ('".$kd_booking."','$kd_transaksi',$total_bayar')";
$ok = mysqli_query($conn,$book);
if ($ok) {
    header('location:../mybooking.php');
} else{
  mysqli_close($conn);
}

$cek = mysqli_query($conn, "SELECT max(kd_booking) AS kode FROM booking WHERE kd_booking LIKE '$tgl_pesan%'");

CREATE TABLE `booking` (
  `kd_booking` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `kd_paket` int(11) NOT NULL,
  `jml_org` int(11) NOT NULL,
  `tgl_pesan` date NOT NULL,
  `tgl_wisata` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;