PHP-Code-Console/codeSearcher.php at master · adamchenwei/PHP-Code-Console · GitHub

History

78 lines (61 loc) · 1.42 KB

Raw

<?php

/**

* @todo

* @version

* 1.0

require_once('common.php');

$my_report_id = -1;

require_once('incl-auth.php');

if ( !isset( $auth_who ) ) {

echo '<h2>You need to be logged in to use this tool</h2>';

exit;

}else{

//echo $auth_who;

}

/*Load User Info*/

$log = new PHPConsoleLog;

$log->initials = $auth_employee->initials;

$log->ipnum = ip2long($_SERVER['REMOTE_ADDR']);

$log->hostname = $_SERVER['HTTP_HOST'];

//var_dump($log->initials);

/*Receive Data*/

/*$data = file_get_contents("php://input");

$objData = json_decode($data);*/

$objData= new stdClass();

$objData->codeTerm = $_GET['codeTerm'];

$objData->recordPerPage = $_GET['recordPerPage'];

$objData->totalRecords = 0;

//$objData = "fsa";

/*Get Data From DB*/

echo (" fd f d fd fd<br>");

echo ($objData->recordPerPage);

echo ("<br>");

echo ($objData->codeTerm);

echo ("<br>");

$db = db::logs();

$sql = "

SELECT

myCodeId

FROM

php_console_history_beta_mycode

WHERE

myCodeName LIKE '%$objData->codeTerm%'

ORDER BY

myCodeLastEditDate DESC

$res = $db->query( $sql );

if(!$res){

echo ("res not found!");

}

$result = $res->fetch_object();

/*Conversion*/

$res = $db->query( $sql );

$result=array();

while($entry = $res->fetch_assoc()){$result[]=$entry;}

$objData->totalRecords=count($result);

$objData->totalPages=ceil($objData->totalRecords/$objData->recordPerPage);

$objData->currentPage=1;

$objData = json_encode($objData);

echo $objData ;

PHP-Code-Console/codeSearcher.php at master · adamchenwei/PHP-Code-Console · GitHub

Expand file tree

Breadcrumbs

codeSearcher.php

Latest commit

History

Breadcrumbs

codeSearcher.php

File metadata and controls