File manager - Edit - /home/autoph/public_html/voc/home/sub_save_cust_interest.php
Back
<?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); //echo "Connected"; //$apptDate = mysql_escape_string($_POST['apptDate']); //$newApptDate = date_format(date_create_from_format('Y-m-d', $apptDate), 'Y/m/d'); //transDate if(isset($_POST['likes'])){ $myInterest = mysql_escape_string($_POST['myInterest']); $myInterestDesc = mysql_escape_string($_POST['myInterestDesc']); $inCustID = mysql_escape_string($_POST['inCustID']); //$NewTransDate = date_format(date_create_from_format('Y-m-d', $afDate), 'Y/m/d'); mysql_query("INSERT INTO vts_likes (s_cust_id, s_name, s_desc) VALUES('{$inCustID}','{$myInterest}','{$myInterestDesc}')"); //mysql_query("UPDATE `vts_service_transaction` SET `transferred_to` ='$Destination', `transfer_date`='$NewTransDate',`s_arrived_date`='',`s_arrived_time`='' WHERE `s_ro_no`='$vRONumber'"); exit(); } if(isset($_POST['displaylikes'])){ $inCustID = mysql_escape_string($_POST['inCustID']); $searchID= $inCustID; $getVehicle=mysql_query("SELECT * FROM `vts_likes` WHERE `s_cust_id`='$searchID' ORDER BY `s_name` ASC"); echo "<table style='width:100%'>"; echo "<tr>"; echo "<td style='font-family:Calibri;font-size:10px;border:1px solid lightgray;background:#eafafa;padding:1px'>INFO. TYPE</td>"; echo "<td style='font-family:Calibri;font-size:10px;border:1px solid lightgray;background:#eafafa;padding:1px'>NAME / DESCRIPTION</td>"; echo "</tr>"; while($vRow = mysql_fetch_array($getVehicle)){ echo "<tr>"; echo "<td style='font-family:Calibri;font-size:10px;padding:1px;border:1px solid lightgray'>".$vRow['s_name']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;padding:1px;border:1px solid lightgray'>".$vRow['s_desc']."</td>"; echo "</trd>"; } echo "</table>"; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings