I'm using mysql and php to show some data, here is my code :
<?php
require_once('sqlconnect.php');
$sqlQuery = "SELECT name FROM hiltonsmythe.hs_listing_types LIMIT 120";
$result = $unity_connection->query($sqlQuery);
$json1 = array();
while($rows = mysqli_fetch_assoc($result)){
$json1[] = $rows;
}
echo json_encode($json1);
?>
This works fine when i navigate to the php file, but if i change the LIMIT to 121 it doesnt return anything even though the table has over 300 fields. When i run the select in SQLWorkbench it works fine.
Anyone know what this could be? i will eventually need to return around 400 i am not sure why it is stopping, there is no error at all on firebug.
edit : i added
error_reporting(E_ALL); ini_set('display_errors', 1);
still no results..
This is the sql connection file :
<?php
class SQLConnection {
private $mysqli;
public function __construct ($host, $user, $pass, $name) {
$this->mysqli = new mysqli($host, $user, $pass, $name);
$connectionAttempts = 1;
while ($this->mysqli == null && $connectionAttempts < 5){
sleep(1);
$this->mysqli = new mysqli($host, $user, $pass, $name);
$connectionAttempts++;
}
if($this->mysqli->connect_error){
die("$this->mysqli->connect_errno: $this->mysqli->connect_error");
}
}
public function __destruct(){
$this->mysqli->close();
}
public function query($sql, $params = null){
$result = $this->mysqli->query($sql);
return $result;
}
public function real_escape_string($string){
return $this->mysqli->real_escape_string($string);
}
public function getConnection(){
return $this->mysqli;
}
}
?>