databases

mySQL class

a class with all often used mySQL functions

function DB_Class( ) [ line 5 ]

function query( ) [ line 12 ]

function fetch( ) [ line 18 ]

function getone( ) [ line 27 ]

full source of mySQL class [ line 1 - 43 ] | download mySQL class

1	<?php
2	class DB_Class
3	{
4	var $db;
5	function DB_Class($dbname, $username, $password)
6	{
7	$this->db = mysql_connect ('localhost', $username, $password)
8	or die ("Unable to connect to Database Server");
9	mysql_select_db ($dbname, $this->db)
10	or die ("Could not select database");
11	}
12	function query($sql)
13	{
14	$result = mysql_query ($sql, $this->db)
15	or die ("Invalid query: " . mysql_error());
16	return $result;
17	}
18	function fetch($sql)
19	{
20	$data = array();
21	$result = $this->query($sql);
22	while($row = mysql_fetch_assoc($result)) {
23	$data[] = $row;
24	}
25	return $data;
26	}
27	function getone($sql)
28	{
29	$result = $this->query($sql);
30	if(mysql_num_rows($result) == 0)
31	$value = FALSE;
32	else
33	$value = mysql_result($result, 0);
34	return $value;
35	}
36	}
37	?>
38	use like
39	<?
40	$dbconnect = new DB_Class('table', 'user', 'password');
41	$query = "SELECT aaa FROM bbb WHERE $match = $search ORDER BY ccc DESC";
42	$result = $dbconnect->fetch($query);
43	?>

15 hits by 7 users in the last 30 minutes.