function ejecutarSelect($query) { try { //connect as appropriate as above return $this->dataBase->query($query); } catch (PDOException $ex) { echo "An Error occured!"; //user friendly message some_logging_function($ex->getMessage()); } }
function ejecutarSelectPerpared($sentencia) { try { //connect as appropriate as above $sentencia->execute(); echo $sentencia->debugDumpParams(); return $sentencia; } catch (PDOException $ex) { echo "An Error occured!"; //user friendly message some_logging_function($ex->getMessage()); } }
/** * select * @param string $sql An SQL string * @param array $array Paramters to bind * @param constant $fetchMode A PDO Fetch mode * @return mixed */ public function Query_AR($where = '', $strOrder = '', $intRecords = 100, $intPage = 1, $_id = 0) { //if(is_array($this)) //$table=$this->fie; //var_dump($this);// $this->tbl; //echo $_id; $strWhere = $this->prefix . 'uin > 0 '; if ($this->tbl == '') { return false; } if ($_id > 0) { $strWhere .= ' and ' . $this->prefix . 'uin =' . $_id; } if (is_array($this->fields)) { $strFields = implode(',', $this->fields); } else { return false; } if ($where != '') { $strWhere .= ' and ' . $where; } if ($strOrder != '') { $strOrder = 'order by ' . $strOrder; } $limit = sprintf(' limit %d, %d', ($intPage - 1) * $intRecords, $intRecords); $strSQL = "SELECT {$strFields} FROM {$this->tbl} where {$strWhere} {$strOrder} {$limit}"; try { //connect as appropriate as above $statement = $this->db->prepare($strSQL); //$objRes = $statement->fetch(); $objRes = $this->db->query($strSQL); //invalid query! } catch (PDOException $ex) { echo "An Error occured!"; //user friendly message some_logging_function($ex->getMessage()); } //echo $strSQL;//die(); //$objRes = mysql_query($strSQL) or die('Invalid SQL: '.mysql_error()); //self::$data=$objRes; return $objRes; }