Novices Under FOUNDPHP Use DBO Plug-in to Run the Database

English

### DBO Quick Start
FoundPHP integrates the DBO class to perform database addition, deletion, modification, and check operations. This class also inherits the advantages of the system and also provides compatibility with the latest version of PHP 5.4-php7, without worrying about stability.

### Database Configuration

```php
<?php
$config['db']['dbhost'] 	= '127.0.0.1';	//server address
$config['db']['dbuser'] 	= 'root';		//account number
$config['db']['dbpass'] 	= 'root';		//password
$config['db']['dbname'] 	= 'databases';	//data storage name
$config['db']['dbtype'] 	= 'mysqli';		//database type
$config['db']['charset'] 	= 'utf8';		//character Encoding
$config['db']['pre'] 		= 'n_';			//database header ID
?>
```
##### The database type supports the following types:
| DBtype     | Description  |
| --------   | -----    |
| mysql      | MySQL is the most popular relational database management system|
| mysqli     | After PHP 5.4, you need to use this method to use MySQL |
| sqlite     | Lightweight single-file relational database |
| sqlite3    | Upgraded version of SQLite |
| pgsql      | PostgreSQL is a relational database management system with very complete features|
| mariadb    |MariaDB is a branch database of MySQL |
| sqlver    | SQLserver Microsoft's database |
| redis    | Message queue push (first in first out by default) |
| Memcached    | Memcached cache |

### Start Using the Database

```php
<?php
//introduce the dbo class and instantiate it
$db	= load('class/database/dbo','FoundPHP_dbo',$config['db']);
//Define the data table
$table['a']	= 'admin_user';//administrator table
$table['b']	= 'admin_group';//administrator group table
$ljoin['b']	= 'b.id=a.gid';//associated conditions
$t_field	= 'a.id,a.nickanme,b.group_name';//query field
//query data
$data_info	= sql_select(array('table'=>$table['a'],'where'=>"id=1"));
username
//adding data
//build insert data
$insert_data = array(
	'nickname'	=> 'FoundPHP user',//username
	'dates'		=> time(),//insertion time
);
//build data insertion validation conditions
$check_data	 = array(
	'nickname'	=> 'FoundPHP user',//username
);

/*
	table nisert table name
	data  Insert data array('field name'=>'value';
	checkData verification array('Verification field name'=>'Verification value')
*/
sql_update_insert(array('table'=>$table['a'],'data'=>$insert_data,'check'=>$check_data));

//edit data
//build and edit data
$update_data = array(
	'nickname'	=> 'FoundPHP edit user',//username
);
sql_update_insert(array('table'=>$table['a'],'data'=>$update_data,'where'=>'id=1'));
//delete data
sql_del(array('table'=>$table['a'],'where'=>'id!=1'));

//close the database
$db->close();
?>
```