php api数据,php API查询数据

session_start();

if (key_exists('page', $_GET)) {

if(intval($_GET['page'])>0){

// 判断是否存在次数

if (isset($_SESSION['LIMIT'])) {

// 判断是否已经访问了2000次

if ($_SESSION['LIMIT'] > 2000) {

// 判断如果超过2000次则12小时后才能再次访问

if (intval(time()) - intval($_SESSION['XS_TIME']) >= 43200) {

$_SESSION['LIMIT'] = 0;

}

$data = array(0, 'error', "Rate Limit Exceeded");

header('Content-Type: application/json');

echo json_encode($data);

} else {

$_SESSION['XS_TIME'] = time();

$_SESSION['LIMIT'] = $_SESSION['LIMIT'] + 1;

$servername = "localhost";

$username = "xx";

$password = "xx";

$dbname = 'xx';

$link = mysqli_connect($servername, $username, $password);

if (!$link) {

die('Could not connect to MySQL: ' . mysqli_error());

} else {

$pdo = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

$pdo->exec('set names utf8');

// 总页数

$sum = "SELECT * FROM ay_content WHERE id != 1 AND id != 2 AND id != 3 AND id != 20 AND id != 21 AND id != 22 AND id != 23 AND id != 26 AND id != 27 AND id != 109 AND id != 110 AND id != 111 AND id != 112 AND id != 113 AND id != 119 AND id != 753 AND id != 754 AND id != 755";

//分页

$sql = "SELECT ay_content.id,ay_content.scode,ay_content.title,author,source,ay_content.date,ay_content.ico,ay_content.pics,ay_content.content,ay_content.tags,enclosure,ay_content.keywords,ay_content.description,ay_content.sorting,ay_content.status,ay_content.istop,ay_content.isrecommend,ay_content.isheadline,ay_content.visits,ay_content.likes,ay_content.oppose,ay_content.create_user,ay_content.update_user,ay_content.create_time,ay_content.update_time,ay_content_sort.name AS className FROM ay_content INNER JOIN ay_content_sort ON ay_content.scode=ay_content_sort.id LIMIT ".((intval($_GET['page'])-1) * 100).",100";

$sum = $pdo->query($sum);

$sum = $sum->fetchAll(PDO::FETCH_ASSOC);

$num = count($sum);

$page = intval($num / 100);

if($num % 100 !=0){

$page +=1;

}

$smt = $pdo->query($sql);

//总数据数

$rows['num'] = count($sum);

//分页总数

$rows['page_count'] = $page;

//当前页数

$rows['page'] = $_GET['page'];

$smt = $smt->fetchAll(PDO::FETCH_ASSOC);

//当前页数据总数

$rows['page_num'] = count($smt);

//当前页数据

$rows['data'] = $smt;

$rows = json_encode($rows);

$data = json_decode($rows);

$data = array(1, 'success', $data);

header('Content-Type: application/json');

echo json_encode($data);

};

mysqli_close($link);

}

} else {

$_SESSION['LIMIT'] = 0;

}

} else {

$data = array(0, 'error', "Please pass in the correct parameters");

header('Content-Type: application/json');

echo json_encode($data);

}

}else{

$data = array(0, 'error', "Please pass in the correct parameters");

header('Content-Type: application/json');

echo json_encode($data);

}