commiting ccan web pages

[ccan] / web / searchengine.php

diff --git a/web/searchengine.php b/web/searchengine.php
new file mode 100644 (file)
index 0000000..6117f38
--- /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