Re: Capturing a sql query

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

 



Trying to set this up and have a question:
Example below , the example for state.
The field name is s_LocationState
The variable is set to state.

$State = "";
// check any item is selected
if (count($s_LocationState) > 0 AND
is_array($s_LocationState)) {
     $State = "'".implode("','",
$s_LocationState)."'";


So in this example, which should be the keywords, and
I'm thinking it probably doesn't matter.  The s_fields
though are more parameters then variables.  ??


> $searchQuery = array();
> $searchQuery["Keywords"]= $_POST["keyword"];
> $searchQuery["JobCategory"]= $_POST["category"];
> $searchQuery["Pay"]=$_POST["pay"];

Thank you ,
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.
> 

-- 
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