PHP MYSQL valid query gives no error or result unless LIMIT added to query -


this php i'm using should yield result of 10300 rows 2 values per row. running script instantly completed , results in white page no error feedback on screen or in various apache , mysql logs.

$output = array();  $sql = "select id, name objects order id desc"; $result = $conn->query($sql) or die(mysqli_error()); $count = 0; while($row = $result->fetch_assoc()) {     $output['records']['objects'][$count]['id'] = $row['id'];     $output['records']['objects'][$count]['name'] = $row['name'];      $count++; } echo json_encode($output); 

however if change query such

$sql = "select id, name objects order id desc limit 500"; 

i receive results expected , output (after json encode) seems 31kb (31418 characters)

am exceeding limit here , have error levels set wrong?


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -