Php / MySQL Store custom searches between pages so the user can return to them

Question

I am writing a php-mysql application. The application allows the user to search the database. When the search is performed, if the user clicks on the "Back" button to return to it after studying the subject raised by him, they will be asked if they want to resend the request (he uses the message). This will result in a repeated search in the database. Using get will not result in a retransmission request - but it will repeat the search anyway.

Is there a way to save the search and call it without reloading it in the database?

It can be stored in a database or somehow in php - perhaps from sessions? There may be a lot of data from these searches; I feel that this is too much for the sessions.

Another way I can imagine is to store it in a database in a temporary table. Create a table with columns that I intend to query, then choosing insert. Then select * from the table. It also seems like a bad idea. Many dynamically created temporary tables floating around.

I know that this can be done. Saved searches are what you see in many web applications. So how is this done at all?

Answer 1

memcached

or

APC

, , . " , , ", . .

. ""? ? ? ? ?

, MySQL , ? , . "" mysql , . ?

Answer 2

" ", db, , :

search.php?searchId=22

if (isset($_GET['searchId'])) {
  $search = $_SESSION['search'][$_GET['searchId'];
  // do search
} elseif (isset($_POST['search'])) {
  $_SESSION['search'][] = $_POST;
  header('Location: search.php?searchId=' . (count($_SESSION['search']) - 1);
}

$_SESSION ['search'] [22] db...

, , SERP db... - , ...

( ), , .

, .