File manager

File manager - Edit - /home/autoph/public_html/connect/api/prf/prf_LoadItemINfor.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("Y/m/d"); $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(). '.'); $ApiKey= $_REQUEST['keyID']; // Expect LoginName, LoginPassword //========================================================= if($ApiKey == '34234234324234234'){ $userID = $_REQUEST['userID']; $itemID= $_REQUEST['itemID']; $refCode = mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$itemID'"),0); $purposeOfRequest = mysql_result(mysql_query("SELECT `purpose_of_request` FROM `prf_request_hdr` WHERE `reference_code`='$refCode'"),0); $itemDesc = mysql_result(mysql_query("SELECT `item_description` FROM `prf_request_detl` WHERE `id`='$itemID'"),0); $itemUoM = mysql_result(mysql_query("SELECT `uom` FROM `prf_request_detl` WHERE `id`='$itemID'"),0); $itemQTY = mysql_result(mysql_query("SELECT `quantity` FROM `prf_request_detl` WHERE `id`='$itemID'"),0); $compID = mysql_result(mysql_query("SELECT `comp_id` FROM `prf_request_detl` WHERE `id`='$itemID'"),0); $compName = mysql_result(mysql_query("SELECT `comp_name` FROM `vts_company` WHERE `comp_id`='$compID'"),0); $PRFNumber=mysql_result(mysql_query("SELECT `header_ref_code` FROM `prf_request_detl` WHERE `id`='$itemID'"),0); $dateNeeded = mysql_result(mysql_query("SELECT `date_needed` FROM `prf_request_hdr` WHERE `reference_code`='$refCode'"),0); $reqByID = mysql_result(mysql_query("SELECT `request_by` FROM `prf_request_hdr` WHERE `reference_code`='$refCode'"),0); $reqByFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$reqByID'"),0); $reqByLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$reqByID'"),0); $reqByFullname = $reqByFName ." ". $reqByLName; $approvalCode = mysql_result(mysql_query("SELECT `code` FROM `prf_validate_links` WHERE `item_id`='$itemID' AND `uid`='$userID' AND `link` LIKE '%exapr.php%' AND `completed`=0"),0); $json = json_encode(["purposeOfRequest" => "$purposeOfRequest","itemDesc" => "$itemDesc","itemUoM" => "$itemUoM","itemQTY" => "$itemQTY","dateNeeded" => "$dateNeeded","requestedBy" => "$reqByFullname","PrfNumber" => "$PRFNumber","Company" => "$compName","approvalCode" => "$approvalCode"]); // } //=========================================================================== if($ApiKey == '34234234000000324234234'){ $userID = $_REQUEST['userID']; $itemID= $_REQUEST['itemID']; $sql = "SELECT prf_uploadedcanvass.vendor_code, prf_uploadedcanvass.ref_code, prf_uploadedcanvass.vendor_name, prf_uploadedcanvass.`id`, prf_uploadedcanvass.`file_code`, prf_canvass_sheet.item_id, prf_canvass_sheet.canvass_id,prf_canvass_sheet.id as CanvassSheetID, prf_canvass_sheet.quantity, prf_canvass_sheet.dummy_amount as amount,prf_canvass_sheet.dummy_total_amount, prf_canvass_sheet.user_feedback as ranking FROM prf_uploadedcanvass JOIN prf_canvass_sheet ON prf_canvass_sheet.canvass_id = prf_uploadedcanvass.id WHERE prf_canvass_sheet.item_id = $itemID"; $sqlTable = mysql_query($sql, $conn); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $count = $count + 1; $return_tag[]= $sqlRecord; } if($count > 0){ $visible="false"; $itemDescVisible="true"; }else{ $visible="true"; $itemDescVisible="false"; } $json = json_encode([$return_tag,"Visible" => "$visible","itemDesVisible" => "$itemDescVisible"]); } //=========================================================================== echo $json; ?>

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