Interact with database

Permalink
Hi.

How can i interact with the Database?
The data, a user fills into the forms, is saved in the database.
Who can i use the data for functionality which is performed at another place and time?
I don't find a answer.

 
jgarcia replied on at Permalink Reply
jgarcia
Dashboard -> Reports

Is that what you are looking for?
mage replied on at Permalink Reply
thx fopr your anwer.
in don't think this can help me, but i'm not sure.
a simple Example:
If an user posts 2 numbers in a form, then both numbers are stored in th db.
Then there i have a button somewhere else on the page, which calculates the sum of the two numbers.
At this point the program has to read the numbers out of the db. How can i do this?
greets,
tom
DragonReeper replied on at Permalink Reply
DragonReeper
Here's an example how to fetch something from a database.
<?php
  $db=Loader::db();
  $r=$db->Execute("SELECT * FROM [table] WHERE [column]=[value]")
  $row=$r->FetchRow();
  echo $row[colomn name];


words enclosed in brackets"[]" are values you have to enter.

I take no credit, this is from a cheat sheet, anyway hope that's what you're looking for.