Gecko [ midwest-tb.com ]

Name	Size	Permission
assets	[ DIR ]	drwxr-xr-x
functions	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
.htaccess	4.65 KB	-rw-r--r--
.mad-root	0 B	-rw-r--r--
01admin.zip	112.24 KB	-rw-r--r--
add_user.php	11.21 KB	-rw-r--r--
banner.php	1.41 KB	-rw-r--r--
db.php	30 B	-rw-r--r--
delete.php	357 B	-rw-r--r--
delete_banner.php	736 B	-rw-r--r--
delete_post.php	960 B	-rw-r--r--
delete_user.php	991 B	-rw-r--r--
edit_banner.php	3.38 KB	-rw-r--r--
edit_post.php	11.55 KB	-rw-r--r--
edit_post2.php	5.62 KB	-rw-r--r--
edit_user.php	13.09 KB	-rw-r--r--
editsettings.php	2.61 KB	-rw-r--r--
error_log	54.03 KB	-rw-r--r--
function_users.php	6.8 KB	-rw-r--r--
functions.php	10.92 KB	-rw-r--r--
home.php	6.62 KB	-rw-r--r--
index.php	56 B	-rw-r--r--
insert_banners.php	3.07 KB	-rw-r--r--
insert_post.php	9.63 KB	-rw-r--r--
login.php	1.57 KB	-rw-r--r--
login_admin.php	3.11 KB	-rw-r--r--
logout.php	164 B	-rw-r--r--
member.php	17.64 KB	-rw-r--r--
payment_setting.php	2.97 KB	-rw-r--r--
picupload.php	2.12 KB	-rw-r--r--
post.php	2.02 KB	-rw-r--r--
posts.php	2.94 KB	-rw-r--r--
print_shipment.php	1.91 KB	-rw-r--r--
register_admin.php	8.45 KB	-rw-r--r--
remove_amount.php	1.01 KB	-rw-r--r--
searchmembers.php	2.94 KB	-rw-r--r--
send_email.php	5.02 KB	-rw-r--r--
testimony.php	3.15 KB	-rw-r--r--
upload_files.php	2.59 KB	-rw-r--r--
user_error.php	188 B	-rw-r--r--
user_withdrawal.php	4.99 KB	-rw-r--r--
view_admin.php	2.84 KB	-rw-r--r--
view_banners.php	2.4 KB	-rw-r--r--
view_posts.php	2.85 KB	-rw-r--r--
view_referrals_bonus.php	2.83 KB	-rw-r--r--
view_users.php	4.78 KB	-rw-r--r--
viewconversation.php	5.37 KB	-rw-r--r--
viewmessage.php	2.4 KB	-rw-r--r--
viewmessages.php	4.24 KB	-rw-r--r--
website_setting.php	3.09 KB	-rw-r--r--

Code Editor : searchmembers.php

<?php include("includes/header.php");
include("includes/navbar.php");
?>

<?php

?>
<?php
/*
	Highlight Words in Search Results with PHP
	http://www.internoetics.com/2013/11/06/highlight-words-in-search-results-with-php/
*/	
function highlight($text, $words, $color='yellow', $case='1') { 
 $words = trim($words); 
 $wordsArray = explode(' ', $words);

foreach($wordsArray as $word) { 
  if(strlen(trim($word)) != 0) 
   if ($case) {
    $text = eregi_replace($word, '<font style="background:' . $color . '";>\\0</font>', $text);
     } else {
    $text = ereg_replace($word, '<font style="background:' . $color . '";>\\0</font>', $text); 
   }
  } 
 return $text; 
}

?>
<?php

if(isset($_GET['search'])){

$search_id = $_GET['value'];
//where the value is not "search" @sidebar form ok!!!!
?>
<html><head>
<title>Search results for <?php echo $search_id;?></title>
</head> <body>

<div id="main_content2">
<center><h3> Searching for "<?php echo '<font !style="background:yellow;">' .$search_id."</font>"  ?>"</h3></center><hr/>
<?php
if($search_id==""){
	echo "please type in a name to search!!";
}
else{

$offset= 0;
$page_result= 50;

if(isset($_GET['pageno'])){

$page_value = $_GET['pageno'];

if($page_value > 1){
						$offset= ($page_value - 1) * $page_result;
					}
				}

$sql="SELECT * FROM users where  fullname like '%$search_id%' OR username like '%$search_id%' OR phone_number like '%$search_id%'
OR email like '%$search_id%'  ORDER BY fullname  LIMIT $offset, $page_result ";

//$sql="SELECT * FROM posts where post_content like '%$search_id%' ";

$run=mysqli_query($con,$sql);
$numrows =mysqli_num_rows($run);

if($numrows==0){
	echo "Search result did not match with any student ";
}
	while($row= mysqli_fetch_array($run)){
	$id = $row['id'];
	$fullname = $row['fullname'];
	$regno = $row['regno'];
	$gender = $row['gender'];
	$photo = $row['photo'];
	$dept = $row['dept'];
	$level = $row['level'];
	$username = $row['username'];

//$text ="crystal john is goood crystal";

//$words ="crystal john";
	echo '<img src ="'.$link.'images2/small'.$photo.'" width="30" height="30" >';
	echo "<strong> ".$fullname."</strong><br/>";
	echo '<a href="'.$username.'"/>View user</a><br/>';
	echo '<a href="delete_user.php?user='.$username.'"/>DELETE user</a><br/><hr/>';

}

$sql="SELECT id FROM users where fullname like '%$search_id%' OR username like '%$search_id%' OR phone_number like '%$search_id%'
OR email like '%$search_id%'  ORDER BY fullname   ";

$run= mysqli_query($con,$sql);
$numrows=mysqli_num_rows($run);

$pagecount = $numrows; // Total number of rows
$num = $pagecount / $page_result ;

if($_GET['pageno'] < $num)
{
   echo "<a href = 'searchmembers.php?value=".$search_id."&search=Search&pageno=".($_GET['pageno'] + 1)." '> view more results </a>";
}

?>
</div>

</div>
</body>
<?php
include("includes/footer.php");

${this.title}

Code Editor : searchmembers.php