db_fetch_objects PHP Code Examples

Example #1

0

Show file

File: news.php Project: NazarK/timedesk

function page_news_list()
{
    page_header("{~НОВОСТИ}");
    $news = db_fetch_objects(db_query("SELECT * FROM news ORDER BY weight DESC"));
    $o = "";
    foreach ($news as $r) {
        obj_trans($r);
        $GLOBALS['news'] = $r;
        $o .= template("news_list");
    }
    return $o;
}

Example #2

0

Show file

File: search.php Project: NazarK/sqp

function page_search($search = "")
{
    mb_internal_encoding("UTF-8");
    $s = $search;
    if (!$s) {
        $s = form_post("s");
    }
    $o = "";
    if ($s) {
        $rr = db_fetch_objects(db_query("SELECT * FROM pages WHERE content_search like '%%%s%%' LIMIT 10", $s));
        if (count($rr) == 0) {
            $o .= "Под запрос <strong>{$s}</strong> не подходит ни одна страница.";
        } else {
            foreach ($rr as $r) {
                $r->content = fld_trans(strip_for_search($r->content));
                $r->content_search = fld_trans($r->content_search);
                $p = 0;
                if (mb_strpos($r->content_search, mb_strtolower($s)) !== FALSE) {
                    $p = mb_strpos($r->content_search, mb_strtolower($s), 0);
                    $r->content = mb_substr($r->content, 0, $p) . "<strong>" . mb_substr($r->content, $p, mb_strlen($s)) . "</strong>" . mb_substr($r->content, $p + mb_strlen($s), mb_strlen($r->content));
                }
                $start = $p - 200;
                if ($start < 0) {
                    $start = 0;
                }
                $r->span = mb_substr($r->content, $start, 400);
                $r->url = translit(fld_trans($r->short, "ru"));
                $r->short = fld_trans($r->short);
                $GLOBALS['r'] = $r;
                $o .= template("search");
            }
        }
    }
    $o .= "<div style='padding-top:20px'><a href=search/google&s=" . urlencode($s) . ">Использовать google поиск по сайту</a></div>";
    return $o;
}

Example #3

0

Show file

File: menu.php Project: NazarK/timedesk

function menu_items($parent_id)
{
    $items = db_fetch_objects(db_query("SELECT * FROM menu WHERE parent_id=%d ORDER BY weight", $parent_id));
    return $items;
}

Example #4

0

Show file

File: bios.php Project: NazarK/sqp

function db_objects_get($table, $where_and_limit)
{
    return db_fetch_objects(db_query("SELECT * FROM {$table} WHERE {$where_and_limit}"));
}

Example #5

0

Show file

File: catalog.php Project: NazarK/sqp

function catalog_menu()
{
    $items = db_fetch_objects(db_query("SELECT id,title FROM catalog WHERE parent_id=0 ORDER BY weight"));
    $o = "";
    global $lang_dir;
    foreach ($items as $item) {
        $url = to_url(fld_trans($item->title, "eng"));
        $item->title = fld_trans($item->title);
        $o .= "<div class='menuItemDiv level1'><div class=title><a href={$lang_dir}catalog/{$url}>{$item->title}</a></div>";
        $sub_items = db_fetch_objects(db_query("SELECT id,title FROM catalog WHERE parent_id={$item->id} ORDER BY weight"));
        $o .= "<div class=subMenu>";
        foreach ($sub_items as $sub) {
            $sub_url = to_url(fld_trans($sub->title, "eng"));
            $sub->title = fld_trans($sub->title);
            $o .= "<div class='menuItemDiv level2'><div class=title><a href={$lang_dir}catalog/{$url}/{$sub_url}>{$sub->title}</a></div></div>";
        }
        $o .= "</div>";
        $o .= "</div>";
    }
    return $o;
}

Example #6

0

Show file

File: app.php Project: NazarK/timedesk

function page_report($daysago = 0)
{
    $midnight = @mktime(0, 0, 0, date('n'), @date('j') - $daysago);
    $rr = db_fetch_objects(db_query("SELECT * FROM log WHERE time_time>{$midnight}"));
    table_start(6);
    $state = 0;
    $total = 0;
    foreach ($rr as $r) {
        $next = db_result(db_query("SELECT time_time FROM log WHERE id>{$r->id} ORDER BY id LIMIT 1"));
        if (!$next) {
            $next = time();
        }
        $span = round(($next - $r->time_time) / (60 * 60), 2);
        if ($r->active_check) {
            table_add("<input class=active_check type=checkbox>");
        } else {
            table_add("");
        }
        table_add(@date("H:i:s", $r->time_time));
        table_add($r->memo);
        table_add($span, " class=span ");
        $mins = 60 * $span;
        table_add("hour ({$mins} min)");
        $h = $span * 200;
        if ($r->active_check) {
            $bg = "#0f0";
        } else {
            $bg = "#ddd";
        }
        table_add("<div style='height:{$h}px;background:{$bg};'>&nbsp;</div>");
        if ($r->active_check) {
            $total += $span;
        }
    }
    $o = table();
    $total_min = 60 * $total;
    $o .= "total: {$total} ({$total_min} min)<br>";
    $o .= "checked total: <span id=checked_total></span>";
    return $o;
}

Example #7

0

Show file

File: menu.php Project: NazarK/sqp

function menu_id_by_title_trans($title, $parent_id = -1)
{
    if ($parent_id == -1) {
        $menu = db_fetch_objects(db_query("SELECT id, title FROM menu"));
    } else {
        $menu = db_fetch_objects(db_query("SELECT id, title FROM menu WHERE parent_id=%d", $parent_id));
    }
    foreach ($menu as $m) {
        if (translit(fld_trans($m->title)) == $title) {
            $GLOBALS['menu__active'] = $m;
            $GLOBALS['menu__active_item__title_full'] = $m->title;
            return $m->id;
        }
    }
    return false;
}

Example #8

0

Show file

File: pages.php Project: NazarK/sqp

function page_id_by_title($title, $lang = "rus")
{
    $pages = db_fetch_objects(db_query("SELECT id,short FROM pages"));
    foreach ($pages as $page) {
        if (fld_trans($page->short, $lang) == $title) {
            return $page->id;
        }
    }
    return 0;
}

PHP db_fetch_objects Examples