示例#1
0
// +----------------------------------------------------------------------+
// | monitor.php, Copyright (c) 2004 Lawrence Osiris, All Rights Reserved |
// +----------------------------------------------------------------------+
// | This program is free software; you can redistribute it and/or modify |
// | it under the terms of the GNU General Public License as published by |
// | the Free Software Foundation; either version 2 of the License, or    |
// | (at your option) any later version. Read the full included license.  |
// +----------------------------------------------------------------------+
require_once 'config.DB_eSession.php';
require_once 'class.DB_eSession.php';
$sess_param['stop_on_warn'] = FALSE;
$sess_param['session_start'] = FALSE;
// Don't need to do
$sess = new DB_eSession($sess_param);
$db = $sess->getDBResource();
// Get DB resource link
// Example of using the DB resource link for your own query. Or you could add
// results from nbrActiveSess() and nbrInactiveSess() to get total rows in table
function totalRows()
{
    global $db, $sess;
    // Could use SELECT count(*)
    $_sql = 'SELECT ' . $sess->getLockName() . '  FROM ' . $sess->getTableName();
    $_result = @mysql_query($_sql, $db);
    if (!$_result) {
        echo 'totalRows() query error<br>';
        return 0;
    } else {
        return @mysql_num_rows($_result);
    }