Advertisement
Guest User

Untitled

a guest
Apr 16th, 2014
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. $DB = new ZendDbAdapterAdapter(array(
  2. 'driver' => 'Mysqli',
  3. 'database' => 'database',
  4. 'username' => 'user',
  5. 'password' => 'pass'
  6. ));
  7. use ZendDbSqlDdl;
  8. use ZendDbSqlDdlColumn;
  9. use ZendDbSqlDdlConstraint;
  10. $table = new DdlCreateTable('table');
  11. $table->setTable('table');
  12. $table->addColumn(new ColumnInteger('id',false,NULL,array('autoincrement'=>true)));
  13. $table->addColumn(new ColumnVarchar('name', 255));
  14. $table->addConstraint(new ConstraintPrimaryKey('id'));
  15.  
  16. use ZendDbSqlSql;
  17.  
  18. // your code
  19.  
  20. $sql = new Sql($DB);
  21.  
  22. $DB->query(
  23. $sql->getSqlStringForSqlObject($table),
  24. $DB::QUERY_MODE_EXECUTE
  25. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement