query($get_inch); $set_u = mysql_fetch_array($get_inches); $insert_query = "INSERT INTO tbl_appointment_office_track (track_id, earlier_date, hour_date, min_date, am_date, app_id, added_date) VALUES('$id', '".$set_u['appointment_date']."', '".$set_u['hour_date']."', '".$set_u['min_date']."', '".$set_u['am_date']."', '".$set_u['app_id']."', '$my_date');"; $DB->query($insert_query); $flag="sucess"; $Query="update tbl_appointment_office set appointment_date = '$date', mobile_no='".$_POST['mobile']."', order_id = '".$_POST['order_id']."', name='".$_POST['name']."', location='".$_POST['location']."', razid='".$_POST['vehicle']."', amount = '".$_POST['age']."', payment = '".$_POST['req_pay']."', des = '".$_POST['consulting']."', paid_amount = '".$_POST['paid_amount']."', app_id = '$app_id', hour_date = '$hh', min_date = '$mm', am_date = '$am', update_status='$update_status' where id='$id'"; $DB->query($Query); $insert_query = "INSERT INTO tbl_appointment_office_track (track_id, earlier_date, modified_date, from_hour, from_min, from_sta, to_hour, to_min, to_sta, added_date) VALUES('$id', '', '', 0, 0, '', 0, 0, '', '');"; $flag="sucess"; // header("location:appointment_details_direct.php"); } ?>
Success! Data Added Sucessfully.
Danger! Already Exists.

Appointmenr

query($get_in); $get_infos = mysql_fetch_array($get_info); $get_inch = "select * from tbl_appointment_office_track where track_id = '$_REQUEST[id]' order by id asc limit 1"; $get_inches = $DB->query($get_inch); $check_rows = mysql_num_rows($get_inches); if($check_rows > 0){ $set_u = mysql_fetch_array($get_inches); $earlier_date = $set_u['earlier_date']; }else{ $earlier_date = $get_infos['appointment_date']; } ?>
'https://drganbuganapathi.com/superadmin/order-admin/fill_dropdown.php', CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => '', CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 0, CURLOPT_FOLLOWLOCATION => true, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => 'POST', CURLOPT_POSTFIELDS => array('prod_id' => $mydate, 'id'=>$_REQUEST['id']), CURLOPT_HTTPHEADER => array( 'Cookie: PHPSESSID=kevjicbelm6ji9j22cnmjrfgd7' ), )); $response = curl_exec($curl); curl_close($curl); echo $response; ?>