| Re: Query or Array functions [message #176968 is a reply to message #176967] |
Fri, 10 February 2012 14:11   |
Captain Paralytic
Messages: 204
Registered: September 2010
Karma:
|
Senior Member |
|
|
On Feb 10, 2:01 pm, Scott Johnson <nooneh...@chalupasworld.com> wrote:
> On 2/10/2012 2:44 AM, Captain Paralytic wrote:
>
>
>
>
>
>
>
>
>
>> On Feb 10, 1:18 am, Scott Johnson<nooneh...@chalupasworld.com> wrote:
>>> OK I will try to ask this and make sense out of this also.
>
>>> First off I am doing this on a back-end admin page.
>>> I have a DB with lets say 5000 records and a dozen or more fields.
>
>>> On the page which will display these records I am planning on using
>>> pagination to display so many records at once. So far so good.
>
>>> What i would like to do is provide a row above the table of records
>>> where the user can enter text to filter the display on each column.
>
>>> I plan to use AJAX and filter as the user types which in itself is not a
>>> problem.
>
>>> The problem I see is the numerous DB queries and I don't see querying
>>> the DB each time the user types a letter as a practical approach. (I
>>> could be wrong).
>
>>> What I was thinking of doing is loading the full record set into an
>>> array and then filter out the array of the needed data as the user types.
>
>>> I have not done any intense array manipulations like this before and am
>>> wondering if this seems like a practical approach.
>
>>> I would like to ask for any advice or suggestions on this. I may even
>>> have my head in the wrong area and not see the forest thru the trees.
>
>>> Thanks
>>> Scotty
>
>> If you're going to g the ajax route, I can recommend
>> http://www.sencha.com/products/extjs/. You will find an example there
>> that does almost exactly what you are talking about.
>
> Hmmm. Very worth a deeper look. Thanks for the resource.
You can couple it with:
http://php-ext.quimera-solutions.com/
(not that I have used that bit yet)
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]