File manager

File manager - Edit - /home/autoph/public_html/connect/home/sub_save_cust_affiliates.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['done'])){ $afDate = mysql_escape_string($_POST['afDate']); $afContact = mysql_escape_string($_POST['afContact']); $afOrg = mysql_escape_string($_POST['afOrg']); $afIndustry = mysql_escape_string($_POST['afIndustry']); $afRole = mysql_escape_string($_POST['afRole']); $apOffice= mysql_escape_string($_POST['apOffice']); $loadCustData = mysql_escape_string($_POST['loadCustData']); $NewTransDate = date_format(date_create_from_format('Y-m-d', $afDate), 'Y/m/d'); mysql_query("INSERT INTO vts_cust_affiliates (a_cust_id, a_name, a_desc, a_position, a_start) VALUES('{$loadCustData}','{$afOrg}','{$afIndustry}','{$afRole}','{$NewTransDate}')"); //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['display'])){ $loadCustData = mysql_escape_string($_POST['loadCustData']); $searchID= $loadCustData; $getVehicle=mysql_query("SELECT * FROM `vts_cust_affiliates` WHERE `a_cust_id`='$searchID' ORDER BY `a_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'>COMPANY / ORGANIZATION NAME</td>"; echo "<td style='font-family:Calibri;font-size:10px;border:1px solid lightgray;background:#eafafa;padding:1px'>DESCRIPTION/TYPE OF BUSINESS</td>"; echo "<td style='font-family:Calibri;font-size:10px;border:1px solid lightgray;background:#eafafa;padding:1px'>POSITION</td>"; echo "<td style='font-family:Calibri;font-size:10px;border:1px solid lightgray;background:#eafafa;padding:1px'>DATE START</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['a_name']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;padding:1px;border:1px solid lightgray'>".$vRow['a_desc']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;padding:1px;border:1px solid lightgray'>".$vRow['a_position']."</td>"; echo "<td style='font-family:Calibri;font-size:10px;padding:1px;border:1px solid lightgray'>".$vRow['a_start']."</td>"; echo "</trd>"; } echo "</table>"; } ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings