Flexigrid - Lightweight but rich data grid

Flexigrid - Lightweight but rich data grid

El Forum
Unregistered

#288

05-07-2008, 08:06 AM

[eluser]tayson[/eluser]
[quote author="mjhan300" date="1210183462"]Does anyone know of any examples of using Flexigrid to load an XML file. Nothing fancy here, just need the basics. All the site I run across either use json file format or don't go in to enough detail. Documentation is very limited.[/quote]

I did this:

data.php

Code:
&lt;? 

error_reporting(0);

function runSQL($rsql) {

    $hostname = "xxx";

    $username = "xxx";

    $password = "xxx";

    $dbname   = "xxxx";

    $connect = mysql_connect($hostname,$username,$password) or die ("Error: could not connect to database");

    $db = mysql_select_db($dbname);

    $result = mysql_query($rsql) or die (mysql_error()); 

    return $result;

    mysql_close($connect);

}

function countRec($fname,$tname,$where) {

$sql = "SELECT count($fname) FROM $tname $where";

$result = runSQL($sql);

while ($row = mysql_fetch_array($result)) {

return $row[0];

}

}

$page = $_POST['page'];

$rp = $_POST['rp'];

$sortname = $_POST['sortname'];

$sortorder = $_POST['sortorder'];

if (!$sortname) $sortname = 'product';

if (!$sortorder) $sortorder = 'desc';

$sort = "ORDER BY $sortname $sortorder";

if (!$page) $page = 1;

if (!$rp) $rp = 10;

$start = (($page-1) * $rp);

$limit = "LIMIT $start, $rp";

$query = $_POST['query'];

$qtype = $_POST['qtype'];

$where = "";

if ($query) $where = " WHERE $qtype LIKE '%$query%' ";

$sql = "SELECT * FROM products $where $sort $limit";

$result = runSQL($sql);

$total = countRec("id","products $where"); 

header("Expires: Mon, 26 Jul 1997 05:00:00 GMT" );

header("Last-Modified: " . gmdate( "D, d M Y H:i:s" ) . "GMT" );

header("Cache-Control: no-cache, must-revalidate" );

header("Pragma: no-cache" );

header("Content-type: text/xml");

$xml = "&lt;?xml version=\"1.0\" encoding=\"utf-8\"?&gt;\n";

$xml .= "<rows>";

$xml .= "<page>$page</page>";

$xml .= "<total>$total</total>";

while ($row = mysql_fetch_array($result)) {

style='border:0'></a>";

$xml .= "<row id='".$row['id']."'>";

$xml .= "<cell>&lt;![CDATA[".$row['ref']."]]></cell>";

$xml .= "<cell>&lt;![CDATA[".utf8_encode($row['product'])."]]></cell>";

$xml .= "</row>"; 

}

$xml .= "</rows>";

echo $xml;

?&gt;

index.php

Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

&lt;html&gt;

&lt;head&gt;

&lt;title&gt;Flexigrid&lt;/title&gt;

&lt;link rel="stylesheet" type="text/css" href="css/flexigrid.css" /&gt;

$(document).ready(function(){

    $("#flex1").flexigrid

            (

            {

            url: 'dados.php',

            dataType: 'xml',

            colModel : [

                {display: 'ID', name : 'id', width : 55, sortable : true, align: 'center'},

                {display: 'Product', name : 'product', width : 300, sortable : true, align: 'left'},

                {display: 'Ref', name : 'ref', width :100, sortable : true, align: 'left'},

                ],

            buttons : [

                {name: 'Add', bclass: 'add'},

                {name: 'Delete', bclass: 'delete'},

                {separator: true}

                ],

            searchitems : [

                {display: 'Product', name : 'product'},

                ],

            sortname: "product",

            sortorder: "asc",

            usepager: true,

            useRp: true,

            rp: 15,

            showTableToggleBtn: false,

            width: 647,

            height: 'auto'

            }

            );  

});

&lt;/head&gt;

&lt;body&gt;

<table id="flex1" style="display:none"></table>

&lt;/body&gt;

&lt;/html&gt;