leftJoin('user_profile','user_profile.user_id','=','user_reg.id')
->where('gender','!=', $gender )
->where('deactivate_status','=','0')
->where('username','LIKE', $searchword.'%' )->get();
//var_dump($sql_res);
if(count($sql_res)>0)
{
foreach($sql_res as $auto)
{
$id=$auto->user_id;
$username=$auto->username;
$path= $auto->path;
$country=$auto->email;
$encrypted_id = base64_encode($id);
?>
>
); ?> )
username; ?>
email; ?>