|
|
|
|
|
|
| |
| <?php
/**
* This class provides methods for setting the
* parameters needed to connect to a MySQL
* database and creates the link to the
* database (mysqli_connect).
*/
class DBSettings
{
private $host; # The name of the server
private $db; # The name of the database
private $user; # The username
private $pass; # The password
private $link; # The mysqli_connect link.
/**
* The class constructor.
*
* @param string $host
* @param string $db
* @param string $user
* @param string $pass
* @return DBSettings
*/
function DBSettings($host, $db, $user, $pass)
{
$this->host = $host; # The name of the server
$this->db = $db; # The name of the DB
$this->user = $user; # The username
$this->pass = $pass; # The password
}
/**
* Creates the link to the database (mysqli_connect).
* The parameter $encrypt specifies if the password
* will be encrypted using the md5 algorythm or not.
* The default value of 1 encrypts the password.
*
* @param numeric $encrypt
* @return object
*/
function dbConnect($encrypt = 1)
{
###############################
### Validate the parameters ###
###############################
if ($encrypt !== 1 && $encrypt !== 0)
{
printf('Invalid parameter for $encrypt. The parameter must be either 1 or 0.');
exit();
}
$host = $this->host;
$db = $this->db;
$user = $this->user;
$pass = $this->pass;
if ($encrypt === 1)
{
$pass = md5($this->pass); # Encrypt the password
}
# Link to the DB
$this->link = mysqli_connect($host, $user, $pass, $db);
if (!$this->link)
{
# Error message if connection fails
printf("Can't connect to the MySQL Database Server.");
exit;
}
else
{
return $this->link; # Return the link
}
}
}
?> | |
|
|
| email new items in db
Categories : PHP, Email, Databases, MySQL, Beginner Guides | | | MySQL Handler
Categories : PHP, Databases, MySQL, Classes and Objects, PHP Classes | | | Powerful php/mysql Pagination for up to 6 URL Params
Categories : PHP, PHP Classes, Databases, MySQL, Navigation | | | PostGreSQL and MySQL 2 in 1 db Manager
Categories : PHP, PHP Classes, Databases, PostgreSQL, MySQL | | | MySQL Class to ease Database connectivity
Categories : MySQL, PHP Classes, Databases, PHP | | | usercounter class
Categories : PHP, PHP Classes, Databases, MySQL, Environment Variables | | | Simple Mini Poll class library (SimPoll)
Categories : PHP, PHP Classes, Databases, MySQL, Complete Programs | | | Online Automatic Class Generator for MySQL Tables
Categories : PHP, PHP Classes, Classes and Objects, Databases, MySQL | | | Convert a File database into MySQL
Categories : PHP, Filesystem, Databases, MySQL, Beginner Guides | | | Simple database class
Categories : PHP, PHP Classes, MySQL, Databases | | | Simple usersOnline class - keep track of how many users are online on your site
Categories : PHP, PHP Classes, Databases, MySQL | | | Setting up InnoDB on MySQL and using Transactions Begin, Commit, Rollback in PHP.
Categories : PHP Classes, Databases, PHP, MySQL, InnoDB | | | Newbie Notes #4 - Trapping dumb MySQL query errors
Categories : PHP, Databases, MySQL, Debugging, Beginner Guides | | | mySQL/PHP/search with multientry
form and table output with colored rows
Categories : PHP, Beginner Guides, MySQL, HTML and PHP, Databases | | | Ajax PHP Tree (Left and Right) with MySQL
Categories : PHP, Databases, MySQL, AJAX, PHP Classes | |
| | | | Joseph Crawford wrote :1366
this code example is pretty much the basics may as well have just used the mysql_ php functions.
| |
|
|
|
