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: Open
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 : Comment
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 : Comment
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.

Do register to be able to answer

Add This Article To:
Del.icio.us	Digg	Google	Spurl
Blink	Wong	Simpy	Y! MyWeb

Contact

page generated in 47.768120 milliseconds

Why Google AdSense ads ?

New Improved Search!