jQuery Grid Plugin - jqGridForum

19/06/2009
04:50

MsvP

New Member

Members

Forum Posts: 2

Member Since:
19/06/2009

Offline

1

Hi,

i've got a problem with jgrid in ie.

In FF jgrid show me all informations from my Database correctly, but the IE doesn't.

The IE only shows the load Icon:

http://d21.udmedia.de/gridtest/

My Script:

[HTML]

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

<html>

<head>

<link rel="stylesheet" type="text/css" media="screen" href="styles/design.css" />
<link rel="stylesheet" type="text/css" media="screen" href="plugins/jquerygrid/css/ui.jqgrid.css" />

</head>

<body>

<?php include('header.php'); ?>

<?php include('mainMenu.php'); ?>

<table id="list" class="scroll"></table>
            <div id="pager" class="scroll" style="text-align:center;"></div>

</div>

</body>

</html>

[PHP]

<?php
include("dbconf");

$page = $_GET['page']; // get the requested page
$limit = $_GET['rows']; // get how many rows we want to have into the grid
$sidx = $_GET['sidx']; // get index row - i.e. user click to sort
$sord = $_GET['sord']; // get the direction
if(!$sidx) $sidx =1;
// connect to the database
$db = mysql_connect($dbhost, $dbuser, $dbpassword)
or die("Connection Error: " . mysql_error());

mysql_select_db($database) or die("Error conecting to db.");

$result = mysql_query("SELECT COUNT(*) AS count FROM grid");
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$count = $row['count'];

if( $count >0 ) {
$total_pages = ceil($count/$limit);
} else {
$total_pages = 0;
}

if ($page > $total_pages) $page=$total_pages;
$start = $limit*$page - $limit; // do not put $limit*($page - 1)
$SQL = "SELECT number, subject, status, open, ability, editor FROM grid ORDER BY $sidx $sord LIMIT $start , $limit";
$result = mysql_query( $SQL );

if ( stristr($_SERVER["HTTP_ACCEPT"],"application/xhtml+xml") ) {
header("Content-type: application/xhtml+xml;charset=utf-8"); } else {
header("Content-type: text/xml;charset=utf-8");
}
$et = ">";

echo "<?xml version='1.0' encoding='utf-8'?$et\\n";
echo "<rows>";
echo "<page>".$page."</page>";
echo "<total>".$total_pages."</total>";
echo "<records>".$count."</records>";

// be sure to put text data in CDATA
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
    echo "<row id='". $row[number]."'>";
    echo "<cell>". $row[number]."</cell>";
    echo "<cell><![CDATA[". $row[subject]."]]></cell>";
    echo "<cell>". $row[status]."</cell>";
    echo "<cell>". $row[open]."</cell>";
    echo "<cell><![CDATA[". $row[ability]."]]></cell>";
    echo "<cell><![CDATA[". $row[editor]."]]></cell>";
    echo "</row>";
}
echo "</rows>";

?>

Thanks for your help.

Greetings - MsvP

21/06/2009
06:31

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

2

Hello,

In FireFox, Safari and Chrome browsers I see wrong German charcters (umlauts and others), which mean that you server side code does not send the appropriate headers.

In IE is not working at all.

Also please be sure.

1. html page is utf-8

2. your database is utf-8 and before the query you do (in MySQL)

SET NAMES utf8

3. use the header in php to send the utf 8

Best Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

22/06/2009
09:12

MsvP

New Member

Members

Forum Posts: 2

Member Since:
19/06/2009

Offline

3

Perfect! That's it!

Now it runs in ie.

Thank you.

MsvP