<?php
require_once 'common.php';
// check login first
if (!already_login()) {
die;
}
//
function search_config($name)
{
$name = check_sql($name);
$userId = $_SESSION['userID'];
$query = "SELECT Config.ID,Config.Name,Config.Time,Config.Config,Config.AutoI,Config.Description,Config.IsDefault FROM Config,User WHERE Config.User_ID=User.ID AND Config.Name LIKE '%{$name}%'";
// echo $query.'<br>';
$ret = array('data' => array());
$result = mysql_query($query);
while ($row = mysql_fetch_row($result)) {
// foreach ($row as $key => $value){
// $row[$key] = check_xss($value);
// }
$ret['data'][] = $row;
// var_dump($row);
}
return $ret;
}
$name = check_sql(trim($_REQUEST['name']));
$data = search_config($name);
echo json_encode($data);
require_once 'common.php';
// check login first
if (!already_login()) {
error_jump();
}
function search_config($s)
{
$name = check_sql($name);
$userId = $_SESSION['userID'];
$query = "SELECT Config.Name,Config.Description FROM Config,User WHERE Config.User_ID=User.ID AND Config.Name like '%{$name}%'";
// echo $query.'<br>';
$ret = array();
$result = mysql_query($query);
while ($row = mysql_fetch_row($result)) {
foreach ($row as $key => $value) {
$row[$key] = check_xss($value);
}
$ret[] = $row;
// var_dump($row);
}
return $ret;
}
if (isset($_SERVER['HTTP_X_REQUESTED_WITH']) and strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) == 'xmlhttprequest') {
$ret = search_config($_GET['s']);
echo '<ul>';
foreach ($ret as $row) {
echo '<li><a href="#">' . $row[0] . '</a></li>';
// var_dump($row);
}
echo '</ul>';
}
