SlickGrid需要一个数据数组才能填充表。您可以在PHP中将其创建为字符串,并在创建SlickGrid时在Javascript中使用它。
请注意; 这是快速,肮脏和未经测试的!
的PHP
$data = '';$i = 0;$query = " SELECt `title`, `duration`, `percentComplete`, `start`, `finish`, `effortDriven` FROM `myTable`";$result = mysql_query($query);while($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $data .= ' data['.$i.'] = { title: "'.$row['title'].'", duration: "'.$row['duration'].'", percentComplete: "'.$row['percentComplete'].'", start: "'.$row['start'].'", finish: "'.$row['finish'].'", effortDriven: "'.$row['percentComplete'].'" }; '; $i++;}的Javascript
<script type="text/javascript"> var grid; var columns = [ {id:"title", name:"Title", field:"title"}, {id:"duration", name:"Duration", field:"duration"}, {id:"%", name:"% Complete", field:"percentComplete"}, {id:"start", name:"Start", field:"start"}, {id:"finish", name:"Finish", field:"finish"}, {id:"effort-driven", name:"Effort Driven", field:"effortDriven"} ]; var options = { enableCellNavigation: false, enableColumnReorder: false }; $(function() { var data = []; <?php echo $data; ?> //This is where we echo the PHP variable $data which contains our Javascript array as a string. grid = new Slick.Grid($("#myGrid"), data, columns, options); })</script>


