File manager - Edit - /home/autoph/public_html/connect/MODELView_Service.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(). '.'); $selModel = $_REQUEST['selModel']; $getM= $_REQUEST['getModel']; $vDealer= $_REQUEST['vDealer']; if($getM==102477062207210911){ $return_ar = Array(); $imageLink = mysql_result(mysql_query("SELECT `image` FROM `vts_model` WHERE `m_name`='$selModel'"),0); $ModelInfoLinkk = mysql_result(mysql_query("SELECT `catalog_link` FROM `vts_model` WHERE `m_name`='$selModel'"),0); //$sql = "SELECT * FROM db_vehicle_inventory WHERE `dealer`='$vDealer' AND brand_code ='$selModel' AND `sold`= 0 AND `returned`= 0 ORDER BY brand_code ASC"; $sql = "SELECT id,brand,brand_code,status,cs_number,year_model,description,color,vin_number,engine_code,date_received,selling_dealer,unit_location,remarks,sold,reserved,incoming_unit,tagged,returned,date_released,FORMAT(price,2)as price,discount,commission,tag_expiration_date,company,dealer,released_by,released_by_comp,time_stamp FROM `db_vehicle_inventory` WHERE `dealer`='$vDealer' AND brand_code ='$selModel' AND `sold`= 0 AND `returned`= 0 ORDER BY brand_code ASC"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_ar[]= $sqlRecord; } //$json = json_encode($return_ar); $json = json_encode([$return_ar,"image"=>$imageLink,"catalog"=>$ModelInfoLinkk]); } 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