README

一个简单的SQL生成库 Native PHP

安装

下载ZIP文件或使用

composer create-project yudhigule/sql-gen

使用方法

<?php 
 require_once __DIR__ . '/../vendor/autoload.php';
 use SQLGen\SQLGenerator as SQL;
 $sqlGenerator = new SQL("table_name");

示例

例如，我在测试目录中运行了测试

<?php 
<?php 
 require_once __DIR__ . '/../vendor/autoload.php';
 use SQLGen\SQLGenerator as SQL;

 $sqlGenerator = new SQL("members");
 $insertParams = [
	 "id"=>1,
	 "name"=>'yudhigule',
	 'email'=>'yudhigule@sqlgen.com',
	 'age'=>24
 ];
 $sqlInsert = $sqlGenerator->create($insertParams)->sql();
 $sqlUpdate = $sqlGenerator->update($insertParams)
				 ->where("name","yudhigule")
				 ->where("age",24,'>')
				 ->sql();
 $sqlSelect = $sqlGenerator->select(['id','name'])->where('id',1)->sql();
 $sqlDelete = $sqlGenerator->delete()->where('id',1)->sql();

printf("%s \n",$sqlInsert);
printf("%s \n",$sqlUpdate);
printf("%s \n",$sqlSelect);
printf("%s \n",$sqlDelete);

然后它会返回

INSERT INTO members(id,name,email,age) VALUES('1','yudhigule','yudhigule@sqlgen.com','24') 
UPDATE members SET id='1',name='yudhigule',email='yudhigule@sqlgen.com',age='24' WHERE name = 'yudhigule' AND age > '24' 
SELECT id,name FROM members WHERE id = '1'  
DELETE FROM members WHERE id = '1'

yudhigule / sql-gen

维护者

详情

README

安装

使用方法

示例