README

这是一个使用PHP编写并基于Doctrine/DBAL构建的简单SQL抽象层适配器，用于处理CRUD操作。此库不提供任何ORM或ODM。

安装

建议使用 Composer 安装 Soupmix。

$ composer require soupmix/sql "~0.7"

这将安装 Soupmix 及其所有依赖。Soupmix 需要 PHP 5.6.0 或更高版本。

文档

API 文档：查看数据库适配器功能的详细信息

使用

// Connect to SQL Service


$config = [
    'dbname'    => 'test',
    'user'      => 'root',
    'password'  => '',
    'host'      => '127.0.0.1',
    'port'      => 3306,
    'charset'   => 'utf8',
    'driver'    => 'pdo_mysql',
];
$client = \Doctrine\DBAL\DriverManager::getConnection($config);
$sql = new \Soupmix\SQL(['db_name'=>$config['dbname']], $client);


$docs = [];
$docs[] = [
    "full_name" => "John Doe",
    "age" => 33,
    "email"    => "johndoe@domain.com"      
];
$docs[] = [
    "full_name" => "Jack Doe",
    "age" => 38,
    "email"    => "jackdoe@domain.com"
];

$docs[] = [
    "full_name" => "Jane Doe",
    "age" => 29,
    "email"    => "janedoe@domain.com"
];

foreach($docs as $doc){
    // insert user into database
    $sql_user_id = $sql->insert("users",$doc);
}
// get user data using id
$user_data = $sql->get('users', $sql_user_id);



// user's age lower_than_and_equal to 34 or greater_than_and_equal 36 but not 38
$filter = [[['age__lte'=>34],['age__gte'=>36]],"age__not"=>38];

//find users that has criteria encoded in $filter
$docs = $sql->find("users", $filter);

贡献

如果发现错误，请提交问题或发送拉取请求。
如有任何疑问，请随时提问。

soupmix / sql

维护者

详细信息

README

安装

文档

使用

贡献