I am trying to write a thin wrapper around pdo mysql, but I am running into an issue where a public function is returning null instead of the expected array of associative arrays. Is this a problem with pass by value/reference? My initial thought was this was a reference or public issue, but the trivial example works.
<?php
class PDOMysqlAdapter {
public $db;
public $result;
public $test = array(1,2);
public function get(){
return $this->test;
}
public function __construct($host, $port, $dbname, $username, $password, $charset = "utf8") {
$this->db = new PDO(
"mysql:host={$host};port={$port};dbname={$dbname};charset={$charset}",
$username,
$password
);
$this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
public function singleton($sql, $debug = false) {
if($debug) { error_log("Executing:
{$sql}
"); }
try {
$this->result = $this->db->query($sql)->fetch(PDO::FETCH_ASSOC);
if($debug) { error_log(print_r($this->result, true)); }
return $this->result;
} catch(PDOException $ex) {
error_log($ex->getMessage()."
");
return NULL;
}
}
public function multiple($sql, $debug = false) {
if($debug) { error_log("Executing:
{$sql}
"); }
try {
$this->result = $this->db->query($sql)->fetchAll(PDO::FETCH_ASSOC);
if($debug) { error_log(print_r($this->result, true)); }
error_log(count($this->result));
return $this->result;
} catch(PDOException $ex) {
error_log($ex->getMessage()."
");
return NULL;
}
}
}
$db = new PDOMysqlAdapter(DB_SERVER, DB_PORT, DB_NAME, DB_USER, DB_PASS);
error_log(print_r($db->get(), true)); // does what I think it should
$result = $db->singleton("SELECT 1", true);
error_log(print_r($result, true)); // return { '1' => '1' }
$foo = $db->multiple("SELECT * FROM users LIMIT 2", true); // query returns without error and result exists within scope
error_log(print_r($foo, true)); // null
error_log(count($db->result)); // variable is public and full of expected contents
Why is $foo NULL here? $db->result
contains the things that I expect to be returned into $foo.