Lets say you want to limit the number of records users can add to the certain table. For example, if you run a classified ads website, and you want free users to be able to post up to 3 ads, basic plan users to add up to 10 ads, etc.
Sample database structure
Table1: users, userid, password, limit.
Table2: ads, id, userid, adtext.
Tables are linked via the userid field. It would also make sense to turn on Advanced security mode 'Users can see all data; can edit their own data only'.
Use the following code in the Add page: Before Record Added event.
Scenario 1. All users can add the same number of records
$limit = 3;
$rs = DB::Query("select count(*) as c from ads where userid = " . $_SESSION["UserID"]);
$data = $rs->fetchAssoc();
$count = $data["c"];
if ($count>= $limit)
{
echo "Limit reached: $count records added already";
exit();
}
Scenario 2. Each user has it's own limit. Limits are stored in the userlimit field of users table
$rs = DB::Query("select count(*) as c from ads where userid = " . $_SESSION["UserID"]);
$data = $rs.fetchAssoc();
$count = $data["c"];
$rs2 = DB::Query("select ".AddFieldWrappers( "userlimit" )." from users where userid = " . $_SESSION["UserID"]);
$data2 = $rs2.fetchAssoc();
$limit = $data2["userlimit"];
if ($count>= $limit)
{
echo "Limit reached: $count records added already";
exit();
}
See also:
•QueryResult object fetchAssoc()
