aweitian/sql-auto-gen

sql auto generator

常用验证 组件

安装组件

使用 composer 命令进行安装或下载源代码使用。, _(*1)

composer require aweitian/sql-auto-gen, _(*2)

$gen = new \Aw\Sql\Mysql\gen();
$gen->setConnection(new Aw\Db\Connection\Mysql (array(
    'host' => '127.0.0.1',
    'port' => '3306',
    'user' => 'root',
    'password' => 'root',
    'charset' => 'utf8',
    'database' => 'hdf'
)));
$gen->setTableName('data_article');

select ($gen->select())

SELECT * FROM data_article, _(*3)

insert ($gen->insert())

INSERT INTO data_article (kw,desc,thumb,title,content,date) VALUES (:kw,:desc,:thumb,:title,:content,:date), _(*4)

delete ($gen->remove())

DELETE FROM data_article WHERE sid = :sid, _(*5)

update ($gen->update())

UPDATE data_article SET kw=:kw,desc=:desc,thumb=:thumb, title=:title,content=:content,date=:date WHERE sid = :sid, _(*6)