note 16033 added to ref.mysql
| From: | matias dot muhonen at iki dot fi | Date: | Sat, 13 Oct 2001 15:12:58 +0000 |
| Subject: | note 16033 added to ref.mysql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-18879@lists.php.net to get a copy of this message | ||
I wrote a simple class for mysql database. I found it useful, so give it a try if you want :)
<?
// mysql.class
// a helper class for mysql database interaction
class mysqlDatabase
{
var $_hostname;
var $_username;
var $_password;
var $_database;
var $_handle;
// a class constructor function which does some
// juggling to correct php's insufficient class
// implementation
function mysqlDatabase($hostname,$username,$password,$database)
{
$this->_hostname = $hostname;
$this->_username = $username;
$this->_password = $password;
$this->_database = $database;
}
// Purpose: Inits MySQL database connection
// Arguments: db hostname, db username,
// db password and db name
// Return: true for success, false for error
function connect()
{
$this->_handle = mysql_connect($this->_hostname,$this->_username,$this->_password);
if($this->_handle != false)
{
$ret = mysql_select_db($this->_database,$this->_handle);
if($ret == true)
{
return true;
}
else
{
return false;
}
}
else
{
return false;
}
}
// Purpose: Query MySQL database
// Arguments: SQL query line
// Return: rows for success, false for error
function query($query)
{
$result = mysql_query($query,$this->_handle);
if($result != false)
{
return $result;
}
else
{
return false;
}
}
// Purpose: Parses MySQL query results
// Arguments: result to parse
// Return: parsed result for success, false if no data to parse
function parse($result)
{
$data = mysql_fetch_array($result,$this->_handle);
if($data != false)
{
return $data;
}
else
{
return false;
}
}
// Purpose: Closes MySQL database connection
// Arguments: none
// Return: ok for success, false for error
function close()
{
$status = mysql_close($this->_handle);
if($status == true)
{
return true;
}
else
{
return false;
}
}
}
?>
Here's an example how to use the class.
<?
// This is an example how to use mysql class.
// The class' methods should be covered here.
include('mysql.class');
// these could be included from a header file...
define('MYSQL_SERVER','somehost');
define('MYSQL_LOGIN','somelogin');
define('MYSQL_PASSWORD','somepassword');
define('MYSQL_DB','somedatabase');
$db = new mysqlDatabase( MYSQL_SERVER, MYSQL_LOGIN, MYSQL_PASSWORD, MYSQL_DB );
if( $db->connect() == true )
{
$result = $db->query("SELECT * FROM foo");
if( $result != false )
{
while( $row = $db->parse($result) )
{
echo $row['bar'];
}
}
else
{
echo "Error: couldn't query database.";
}
$db->close();
}
else
{
echo "Error: couldn't open database connection.";
}
?>
--
http://www.php.net/manual/en/ref.mysql.php
http://master.php.net/manage/user-notes.php?action=edit+16033
http://master.php.net/manage/user-notes.php?action=delete+16033
http://master.php.net/manage/user-notes.php?action=reject+16033