European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Languages :: PHP :: php,mysql,ajax based datagrid
By: phpsnook	Date: 30/09/2008 09:12:30	Points: 20	Status: Answered Quality : Excellent
hai guys im into a project where the is huge data tht needs to be put up in a datagrid im in look out for a really gud one .......pls help
By: VGR	Date: 30/09/2008 19:53:41		Type : Comment
Well, I usually put large volumes of data in a paginated (say, 10 000 rows a page) display like the one used here for the Questions. Basically, it's : - a navigation bar (depending on the number of calculated pages and where you already stand in them) - a query with a LIMIT n,m clause (n=numero of the page minus one, m = size of the page) to retrieve the data - a table displaying the current page (data retrieved above) it's not high wizardry and it works. If you need more help, post your code and we'll have a look. HTH

By: phpsnook	Date: 01/10/2008 07:08:07		Type : Comment
hey thanks for the reply i was searching for a datagrid.And i bumped into www.extjs.com/ it luks gud ....but i wud like to have your expert view when extjs with php/mysql

By: VGR	Date: 01/10/2008 08:39:03		Type : Comment
well, as far as it's javascript, any language generating DHTML can use it. Even ASP.Net ;-) Seems good and as you can see, the Grid component is exactly what I said :a nav bar, a tabular display. The only part I can't be sure of the inocuity is the query part. I hope they don't retrieve the whole dataset and then display only a small part ;-) the advantage of my solution is that it's free, you get only the "data grid" part, and it's some hundreds of javascript lines. Installing and customizing it can be a nightmare, though. keep us posted on this, thanks

By: phpsnook	Date: 01/10/2008 10:52:46		Type : Comment
hey i tested the script...Buddy you are right customizing it is a big night mare!..... im bit stuck right now...tried many php scripts too....guess you wud know a really gud one pls let me know.....

By: phpsnook	Date: 14/10/2008 14:18:26		Type : Comment
hai vgr came across a prog called jqgrid ive got two questions now 1) will it using XML bring any vulnerablity 2)how abt json? pls give your expert view

By: VGR	Date: 14/10/2008 23:26:55		Type : Comment
well, JSON is shorter than XML ; I hate XML, it's unefficient. Why not use your own custom data interchange format ? I usually use one character-delimited string containing just the values. Why keep all the pairs (variable,value) if you don't need it ? for a datagrid, for instance, what you transmit is like a CSV file, and CSV is the most efficient format I know. As for XML vulnerabilities, there are none per se ; the failing parts are more in XML-RPC and buggy web services more than in the data format itself.

By: VGR	Date: 14/10/2008 23:28:24		Type : Comment
you'll have a comprehensive explanation of what I mean by reading http://www.webservicessummit.com/Articles/XMLThreats.htm.

By: phpsnook	Date: 15/10/2008 07:11:00		Type : Comment
is it possible to make a php/mysql datagrid work as dynamic like those from extjs or jqgrid????

By: VGR	Date: 16/10/2008 08:14:57		Type : Assist
well, it is already useable from PHP but it is a client-side solution. This is perhaps the better trade-off IMHO. The server has a rough time handling the huge datasets, and the client has the rough job of rpesenting them to the user and provide the dbGrid functionality. jqGrid is an Ajax-enabled JavaScript control that provides solutions for representing and manipulating tabular data on the web. Since the grid is a client-side solution loading data dynamically through Ajax callbacks, it can be integrated with any server-side technology, including PHP,[...]

By: BrianMM	Date: 25/09/2009 11:16:12		Type : Assist
I have used and subsequently help on it's development (mainly QA) a project called Datatables. Datatables.net It's an AJAX solution, which is very fast and scalable. I have used it for a couple very high volume solutions.

By: OpConsole	Date: 03/04/2011 19:01:37		Type : Comment
force close

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

Contact

page generated in 121.523860 milliseconds

Why Google AdSense ads ?

New Improved Search!