Changeset 149 for Dev/trunk/classes/QuestionConnector.php

Timestamp:

11/07/11 16:55:36 (13 years ago)

Author:

jkraaijeveld

Message:

Added missing classes for the database connection

File:

• Dev/trunk/classes/QuestionConnector.php (modified) (3 diffs)

Dev/trunk/classes/QuestionConnector.php

@@ -59 +59 @@
         $keys = array_keys($arguments);
         //Set default values for arguments
-        $uid = "?uid"; $title = "?title"; $type = "?type"; $description = "?description"; $category = "?category";
+        $uid = "?uid"; $title = "?title"; $type = "?type"; $description = "?description"; $category = "?category"; $has_answer = "";
         //Set the arguments if they are supplied
         if(in_array("uid", $keys))
@@ -70 +70 @@
             $description = "\"".$arguments["description"]."\"";
         if(in_array("category", $keys))
-            $style = "\"".$arguments["category"]."\"";
+                        $style = "\"".$arguments["category"]."\"";
+                if(in_array("answers", $keys))
+                {
+                        foreach($arguments["answers"] as $answer)
+                        {
+                                $has_answer = $has_answer . 'predicates:has_answer \'' . $answer . '\' ';
+                        }
+                }
            
         $querystring = '
-         PREFIX  predicates: <' . SURVEYTOOL_PREDICATES_NAMESPACE . '>
+            PREFIX  predicates: <' . SURVEYTOOL_PREDICATES_NAMESPACE . '>
             PREFIX  resources: <' . SURVEYTOOL_RESOURCES_NAMESPACE . '>
             SELECT DISTINCT ?uid, ?title, ?type, ?description, ?category
@@ -89 +96 @@
                 predicates:question_type ' . $type . '
                 predicates:description ' . $description . '
-                predicates:question_category ' . $category . ' 
+                                predicates:question_category ' . $category . ' 
+                                ' . $has_answer . '
             }';
         //Create the querystring 
         $results = $this->model->sparqlQuery($querystring);
+
         
         $questions = array();