This topic is locked

AJAX Grid

6/5/2007 5:43:31 AM
PHPRunner General questions
M
marymary author

Hi,

Im new to this tool but can it display ajax grid like this:

http://cristian.nexcess.net/ajax/grid/
I\'m not talking about the edit, Im talking about the table\'s view and navigation between pages.
Thanks

Admin 6/5/2007

What's the difference between grid that PHPRunner builds and one that you mentioned?

M
marymary author 6/6/2007

If you look at the grid in PHPRunner, when you have more than one page result, and you want to navigate between pages, there is a java script code on the page number when you click on the page number, a new request for the server is created, and the requested page comes from the server.
The example that I\'ve provided is not like that, when you want to do the same operation (navigation between pages), the result comes from the client, no need to new request for the server, got it?
Mary

Admin 6/6/2007

Mary,
you are wrong.
Even if this grid AJAX-based still new request is generated and server delivers a new set of data.

J
jim9 6/6/2007

Where do you think the data is stored, (ON THE SERVER), If you could get more from client then that means all records were put into memory. This defeats the purpose of database programming if you have all records on client. If you believe you can load all on client, then try a database with 5,000,000,000 records. I believe you need to learn databases in general before you do anything else! Believe me you do not want 5,000,000,000 records loaded into memory on your computer, rather you want only a few requested records at a time (That's why they are called paged results). Read on the Microsoft site and the sql server docs, this will explain why retrieving only a few records at a time is wise over the internet. Even desktop databases like visual foxpro, dbase, and access don't load every record into memory at once. PLEASE PLEASE PLEASE, learn some databasing before you pursue anything any further. And remember, ajax is just another tool, not a complete database management system. If you have ever opened a comma delimited database in wordpad that is huge you'll see how long it takes and how slow computer runs, this is what happens if you load a huge databse to your desktop. Even with a gig memory stick, this is not the correct way of databasing. Please for the sake of others pursuing good sound things in phprunner, learn some server database basics first.

S
spoilar 6/6/2007

I think what mary is trying to say, is that the example mary provided shows the grid content changing (table data), without refreshing the rest of the page. And can this be implemented into her view page. I think.

M
marymary author 6/7/2007

@jim9 instead of writing useless post, it was better to read what I meant, I am new to this tool, but I am not for programming and databasing.

read carefully before you reply, I meant be request the web page itself, obviously any framework is smart enough to not put database code in view pages, do you know MVC? LOL
@spoilar: yea thats what I meant by new request, the whole web page.

in the example I provided the page stays where in PHPrunner the whole pages refresh
@admin: is that possible? to make only the table changes not the whole page?
Mary

Admin 6/7/2007

Mary,
no, this is not possible with PHPRunner.
We might add something like this in one of later version however I don't see this technique to be a performance booster.

And what I think is the most important part here - user experience will suffer as browser's Back button will be broken and won't take you where you expect.