File manager - Edit - /home/autoph/public_html/voc/home/sub_add_company.php
Back
<?php $connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; mysql_connect('localhost','autoph_arnel','Hke@2001') or die ($connect_error); mysql_select_db('autoph_connect') or die($connect_error); //error_reporting(1); //if submit/ save to databasevar if(isset($_POST['done'])){ $compName = mysql_escape_string($_POST['compName']); $compContact = mysql_escape_string($_POST['compContact']); $compCode = mysql_escape_string($_POST['compCode']); $compAddress = mysql_escape_string($_POST['compAddress']); $compLocation = mysql_escape_string($_POST['compLocation']); $compRemarks = mysql_escape_string($_POST['compRemarks']); $addBy = mysql_escape_string($_POST['addBy']); $addDate = mysql_escape_string($_POST['addDate']); //insert mysql_query("INSERT INTO vts_company (comp_code, comp_name, comp_address,comp_city, comp_remarks,comp_contact, date, add_by) VALUES('{$compCode}','{$compName}','{$compAddress}','{$compLocation}','{$compRemarks}','{$compContact}','{$addDate}','{$addBy}')"); exit(); } //display from database if(isset($_POST['display'])){ $result = mysql_query("SELECT * FROM vts_company WHERE `comp_status`=1 ORDER BY `date` DESC"); echo "<table style='width:100%;'>"; echo "<thead> <tr> <th class='bgColorBlue'>CODE</th> <th class='bgColorBlue'>COMPANY NAME</th> <th class='bgColorBlue'>ADDRESS</th> <th class='bgColorBlue'>CITY</th> <th class='bgColorBlue'>STATUS</th> </tr> </thead>"; while($row=mysql_fetch_array($result)){ echo "<tr>"; echo "<td>".$row['comp_code']."</td>"; echo "<td>".$row['comp_name']."</td>"; echo "<td>".$row['comp_address']."</td>"; echo "<td>".$row['comp_city']."</td>"; echo "<td>"; if($row['comp_status']==1){echo 'Active';}else{echo 'InActive';} echo "</td>"; echo "</tr>"; } echo "</table>"; exit(); } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings