0,0 → 1,102 |
<?php |
#################################################### |
# AstWeb - Asterisk PBX Dynamic config environment # |
# # |
# Written by: Jamie Carl # |
# jazz@funkynerd.com # |
# # |
# Copyright (C) 2006 Achieve Corp # |
# # |
# Licence: This software is licenced under the # |
# GNU/GPL. Please see licence.txt for # |
# more information. # |
#################################################### |
|
if ( !defined('IN_ASTWEB') ) { |
die("Hacking attempt"); |
} |
|
class db_obj { |
private $connection; |
private $result; |
private $row; |
|
function __construct($host, $user, $password, $database) { |
$this->connection = pg_connect('host='.$host.' user='.$user.' password='.$password.' dbname='.$database) or |
die("SQL service unavailable please try again later"); |
} |
|
function __destruct() { |
if($this->connection) { |
pg_close($this->connection); |
} |
} |
|
function query($sql) { |
if($this->connection) { |
$this->result = pg_query($this->connection, $sql) or die('Query failed: '.$sql); |
return $this->result; |
} |
return false; |
} |
|
function query_params($sql, $params) { |
if($this->connection) { |
$this->result = pg_query_params($this->connection, $sql, $params) |
or die('Query failed: '.$sql); |
return $this->result; |
} |
return false; |
} |
|
function fetch_row() { |
if($this->result) { |
$this->row = pg_fetch_assoc($this->result); |
return $this->row; |
} |
return false; |
} |
|
function fetch_row_idx() { |
if($this->result) { |
$this->row = pg_fetch_row($this->result); |
return $this->row; |
} |
return false; |
} |
|
function fetch_all() { |
if($this->result) { |
return pg_fetch_all($this->result); |
} |
return false; |
} |
|
function num_rows() { |
if($this->result) { |
return pg_num_rows($this->result); |
} |
|
return 0; |
} |
|
function num_fields() { |
if($this->result) { |
return pg_num_fields($this->result); |
} |
} |
|
function get_field_name($col) { |
if($this->result) { |
return pg_field_name($this->result, $col); |
} |
} |
|
function get_field($col) { |
if($this->row) { |
return $this->row[$col]; |
} |
return NULL; |
} |
} |
?> |