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've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Archive /

Our old forums are still available as a read-only archive.

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

Database querys and OOP


Go to End


3 Posts   1587 Views

Avatar
frankibodo

Community Member, 1 Post

6 December 2007 at 11:53pm

Hello

I have trouble getting my head around classes and so on. I want to have a page where I can query the database for a table (installed from outside SS). I have set up a ProductPage.php, ProductHolder.php, but I have no idea how to connect to the databse through SS, and how to actually query?????

Please help me!!

As of now I have this error and I have not even tryed to query anything..:(

Fatal error: Call to a member function XML_val() on a non-object in /tmp/silverstripe-cache-home-forbrsut-public_html-silverbullet/.cache.home.forbrsut.public_html.silverbullet.tutorial.templates.Layout.ProductHolder.ss on line 84

Avatar
OzziNL

Community Member, 37 Posts

7 December 2007 at 11:26pm

No ideas for this one? I do want something similar...

But I was looking in this forum before trying, so if I find out how...I'll post it.

Avatar
Fuzz10

Community Member, 791 Posts

8 December 2007 at 4:28am

In order to create stuff with SS , it's handy to have a basic grasp of Object Oriented design (inheritance and data encapsulation being the most important subjects).

Basically, you have to create "data-object" classes which map 1-1 on your database-tables (1 class for every table). You don't access the database directly through queries : the data-objects "encapsulate" the interaction with the DB (they take care of that themselves).

If you want to use an external data-source or a different table , you probably need to peruse the docs Data-Object classes in the docs.

Good luck !