String as a URL variable - split to query recordset

[Vlinder]

I'd like to pass a multi-word string as a variable to a page which then splits the string into seperate words. After this I want to create a recordset using each of the words in the query on the same field eg:

the url would look like this:

mypage1.php?search=apple banana

where fruit LIKE apple OR fruit LIKE banana (in this example)

I've been bothering this for a while now and can't seem to get it to work. I'm using Dreamweaver 8

Any help would be greatly appreciated.

[ak1dnar]

Nothing to do with dreamweaver here, You have to use a script like this. Check this out please:

split_url_string.php

<?php
$OriginalQuery = "SELECT col_names FROM table";
$string = array();
$where = "";
if (isset($_GET['search']) AND !empty($_GET['search'])) {
  $URLString=explode(" ",$_GET['search']);
  foreach($URLString as $key){
  $string[] = " fruit LIKE $key "; // Hope You Know the Logic use to "LIKE"  :D
  }
  }
if(!empty($string)){
$where = " WHERE ".implode("OR", $string);
}
echo $OriginalQuery.$where; 
?>
 

Once you called to the page like in way of this format:
http://localhost/tut/split_url_string.php?search=banana apple
outputs:
SELECT col_names FROM table WHERE fruit LIKE banana OR fruit LIKE apple

[Vlinder]

Many thanks. Had to tinker around with it a bit but got it working in the end. Most importantly, I've learned a few things.

Again, thank.

[ak1dnar]

Many thanks. Had to tinker around with it a bit but got it working in the end. Most importantly, I've learned a few things.

Again, thank.

Glad I could help ! post back to the forum any time.
Good luck! :)