PHP format_rows Examples

Example #1

File: read.php Project: nbtscommunity/phpfnlib

    $q .= " LIMIT " . (JOURNAL_DISPLAYLIMIT + 1);
}
$r = mysql_query($q);
if ($nsidebars = JOURNAL_SIDEBARS) {
    $sidebars = mysql_fetch_all(mysql_query("SELECT * FROM sidebars \n\t\t\t\tWHERE username = '******' \n\t\t\t\tORDER BY timestamp DESC\n\t\t\t\tLIMIT {$nsidebars}"));
    print "<div class='sidebars'>";
    foreach ($sidebars as $sidebar) {
        extract($sidebar);
        print "<div class='sidebar'><h2\n\t\t\tclass='title'>{$title}</h2><div class='content'>" . wiki_render($data) . "</div></div>";
    }
    print "</div>";
}
if ($r) {
    $r = mysql_fetch_all($r);
    if (count($r) > 1) {
        print format_rows($r, JOURNAL_DISPLAYLIMIT);
    } else {
        print format_entry(array_shift($r));
    }
    if ($date and !$time) {
        $q = "SELECT date_format(date, '%Y-%m-%d') AS date \n\t\t\t\tFROM journal \n\t\t\t\tWHERE username = '******' \n\t\t\t\t\tAND date_format(date, '%Y-%m-%d') > '{$date}' \n\t\t\t\tORDER BY date LIMIT 1";
        $r = mysql_query($q);
        $row = mysql_fetch_assoc($r);
        $nextdate = $row['date'];
        $q = "SELECT date_format(date, '%Y-%m-%d') AS date \n\t\t\t\tFROM journal \n\t\t\t\tWHERE username = '******' \n\t\t\t\t\tAND date_format(date, '%Y-%m-%d') < '{$date}' \n\t\t\t\tORDER BY date DESC LIMIT 1";
        $r = mysql_query($q);
        $row = mysql_fetch_assoc($r);
        $prevdate = $row['date'];
    }
} else {
    print "No journal entries, sadly";

Example #2

File: friends.php Project: nbtscommunity/phpfnlib

if (defined("JOURNAL_FRIENDSENTRIES")) {
    $limit = JOURNAL_FRIENDSENTRIES;
} else {
    $limit = 25;
}
function get_cached_friends($username, $limit = 0)
{
    if (!$limit) {
        $limit = JOURNAL_FRIENDSENTRIES;
    }
    $r = mysql_fetch_all(mysql_query("SELECT * FROM cache \n\t\t\t\tINNER JOIN friends ON (friends.uri = cache.friend_uri)\n\t\t\t\tWHERE friends.username = '******' \n\t\t\t\tORDER BY cache.date DESC \n\t\t\t\tLIMIT {$limit}"));
    foreach ($r as $key => $row) {
        $r[$key]['data'] = $row['body'];
        if (ereg('opendiary.com', $r[$key]['friend_uri'])) {
            $r[$key]['friend'] .= '(OD)';
        } elseif (ereg('diaryland.com', $r[$key]['friend_uri'])) {
            $r[$key]['friend'] .= '(DL)';
        } elseif (ereg('livejournal.com', $r[$key]['friend_uri'])) {
            $r[$key]['friend'] .= '(LJ)';
        }
        unset($r[$key]['body']);
    }
    return $r;
}
$friendsentries = get_cached_friends(JOURNAL_USERNAME, $limit);
if (count($friendsentries) > 0 and is_array($friendsentries)) {
    print format_rows($friendsentries, $limit);
} else {
    print "No friend entries, sadly";
}