DAL Methods
1. Add()
Insert a record.
DAL
$tbl->Value["event"] = "First event";
$tbl->Add();Database API
$data["event"] = "First event";
DB::Insert("EventsTable", $data);2. Update()
Updates records.
DAL
$tbl->Param["ID"] = 32;
$tbl->Value["FirstName"] = "Jim";
$tbl->Update();Database API
$data["FirstName"] = "Jim";
$where["ID"] = 32;
DB::Update("UsersTable", $data, $where);3. Delete()
Deletes records.
DAL
$tbl->Param["ID"] = 32;
$tbl->Delete();Database API
$where["ID"] = 32;`
DB::Delete("UsersTable", $where);4. Query()
Select records with ordering.
DAL
$rs = $tbl->Query("ID=10", "Name");
Database API
$rs = DB::Query("SELECT * FROM EventsTable WHERE ID=10 ORDER BY Name");
5. QueryAll()
Select all records.
DAL
$rs = $tbl->QueryAll();
Database API
$rs = DB::Query("SELECT * FROM EventsTable");
6. FetchByID()
Select records matching Param values.
DAL
$tbl->Param["ID"] = 32;
$rs = $tbl->FetchByID();Database API
$rs = DB::Select("UsersTable", array("ID"=>32));
7. CustomQuery()
Run arbitrary SQL.
DAL
$rs = CustomQuery("select * from users");
Database API
$rs = DB::Query("select * from users");
8. DBLookup()
Returns first value of first row.
DAL
$value = DBLookup("select zip from users where userid=25");
Database API
$value = DB::Query("select zip from users where userid=25")->value();
9. TableName()
Returns formatted table name.
DAL
$sql = "select * from " . $tbl->TableName();
Database API
Usually unnecessary.
If needed:
$sql = DB::PrepareSQL("select * from EventsTable");
10. UsersTableName()
Returns login table name.
DAL
$sql = "select * from " . UsersTableName();
Modern approach
Use Security API.
Example:
$table = Security::getUserTable();
