I am using the DP for the Grid but I am not getting any output of data. I have verified the setting in my database and connector file and still nothing. The debugger shows nothing what am I doing wrong?
html page
<!DOCTYPE html>
<html>
<head>
<title>Test Page</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="http://code.jquery.com/mobile/1.1.1/jquery.mobile-1.1.1.min.css" />
<script src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
<script src="http://code.jquery.com/mobile/1.1.1/jquery.mobile-1.1.1.min.js"></script>
<style type="text/css">
@import url(http://fonts.googleapis.com/css?family=Allura);
@import url(http://fonts.googleapis.com/css?family=Arizonia);
#logo {
font-size: 1.9em
font-family 'Arizonia', cursive;
color: #9400D3; /*#68228B; /*#B23AEE; /*#8A2BE2; */
}
.splash {
color: #fff;
}
html {
width:240px;
height:600px;
}
</style>
</head>
<body>
<div data-role="page" data-theme="a" id="admin_page" >
<!-- Grid code HERE ------------------------------------------------->
<link rel="stylesheet" type="text/css" href="dhtmlxSuite/dhtmlxGrid/codebase/dhtmlxgrid.css"/>
<link rel="stylesheet" type="text/css" href="dhtmlxSuite/dhtmlxGrid/codebase/dhtmlxgrid_skins.css">
<script src="dhtmlxSuite/dhtmlxGrid/codebase/dhtmlxcommon.js"></script>
<script src="dhtmlxSuite/dhtmlxGrid/codebase/dhtmlxgrid.js"></script>
<script src="dhtmlxSuite/dhtmlxGrid/codebase/dhtmlxgridcell.js"></script>
<script src="dhtmlxSuite/dhtmlxDataProcessor/codebase/dhtmlxdataprocessor.js"></script>
<script src="dhtmlxSuite/dhtmlxDataProcessor/codebase/dhtmlxdataprocessor_debug.js" type="text/javascript"></script>
<script type="text/javascript" >
$( '#admin_page' ).live( 'pageinit',function(event){
$('#clients').live('click', function(){
mygrid = new dhtmlXGridObject('gridbox');
mygrid.setImagePath("dhtmlxSuite/dhtmlxGrid/codebase/imgs/");//path to images required by grid
mygrid.setHeader("name, address, town, phone,email");//set column names
mygrid.setInitWidths("100,250,100,100,100");//set column width in px
mygrid.setColAlign("right,left, center,center,center");//set column values align
mygrid.setColTypes("ro,ed,ed,ed,ed");//set column types
mygrid.setColSorting("str,str,str,str,str");//set sorting
mygrid.setSkin("dhx_classic");//set grid skin
mygrid.init();//initialize grid
mygrid.load('db_connector.php'); //load data
var dp = new dataProcessor('db_connector.php');
dp.init(mygrid);
});
$('#product').live('click', function(){
alert( 'My products' );
});
$('#service').live('click', function(){
alert( 'THe services I offer' );
});
$('#schedual').live('click', function(){
alert( 'My schedual' );
});
$('#register').live('click', function(){
alert( 'Registration List' );
});
});
</script>
<div data-role="header" data-position="fixed">
<h1 style="font-size:1.5em; font-family:Georgia, sans-serif; ">Loxx by Lisa Dashboard</h1>
<div data-role="navbar" data-iconpos="right" >
<ul>
<li><a href="#" id="clients">Client List</a></li>
<li><a href="#" id="register">Registration</a></li>
<li><a href="#" id="product">Products</a></li>
<li><a href="#" id="service">Services</a></li>
<li><a href="#" id="schedual">My Schedual</a></li>
</ul>
</div>
</div><!-- /header -->
<div data-role="content" style="width: 100%; height: 100%; background-image: url('background_loxx.jpg'); repeat-x">
<div style="background-color: #000; height: 960px; width: 960px; border: 5px solid #D8D7D5; border-radius: 10px; margin: 10px auto 20px auto;">
<div id="gridbox" style="width:650px;height:800px; margin: 20px auto 0 auto;"></div>
</div>
</div>
<div data-role="footer" data-position="fixed">
<a href="index.html" class="ui-btn-left" data-theme="e">My Account</a>
<h2>User: <span style="color: red">Lisa</span> Last login: <span style="color: green;">2:00pm Saturday May 5th 2012</span></h2>
<a href="index.html" class="ui-btn-right" data-theme="e">Logout</a>
</div>
</div> <!-- /page -->
</body>
</html>
My connector
<?php
include './dhtmlxSuite/dhtmlxConnector/php/codebase/keygrid_connector.php';
$conn = mysql_connect("localhost", "root", "");
mysql_select_db("loxx", "MySQL");
$grid = new KeyGridConnector($conn);
$grid->render_table("clients","name", "name,address, town, phone, email");
$grid->enable_log("log.txt", true);
?>
Also I verified that database has been seeded but nothing?
[img]
[/img]