PHP Data storage

[rakesh19]

Hi,

I am building an application similar to google autosuggest. I want to fetch the list of items to be suggested using PHP. Those items are stored in a database. Is it a good idea to make a database connection everytime or store them in a batch in some kind of PHP data structure. Latter seems more viable. What kind of data structure in PHP is best suited. Is it arrays or some kind of storables. I am new to PHP. Also, the no. of items will be around 5k.

Thanks.

[Dormilich]

for user interaction you can't use php (alone). you probably should store your items in javascript (so you don't need an ajax call every time)...

regards

[rakesh19]

for user interaction you can't use php (alone). you probably should store your items in javascript (so you don't need an ajax call every time)...

regards

Thanks for replying
I am storing it in javascript and displaying to user by formatting,CSS and all .
My worry is how do I keep those items at a backend for a faster retrieval like files,arrays, hashes etc

[Dormilich]

when storing data in javascript, I can only think of arrays and objects as reasonable. javascript has very limited access to files (if at all) and I don't know anything about hashes and javascript. cookies are possible too, but they have to be a) enabled and b) do you want to have a 5k cookie?

what do you mean by "backend"?

regards

[pbmods]

Heya, rakesh19.

Look at jQuery's Autocomplete plugin, which makes use of local storage as well as Ajax (http://docs.jquery.com/Plugins/Autocomplete).

[rakesh19]

Heya, rakesh19.

Look at jQuery's Autocomplete plugin, which makes use of local storage as well as Ajax (http://docs.jquery.com/Plugins/Autocomplete).

That sounds really good Thanks for the link

[rakesh19]

when storing data in javascript, I can only think of arrays and objects as reasonable. javascript has very limited access to files (if at all) and I don't know anything about hashes and javascript. cookies are possible too, but they have to be a) enabled and b) do you want to have a 5k cookie?

what do you mean by "backend"?

regards

I have a set of 8000 items at my backend( PGSQL Database). I cannot make a DB call( I don think it as a good idea), when the user keys in something. So I was thinking of something better to speed up calls.

Thanks