PHP SQL::numの例

if (strlen($forum_user['realname']) > 0) {
    echo stripslashes(rtrim($forum_user['realname']));
} else {
    echo stripslashes(rtrim($forum_user['username']));
}
echo '</strong></a>';
echo '<br/><span style="font-size:11px;">Last Visit: ' . date('d/m/Y g:i A', $forum_user['last_visit']) . '</span>';
echo '<br/><a href="../forum/profile.php?section=identity&id=' . $forum_user['id'] . '" style="font-size:11px;">Edit Profile</a>';
echo '</div>';
echo '</div>';
$db = new SQL(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME, false);
$user_id = $forum_user['id'];
$query1 = $db->query("SELECT id FROM ip_shouts WHERE user_id='{$user_id}'");
$query2 = $db->query("SELECT id FROM ip_updates WHERE user_id='{$user_id}'");
$query3 = $db->query("SELECT id FROM ip_requests WHERE user_id='{$user_id}'");
$total1 = $db->num($query1);
$total2 = $db->num($query2);
$total3 = $db->num($query3);
echo '<div class="user-topleft-nav">';
echo '<ul class="nav nav-list">';
echo '<li><a href="profile.php?id=' . $forum_user['id'] . '&sp=shouts" style="color:#333"><i class="icon-comments-alt muted"></i> My Messages <span class="badge pull-right" style="margin-top:1px;">' . $total1 . '</span></a></li>';
echo '<li><a href="profile.php?id=' . $forum_user['id'] . '&sp=updates" style="color:#333"><i class="icon-list-alt muted"></i> My Updates <span class="badge pull-right" style="margin-top:1px;">' . $total2 . '</span></a></li>';
echo '<li><a href="profile.php?id=' . $forum_user['id'] . '&sp=requests" style="color:#333"><i class="icon-list-alt muted"></i> My Requests <span class="badge pull-right" style="margin-top:1px;">' . $total3 . '</span></a></li>';
echo '</ul>';
?>
    </div>
    </div>
    
    <div class="left-menu">
    <ul class="nav nav-list">
      <li class="nav-header">Forum Quick Links</li>

コード例 #2

ファイルを表示

ファイル: index.php プロジェクト: heiswayi/ishareportal

<?php 
html_footer();
?>

<div id="ipStats" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
  <div class="modal-header">
    <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
    <h3 id="myModalLabel">IsharePortal Statistics</h3>
  </div>
  <div class="modal-body">
<div class="stat-data">
<?php 
require_once SITE_ROOT . 'portal_config.php';
require_once SITE_ROOT . 'include/database.class.php';
$db = new SQL(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME, false);
$t_users = $db->num($db->query("SELECT id FROM forum_users")) - 1;
$t_shouts = $db->num($db->query("SELECT id FROM ip_shouts"));
$t_updates = $db->num($db->query("SELECT id FROM ip_updates"));
$t_requests = $db->num($db->query("SELECT id FROM ip_requests"));
$t_reply = $db->num($db->query("SELECT id FROM ip_reply"));
$t_sharerlinks = $db->num($db->query("SELECT id FROM ip_sharerlinks"));
echo 'Total of registered users: <strong>' . $t_users . ' usernames</strong><br/>';
echo 'Total of current shouts: <strong>' . $t_shouts . ' messages</strong><br/>';
echo 'Total of <code>!update</code> shouts: <strong>' . $t_updates . ' messages</strong><br/>';
echo 'Total of <code>!request</code> shouts: <strong>' . $t_requests . ' messages</strong><br/>';
echo 'Total of replies: <strong>' . $t_reply . ' messages</strong><br/>';
echo 'Total of sharerlinks: <strong>' . $t_sharerlinks . ' links</strong><br/>';
$top5 = $db->query("SELECT user_id, COUNT(user_id) AS top5 FROM ip_shouts GROUP BY user_id ORDER BY top5 DESC LIMIT 5");
$rank = 1;
echo 'Top 5 Shouters:<br/>';
while ($row = $db->fetch_assoc($top5)) {

コード例 #3

ファイルを表示

ファイル: user_count.php プロジェクト: heiswayi/ishareportal

<?php

if (!defined('SITE_ROOT')) {
    define('SITE_ROOT', '../');
}
require_once SITE_ROOT . 'portal_config.php';
require_once SITE_ROOT . 'include/database.class.php';
$db = new SQL(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME, false);
$query = $db->query("SELECT id FROM forum_users");
$total_users = $db->num($query) - 1;
echo $total_users;
$db->close();

コード例 #4

ファイルを表示

ファイル: online_user_count.php プロジェクト: heiswayi/ishareportal

<?php

if (!defined('SITE_ROOT')) {
    define('SITE_ROOT', '../');
}
require_once SITE_ROOT . 'portal_config.php';
require_once SITE_ROOT . 'include/database.class.php';
$db = new SQL(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME, false);
$query = $db->query("SELECT user_id FROM forum_online");
echo $db->num($query);
$db->close();

コード例 #5

ファイルを表示

ファイル: shoutbox_count.php プロジェクト: heiswayi/ishareportal

<?php

if (!defined('SITE_ROOT')) {
    define('SITE_ROOT', '../');
}
require_once SITE_ROOT . 'portal_config.php';
require_once SITE_ROOT . 'include/database.class.php';
// Removing messages older than X days
$keep_period1 = time() - 86400 * KEEP_SHOUTS;
$keep_period2 = time() - 86400 * KEEP_REQUESTS;
$keep_period3 = time() - 86400 * KEEP_UPDATES;
$keepdb = new SQL(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME, false);
$keepq1 = $keepdb->query("SELECT id FROM ip_shouts WHERE shout_time < {$keep_period1}");
if ($keepdb->num($keepq1) > 0) {
    $keepdb->query("DELETE FROM ip_shouts WHERE shout_time < {$keep_period1}");
}
$keepq2 = $keepdb->query("SELECT id FROM ip_requests WHERE shout_time < {$keep_period2}");
if ($keepdb->num($keepq2) > 0) {
    $keepdb->query("DELETE FROM ip_requests WHERE shout_time < {$keep_period2}");
}
$keepq3 = $keepdb->query("SELECT id FROM ip_updates WHERE shout_time < {$keep_period3}");
if ($keepdb->num($keepq3) > 0) {
    $keepdb->query("DELETE FROM ip_updates WHERE shout_time < {$keep_period3}");
}
$keepdb->close();
// End of Removing messages older than X days
$db = new SQL(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME, false);
$db->query("SELECT COUNT(id) FROM ip_shouts");
echo implode($db->fetch_assoc());
$db->close();