lost DBWrapper.lib.php- <?php
- class DBWrapper extends PDO //pdo larla epey kariik yapmis evet
- {
- private $connection;
- public function __construct($engine = "odbc", $database = DBNAME, $user = DBUSER, $password = DBPASS, array $options = array())
- {
- try {
- if ($engine == "odbc")
- $this->connection = new PDO("$engine:$database",$user,$password,$options);
- /*
- else if ($engine == "mssql")
- $this->connection = new PDO("$engine:dbname=$database;host=ko.kocity.net;port=1433;",$user,$password,$options);
- */
- else {
- die("Error connecting to server");//, message: invalid engine<br />");
- }
- }
- catch (PDOException $e)
- {
- die("Error connecting to server");//, message: ".$e->getMessage()."<br />");
- }
- }
- public function query($sql, array $params = array())
- {
- try {
- $query = $this->connection->prepare($sql);
- }
- catch (PDOException $e)
- {
- die("Error preparing query");//, message: ".$e->getMessage()."<br />");
- }
- try {
- $query->execute($params);
- }
- catch (PDOException $e)
- {
- die("Error executing query");//, message: ".$e->getMessage()."<br />");
- }
- switch($query->columnCount())
- {
- case 0:
- return 0;
- case 1:
- return $query->fetchColumn();
- default:
- return $query->fetchall(PDO::FETCH_ASSOC);
- }
- }
- }
|
