PHP PSU::searchPhonebookの例

コード例 #1

ファイル: functions.php プロジェクト: AholibamaSI/plymouth-webapp

function phonebookSearch($search_string, $search_type = 'all')
{
    if ($search_type == 'all') {
        $input = array('search_phrase' => $search_string, 'everybody' => true, 'count' => 100);
        return PSU::searchPhonebook($input);
    } else {
        $search_string = substr($GLOBALS['PHONEBOOK']->qstr($search_string), 1, strlen($search_string));
        if ($search_type == 'phone') {
            $where = "(REPLACE(REPLACE(REPLACE(REPLACE(phone_of,' ',''),'-',''),')',''),'(','') like '%" . $search_string . "%' OR REPLACE(REPLACE(REPLACE(REPLACE(phone_vm,' ',''),'-',''),')',''),'(','') like '%" . $search_string . "%')";
        } else {
            $where = $search_type . " like '" . $search_string . "%'";
        }
        //end else
        $sql = "SELECT * FROM phonebook WHERE {$where} ORDER BY name_last, name_first, email LIMIT 500";
        return $GLOBALS['PHONEBOOK']->GetAll($sql);
    }
    //end else
}