Re: Capturing a sql query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Serialized because it is easier to store ?

Stuart


--- M Saleh EG <m.saleh.eg@xxxxxxxxx> wrote:

> I'd recommand u to use a serialized variable saved
> in ur database.
> As in the an array of keywords saved in an
> serialized variable once
> the form is submited to save the query.
> e.g. 
> $searchQuery = array();
> $searchQuery["Keywords"]= $_POST["keyword"];
> $searchQuery["JobCategory"]= $_POST["category"];
> $searchQuery["Pay"]=$_POST["pay"];
> ...
> ...
> ...
> $s_sq=serialize($searchQuery);
> 
> then save $s_sq into ur DB.
> 
> now... u should have a page that shows the saved
> searches right?  now
> by clicking on the saved search u should grab the
> data saved and query
> ur database according to the query saved in $s_sq.
> 
> Simple isnt it?
> 
> 
> About emailing the search agent results. I'd prefer
> pluging that into
> ur mailing-list solutions. I mean try to query every
> user's searches
> before sending an email so ull email users proper
> jobs according to
> their searches and criterias.
> 
> Need explanation? 
> Hope that was of a help.
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux