MsvP on Table in IE empty

Mon, 22 Jun 2009 09:12:20 +0300

Perfect! That's it!

Now it runs in ie.

Thank you.

MsvP

tony on Table in IE empty

Sun, 21 Jun 2009 06:31:40 +0300

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

MsvP on Table in IE empty

Fri, 19 Jun 2009 04:50:25 +0300

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

jQuery Grid Plugin - jqGrid - Topic: Table in IE empty

MsvP on Table in IE empty

tony on Table in IE empty

MsvP on Table in IE empty