public static function read($name, $array) { $sql = "SELECT * FROM " . $name; if ($array) { $first = true; $sql .= " where "; foreach ($array as $key => $value) { if (!$first) { $sql = " and "; } else { $first = false; } $sql .= $key . "='" . $value . "' "; } } LOG::trace("sql:{$sql}"); $ds = new DataSource(); $payload = $ds->matrix($sql); if (!$payload) { if ($ds->error()) { throw new Exception($ds->error()); } } return $payload; }