X-Git-Url: http://git.ozlabs.org/?a=blobdiff_plain;ds=sidebyside;f=web%2Fsearchengine.php;fp=web%2Fsearchengine.php;h=6117f38b864cfbc6aa2198686ded1109ff5e865c;hb=d2c982b37f3c4373e99e7c60c19d048de02b5919;hp=0000000000000000000000000000000000000000;hpb=2e0ef31d8963eb146337093252d6ae28d2b18813;p=ccan

diff --git a/web/searchengine.php b/web/searchengine.php
new file mode 100644
index 00000000..6117f38b
--- /dev/null
+++ b/web/searchengine.php
@@ -0,0 +1,17 @@
+<?php
+function searchdb($text, $in, $db)
+{
+	//search db 
+	$handle = sqlite3_open($db) or die("Could not open database");
+	if($in == 'module')
+		$query = "select * from search where title LIKE \"%$text%\"";
+	else if($in == 'author')
+		$query = "select * from search where author LIKE \"%$text%\"";
+	else 	
+		$query = "select * from search where title LIKE \"%$text%\" or author LIKE \"%$text%\"";
+		
+	$result = sqlite3_query($handle, $query) or die("Error in query: ".sqlite3_error($handle));
+	return $result;
+}
+
+?>
\ No newline at end of file