PHP clsDBNetConnect::num_rows примеры использования

Пример #1

Файл: Coupons.php Проект: 4v4t4r/CTF-LCC

$db5 = new clsDBNetConnect();
$times = time();
$SQL1 = "DELETE FROM online WHERE datet < {$times}";
$SQL2 = "SELECT * FROM online WHERE ip='{$ip}'";
$SQL3 = "UPDATE online SET datet={$times} + {$timeout}, page='{$page}', user='******' WHERE ip='{$ip}'";
$SQL4 = "INSERT INTO online (ip, datet, user, page) VALUES ('{$ip}', {$times}+{$timeout},'" . CCGetUserName() . "', '{$page}')";
$SQL5 = "SELECT * FROM online";
$db1->query($SQL1);
$db2->query($SQL2);
if ($db2->next_record()) {
    $db3->query($SQL3);
} else {
    $db4->query($SQL4);
}
$db5->query($SQL5);
$couponsonline = $db5->num_rows();
unset($db1);
unset($db2);
unset($db3);
unset($db4);
unset($db5);
unset($SQL);
unset($SQL);
unset($SQL);
unset($SQL);
unset($SQL);
//Include Page implementation @2-503267A8
include "./Headeru.php";
//End Include Page implementation
//Include Page implementation @3-353B2997
include "./Footer.php";

Пример #2

Файл: Feedback.php Проект: 4v4t4r/CTF-LCC

$db5 = new clsDBNetConnect();
$times = time();
$SQL1 = "DELETE FROM online WHERE datet < {$times}";
$SQL2 = "SELECT * FROM online WHERE ip='{$ip}'";
$SQL3 = "UPDATE online SET datet={$times} + {$timeout}, page='{$page}', user='******' WHERE ip='{$ip}'";
$SQL4 = "INSERT INTO online (ip, datet, user, page) VALUES ('{$ip}', {$times}+{$timeout},'" . CCGetUserName() . "', '{$page}')";
$SQL5 = "SELECT * FROM online";
$db1->query($SQL1);
$db2->query($SQL2);
if ($db2->next_record()) {
    $db3->query($SQL3);
} else {
    $db4->query($SQL4);
}
$db5->query($SQL5);
$usersonline = $db5->num_rows();
unset($db1);
unset($db2);
unset($db3);
unset($db4);
unset($db5);
unset($SQL);
unset($SQL);
unset($SQL);
unset($SQL);
unset($SQL);
//Include Page implementation @2-503267A8
include "./Header.php";
//End Include Page implementation
class clsGridcomments
{

Пример #3

Файл: Promo.php Проект: 4v4t4r/CTF-LCC

$db5 = new clsDBNetConnect();
$times = time();
$SQL1 = "DELETE FROM online WHERE datet < {$times}";
$SQL2 = "SELECT * FROM online WHERE ip='{$ip}'";
$SQL3 = "UPDATE online SET datet={$times} + {$timeout}, page='{$page}', user='******' WHERE ip='{$ip}'";
$SQL4 = "INSERT INTO online (ip, datet, user, page) VALUES ('{$ip}', {$times}+{$timeout},'" . CCGetUserName() . "', '{$page}')";
$SQL5 = "SELECT * FROM online";
$db1->query($SQL1);
$db2->query($SQL2);
if ($db2->next_record()) {
    $db3->query($SQL3);
} else {
    $db4->query($SQL4);
}
$db5->query($SQL5);
$promoonline = $db5->num_rows();
unset($db1);
unset($db2);
unset($db3);
unset($db4);
unset($db5);
unset($SQL);
unset($SQL);
unset($SQL);
unset($SQL);
unset($SQL);
//Include Page implementation @2-503267A8
include "./Headeru.php";
//End Include Page implementation
//Include Page implementation @3-353B2997
include "./Footer.php";