jQuery UI Widgets Forums General Discussions Error in Data.php in master/detail

This topic contains 1 reply, has 2 voices, and was last updated by  Hristo 8 years, 2 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • Error in Data.php in master/detail #87636

    gbose
    Participant

    Data.php

    <?php
    // Include the connect.php file
    include (‘connect.php’);

    // Connect to the database
    // connection String
    $mysqli = new mysqli($hostname, $username, $password, $database);
    /* check connection */
    if (mysqli_connect_errno())
    {
    printf(“Connect failed: %s\n”, mysqli_connect_error());
    exit();
    }
    // get data and store in a json array
    if (isset($_GET[‘customerid’]))
    {
    // get data and store in a json array
    $pagenum = $_GET[‘pagenum’];
    $pagesize = $_GET[‘pagesize’];
    $customerid = $_GET[‘customerid’];
    $start = $pagenum * $pagesize;
    $query = “SELECT SQL_CALC_FOUND_ROWS OrderDate, ShippedDate, ShipName, ShipAddress, ShipCity, ShipCountry FROM orders WHERE CustomerID=? LIMIT ?,?”;
    $result = $mysqli->prepare($query);
    $result->bind_param(‘sii’, $customerid, $start, $pagesize);
    $result->execute();
    /* bind result variables */
    $result->bind_result($OrderDate, $ShippedDate, $ShipName, $ShipAddress, $ShipCity, $ShipCountry);
    /* fetch values */
    while ($result->fetch())
    {
    $orders[] = array(
    ‘OrderDate’ => $OrderDate,
    ‘ShippedDate’ => $ShippedDate,
    ‘ShipName’ => $ShipName,
    ‘ShipAddress’ => $ShipAddress,
    ‘ShipCity’ => $ShipCity,
    ‘ShipCountry’ => $ShipCountry
    );
    }
    $result = $mysqli->prepare(“SELECT FOUND_ROWS()”);
    $result->execute();
    $result->bind_result($total_rows);
    $result->fetch();
    $data[] = array(
    ‘TotalRows’ => $total_rows,
    ‘Rows’ => $orders
    );
    echo json_encode($data);
    }
    else
    {
    // get data and store in a json array
    $pagenum = $_GET[‘pagenum’];
    $pagesize = $_GET[‘pagesize’];
    $start = $pagenum * $pagesize;
    $query = “SELECT SQL_CALC_FOUND_ROWS CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Country FROM customers LIMIT ?,?”;
    $result = $mysqli->prepare($query);
    $result->bind_param(‘ii’, $start, $pagesize);
    $result->execute();
    /* bind result variables */
    $result->bind_result($CustomerID, $CompanyName, $ContactName, $ContactTitle, $Address, $City, $Country);
    /* fetch values */
    while ($result->fetch())
    {
    $customers[] = array(
    ‘CustomerID’ => $CustomerID,
    ‘CompanyName’ => $CompanyName,
    ‘ContactName’ => $ContactName,
    ‘ContactTitle’ => $ContactTitle,
    ‘Address’ => $Address,
    ‘City’ => $City,
    ‘Country’ => $Country
    );
    }
    $result = $mysqli->prepare(“SELECT FOUND_ROWS()”);
    $result->execute();
    $result->bind_result($total_rows);
    $result->fetch();
    $data[] = array(
    ‘TotalRows’ => $total_rows,
    ‘Rows’ => $customers
    );
    echo json_encode($data);
    }
    $result->close();
    /* close connection */
    $mysqli->close();
    ?>

    Error Messgae I received:

    Notice: Undefined index: pagenum in C:\xampp\htdocs\testmaster\data.php on line 53

    Notice: Undefined index: pagesize in C:\xampp\htdocs\testmaster\data.php on line 54

    Notice: Undefined variable: customers in C:\xampp\htdocs\testmaster\data.php on line 81
    [{“TotalRows”:93,”Rows”:null}]

    Please help

    Error in Data.php in master/detail #87661

    Hristo
    Participant

    Hello gbose,

    It is looks like are set incorrectly indexes (pagenum, pagesize). Could you check what data you receive there and is this a correct?
    Also I would like to suggest you one article, that could be useful:
    http://www.jqwidgets.com/jquery-widgets-documentation/documentation/phpintegration/bind-jquery-grid-to-mysql-database-using-php.htm?search=ph
    and this one:
    http://www.jqwidgets.com/jquery-widgets-documentation/documentation/phpintegration/php-server-side-grid-paging.htm?search=ph

    Best Regards,
    Hristo Hristov

    jQWidgets team
    http://www.jqwidgets.com

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

You must be logged in to reply to this topic.