File manager - Edit - /home/autoph/public_html/voc/home/sub_add_vehicle_model.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); //if submit/ save to databasevar if(isset($_POST['done'])){ $modelName = mysql_escape_string($_POST['modelName']); $modelDesc = mysql_escape_string($_POST['modelDesc']); $brandID = mysql_escape_string($_POST['brandSelected']); $addBy = mysql_escape_string($_POST['addBy']); $addDate = mysql_escape_string($_POST['addDate']); $outStat = '1'; mysql_query("INSERT INTO vts_model (b_id, m_name, m_desc, m_status, date, add_by, brand_id) VALUES('{$brandID}','{$modelName}','{$modelDesc}','{$outStat}','{$addDate}','{$addBy}','{$brandID}')"); //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('{$dealName}','{$outStat}','{$outCode}')"); //$systemMessage="Record has been saved..."; exit(); } //display from database if(isset($_POST['display'])){ $result = mysql_query("SELECT * FROM vts_model WHERE `m_status`=1 ORDER BY `m_name` DESC"); echo "<table style='width:100%;'>"; echo "<thead> <tr> <th>ID</th> <th>BRAND</th> <th>MODEL</th> <th>SHORT DESCRIPTION</th> </tr> </thead>"; while($row=mysql_fetch_array($result)){ echo "<tr>"; echo "<td>".$row['b_id']."</td>"; echo "<td>"; $brandName = mysql_result(mysql_query("SELECT `b_name` FROM `vts_brands` WHERE `b_id`='".$row['b_id']."'"),0); echo $brandName; echo "</td>"; echo "<td>".$row['m_name']."</td>"; echo "<td>".$row['m_desc']."</td>"; echo "</tr>"; } echo "</table>"; exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings