Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Richard Thomas' Blog:
Solar Framework Shorts - Table creation
Sep 18, 2009 @ 16:49:29

On his PHPJack blog Richard Thomas has posted a quick entry (with a handy code snippet) using the auto-create functionality the Solar framework includes.

One of the nice things about the Solar Framework is the ability to define table layout within the models.. Its not something you have to do but when you do Solar will auto create the table if it does not exist. [...] Auto create however has 2 issues.. 1. Pre populating data, 2. Table settings outside of Solar's realm (like temp tables). This however is really easy to solve by extending Solar.

His code sets up a custom model that loads in a SQL file and executes it into the database you've set up. Each line is split and looped through to ensure that those databases without multiple query support will still cooperate.

tagged: table create solar framework

Link:


Trending Topics: