README

简单、基本、简单的MySQL提供程序
一个超级简单的函数，它从您的PDO语句返回完整的SQL查询
适用于MySQL和PostgreSQL的PDO数据库服务提供程序

Composer安装

composer require stnc/pdo-database

1. 安装-连接

require_once 'vendor/autoload.php';
  define('DB_TYPE', 'mysql');
  define('DB_HOST', 'localhost');
  define('DB_NAME', 'wordpress');
  define('DB_USER', 'root');
  define('DB_PASS', '');

2. 连接

/* //use 1 
use Stnc\Db\MysqlAdapter ;
$db = new MysqlAdapter();
*/

/* //use 2
use Stnc\Db\MysqlAdapter as dbs;
$db = new dbs();
*/


//use 3
$db = new Stnc\Db\MysqlAdapter();
$tableName = 'users';

3. 选择多行

$q = "SELECT * FROM ".$tableName;
$array_expression = $db->fetchAll ( $q );
foreach ( $array_expression as $value ) {
	echo  $value ['name'];
	echo '<br>';
}

4. 选择单行

$tableName = 'wp_options';//wordpress 
$q = "SELECT * FROM ".$tableName;
$array_expression = $db->fetch ( $q );
echo $array_expression ['name'];
//or 
$q = 'SELECT * FROM '.$tableName.' where option_name="siteurl" ';
$array_expression = $db->fetch ( $q );
print_r ($array_expression);
echo $array_expression ['option_name'];

5. 查询

$q = "ALTER TABLE users MODIFY COLUMN user_id  int(11) NOT NULL AUTO_INCREMENT FIRST";
$db->query ( $q );

6. 插入数据

$data = array (
		'name' => "john",
		'lastname' => "carter",
		'status' => 1,
		'age' => 25 
);


$db->insert ( $tableName, $data );

7. 更新方法

$data = array (
		'name' => "john",
		'lastname' => "carter",
		'status' => 1,
		'age' => 25 
);
$where = array (
		'user_id' => 1 
);
$db-> update ( $tableName, $data, $where );

8. 删除方法

$where = array (
		'user_id' => 1 
);

return $db->delete ( $tableName, $where );

9. 最后的ID

$db->lastID();

10. ORM批量更新

$db->tableName=$tableName;
$db->where('id', '=', 1)->update2(['username' =>'selman sedat']);