MySQL database

[hmvrulz]

I have created a class to handle my mysql stuff...
Can some one Tell me how i can include methods for
INSERTING , UPDATE, SELET, DELETE in to this
If am taking keys..values as an array...

<?php



class dbHandler
{

			// Defining CONNECTION Parameters
			const HOST = 'localhost'; // SERVER
			const USERNAME = 'abc'; // Username
			const PASSWORD = '123'; // Password
			const DATABASE = 'db'; // Database

			// Method to Connect to the database and select it.
			function connect()
			{
							$this->conn = mysql_connect(HOST, USERNAME, PASSWORD) or die("Connection to the Database Failed!!!");
							mysql_select_db(DATABASE);

			}

			// Method to Process the general Queries.
			function query($query)
			{
							$result = mysql_query($query, $this->conn) or die("Database Query Failed !!! <br/> $query <br/>" .
											mysql_error());
							return $result;

			}

			// Method to Fetch data from the Database in the form of Array Assoc
			function fetchArray($query)
			{
							$result = $this->query($query);
							$result = mysql_fetch_assoc($result);
							return $result;

			}

			// Method to fetch No of Rows
			function numRows($query)
			{
							$result = $this->query($query);
							$result = mysql_num_rows($result);
							return $result;

			}

			// Method to Disconenct the Opened Conenction
			function disconnect()
			{
							mysql_close($this->conn);
			}





}

?>

[bpat1434]

Well, I'd think you could just add the methods delete(), update(), insert(), and select()...

For example a delete might look like:

/**
 * Delete selected row(s) from table
 *
 * @param $table  string  Table name to delete row(s) from
 * @param $conditions array  Conditions needed for rows to be deleted
 * @param $limit int  Maximum number of rows to delete (default: 1)
 * @return boolean
 */
function delete($table, $conditions=array(), $limit=1)
{
    $sql = "DELETE FROM `".$table."` ";

$sql .= $this->buildConditionsClause($conditions);

$sql .= "LIMIT ". $limit;

$result = mysql_query($query);
if(!$result || mysql_affected_rows() < $limit)
    return false;

return true;
}

/**
 *  Dynamically build a WHERE clause based upon conditions given
 *
 * @param $conditions array  Array of conditions
 * @return string
 */
function buildConditionsClause($conditions)
{
    // No conditions, return an empty string
    if(empty($conditions))
        return '';

$sql = "WHERE ";
$connector = false;
foreach($conditions as $key=>$val)
{
    if(!is_array($val))
    {
        if($connector)
            $sql .= "AND ";

        $sql. = "`".$key."` = '".$val."' ";
        $connector = true;
    }
    else
    {
        $type = $key;
        foreach($val as $key=>$val2)
        {
            if($connector)
                $sql .= strtoupper($type)." ";

            $sql .= "`".$key."` = '".$val2."' ";
            $connector = true;
        }
    }
}

return $sql;
}

You should then be able to pass in arrays like:

<?php
$conditions = array(
    'column1' => 'some value',
    'column2' => 'some other value',
);

// Or to use OR ...
$conditions = array(
    'or' => array(
        'column1' => 'some value',
        'column2' => 'some other value'
    ),
);

It's mimicked of cakePHP's conditions; albeit, very very simplified. Anyway, you can do much the same thing with select, update, and insert statements.