set_charset("utf8");
if($mysql->connect_errno) {
echo "db connection error : " . $mysql->connect_error;
exit();
}
if(empty($sql)) {
$sql = "SELECT * FROM movieView where rating='PG' ORDER BY title LIMIT 50";
}
$results = $mysql->query($sql);
if(!$results) {
echo "SQL error: ". $mysql->error;
exit();
}
$json_array = array();
while($currentrow = $results->fetch_assoc()) {
$json_array[] = $currentrow;
}
/*
echo "";
print_r($json_array);
echo "
";
*/
$json2 = json_encode($json_array);
// echo "json error: " . json_last_error_msg() . "
";
echo $json2;