File manager - Edit - /home/autoph/public_html/voc/home/add_save_new_appointment.php
Back
<?php include 'core/init.php'; //$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); $dealID= $user_data['dealer']; $compID= $user_data['company']; //if submit/ save to databasevar if(isset($_POST['done'])){ $fullDate = mysql_escape_string($_POST['fullDate']); $clickDate = mysql_escape_string($_POST['clickDate']); exit(); } //display from database if(isset($_POST['display'])){ $fullDate = mysql_escape_string($_POST['fullDate']); $clickDate = mysql_escape_string($_POST['clickDate']); $result = mysql_query("SELECT * FROM vts_service_transaction WHERE `s_date`='$fullDate' ORDER BY `s_date` DESC"); echo "<table style='width:100%;'>"; echo "<thead> <tr> <th>PLATE</th> <th>COMPANY</th> <th>DEALER</th> <th>DATE</th> <th>TIME</th> <th></th> </tr> </thead>"; while($row=mysql_fetch_array($result)){ echo "<tr>"; echo "<td>".$row['s_v_plate']."</td>"; echo "<td>".$row['s_comp_code']."</td>"; echo "<td>".$row['s_deal_code']."</td>"; echo "<td>".$row['s_date']."</td>"; echo "<td>".$row['s_time']."</td>"; echo "<td>»</td>"; echo "</tr>"; } echo "</table>"; exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings