Connecting to the database from an application

iuxc

I'm trying to write an application for Garden and have run into a roadblock with the database.

The application works fine with basic HTML, but I need to connect to my database and display/manipulate the data.

I have this code in the application manage.php controller:
$DataSet = $Database->Select('Name')->From('GDN_User')->Get();

When I try to load the page myapp/manage, I'm getting this error:
Undefined variable: Database

Any help you can provide is greatly appreciated!

luc

As stated by the error, you need to create your Database object.

Database = Gdn::Database();
should do the trick.

garymardell

Also you don't prefix the table in FROM with GDN_ as that is already set in the database class.

luc

True, I didn't really read the full comment, just the error part.

S

Ho. Actually, you shouldn't use any data manipulation in application controller. Getting data from database (data manipulation in the general case) it is job for model.