PHP strcount 예제들

예제 #1

파일: calendar.php 프로젝트: tech-nik89/lpm4

function calendar($s)
{
    global $db;
    global $lang;
    global $login;
    global $rights;
    $return = array();
    $tbl = MYSQL_TABLE_PREFIX . 'calendar';
    $isallowed = $rights->isAllowed('calendar', 'manage');
    if ($isallowed) {
        $result = $db->selectList($tbl, "*", "INSTR(`title`, '" . $s . "') > 0 OR\r\n\t\t\t\t\t\t\t\t\t\t\t\tINSTR(`description`, '" . $s . "') > 0");
    } else {
        if ($login->currentUser() === false) {
            $result = $db->selectList($tbl, "*", "(INSTR(`title`, '" . $s . "') > 0 OR\r\n\t\t\t\t\t\t\t\t\t\t\t\tINSTR(`description`, '" . $s . "') > 0 )\r\n\t\t\t\t\tAND ( (`visible`=2)  OR  (`visible`=0 AND `userid`=" . $login->currentUserID() . ") )");
        } else {
            $result = $db->selectList($tbl, "*", "(INSTR(`title`, '" . $s . "') > 0 OR\r\n\t\t\t\t\t\t\t\t\t\t\t\tINSTR(`description`, '" . $s . "') > 0 ) \r\n\t\t\t\t\tAND ( (`visible`=2)  OR  (`visible`=0 AND `userid`=" . $login->currentUserID() . ") OR (`visible`=1) )");
        }
    }
    if (count($result) > 0) {
        foreach ($result as $i => $r) {
            $engine = $lang->get('engines_calendar');
            $title = $r['title'];
            $description = $r['description'];
            $url = makeURL('calendar', array('mode' => 'view', 'calendarid' => $r['calendarid'], 'day' => $r['start']));
            $relevance = strcount($r['description'], $s);
            $return[] = array('engine' => $engine, 'title' => $title, 'description' => $description, 'url' => $url, 'relevance' => $relevance);
        }
    }
    return $return;
}

예제 #2

파일: content.php 프로젝트: tech-nik89/lpm4

function content($s)
{
    global $db, $lang;
    $tbl = MYSQL_TABLE_PREFIX . 'content';
    $return = array();
    $result = $db->queryToList("select c.key, c.title, c.text, c.box_content\r\n\t\t\tfrom (\r\n\t\t\tselect `key`, max(version) as latest\r\n\t\t\tfrom " . $tbl . "\r\n\t\t\tgroup by `key`\r\n\t\t\t)\r\n\t\t\tas x\r\n\t\t\tinner join " . $tbl . " as c\r\n\t\t\ton c.key = x.key and c.version = x.latest\r\n\t\t\twhere title like '%" . $s . "%'\r\n\t\t\tor text like '%" . $s . "%'\r\n\t\t\tor box_content like '%" . $s . "%'");
    if (count($result) > 0) {
        foreach ($result as $i => $r) {
            $engine = $lang->get('engines_content');
            $title = cutString($r['title']);
            $description = $r['text'];
            $url = makeURL($r['key']);
            $relevance = strcount($r['text'] . ' ' . $r['title'] . ' ' . $r['title'] . ' ' . $r['title'], $s);
            $return[] = array('engine' => $engine, 'title' => $title, 'description' => $description, 'url' => $url, 'relevance' => $relevance);
        }
    }
    return $return;
}

예제 #3

파일: article.php 프로젝트: tech-nik89/lpm4

function article($s)
{
    global $db, $lang;
    $tbl = MYSQL_TABLE_PREFIX . 'article';
    $return = array();
    $result = $db->selectList($tbl, "*", "INSTR(`title`, '" . $s . "') > 0 OR\r\n\t\t\t\t\t\t\t\t\t\t\t\tINSTR(`text`, '" . $s . "') > 0");
    if (count($result) > 0) {
        foreach ($result as $i => $r) {
            $engine = $lang->get('engines_article');
            $title = $r['title'];
            $description = $r['preview'];
            $url = makeURL('article', array('articleid' => $r['articleid']));
            $relevance = strcount($r['text'] . $r['title'], $s);
            $return[] = array('engine' => $engine, 'title' => $title, 'description' => $description, 'url' => $url, 'relevance' => $relevance);
        }
    }
    return $return;
}

예제 #4

파일: shoutbox.php 프로젝트: tech-nik89/lpm4

function shoutbox($s)
{
    global $db, $lang;
    $tbl = MYSQL_TABLE_PREFIX . 'shoutbox';
    $return = array();
    $result = $db->selectList($tbl, "*", "INSTR(`text`, '" . $s . "') > 0");
    if (count($result) > 0) {
        foreach ($result as $i => $r) {
            $engine = $lang->get('engines_shoutbox');
            $title = $s;
            $description = $r['text'];
            $url = makeURL('shoutbox');
            $relevance = strcount($r['text'], $s);
            $return[] = array('engine' => $engine, 'title' => $title, 'description' => $description, 'url' => $url, 'relevance' => $relevance);
        }
    }
    return $return;
}

예제 #5

파일: users.php 프로젝트: tech-nik89/lpm4

function users($s)
{
    global $db, $lang;
    $tbl = MYSQL_TABLE_PREFIX . 'users';
    $return = array();
    $result = $db->selectList($tbl, "*", "INSTR(`nickname`, '" . $s . "') > 0 OR\r\n\t\t\t\t\t\t\t\t\t\t\t\tINSTR(`prename`, '" . $s . "') > 0");
    if (count($result) > 0) {
        foreach ($result as $i => $r) {
            $engine = $lang->get('engines_user');
            $title = $r['nickname'];
            $description = $r['prename'] . " '" . $r['nickname'] . "' " . stripLastName($r['lastname']);
            $url = makeURL('profile', array('userid' => $r['userid']));
            $relevance = strcount($r['prename'] . $r['nickname'], $s);
            $return[] = array('engine' => $engine, 'title' => $title, 'description' => $description, 'url' => $url, 'relevance' => $relevance);
        }
    }
    return $return;
}

