Zend how do I create mysql table programmatically?

Question

I'm building a zend application.I was wondering if I can build mysql tables programmatically without using phpmyadmin.I would want to build them in the act of setting up my web application.If I'm not wrong you can do this in Symfony.

Thanks

Luca

what's your situation where you'd want to dynamically create mysql tables at runtime? — Casey Flynn
– Casey Flynn, Commented Jun 30, 2011 at 11:21
Let's say I'm setting up my application..I set my .ini file,my bootstrap and my models ecc. Ex I have built "Games" class extending Zend_Db_Table_Abstract.Now I would need to go over phpmyadmin and "manually" build "Games" table..How can I do this whitout using phpmyadmin? — luca
– luca, Commented Jun 30, 2011 at 11:37

Fatmuemoo · Accepted Answer · 2011-06-30 12:23:27Z

1

You should look into doctrine.

Lots of info on the web about integrating doctrine with zf. Check out [zend casts for some good tuts. G'luck

answered Jun 30, 2011 at 12:23

Fatmuemoo

2,2174 gold badges18 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tomáš Fejfar · Accepted Answer · 2011-07-01 07:56:12Z

1

Try

$dbAdapter->query('CREATE TABLE myTable ...');

That should work fine, I guess.

answered Jul 1, 2011 at 7:56

Tomáš Fejfar

11.2k8 gold badges58 silver badges85 bronze badges

Comments

Raoul · Accepted Answer · 2011-06-30 11:21:39Z

0

Why not put your schema creation SQL into a file and run it as part of the web app installation?

answered Jun 30, 2011 at 11:21

Raoul

3,9293 gold badges26 silver badges30 bronze badges

1 Comment

Raoul Over a year ago

Create a sql file, it should contain SQL table create statements for your tables, triggers, indices etc. I've never used PHPmyadmin but apparently it has a way to export all this for you... superuser.com/questions/168595/… Once you have this in a sql file, your application install script should call mysql with this file, it'll create the schema automatically. For more info on the last part see stackoverflow.com/questions/147821/…

Collectives™ on Stack Overflow

Zend how do I create mysql table programmatically?

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related