README

<?php

define("DATA_FIREBIRD_CONFIG",[
        "hostname"=>"",
        "database"=>"",
        "username"=>"",
        "password"=>"",
        "port"=>"3050",
   ]);
	
use Cacio\ProdFirebird\ProdFirebird;


$db = new ProdFirebird();


### Metodo Basico

Veja abaixo os métodos básicos para chamar select, update, delete e query na classe.

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

$db->execute();

更新

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

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

$db->execute();

删除

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

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

$db->execute();

获取数据

以下展示了使用PHP数据库类搜索数据的不同方法。

获取行

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

$db->execute();

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

获取关联数组

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

$db->execute();

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

获取对象

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

$db->execute();

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

其他数据库类方法

以下展示了PHP数据库类的其他实用方法。

关闭连接

$db->close();

开始事务

$db->begin_trans();

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

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

$db->execute();

$db->commit();

回滚事务

$db->rollback();

提交事务

$db->commit();