connect_errno) { echo "db connection error : " . $mysql->connect_error; exit(); } $sql = "SELECT * FROM movieView"; $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 "

"; exit(); $json2 = json_encode($json_array); echo $json2;