Changeset 525 for trunk/phpbms/include

Timestamp:

05/13/09 20:00:01 (3 years ago)

Author:

brieb

Message:

* Initial implementation of API interface as a new module. It is now possible to talk to phpBMS through a form posting (api_json.php) in json format. This includes querying more than single records (searching) by accesing mySQL stored procedures.

Location:

trunk/phpbms/include

Files:

• db.php (modified) (1 diff)
• session.php (modified) (5 diffs)
• tables.php (modified) (1 diff)

trunk/phpbms/include/db.php

@@ -120 +120 @@
 
 
+    /**
+     * Establishes a connection to the database
+     *
+     * Establishes a connection to the database.  If the {@link $pconnect} setting
+     * is set, it uses the mysql_pconnect (for persistennt connections). We pass
+     * connection flags of 65536 so that calling simple stored procedures will
+     * successfully return results
+     */
     function connect(){
-        // This functions connects to the server.
-        // It uses pconnect if the constant is set (via the settings.php file)
 
         if($this->pconnect)
-            $this->db_link = @ mysql_pconnect($this->hostname,$this->dbuser,$this->dbpass);
+            $function = "mysql_pconnect";
         else
-            $this->db_link = @ mysql_connect($this->hostname,$this->dbuser,$this->dbpass);
+            $function = "mysql_connect";
+
+        $this->db_link = @ $function($this->hostname, $this->dbuser, $this->dbpass, 65536);
 
         if(!$this->db_link){

trunk/phpbms/include/session.php

@@ -446 +446 @@
 
 
-        function verifyAPIlogin($user, $pass){
+        function verifyAPIlogin($user, $pass, $format = "json"){
 
                 $thereturn = false;
@@ -474 +474 @@
                 if(!$queryresult) {
 
-                        $error = new appError(-720,"","Error retrieving user record",true,true,true,"json");
+                        $error = new appError(-720,"","Error retrieving user record",true,true,true,$format);
                         return false;
 
@@ -497 +497 @@
 
                         if(!$queryresult)
-                                $error = new appError(-730,"","Error Updating User Login Time",true,true,true,"json");
+                                $error = new appError(-730,"","Error Updating User Login Time",true,true,true,$format);
                         else
                                 $thereturn = true;
@@ -553 +553 @@
         //Testing for API login
         if(strpos($scriptname,"api_")!==false){
+
+                if(!isset($_POST["phpbmsformat"]))
+                    $_POST["phpbmsformat"] = "json";
+
                 if(isset($_POST["phpbmsusername"]) && isset($_POST["phpbmspassword"])){
 
@@ -569 +573 @@
 
 
-                        if(!$phpbmsSession->verifyAPILogin($_POST["phpbmsusername"],$_POST["phpbmspassword"]))
+                        if(!$phpbmsSession->verifyAPILogin($_POST["phpbmsusername"],$_POST["phpbmspassword"], $_POST["phpbmsformat"]))
                                 $error = new appError(-700,"","Login credentials incorrect",true,true,true,"json");
 
                 } else
-                        $error= new appError(-710,"","No login credentials passed",true,true,true,"json");
+                    $error= new appError(-710, "", "No login credentials passed", true, true, true, $_POST["phpbmsformat"]);
 
         } else {

trunk/phpbms/include/tables.php

@@ -322 +322 @@
             return $therecord;
 
-        }//edn function getDefaults
+        }//end function getDefaults
+
 
         // Gets a specific individual record from the table