PHP code example of espongha / php_database_class

1. Go to this page and download the library: Download espongha/php_database_class library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

espongha / php_database_class example snippets



 new Database('MySQL');


$db->driver->connect('hostname', 'database', 'username', 'password');


$db_column = array(
	'column1',
	'column2'
);
			  
$db_where = array(
	'search_column_name' => 'search_value'
);
			  
$db_order = array(
	'column_name_to_order' => 'desc'
);
			  
$db->driver->select('tablename', $db_column, $db_where, $db_order);

$db->driver->execute();


$db_column = array(
	'column1' => 'column1_value',
	'column2' => 'column2_value'
);
			 
$db_where = array(
				'search_column_name' => 'search_value'
			)

$db->driver->update('tablename', $db_column, $db_where);

$db->driver->execute();


$db_where = array(
	'search_column_name' => 'search_value'
)

$db->driver->delete('tablename', $db_where);

$db->driver->execute();


$db_column = array(
	'column1',
	'column2'
);
			  
$db->driver->select('tablename', $db_column);

$db->driver->execute();

foreach($db->driver->fetch_row() as $value){
	echo $value[0];
	echo $value[1];
}


$db_column = array(
	'column1',
	'column2'
);
			  
$db->driver->select('tablename', $db_column);

$db->driver->execute();

foreach($db->driver->fetch_assoc() as $value){
	echo $value['column1'];
	echo $value['column2'];
}


$db_column = array(
	'column1',
	'column2'
);
			  
$db->driver->select('tablename', $db_column);

$db->driver->execute();

foreach($db->driver->fetch_object() as $value){
	echo $value->column1;
	echo $value->column2;
}


$db->driver->close();


$db->driver->begin_trans();

$db_where = array(
	'search_column_name' => 'search_value'
)

$db->driver->delete('tablename', $db_where);

$db->driver->execute();

$db->driver->commit();


$db->driver->rollback();


$db->driver->commit();