File manager - Edit - /home/autoph/public_html/connect/InHouseLeadCount.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['APIkey']; //====================================================================== //========================================================= if($APIkey == 10241024102410241024102410241024001){ $userID = $_REQUEST['userID']; $assigned = mysql_result(mysql_query("SELECT COUNT('id') FROM `asa_InHouseLeads` WHERE deleted='0' AND `status`=0 AND `sc_id`!= 0"),0); $open = mysql_result(mysql_query("SELECT COUNT('id') FROM `asa_InHouseLeads` WHERE deleted='0' AND `status`=0 AND `sc_id`= 0 AND `pros_status`!='Closed'"),0); $myLeads= mysql_result(mysql_query("SELECT COUNT('id') FROM `asa_InHouseLeads` WHERE deleted='0' AND `status`=0 AND `sc_id`= $userID"),0); $myReferrals= mysql_result(mysql_query("SELECT COUNT('id') FROM `asa_InHouseLeads` WHERE deleted='0' AND `ower_id`= $userID"),0); $json = json_encode(["assigned"=>$assigned,"open"=>$open,"myLeads"=>$myLeads,"myReferrals"=>$myReferrals]); echo $json; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings