Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Database Connectivity

Go to End

4 Posts   1559 Views


Community Member, 1 Post

15 June 2009 at 5:37pm

Hi. I'm new to CMSs and am choosing one to work with. If you have a good answer to the following question, I'm yours.
Lets say I have a large product database. I want to either:
- load the database into SilverStripe, so I can display it, or
- let SilverStripe read the database, displaying fields on a page, or
- access the source code of a page, so I can insert my own php commands to access the database.
Is any of this possible? If so, how?
Really basic question I would have thought, but I can't find anything about it.



Forum Moderator, 5523 Posts

15 June 2009 at 6:12pm

If you want to interact with the Database you can use the ORM layer - eg to get all the products you can do DataObject::get('Product') which will return a set of Product elements. If you want to bypass that (and sometimes its faster) you can use SQLQuery -


Community Member, 1 Post

19 September 2009 at 5:44am

What if I have all of the info I need in the database, but do not know how to CREATE the database? e.g. I am contemplating Silverstripe for my company's CMS and website, and need to create pricing tables for our products. I would like for these tables to be database driven, for ease of updating. Suggestions?

Many thanks,


Community Member, 283 Posts

19 September 2009 at 7:50am

@wundabred That is pretty trivial with SS. Once you create your custom DataObject representing your products and build the tables will be created. Next step is to load your data ( pause here... many ways to do this).

The data is easily maintained with the ModelAdmin, which provides full CRUD operations for your tables in a pleasant GUI. It only takes a few lines of code to use it: