Viewing file:  clsConnection.php (1.44 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
ini_set('include_path','/var/www/sekret:.');
include_once("eperson.inc");
class Connection{
var $c;
//var $h = $GLOBALS["HOST"];
//var $u = $GLOBALS["USERNAME"];
//var $p = $GLOBALS["PASSWORD"] ;
//var $db = $GLOBALS["DBNAME"];
function Connection($dbServer="", $dbName="", $dbUser="", $userPassword=""){
$this->h = ($dbServer=="") ? $GLOBALS["HOST_PC"] : $dbServer;
$this->db = ($dbName=="") ? $GLOBALS["DBNAME_PC"] : $dbName;
$this->u = ($dbUser=="") ? $GLOBALS["USERNAME_PC"] : $dbUser;
$this->p = ($userPassword=="") ? $GLOBALS["PASSWORD_PC"] : $userPassword;
$this->Connect();
}
function Connect(){
$this->c = mysql_connect($this->h, $this->u, $this->p);
if (!$this->c) {
die("<p align=center>
<table align=center border=0 cellpadding=3 cellspacing=1 bgcolor=red>
<tr align=center bgcolor=#ff9999><th>เกิดข้อผิดพลาด</th></tr>
<tr align=center bgcolor=#ffffff><td><br>ไม่สามารถติดต่อฐานข้อมูลได้<br><br></td></tr>
</table>
</p>");
}
mysql_select_db($this->db, $this->c);
mysql_query("SET NAMES 'tis620'");
}
function Disconnect(){
return mysql_close($this->c);
}
function Execute($query){
return mysql_query($query, $this->c);
}
function BeginTrans(){
$this->Execute("SET AUTOCOMMIT=0");
}
function CommitTrans(){
$this->Execute("commit");
$this->Execute("SET AUTOCOMMIT=1");
}
function RollbackTrans(){
$this->Execute("rollback");
$this->Execute("SET AUTOCOMMIT=1");
}
}
?>
|