About PHP's judgment statement
$pubdate = $dsql->getone ("Select pubdate from article where writer = '". $writer. "' ORDER BY id DESC limit 1");
if (Time ()-$pubdate [' pubdate ']) < (3600*24)) {
ShowMsg ("Sorry, a member can only send an article every day!") ","-1 "," 0 ", 5000);
Exit
}
The above judge a member in a day can only submit a document, want to change to can submit 3 articles, how should do?
Share to:
------Solution--------------------
Change the original code to
$n = 1; Number of posts you have specified
$pubdate = $dsql->getone ("SELECT count (*) as CNT from article where From_unixtime (pubdate, '%y%m%d ') =date_format (now ( ), '%y%m%d ') and writer = ' ". $writer." ' ORDER BY id DESC limit 1 ");
if ($pubdate [' pubdate '] > $n) {
ShowMsg ("Sorry, a member can only send $n articles every day!") ","-1 "," 0 ", 5000);
Exit
}