File manager

File manager - Edit - /home/autoph/public_html/connect/TOP_Priority.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(). '.'); $invRequest= $_REQUEST['invKey']; // Expect LoginName, LoginPassword $myBrandName = $_REQUEST['myBrandName']; // Expect LoginName, LoginPassword //====================================================================== //====================================================================================================================================================================================================================================== if($invRequest == 88101010242488){ mysql_query("DROP TABLE IF EXISTS `tempTopPriority`"); $sql = "CREATE TABLE IF NOT EXISTS `tempTopPriority` (`invID` int(11) NOT NULL AUTO_INCREMENT, `brand_name` varchar(30) NOT NULL, `model_name` varchar(30) NOT NULL, `cs_number` varchar(30) NOT NULL, `variant_desc` varchar(100) NOT NULL, `unit_age` varchar(15) NOT NULL, `unit_YearModel` varchar(5) NOT NULL, `unit_color` varchar(50) NOT NULL, `selling_dealer` varchar(50) NOT NULL, `unit_price` varchar(15) NOT NULL, `unit_discount` varchar(15) NOT NULL, `unit_comm` varchar(15) NOT NULL, `unit_status` varchar(10) NOT NULL, `date_received` varchar(7) NOT NULL, `model_picture` varchar(150) NOT NULL, PRIMARY KEY (`invID`))"; $sqlResponse = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): ". mysql_error(). '.'); $sql = "SELECT * FROM db_vehicle_inventory WHERE sold = 0 AND returned = 0 AND brand ='$myBrandName' AND status='Available' ORDER BY id LIMIT 80 "; $sqlTable = mysql_query($sql, $conn); while($row = mysql_fetch_assoc($sqlTable)) { $olddate = $row['date_received']; $now = time(); // or your date as well' $your_date = strtotime($olddate); $datediff = $now - $your_date; $totalCount=round($datediff / (60 * 60 * 24)); if($totalCount > 99){ $myBrand=$row['brand']; $myModel=$row['brand_code']; $myVariant=$row['description']; $myUnitAge=$totalCount." Days"; $myYearModel=$row['year_model']; $myCS = $row['cs_number']; $myColor=$row['color']; $myPrice=number_format($row['price'],2,'.',','); $myDiscount=number_format($row['discount'],2,'.',','); $myComm=number_format($row['commission'],2,'.',','); $myDealer=$row['selling_dealer']; $myStatus=$row['status']; $myDateReceived=$row['date_received']; $modelPicture=mysql_result(mysql_query("SELECT `image` FROM `vts_model` WHERE `m_name`='$myModel'"),0); $sql = "INSERT INTO tempTopPriority( cs_number, brand_name, model_name, variant_desc, unit_age, unit_YearModel, unit_color, unit_price, selling_dealer, unit_discount, unit_comm, unit_status, date_received, model_picture) VALUES( '$myCS', '$myBrand', '$myModel', '$myVariant', '$myUnitAge', '$myYearModel', '$myColor', '$myPrice', '$myDealer', '$myDiscount', '$myComm', '$myStatus', '$myDateReceived', '$modelPicture')"; $sqlQuery = mysql_query($sql, $conn) or die("Couldn't perform query $sql (".__LINE__."): " . mysql_error() . '.'); } } $return_arr = Array(); $return_info = Array(); $sqlQ = "SELECT * FROM tempTopPriority WHERE `unit_status`='Available' ORDER BY unit_age DESC"; $sqlTableQ = mysql_query($sqlQ, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTableQ)) { $return_arr[]= $sqlRecord; } $json = json_encode($return_arr); $did_something += 1; } 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