File manager - Edit - /home/autoph/public_html/voc/home/load_service_appointment.php
Back
<?php error_reporting(0); $connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; mysql_connect('localhost','root','aee1024') or die ($connect_error); mysql_select_db('db_vts') or die($connect_error); //error_reporting(1); //if submit/ save to database if(isset($_POST['search'])){ $searchDate = mysql_escape_string($_POST['searchDate']); //$apptDate = mysql_escape_string($_POST['apptDate']); $newApptDate = date_format(date_create_from_format('Y-m-d', $searchDate), 'Y/m/d'); //insert //mysql_query("INSERT INTO login_history (log_id, u_name, date, time) VALUES('{$firstname}','{$lastname}','{$birthday}','{$address}')"); exit(); } //display from database if(isset($_POST['displaySearch'])){ $searchDate = mysql_escape_string($_POST['searchDate']); $sCompID = mysql_escape_string($_POST['sCompID']); $sDealID = mysql_escape_string($_POST['sDealID']); //$newApptDate = date_format(date_create_from_format('Y-m-d', $searchDate), 'Y/m/d'); echo "<table style='width:100%;'>"; echo "<thead> <tr> <th class='bgBlue;font-color:black;width:15%'>PLATE</th> <th class='bgBlue;font-color:black;width:40%'>BRAND</th> <th class='bgBlue;font-color:black;width:40%'>MODEL</th> <th class='bgBlue;font-color:black;width:15%'>JOB TYPE</th> <th class='bgBlue;font-color:black;width:10%'>APPT. DATE</th> <th class='bgBlue;font-color:black;width:10%'>APPT. TIME</th> </tr> </thead>"; $result = mysql_query("SELECT * FROM vts_service_transaction WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$searchDate' || `transferred_to`='$sDealID' AND `appt_date`='$searchDate' ORDER BY `appt_date` ASC"); while($row=mysql_fetch_array($result)){ $cBrand = mysql_result(mysql_query("SELECT `b_name` FROM `vts_brands` WHERE `b_id`='".$row['brand_id']."'"),0); $Model = mysql_result(mysql_query("SELECT `m_name` FROM `vts_model` WHERE `m_id`='".$row['model_id']."'"),0); $tSlot = mysql_result(mysql_query("SELECT `time_slot` FROM `vts_service_slots` WHERE `slot_id`='".$row['time_slot_code']."'"),0); echo "<tr>"; echo "<td>".$row['s_v_plate']."</td>"; echo "<td>".$cBrand."</td>"; echo "<td>".$Model."</td>"; echo "<td>".$row['s_appt_type']."</td>"; echo "<td>".$row['appt_date']."</td>"; echo "<td>".$tSlot."</td>"; echo "</tr>"; } exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings