File manager - Edit - /home/autoph/public_html/connect/home/sub_add_location.php
Back
<?php include 'core/database/connect.php'; //error_reporting(1); //if submit/ save to databasevar if(isset($_POST['done'])){ $location = mysql_escape_string($_POST['location']); $desc = mysql_escape_string($_POST['desc']); $addBy = mysql_escape_string($_POST['addBy']); $addDate = mysql_escape_string($_POST['addDate']); $outStat = 1; $outCode = 'OUT'; mysql_query("INSERT INTO vts_check_out_reasons (out_description, loc_description, code, out_status, date, add_by) VALUES('{$location}','{$desc}','{$outCode}','{$outStat}','{$addDate}','{$addBy}')"); //UPDATE CHECK-OUT REASON TABLE TO INCLUDE DEALER IN SELECTION DURING GUARD CHECK-OUT //mysql_query("INSERT INTO vts_check_out_reasons (out_description, out_status, code) //VALUES('{$deal_name}','{$outStat}','{$outCode}')"); //$systemMessage="Record has been saved..."; exit(); } //display from database if(isset($_POST['display'])){ $result = mysql_query("SELECT * FROM vts_check_out_reasons WHERE `out_status`=1 AND `code`='OUT' ORDER BY `out_description` ASC"); echo "<table style='width:100%;'>"; echo "<thead> <tr> <th>CODE</th> <th>LOCATION NAME</th> <th>DESCRIPTION</th> </tr> </thead>"; while($row=mysql_fetch_array($result)){ echo "<tr>"; echo "<td>".$row['out_id']."</td>"; echo "<td>".$row['out_description']."</td>"; echo "<td>".$row['loc_description']."</td>"; echo "</tr>"; } } echo "</table>"; exit(); ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings