File manager

File manager - Edit - /home/autoph/public_html/connect/SEARCH_VARIANT.php

Back
<?php date_default_timezone_set('Asia/Manila'); header('Content-Type: application/json'); $sqlUser = 'autoph_arnel'; $sqlDatabase = 'autoph_connect'; $sqlPass = 'Hke@2001'; $toDate = date_create() ->format("m/d/Y"); // for viewing date only $myDate ="As of ".$toDate; $conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) or die ("Couldn't connct to MySQL server on $sqlHost: ". mysql_error(). '.'); $db = mysql_select_db($sqlDatabase, $conn) or die ("Couldn't select database $sqlDatabase: ". mysql_error(). '.'); $keyID= TRIM($_REQUEST['searchKey']); $searchString= TRIM($_REQUEST['searchVariant']); $searchColor= TRIM($_REQUEST['searchColor']); $searchModel= TRIM($_REQUEST['searchModel']); //====================================================================== $searchModelName = mysql_result(mysql_query("SELECT `m_name` FROM `vts_model` WHERE `m_id`='$searchModel'"),0); if($keyID==101010110000){ $searchModel= TRIM($_REQUEST['searchModel']); if($searchString == ""){ exit(); } $return_tag = Array(); $sql = "SELECT brand_code, cs_number, company, dealer, year_model, description, color, cs_number,status,price, discount, commission FROM db_vehicle_inventory WHERE `brand_code` LIKE '%$searchModelName%' AND `returned`= 0 AND `sold`= 0 AND color='$searchColor' ORDER BY description ASC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_tag[]= $sqlRecord; } $json = json_encode($return_tag); } if($keyID==101010111222112212){ if($searchString == ""){ exit(); } $return_tag = Array(); $sql = "SELECT brand_code, cs_number, company, dealer, year_model, description, color, cs_number,status,price, discount, commission FROM db_vehicle_inventory WHERE `description` LIKE '%$searchString%' AND `returned`= 0 AND `sold`= 0 AND color='$searchColor' ORDER BY description ASC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_tag[]= $sqlRecord; } $json = json_encode($return_tag); } if($did_something === 0) { $msg = did_nothing_message; $json = json_encode(["status" => "$MyCustomerID", "statusCode" => "$customerType"]); } echo $json; ?>

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