Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $DB = new ZendDbAdapterAdapter(array(
- 'driver' => 'Mysqli',
- 'database' => 'database',
- 'username' => 'user',
- 'password' => 'pass'
- ));
- use ZendDbSqlDdl;
- use ZendDbSqlDdlColumn;
- use ZendDbSqlDdlConstraint;
- $table = new DdlCreateTable('table');
- $table->setTable('table');
- $table->addColumn(new ColumnInteger('id',false,NULL,array('autoincrement'=>true)));
- $table->addColumn(new ColumnVarchar('name', 255));
- $table->addConstraint(new ConstraintPrimaryKey('id'));
- use ZendDbSqlSql;
- // your code
- $sql = new Sql($DB);
- $DB->query(
- $sql->getSqlStringForSqlObject($table),
- $DB::QUERY_MODE_EXECUTE
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement