Storing large amount of information problem

envitony

Hi,all.

what I am tryign to do is first, i searched a lot of webpages and store the result into a mysql table(i dont want it permenant,i want it a temarary one).how can I destroy the table after the search is done(that measn, closing the browser).

Because the result may containt thousands of items, so I am usign paging to display the result. If i use CREAT TEMPORARY TABLE ... to generate a table ,it works fine for the first page, but it will not work for the second or etc page. is there any way to make that temporary table reachable during the whole life time of the browser?
or is there any other way to do it?
BTW, the size of the informatin exceeds the size limit of cookie,so cookie wont do the job.

ajbrown

First, you need to make sure PHP is running as a module in Apache, not in CGI. Then, you need to use mysql_pconnect() when you open your database connection. this will create a persistent connection that will stay open throughout the browser session.

That should solve your problem with the temporary tables.

EDIT > Note that your temporary table may not necessarily be destroyed once each individual USER closes their browser, but when the thread is finished.

another solution you might try is creating a normal table named by the session id. Then implement a session save handler destroy function which drops that table from the database once the session is destroyed. For more information on session save handlers, check:

http://www.zend.com/manual/function.session-set-save-handler.php

I've never tried this method though, but it seems it should work for your situation

envitony

I did can access to the temporary table created before at the second page in teh same browser but for some reason if you query a "SELECT * FROM ..." (and retrieve the result and display it.) from that table you will not acess to the table anymore even you are using persistent connection. I tried several times it proves it is true you will lose the connection once you use fetch_... method.

I will try the session method ,and I will report what I got later.

Thanks

envitony

ok, i tried use the handler thing.. but I was stuck. I could not destroy the table either in gc() or destory(). seems it can only destory the session data itself.

so I turn to the using of $SESSION, it works great. but I have to creat a new temporary table from teh data in $SESSION which would make the program very unefficient.

I will continue researchign on the use of "persistent connection" to see under what circumstances the connnection could be lost..