Changeset 1683 for trunk/system/libraries/drivers/Database_Mysqli.php

Timestamp:

01/05/2008 05:45:18 PM (12 months ago)

Author:

zombor

Message:

Add preliminary mysqli prepared statement support

Files:

• trunk/system/libraries/drivers/Database_Mysqli.php (modified) (3 diffs)

trunk/system/libraries/drivers/Database_Mysqli.php

@@ -470 +470 @@
         protected $link = NULL;
         protected $stmt;
+        protected $var_names;
+        protected $var_values;
 
         public function __construct($sql, $link)
@@ -486 +488 @@
 
         // Sets the bind parameters
-        public function bind_params()
-        {
-                $argv = func_get_args();
-                return $this;
-        }
-
-        // sets the statement values to the bound parameters
-        public function set_vals()
-        {
+        public function bind_params($param_types, $params)
+        {
+                $this->var_names = array_keys($params);
+                $this->var_values = array_values($params);
+                call_user_func_array(array($this->stmt, 'bind_param'), array_merge($param_types, $var_names));
+
                 return $this;
         }
@@ -501 +500 @@
         public function execute()
         {
-                return $this;
+                foreach ($this->var_names as $key => $name)
+                {
+                        $$name = $this->var_values[$key];
+                }
+                $this->stmt->execute();
+                return $this->stmt;
         }
 }