File Content: save_roomInventory.php <?php include('../library.php'); // Login Detail $roomIdupdate=$_REQUEST['id']; $hotelId=1; $totalRoom=$_REQUEST['qty']; $roomRate=$_REQUEST['rate']; $extraBedRate=$_REQUEST['extraBed']; $roomcatId=$_REQUEST['id']; $dateFrom=date('Y-m-d',strtotime($_REQUEST['date1'])); $dateTo=date('Y-m-d',strtotime($_REQUEST['date2'])); $time1=date('H:i:s'); $date1=date_create($dateFrom); $date2=date_create($dateTo); $diff=date_diff($date2,$date1); echo $days= $diff->format("%a"); $result=$mysql2->m_Query("update tblroomcategory set inventroyStart='$dateFrom',inventroyEnd='$dateTo' where id='$roomIdupdate'"); for($i=0;$i<=$days;$i++) { $i; echo $inventoryDate=date('Y-m-d',strtotime("+".$i."Days",strtotime($dateFrom))); echo $sql="insert into tblroominventory(hotelId,roomId,roomQty,roomRate,extraBedRate,inventoryDates,leftroomQty) values($hotelId,$roomIdupdate,$totalRoom,$roomRate,$extraBedRate,'$inventoryDate',0)"; $result = $mysql->m_Query($sql); } header("location:../Master_Room.php?id=$hotelId&Add-Room=true&msg=setInventroy"); ?> Submit