jQuery UI Widgets Forums General Discussions Table data to JSON array limit

Tagged: , , ,

This topic contains 3 replies, has 2 voices, and was last updated by  rkamarowski 7 years, 5 months ago.

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
  • Table data to JSON array limit #90876

    rkamarowski
    Participant

    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?

    Table data to JSON array limit #90899

    Hristo
    Participant

    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

    • This reply was modified 7 years, 5 months ago by  Hristo.
    Table data to JSON array limit #90918

    rkamarowski
    Participant

    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();
    Table data to JSON array limit #90921

    rkamarowski
    Participant

    The problem is with my provider.

    Thanks.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.