File manager - Edit - /home/autoph/public_html/connect/home/searchReservationResult.php
Back
<?php include 'core/database/connect.php'; $toDate = date_create() ->format("Y/m/d"); if(isset($_POST['searchText'])){ $searchText = mysql_real_escape_string($_POST['searchText']); $ActiveCompanyCode = mysql_real_escape_string($_POST['ActiveCompanyCode']); $bBrand = mysql_real_escape_string($_POST['bBrand']); $getBrand = mysql_query("SELECT * FROM `db_vehicle_inventory` WHERE `brand`= '$bBrand' AND `company` ='$ActiveCompanyCode' AND `reserved`= 1 AND `sold` = 0 AND `cs_number` LIKE '%$searchText%' || `brand` = '$bBrand' AND `company` ='$ActiveCompanyCode' AND `reserved`= 1 AND `sold` = 0 AND `brand_code` LIKE '%$searchText%' ORDER BY brand DESC"); //VALIDATE ACCESS echo "<div class='bodyTitle'>SEARCH RESULT - ".$searchText."</div>"; echo "<table id='mainModel' style='width:100%;margin:00px'>"; echo "<thead>"; echo "<th style='width:5%'>UNIT ID</th>"; echo "<th style='width:10%'>DATE</th>"; echo "<th style='width:10%'>CS NUMBER</th>"; echo "<th style='width:10%'>AGENT CODE</th>"; echo "<th style='width:25%'>VARIANT</th>"; echo "<th style='width:5%'>MAKE</th>"; echo "<th style='width:15%'>V. MODEL</th>"; echo "<th style='width:15%'>COLOR</th>"; echo "</thead>"; while($row=mysql_fetch_array($getBrand)){ ?><tr><?php echo "<td style='text-align:left;padding:5px'>".$row['id']."</td>"; echo "<td style='text-align:left;padding:5px'>".$row['saved_date']."</td>"; echo "<td style='text-align:left;padding:5px'>".$row['cs_number']."</td>"; echo "<td style='text-align:left;padding:5px'>".$row['tagged']."</td>"; echo "<td style='text-align:left;padding:5px'>".$row['description']."</td>"; echo "<td style='text-align:left;padding:5px'>".$row['year_model']."</td>"; echo "<td style='text-align:left;padding:5px'>".$row['brand_code']."</td>"; echo "<td style='text-align:left;padding:5px'>".$row['color']."</td>"; echo "</tr>"; } echo "</table>"; //OF VALIDATION } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings