Location: PHPKode > scripts > Class Database > class-database/class_database_examples.php
<?php
require_once 'class_database.php';

$db_connection = array(
 	'type' => 'mysql',
 	'login' => 'root',
 	'mdp' => '',
 	'server' => 'localhost',
 	'db' => 'my_database'
 	);

$test = new test($db_connection);
if (count($test->ERR_get())>0) quit($test->ERR_get());
$user = $db_connection['login'];
$pwd =  $db_connection['mdp'];
echo "testing root user in table user :[".$test->SELECT_example($user,$pwd)."]<BR>";
if (count($test->ERR_get())>0) quit($test->ERR_get());
echo "insert user [".$test->INSERT_example("bob","dylan")."]<BR>";
if (count($test->ERR_get())>0) quit($test->ERR_get());

function quit($aErr)
{
 echo "some errors occurs<BR>";
 print_r($aErr);
 exit(0);
}

/**************************************************************************
 **************************************************************************
 **************************************************************************
 ***************************************************************************/
class test
{
	/**
	 * @shortdesc : the database object
	 * @type mixed
	 **/
	var $oDB;
	/**
	 * @shortdesc array of errors
	 * @type array
	 **/
	var $aErr;

	/**
	 * @ builder
	 * @param arrray dDSN: array with keys types specified (type, login, mdp, server, db)
	 * @ type void
	 * @public
	 **/
   function test($dDSN)
   {
	 $this->_ERR_ini();
	 $this->oDB = new database($dDSN);
   }
   /**
	* get the error
	**/
   function ERR_get()
   {
   	    return array_merge($this->aErr,$this->oDB->ERR_get());
   }
   
   function _ERR_ini()
   {
   	    $this->aErr = array();
   }
   /**
	* @shortdesc example of use of the SELECT with classe database
	* @param string user : user login
	* @param string pwd : login pwd
	* @type bool
	* @public
	**/
   function SELECT_example($user,$pwd)
   {
	 $this->_ERR_ini();
   	 $user = addslashes($user);
	 $pwd = md5($pwd);
	 $sSQL = "SELECT user_id FROM users WHERE user_login = '".$user."' and user_pwd = '".$pwd."'";
	 $this->oDB->execute($sSQL);
	 if ($this->ERR_get()) return;
	 return ($this->oDB->ENR_found()==1);
   }

   /**
	* @shortdesc example of use of the INSERT with classe database
	* @param string user : user login
	* @param string pwd : login pwd
	* @type bool
	* @public
	**/
   function INSERT_example($user,$pwd)
   {
     $this->_ERR_ini();
   	 $user = addslashes($user);
	 $pwd = md5($pwd);
	 $id = $this->oDB->getID('user');
	 $sSQL = "INSERT INTO users (user_id, user_login, user_pwd) VALUES ('".$id."','".$user."','".$pwd."')";
	 $this->oDB->execute($sSQL);
	 if ($this->ERR_get()) return;
	 return ($this->oDB->ENR_affected()==1);
   }
}
?>
Return current item: Class Database