예제 #6

파일: media.php 프로젝트: tech-nik89/lpm4

function media($s)
{
    global $db, $lang;
    $tbl_cat = MYSQL_TABLE_PREFIX . 'media_categories';
    $tbl_downloads = MYSQL_TABLE_PREFIX . 'media_downloads';
    $tbl_images = MYSQL_TABLE_PREFIX . 'media_images';
    $tbl_movies = MYSQL_TABLE_PREFIX . 'media_movies';
    $return = array();
    $result = $db->selectList($tbl_cat, "*", "INSTR(`name`, '" . $s . "') > 0");
    if (count($result) > 0) {
        foreach ($result as $i => $r) {
            $engine = $lang->get('category');
            $title = $r['name'];
            $description = '';
            $url = makeURL('media', array('categoryid' => $r['categoryid']));
            $relevance = strcount($r['name'], $s);
            $return[] = array('engine' => $engine, 'title' => $title, 'description' => $description, 'url' => $url, 'relevance' => $relevance);
        }
    }
    $result = $db->selectList($tbl_downloads, "*", "INSTR(`name`, '" . $s . "') > 0 OR INSTR(`description`, '" . $s . "') > 0");
    if (count($result) > 0) {
        foreach ($result as $i => $r) {
            $engine = $lang->get('download');
            $title = $r['name'];
            $description = $r['description'];
            $url = makeURL('media', array('categoryid' => $r['categoryid'], 'downloadid' => $r['downloadid']));
            $relevance = strcount($r['name'] . $r['description'], $s);
            $return[] = array('engine' => $engine, 'title' => $title, 'description' => $description, 'url' => $url, 'relevance' => $relevance);
        }
    }
    $result = $db->selectList($tbl_movies, "*", "INSTR(`name`, '" . $s . "') > 0 OR INSTR(`description`, '" . $s . "') > 0");
    if (count($result) > 0) {
        foreach ($result as $i => $r) {
            $engine = $lang->get('movie');
            $title = $r['name'];
            $description = $r['description'];
            $url = makeURL('media', array('categoryid' => $r['categoryid'], 'movieid' => $r['movieid']));
            $relevance = strcount($r['name'] . $r['description'], $s);
            $return[] = array('engine' => $engine, 'title' => $title, 'description' => $description, 'url' => $url, 'relevance' => $relevance);
        }
    }
    return $return;
}

예제 #7

파일: inbox.php 프로젝트: tech-nik89/lpm4

function inbox($s)
{
    global $db;
    global $lang;
    global $login;
    $return = array();
    $tbl = MYSQL_TABLE_PREFIX . 'inbox';
    $result = $db->selectList($tbl, "*", "(INSTR(`subject`, '" . $s . "') > 0 OR\r\n\t\t\t\t\t\t\t\t\t\t\t\tINSTR(`message`, '" . $s . "') > 0) AND\r\n\t\t\t\t\t\t\t\t  \t\t\t\t`recieverid`=" . $login->currentUserID());
    if (count($result) > 0) {
        foreach ($result as $i => $r) {
            $engine = $lang->get('engines_inbox');
            $title = $r['subject'];
            $description = $r['message'];
            $url = makeURL('pmbox', array('mode' => 'inbox', 'pmid' => $r['pmid']));
            $relevance = strcount($r['message'] . $r['subject'], $s);
            @($return[] = array('engine' => $engine, 'title' => $title, 'description' => $description, 'url' => $url, 'relevance' => $relevance));
        }
    }
    return $return;
}

예제 #8

파일: board.php 프로젝트: tech-nik89/lpm4

function board($s)
{
    global $db, $lang;
    $return = array();
    $tbl = MYSQL_TABLE_PREFIX . 'post';
    $tbl_thread = MYSQL_TABLE_PREFIX . 'thread';
    $result = $db->selectList($tbl, "*", "INSTR(`post`, '" . $s . "') > 0");
    if (count($result) > 0) {
        foreach ($result as $i => $r) {
            $thread = $db->selectOneRow($tbl_thread, "*", "`threadid`=" . $r['threadid']);
            $engine = $lang->get('thread');
            $title = $thread['thread'];
            $description = $r['post'];
            $url = makeURL('board', array('boardid' => $thread['boardid'], 'threadid' => $r['threadid']));
            $relevance = strcount($r['post'], $s);
            $return[] = array('engine' => $engine, 'title' => $title, 'description' => $description, 'url' => $url, 'relevance' => $relevance);
        }
    }
    return $return;
}

예제 #9

파일: bug.php 프로젝트: tech-nik89/lpm4

function bug($s)
{
    global $db;
    global $lang;
    global $login;
    $tbl = MYSQL_TABLE_PREFIX . 'bugtracker_issues';
    $return = array();
    $result = $db->selectList($tbl, "*", "(INSTR(`summary`, '" . $s . "') > 0 OR\r\n\t\t\t\t\t\t\t\t\t\t\t\tINSTR(`description`, '" . $s . "') > 0)");
    if (count($result) > 0) {
        foreach ($result as $i => $r) {
            $engine = $lang->get('engines_bug');
            $title = $r['summary'];
            $description = $r['description'];
            $url = makeURL('bug', array('issueid' => $r['issueid']));
            $relevance = strcount($r['summary'] . $r['description'], $s);
            @($return[] = array('engine' => $engine, 'title' => $title, 'description' => $description, 'url' => $url, 'relevance' => $relevance));
        }
    }
    return $return;
}