PHParadise | category databases | copy source code of mySQL class

PHParadise > databases > mySQL class

a very simple mySQL class for connecting, querying and getting some data from a database

copy the code of databases / mySQL class

<?php

/*------------------------------------------------------------------------------
|
|                             PHParadise source code
|
|-------------------------------------------------------------------------------
|
| file:             mySQL class
| category:         databases
|
| last modified:    Wed, 29 Jun 2005 04:52:53 GMT
| downloaded:       Fri, 25 May 2012 02:40:19 GMT as copy from textarea
|
| code URL:
| http://phparadise.de/php-code/databases/mySQL-class/
|
| description:
| a very simple mySQL class for connecting, querying and getting some data from a
| database
|
------------------------------------------------------------------------------*/

class simple_mySQL_class
{
	var $db;

function simple_mySQL_class($dbname, $username, $password)
	{
		// change "localhost" to your database-server address
		// if your database-server is not the machine running this script
		$this->db = mysql_connect('localhost', $username, $password)
			or die('Unable to connect to Database Server');

mysql_select_db($dbname, $this->db)
			or die('Could not select database');
	}

function query($sql)
	{
		$result = mysql_query($sql, $this->db)
			or die('Invalid query: '.mysql_error());
		return $result;
	}

function fetch($sql)
	{
		$data = array();
		$result = $this->query($sql);
		while($row = mysql_fetch_assoc($result))
		{
			$data[] = $row;
		}
		return $data;
	}

function getone($sql)
	{
		$result = $this->query($sql);
		if(mysql_num_rows($result) == 0)
			$value = FALSE;
		else
			$value = mysql_result($result, 0);
		return $value;
	}
}

// use like
// connect to the database with database name, username and password
$dbconnect = new simple_mySQL_class('database', 'user', 'password');
// build your mySQL query
$query = 'SELECT * FROM `mytable` WHERE `id`=\''.$search.'\' ORDER BY `date` DESC';
// get the result in an array
$result = $dbconnect->fetch($query);

// output the data in whatever way you want...
echo '<pre>';
print_r($result);
echo '</pre>';

PHParadise source code of “mySQL class” in category “databases”

PHParadise > databases > mySQL class

copy the code of databases / mySQL class