DB Abstraction

[50cent]

Hey,

i use a file with all my queries but i want to make it even better by making a file called mysql.php which will consist of all the DB select/update/delete/insert function so instead of using in every qurey:

$result = mysql_query("SELECT * FROM person");while($row = mysql_fetch_array($result))
  {
  echo $row['FirstName'] . " " . $row['LastName'];
  echo "<br />"
  }

I will put in the mysql.php file a function that called 'select' then i will use the function in everyfile i want as this:

include("mysql.php");
$result = $DB->select("SELECT * FROM person");
while($row = $DB->fetch_array($result))
  {
  echo $row['FirstName'] . " " . $row['LastName'];
  echo "<br />"
  }

this is an example of just the select function but i want to do it to select/update/delete/insert so there is no complications.

Im sure im making myself clear but does anyone have something like that already coded i would like taking alook at it.

here is an example of IPS mysql DB abstraction:

* Update:
* $db->do_update( 'table', array( 'field' => 'value', 'field2' => 'value2' ), 'id=1' );
* Insert
* $db->do_insert( 'table', array( 'field' => 'value', 'field2' => 'value2' ) );

/*-------------------------------------------------------------------------*/
// Quick function: DO UPDATE
/*-------------------------------------------------------------------------*/

function do_update( $tbl, $arr, $where="", $shutdown=FALSE )
{
	//-----------------------------------------
	// Form query
	//-----------------------------------------

	$dba   = $this->compile_db_update_string( $arr );
	$query = "UPDATE ".$this->obj['sql_tbl_prefix']."$tbl SET $dba";

	if ( $where )
	{
		$query .= " WHERE ".$where;
	}

	//-----------------------------------------
	// Shut down query?
	//-----------------------------------------

	$this->no_prefix_convert = 1;

	if ( $shutdown )
	{
		if ( ! $this->obj['use_shutdown'] )
		{
			$this->is_shutdown = 1;
			$return = $this->query( $query );
			$this->no_prefix_convert = 0;
			$this->is_shutdown = 0;
			return $return;
		}
		else
		{
			$this->obj['shutdown_queries'][] = $query;
			$this->no_prefix_convert = 0;
			$this->cur_query = "";
		}
	}
	else
	{
		$return = $this->query( $query );
		$this->no_prefix_convert = 0;
		return $return;
	}
}
/*-------------------------------------------------------------------------*/
// Quick function: DO INSERT
/*-------------------------------------------------------------------------*/

function do_insert( $tbl, $arr, $shutdown=FALSE )
{
	//-----------------------------------------
	// Form query
	//-----------------------------------------

	$dba   = $this->compile_db_insert_string( $arr );
	$query = "INSERT INTO ".$this->obj['sql_tbl_prefix']."$tbl ({$dba['FIELD_NAMES']}) VALUES({$dba['FIELD_VALUES']})";

	//-----------------------------------------
	// Shut down query?
	//-----------------------------------------

	$this->no_prefix_convert = 1;

	if ( $shutdown )
	{
		if ( ! $this->obj['use_shutdown'] )
		{
			$this->is_shutdown = 1;
			$return = $this->query( $query );
			$this->no_prefix_convert = 0;
			$this->is_shutdown = 0;
			return $return;
		}
		else
		{
			$this->obj['shutdown_queries'][] = $query;
			$this->no_prefix_convert = 0;
			$this->cur_query = "";
		}
	}
	else
	{
		$return = $this->query( $query );
		$this->no_prefix_convert = 0;
		return $return;
	}
}

something like that, of course no need for all that something simple that will make the job.

would appreciate any help, thanks vadim.

[BlueKai]

This seems like a lot of work and a lot of code for not a lot of gain. Is there some reason that I'm not seeing? If I wanted more separation between php code and queries, I'd use stored procedures.

do_update(tablename, thesetothose, where this=that)

mysql_query(update tablename set thesetothose where this=that)

Not seeing much of a difference...

[50cent]

I just think this will be easier when using alot of quries, i have used it in the past with the IPB forum software, i just want to know if this can be done with a simple way cause IPB uses a really complicated way, i couldnt find a tutorial on how to do that so if any body knows anykind of tutorial that does that i would appreciate u posting it, and i didnt ask to show me everything lets say just how to make a function that gona select data from a table and i will do the update,insert, delete by myself, i just need a starting point.

thanks for the help.

[NogDog]

There's always the [man]PDO[/man] extension if using PHP 5.1+, or the PEAR MDB2 package.

[50cent]

thanks but i found something for php4 and what i was just looking for it:

http://homework.nwsnet.de/products/67/

its a great one really easy to use....
thanks for the help. 🙂