Skip to content

Instantly share code, notes, and snippets.

@lukesUbuntu
Created October 3, 2015 03:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lukesUbuntu/58171f3a3babfc8735f2 to your computer and use it in GitHub Desktop.
Save lukesUbuntu/58171f3a3babfc8735f2 to your computer and use it in GitHub Desktop.
query url call example for possible sql
<?php
/**
* Created by PhpStorm.
* User: 9901623
* Date: 3/10/2015
* Time: 4:32 PM
*/
//words
//basic query call
$url = "&img_src&desc&limit=10&random";
//specify in_array security what calls above can be made
//parse to our search array
$searchFlag = array();
$flags = array();
//parse it
parse_str($url,$searchFlag);
//debug $search Array ( [img_src] => [desc] => [limit] => 10 )
//any manual flag not for search goes here
//kill limit if passed
if (isset($searchFlag['limit'])){
//word limit
unset($searchFlag['limit']);
}
if (isset($searchFlag['random'])){
//randomise wordlise
unset($searchFlag['random']);
}
//unique flags
foreach($searchFlag as $key => $value)
$flags[] = $key;
//array map
$search = array_map("addAnd", $flags);
//implode into our query
$query = implode(' & ', $search);
//print out query
print_r($query);
function addAnd($n)
{
return($n.' != ""');
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment