Forum Subject: searching users

Posted on: 05/24/06 08:57am
By: Anonymous (luke)

is there anyway to allow users to search users,

i'm trying to set up and artist network type thing and it would be good if users could type into search.... for example "college name" and find all the users on the site that go to that college.

please help have been stuck on this for awhile

thanks luke

searching users

Posted on: 05/24/06 03:44pm
By: Dirk

User data (from the user's profile) is currently not included in the search. It shouldn't be too hard to add that by either hacking the search class or implementing it as a plugin, though.

bye, Dirk

searching users

Posted on: 05/24/06 07:53pm
By: suprsidr

There is a function to do that already. I use it in a block[*1] , but you could call it wherever you want.

function phpblock_usernameSearch()
{
    global $_CONF, $_TABLES;
    if (!empty($_GET['username'])){
        $username = COM_applyfilter($_GET['username']);
        //query db for matches
        $result = DB_query("SELECT uid, username FROM {$_TABLES['users']} WHERE username LIKE '%$username%'");
        if (DB_numRows($result) >= 1){
            $list = '<p>Results:</p>';
            $list = '<ul>';
            while ($A = DB_fetchArray($result)){
                $list .= '<li><a href="' . $_CONF['site_url'] . '/users.php?mode=profile&uid=' . $A['uid'] . '">' . COM_stripslashes($A['username']) . '</a></li>';
            }
            $list .= '</ul>';
        $list .= '<p>Search Again?</p>';
        }
    }
    //display form
    $form = '<div id="username-search">';
    $form .= '<form action="' . $_PHPSELF . '" method="GET">';
    $form .= '<input type="text" size="12" name="username">';
    $form .= '<input type="submit" value="search">';
    $form .= '</form></div>';

    //return block
    return $list . LB . $form;
}

Hope this helps

-s