File manager - Edit - /home/autoph/public_html/connect/home/leadsquery.php
Back
<?php $connect_error = 'Sorry, we\'re experiencing connection problem. Please try again later... Thank you!'; mysql_connect('localhost','root','aee1024') or die ($connect_error); mysql_select_db('db_vts') or die($connect_error); //error_reporting(0); $select = '*'; if($select == "*") { $empID = 721; // Expects select = * or select = RegID //$return_arr = Array(); $return_chk = Array(); $sql = "SELECT * FROM sales_prospecting WHERE status='open' AND employee_id='$empID' "; $sqlTable = mysql_query($sql); while($sqlRecord = mysql_fetch_assoc($sqlTable)) { $return_chk[]=$sqlRecord; //array_push($return_arr, $sqlRecord); //$sql = "SELECT * FROM $checkins_table LEFT JOIN $registrations_table ON CheckinRegID = RegID WHERE CheckinRegID = ".$sqlRecord['RegID']." ORDER BY CheckinTime DESC LIMIT 1"; //$sqlResult = mysql_query($sql, $conn) or die("Couldn't perform query (".__LINE__."): ". mysql_error(). '.'); //if($sqlCheckin = mysql_fetch_assoc($sqlRecord)) array_push($return_arr, $sqlCheckin); print $return_chk[]; } $json = json_encode($return_chk); //$did_something += 1; $json; } ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings