Welcome Guest, Not a member yet? Register   Sign In
Automatically Creating Database Tables
#7

[eluser]WanWizard[/eluser]
[quote author="Jonah11" date="1292974401"]Thanks for the info. So what is the preferred method of creating tables for a MySQL database with code igniter? Do you just use phpMyAdmin?[/quote]
I used to use dbforge, but due to the fact that it has to support a lot of database engine's, you can only use it for generic table definitions.

So now I don't bother anymore, and include .sql files with my projects for the different database I'd like to support, and a generic one which will probably work on most databases. Then I just load it using file I/O calls, and feed the commands to $this->db->query().
I do upgrades the same way (with .sql files containing 'diffs').

And I use Datamapper ORM to access my databases.


Messages In This Thread
Automatically Creating Database Tables - by El Forum - 12-21-2010, 10:36 AM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 11:24 AM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 11:32 AM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 11:33 AM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 11:36 AM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 03:23 PM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 03:43 PM
Automatically Creating Database Tables - by El Forum - 12-21-2010, 04:00 PM
Automatically Creating Database Tables - by El Forum - 05-24-2013, 03:36 AM
Automatically Creating Database Tables - by El Forum - 05-24-2013, 05:04 AM



Theme © iAndrew 2016 - Forum software by © MyBB