witam, mam taki kod:

[HTML] pobierz, plaintext 
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. <title>The Simplest Dojo DataGrid Example of All Time</title>
  5. <link rel="stylesheet" type="text/css"
  6.  href="http://ajax.googleapis.com/ajax/libs/dojo/1.5/dijit/themes/claro/claro.css" />
  7.  
  8. <link rel="stylesheet" type="text/css"
  9.  href="http://ajax.googleapis.com/ajax/libs/dojo/1.5/dojox/grid/resources/Grid.css" />
  10.  
  11.  <link rel="stylesheet" type="text/css"
  12.  href="http://ajax.googleapis.com/ajax/libs/dojo/1.5/dojox/grid/resources/claroGrid.css" />
  13. </head>
  14.  
  15. <body class="claro">
  16. 	<div style="width: 600px; height: 200px">
  17. 		<table id="billsGrid" dojoType="dojox.grid.DataGrid">
  18. 	  		<thead>
  19. 	    		<tr>
  20. 	      			<th field="number">Number</th>
  21. 	      			<th field="name">Name</th>
  22. 	      			<th field="position">Position</th>
  23. 	      			<th field="victories" width="180px">Super Bowl Victories</th>
  24. 	    		</tr>
  25. 	  		</thead>
  26. 		</table>
  27. 	</div>
  28.  
  29. <script type="text/javascript"
  30.  src="http://ajax.googleapis.com/ajax/libs/dojo/1.5/dojo/dojo.haha.gif.js"
  31. 	djConfig="parseOnLoad:true"></script>
  32.  
  33. <script type="text/javascript">
  34. 	dojo.require("dojox.grid.DataGrid");
  35. 	dojo.require("dojo.data.ItemFileReadStore");
  36. </script>
  37.  
  38. <script type="text/javascript">
  39. dojo.ready(function() {
  40. 	var theGreatestTeamOfAllTime = {
  41. 		items: [ {
  42. 				  "number":"12",
  43. 				  "name":"Jim Kelly",
  44. 				  "position":"QB",
  45. 				  "victories":"0"
  46. 				  },
  47. 		         {
  48. 				  "number":"34",
  49. 				  "name":"Thurman Thomas",
  50. 				  "position":"RB",
  51. 				  "victories":"0"
  52. 				  },
  53. 		         {
  54. 				  "number":"89",
  55. 				  "name":"Steve Tasker",
  56. 				  "position":"WR",
  57. 				  "victories":"0"
  58. 				  },
  59. 			{
  60. 				"number":"78",
  61. 				"name":"Bruce Smith",
  62. 				"position":"DE",
  63. 				"victories":"0"
  64. 			}
  65. 		       ],
  66. 		identifier: "number"
  67. 	};
  68.  
  69. 	var dataStore =
  70. 	new dojo.data.ItemFileReadStore(
  71. 		{ data:theGreatestTeamOfAllTime }
  72. 	);
  73. 	var grid = dijit.byId("billsGrid");
  74. 	grid.setStore(dataStore);
  75. });
  76. </script>
  77.  
  78. </body>
  79. </html>
  80.  
[HTML] pobierz, plaintext


W jaki sposób zmienić kod aby do grid'a pobierał dane z bazy? Znalazłem jakieś informacje, że za pomocą json ale bez szczegołów. Prosze o pomoc.

ok, poradziłem sobie -> dla zainteresowanych:

[PHP] pobierz, plaintext 
  1. $arr = array();
  2.  
  3. $query = "SELECT * FROM json";
  4. $result = mysql_query ($query);
  5. while($row = mysql_fetch_object($result)){
  6. $arr[] = $row;
  7. }
  8. $jsonStr = json_encode($arr);
[PHP] pobierz, plaintext


zmienną $jsonStr wrzucam do:

[HTML] pobierz, plaintext 
  1. 	var theGreatestTeamOfAllTime = {
  2. 		items: <?php echo json_encode($arr);?>,
  3. 		identifier: "number"
  4. 	};
[HTML] pobierz, plaintext