header('content-type:application/json;charset=utf8');
$link
= mysql_connect(
"localhost"
,
"root"
,
"root"
)
or
die
(
"Unable to connect to the MySQL!"
);
mysql_query(
"SET NAMES 'UTF8'"
);
mysql_select_db(
"jilinwula"
,
$link
)
or
die
(
"Unable to connect to the MySQL!"
);
$page
= 0 ;
$pageSize
= 3;
if
(!
is_null
(
$_GET
[
"page"
])) {
$page
=
$_GET
[
"page"
];
}
if
(!
is_null
(
$_GET
[
"pageSize"
])) {
$pageSize
=
$_GET
[
"pageSize"
];
}
$result
= mysql_query(
"select username,password from userinfo limit "
.
$page
.
", "
.
$pageSize
.
""
);
$results
=
array
();
while
(
$row
= mysql_fetch_assoc(
$result
)) {
$results
[] =
$row
;
}
echo
json_encode(
$results
);
mysql_free_result(
$result
);
mysql_close(
$link
);