Table data to JSON array limit

[rkamarowskiParticipant]

I have an input widget I’m using with autocomplete. There seems to be a limit on the number of entries that can be returned in a JSON array. The table is fairly large (500 + entries), but it is static and will not grow. Is there a way to set all the table entries into a JSON array?

[HristoParticipant]

Hello rkamarowski,

Please, check for error message.
If you talk about the dropdown list it is limited by items property.

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[rkamarowskiParticipant]

It’s not even getting that far. If the limit is 100 or above mysqli is not returning any resutls.

Code:

// Connect to the database
$mysqli = mysqli_connect($hostname, $username, $password , $database) or die("Unable to Connect to database" );

$sql="SELECT ";
        $sql .= "VehicleMakeID, ";
        $sql .= "VehicleMakeName ";
        $sql .= "FROM Vehiclemake ";
        $sql .= "WHERE Active = True ";
        $sql .= "ORDER BY VehicleMakeName ";
        $sql .= "LIMIT 0 , 500";

$result=mysqli_query($mysqli, $sql);

while ($row = $result->fetch_array(MYSQL_ASSOC))
    {
   $vehicleMake[] = array(
        "VehicleMakeID" => $row["VehicleMakeID"],
        'VehicleMakeName' => $row["VehicleMakeName"]);
    }

echo json_encode($vehicleMake);

/* close statement */
$result->close();
/* close connection */
$mysqli->close();

[rkamarowskiParticipant]

The problem is with my provider.

Thanks.

[Author]

Posts