File Content: save_BookingE.php <?php include("../library.php"); $vehicle=$_REQUEST['vehicle']; $zone=$_REQUEST['zone']; $shift=$_REQUEST['shift']; $date1=$_REQUEST['date1']; $date2=$_REQUEST['date2']; $indianRate=$_REQUEST['indianRate']; $foreignerRate=$_REQUEST['foreignerRate']; $seat=$_REQUEST['seat']; $id=$_REQUEST['setId']; $date11=date_create($date1); $date12=date_create($date2); $diff=date_diff($date11,$date12); echo $days= $diff->format("%a"); $createdDate=date('Y-m-d'); $query="update tblsetinventroy set startDate='$date1',endDate='$date2',indianRate='$indianRate',foreignerRate='$foreignerRate',seat='$seat' where id=$id"; $result=$mysql->m_Query($query); $result=$mysql->m_Query("delete from tblinventorys where setId=$id"); for($d=0;$d<=$days;$d++) { $dates=date('Y-m-d',strtotime($d.'day',strtotime($date1))); echo $query="insert into tblinventorys(setId,vehicleName,shift,zone,startDate,endDate,seat,leftseat,bookingStatus,status,indianRate,foreignerRate)values('$id','$vehicle','$shift','$zone','$dates','$dates','$seat','$seat','Open','Approved','$indianRate','$foreignerRate')"; $result=$mysql4->m_Query($query); } header("location:../Master-Inventory.php?msg=success"); ?> Submit