Posted By

JonnySnip3r on 11/04/10

Tagged

Versions (?)

Last Edited at 11/04/10 01:50am

Statistics

Viewed 419 times

Favorited by 0 user(s)

Related snippets

php Prepared Statement Search (Needs Improvement)

/ Published in: PHP

Im pretty new to oop php i have tried to create a php search function but im sure this needs alot of improvement. So add on :D

Highlighted TextExpand

public function search($string)
	{
		if(strlen($string) > 40)
		{
			return "Woow too many words, please shorten your search.";
		}
		if(empty($string))
		{
			return "I'm a search, you type things in and I find. Please enter something and try again!";
		}
		if(strlen($string) <= 3)
		{
			return "Come on dude, you expect me to find summin with that? Type some more tags in!";
		}
		
		$x=0;
		// Teh string could be multiple searches so explode::
		$string = explode(" ", $string);
		
		foreach($string as $search)
		{
			$x++;
			if($x == 1)
			{
				@$sql .= "(blog_tags LIKE '%$search%')";
			}
			else
			{
				@$sql .= " OR (blog_tags LIKE '%$search%')";
			}
		}
		
		$sql = "SELECT blog_tags FROM subarc_blog WHERE $sql LIMIT 40";
		
		// TODO:: Count how many search results found::
		$stmt = $this->conn->prepare($sql);
		$stmt->execute();
		
		$meta = $stmt->result_metadata();
		while($field = $meta->fetch_field())
		{
			$var = $field->name;
			$$var = null;
			$params[$var] = &$var;
		}
		
		call_user_func_array(array($stmt,'bind_result'),$params);
		
		while($stmt->fetch())
		{
			return $params;
		}
		$stmt->close();
	}

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.