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
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.