note 99489 added to function.mysql-connect
| From: | gratcypalmaatgmaildotcom at osu1 dot php dot net | Date: | Thu, 19 Aug 2010 18:11:27 +0000 |
| Subject: | note 99489 added to function.mysql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-171864@lists.php.net to get a copy of this message | ||
here my class connection. i created to help my work.
<?php
class DBConfig {
var $host;
var $user;
var $pass;
var $db;
var $db_link;
var $conn = false;
var $persistant = false;
public $error = false;
public function config(){ // class config
$this->error = true;
$this->persistant = false;
}
function
conn($host='localhost',$user='root',$pass='pass',$db='database'){
// connection function
$this->host = $host;
$this->user = $user;
$this->pass = $pass;
$this->db = $db;
// Establish the connection.
if ($this->persistant)
$this->db_link = mysql_pconnect($this->host, $this->user, $this->pass, true);
else
$this->db_link = mysql_connect($this->host, $this->user, $this->pass, true);
if (!$this->db_link) {
if ($this->error) {
$this->error($type=1);
}
return false;
}
else {
if (empty($db)) {
if ($this->error) {
$this->error($type=2);
}
}
else {
$db = mysql_select_db($this->db, $this->db_link); // select db
if (!$db) {
if ($this->error) {
$this->error($type=2);
}
return false;
}
$this -> conn = true;
}
return $this->db_link;
}
}
function close() { // close connection
if ($this -> conn){ // check connection
if ($this->persistant) {
$this -> conn = false;
}
else {
mysql_close($this->db_link);
$this -> conn = false;
}
}
else {
if ($this->error) {
return $this->error($type=4);
}
}
}
public function error($type=''){ //Choose error type
if (empty($type)) {
return false;
}
else {
if ($type==1)
echo "<strong>Database could not connect</strong> ";
else if ($type==2)
echo "<strong>mysql error</strong> " . mysql_error();
else if ($type==3)
echo "<strong>error </strong>, Proses has been stopped";
else
echo "<strong>error </strong>, no connection !!!";
}
}
}
// example to use
$DB = new DBConfig();
$DB -> config();
$DB -> conn();
// mysql command
// mysql_query and others..
$DB -> close();
?>
----
Server IP: 202.158.52.162
Probable Submitter: 122.144.3.3
----
Manual Page -- http://www.php.net/manual/en/function.mysql-connect.php
Edit -- https://master.php.net/note/edit/99489
Del: integrated -- https://master.php.net/note/delete/99489/integrated
Del: useless -- https://master.php.net/note/delete/99489/useless
Del: bad code -- https://master.php.net/note/delete/99489/bad+code
Del: spam -- https://master.php.net/note/delete/99489/spam
Del: non-english -- https://master.php.net/note/delete/99489/non-english
Del: in docs -- https://master.php.net/note/delete/99489/in+docs
Del: other reasons-- https://master.php.net/note/delete/99489
Reject -- https://master.php.net/note/reject/99489
Search -- https://master.php.net/manage/user-notes.php