PHP - Getting 'fatal Error: Uncaught Error: Class 'mysqli' Not Found In'

Hello everyone 
I am working on a simple php mysql project (TodoList with crud funtions with fields- head, content ,date and time ) and i am stuck on this error Fatal error: Uncaught Error: Call to a member function close() on bool Stack trace: #0 {main} 
How can i fix it 
Here is link from the project https://easyupload.io/gxxv1w
 

In PHP Version 8.0 shows error as :
PHP Fatal error:  Uncaught TypeError: Unsupported operand types: string * string 
String is as under :
$TAXVALUE= round($QNTY*($PRICE- ($PRICE*$DISC/100)),2);

In previous versions of PHP it does not show any error.

Please resolve the issue.

Folks,

I got this pagination without PREP STMT working ABSOLUTELY FINE:

	<?php 
//Required PHP Files. 
include 'header_account.php'; //Required on all webpages of the Account. 
?> 
	<?php 
if (!$conn) 
{ 
    $error = mysqli_connect_error(); 
    $errno = mysqli_connect_errno(); 
    print "$errno: $error\n"; 
    exit(); 
} 
	//Grab Username of who's Browsing History needs to be searched. 
if (isset($_GET['followee_username']) && !empty($_GET['followee_username'])) 
{ 
    $followee_username = $_GET['followee_username']; 
    
    if($followee_username != "followee_all" OR $followee_username != "Followee_All") 
    { 
        $query = "SELECT * FROM following_histories WHERE followee_username = \"$followee_username\""; 
        $query_type = "followee_username"; 
        $followed_word = "$followee_username"; 
        $followee_username = "$followee_username"; 
        echo "$followee_username";
    } 
    else 
    { 
        $query = "SELECT * FROM following_histories"; 
        $query_type = "followee_all"; 
        $followed_word = "followee_all"; 
        echo "all";
    } 
} 
	if (isset($_GET['followee_id']) && !empty($_GET['followee_id'])) 
{ 
    $followee_id = $_GET['followee_id']; 
    $query = "SELECT * FROM following_histories WHERE id = \"$followee_id\""; 
    $query_type = "followee_id"; 
    $followed_word = "$followee_id"; 
    echo "$followee_id";
} 
	if (isset($_GET['followee_date_and_time']) && !empty($_GET['followee_date_and_time'])) 
{ 
    $followee_date_and_time = $_GET['followee_date_and_time']; 
    $query = "SELECT * FROM following_histories WHERE date_and_time = \"$followee_date_and_time\""; 
    $query_type = "followee_date_and_time"; 
    $followed_word = "$followee_date_and_time"; 
} 
    
if (isset($_GET['followee_followed_page_converted']) && !empty($_GET['followee_followed_page_converted'])) 
{ 
    $followee_followed_page_converted = $_GET['followee_followed_page_converted']; 
    $query = "SELECT * FROM following_histories WHERE followed_page_converted = \"$followee_followed_page_converted\""; 
    $query_type = "followee_followed_page_converted"; 
    $followed_word = "$followee_followed_page_converted"; 
} 
    
if (isset($_GET['followee_referral_page_converted']) && !empty($_GET['followee_referral_page_converted'])) 
{ 
    $followee_referral_page_converted = $_GET['followee_referral_page_converted']; 
    $query = "SELECT * FROM following_histories WHERE referral_page_converted = \"$followee_referral_page_converted\""; 
    $query_type = "followee_referral_page_converted"; 
    $followed_word = "$followee_referral_page_converted";     
} 
    
if (isset($_GET['followee_gender']) && !empty($_GET['followee_gender'])) 
{ 
    $followee_gender = $_GET['followee_gender']; 
    $query = "SELECT * FROM following_histories WHERE gender = \"$followee_gender\""; 
    $query_type = "followee_gender"; 
    $followed_word = "$followee_gender";         
} 
    
if (isset($_GET['followee_age_range']) && !empty($_GET['followee_age_range'])) 
{ 
    $followee_age_range = $_GET['followee_age_range']; 
    $query = "SELECT * FROM following_histories WHERE age_range = \"$followee_age_range\""; 
    $query_type = "followee_age_range"; 
    $followed_word = "$followee_age_range"; 
} 
    
if (isset($_GET['followee_date_of_birth']) && !empty($_GET['followee_date_of_birth'])) 
{ 
    $followee_date_of_birth = $_GET['followee_date_of_birth']; 
    $query = "SELECT * FROM following_histories WHERE date_of_birth = \"$followee_date_of_birth\""; 
    $query_type = "followee_date_of_birth"; 
    $followed_word = "$followee_date_of_birth"; 
} 
    
if (isset($_GET['followee_skin_complexion']) && !empty($_GET['followee_skin_complexion'])) 
{ 
    $followee_skin_complexion = $_GET['followee_skin_complexion']; 
    $query = "SELECT * FROM following_histories WHERE skin_complexion = \"$followee_skin_complexion\""; 
    $query_type = "followee_skin_complexion"; 
    $followed_word = "$followee_skin_complexion";     
} 
    
if (isset($_GET['followee_height']) && !empty($_GET['followee_height'])) 
{ 
    $followee_height = $_GET['followee_height']; 
    $query = "SELECT * FROM following_histories WHERE height = \"$followee_height\""; 
    $query_type = "followee_height"; 
    $followed_word = "$followee_height"; 
} 
    
if (isset($_GET['followee_weight']) && !empty($_GET['followee_weight'])) 
{ 
    $followee_weight = $_GET['followee_weight']; 
    $query = "SELECT * FROM following_histories WHERE weight = \"$followee_weight\""; 
    $query_type = "followee_weight"; 
    $followed_word = "$followee_weight"; 
} 
    
if (isset($_GET['followee_sexual_orientation']) && !empty($_GET['followee_sexual_orientation'])) 
{ 
    $followee_sexual_orientation = $_GET['followee_sexual_orientation']; 
    $query = "SELECT * FROM following_histories WHERE sexual_orientation = \"$followee_sexual_orientation\""; 
    $query_type = "followee_sexual_orientation"; 
    $followed_word = "$followee_sexual_orientation"; 
} 
    
if (isset($_GET['followee_religion']) && !empty($_GET['followee_religion'])) 
{ 
    $followee_religion = $_GET['followee_religion']; 
    $query = "SELECT * FROM following_histories WHERE religion = \"$followee_religion\""; 
    $query_type = "followee_religion"; 
    $followed_word = "$followee_religion"; 
} 
    
if (isset($_GET['followee_education']) && !empty($_GET['followee_education'])) 
{ 
    $followee_education = $_GET['followee_education']; 
    $query = "SELECT * FROM following_histories WHERE education = \"$followee_education\""; 
    $query_type = "followee_education"; 
    $followed_word = "$followee_education"; 
} 
    
if (isset($_GET['followee_profession']) && !empty($_GET['followee_profession'])) 
{ 
    $followee_profession = $_GET['followee_profession']; 
    $query = "SELECT * FROM following_histories WHERE profession = \"$followee_profession\""; 
    $query_type = "followee_profession"; 
    $followed_word = "$followee_profession"; 
} 
    
if (isset($_GET['followee_marital_status']) && !empty($_GET['followee_marital_status'])) 
{ 
    $followee_marital_status = $_GET['followee_marital_status']; 
    $query = "SELECT * FROM following_histories WHERE marital_status = \"$followee_marital_status\""; 
    $query_type = "followee_marital_status"; 
    $followed_word = "$followee_marital_status"; 
} 
    
if (isset($_GET['followee_working_status']) && !empty($_GET['followee_working_status'])) 
{ 
    $followee_working_status = $_GET['followee_working_status']; 
    $query = "SELECT * FROM following_histories WHERE working_status = \"$followee_working_status\""; 
    $query_type = "followee_working_status"; 
    $followed_word = "$followee_working_status"; 
} 
    
if (isset($_GET['followee_country_of_birth']) && !empty($_GET['followee_country_of_birth'])) 
{ 
    $followee_country_of_birth = $_GET['followee_country_of_birth']; 
    $query = "SELECT * FROM following_histories WHERE country_of_birth = \"$followee_country_of_birth\""; 
    $query_type = "followee_country_of_birth"; 
    $followed_word = "$followee_country_of_birth"; 
} 
    
if (isset($_GET['followee_home_town']) && !empty($_GET['followee_home_town'])) 
{ 
    $followee_home_town = $_GET['followee_home_town']; 
    $query = "SELECT * FROM following_histories WHERE home_town = \"$followee_home_town\""; 
    $query_type = "followee_home_town"; 
    $followed_word = "$followee_home_town"; 
} 
    
if (isset($_GET['followee_home_neighbourhood']) && !empty($_GET['followee_home_neighbourhood'])) 
{ 
    $followee_home_neighbourhood = $_GET['followee_home_neighbourhood']; 
    $query = "SELECT * FROM following_histories WHERE home_neighbourhood = \"$followee_home_neighbourhood\""; 
    $query_type = "followee_home_neighbourhood"; 
    $followed_word = "$followee_home_neighbourhood"; 
} 
    
if (isset($_GET['followee_home_borough']) && !empty($_GET['followee_home_borough'])) 
{ 
    $followee_home_borough = $_GET['followee_home_borough']; 
    $query = "SELECT * FROM following_histories WHERE home_borough = \"$followee_home_borough\""; 
    $query_type = "followee_home_borough"; 
    $followed_word = "$followee_home_borough"; 
} 
    
if (isset($_GET['followee_home_city']) && !empty($_GET['followee_home_city'])) 
{ 
    $followee_home_city = $_GET['followee_home_city']; 
    $query = "SELECT * FROM following_histories WHERE home_city = \"$followee_home_city\""; 
    $query_type = "followee_home_city"; 
    $followed_word = "$followee_home_city"; 
} 
    
if (isset($_GET['followee_home_county']) && !empty($_GET['followee_home_county'])) 
{ 
    $followee_home_county = $_GET['followee_home_county']; 
    $query = "SELECT * FROM following_histories WHERE home_county = \"$followee_home_county\""; 
    $query_type = "followee_home_county"; 
    $followed_word = "$followee_home_county"; 
} 
    
if (isset($_GET['followee_home_district']) && !empty($_GET['followee_home_district'])) 
{ 
    $followee_home_district = $_GET['followee_home_district']; 
    $query = "SELECT * FROM following_histories WHERE home_district = \"$followee_home_district\""; 
    $query_type = "followee_home_district"; 
    $followed_word = "$followee_home_district"; 
} 
    
if (isset($_GET['followee_home_region']) && !empty($_GET['followee_home_region'])) 
{ 
    $followee_home_region = $_GET['followee_home_region']; 
    $query = "SELECT * FROM following_histories WHERE home_region = \"$followee_home_region\""; 
    $query_type = "followee_home_region"; 
    $followed_word = "$followee_home_region"; 
} 
    
if (isset($_GET['followee_home_state']) && !empty($_GET['followee_home_state'])) 
{ 
    $followee_home_state = $_GET['followee_home_state']; 
    $query = "SELECT * FROM following_histories WHERE home_state = \"$followee_home_state\""; 
    $query_type = "followee_home_state"; 
    $followed_word = "$followee_home_state"; 
} 
    
if (isset($_GET['followee_home_country']) && !empty($_GET['followee_home_country'])) 
{ 
    $followee_home_country = $_GET['followee_home_country']; 
    $query = "SELECT * FROM following_histories WHERE home_country = \"$followee_home_country\""; 
    $query_type = "followee_home_country"; 
    $followed_word = "$followee_home_country"; 
} 
	$referral_page_http = $_SERVER['HTTP_REFERRER']; 
$referral_page = "$referral_page_http"; 
$referral_page_original = "$referral_page"; 
	$query_string = $_SERVER['QUERY_STRING']; 
	$current_page_http = $_SERVER['PHP_SELF']; 
$current_page = "$current_page_http"; 
	$followed_page_original = "$current_page"; 
	$visiting_pages_count = "1"; 
if($visiting_pages_count == "") 
{ 
    $visiting_pages_count = "1"; 
} 
else 
{ 
    $visiting_pages_count++; 
} 
	if($visiting_pages_count == "1") 
{ 
    $current_page_converted = "$settings_user_first_quick_link.$current_page"; 
    $referral_page_converted = "$settings_user_first_quick_link.$referral_page";     
} 
elseif($visiting_pages_count == "2") 
{ 
    $current_page_converted = "$settings_admin_second_quick_link.$current_page"; 
    $referral_page_converted = "$settings_admin_second_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "3") 
{ 
    $current_page_converted = "$settings_user_third_quick_link.$current_page"; 
    $referral_page_converted = "$settings_user_third_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "4") 
{ 
    $current_page_converted = "$settings_admin_fourth_quick_link.$current_page"; 
    $referral_page_converted = "$settings_admin_fourth_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "5") 
{ 
    $current_page_converted = "$settings_user_fifth_quick_link.$current_page"; 
    $referral_page_converted = "$settings_user_fifth_quick_link.$referral_page"; 
} 
if($visiting_pages_count == "6") 
{ 
    $current_page_converted = "$settings_admin_first_quick_link.$current_page"; 
    $referral_page_converted = "$settings_admin_first_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "7") 
{ 
    $current_page_converted = "$settings_user_second_quick_link.$current_page"; 
    $referral_page_converted = "$settings_user_second_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "8") 
{ 
    $current_page_converted = "$settings_admin_third_quick_link.$current_page"; 
    $referral_page_converted = "$settings_admin_third_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "9") 
{ 
    $current_page_converted = "$settings_user_fourth_quick_link.$current_page"; 
    $referral_page_converted = "$settings_user_fourth_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "10") 
{ 
    $current_page_converted = "$settings_admin_fifth_quick_link.$current_page"; 
    $referral_page_converted = "$settings_admin_fifth_quick_link.$referral_page"; 
} 
else 
{ 
    $visiting_pages_count = "1"; 
    $current_page_converted = "$settings_user_first_quick_link.$current_page"; 
    $referral_page_converted = "$settings_user_first_quick_link.$referral_page"; 
} 
	$followed_page_converted = "$current_page_converted"; 
	$follower_username = $user; 
$follower_browser = $_SERVER['HTTP_USER_AGENT']; 
	//Insert the User's Click Logs into Mysql Database using Php's Sql Injection Prevention Method "Prepared Statements". 
$stmt = mysqli_prepare($conn,"INSERT INTO following_histories(query_type,followed_word,query_string,followed_page_original,followed_page_converted,referral_page_original,referral_page_converted,followee_username,follower_username,gender,age_range,date_of_birth,skin_complexion,height,weight,sexual_orientation,religion,education,profession,marital_status,working_status,home_town,home_neighbourhood,home_borough,home_council,home_city,home_county,home_district,home_region,home_state,home_country) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); 
mysqli_stmt_bind_param($stmt,'ssssssssssiisssssssssssssssssss',$query_type,$followed_word,$query_string,$followed_page_original,$followed_page_converted,$referral_page_original,$referral_page_converted,$followee_username,$follower_username,$gender,$age_range,$date_of_birth,$skin_complexion,$height,$weight,$sexual_orientation,$religion,$education,$profession,$marital_status,$working_status,$home_town,$home_neighbourhood,$home_borough,$home_council,$home_city,$home_county,$home_district,$home_region,$home_state,$home_country); 
mysqli_stmt_execute($stmt); 
            
//Check if User's Click Logs have been successfully submitted or not. 
if (!$stmt) 
{ 
    echo "Sorry! Our system is currently experiencing a problem logging your following! We will continuously try logging your clicks!"; 
    exit(); 
} 
else 
{ 
    mysqli_stmt_fetch($stmt); 
    mysqli_stmt_close($stmt);
} 
	$query_type_label = str_replace("_"," ","$query_type"); //Removing underscores so they don't show-up on the html. 
$query_type_label = ucwords("$query_type_label"); //Upper Casing the first characters. 
?> 
	<!DOCTYPE html> 
<html> 
<head> 
<meta content="text/html; charset=ISO-8859-1" http-equiv=" content-type"> 
<title><?php echo "Browsing History in $server_time Time.";?></title> 
<meta name="viewport" content="width=device-width, initial-scale=1"> 
</head> 
<body> 
<br> 
<p align="center"><span style="font-weight:bold;"><?php echo "Search Result for:<br> $query_type_label = \"${$query_type}\""; ?></span></p> 
<br> 
<br> 
<?php     
$result = mysqli_query($conn,$query); 
$rows_num = mysqli_num_rows($result); 
    
//Total Number of Pages records are spread-over. 
$page_count = 100; 
$page_size = ceil($rows_num / $page_count); 
//Get the Page Number. Default is 1 (First Page). 
$page_number = $_GET["page_number"]; 
if ($page_number == "") $page_number = 1; 
    $offset = ($page_number -1) * $page_size; 
        
    $query .= " limit {$offset},{$page_size}"; 
    $result = mysqli_query($conn,$query); 
?> 
<table width="1500" border="0" cellpadding="5" cellspacing="2" bgcolor="#666666"> 
<?php 
if($rows_num) 
{ 
    printf("<b> %d Result Found ...</b>\n",$rows_num); ?><br> 
    <br> 
    <tr name="headings"> 
    <td bgcolor="#FFFFFF" name="column-heading_submission-number">Submission Number</td> 
    <td bgcolor="#FFFFFF" name="column-heading_logging-server-date-and-time">Date & Time in <?php echo "$server_time";?></td> 
    <td bgcolor="#FFFFFF" name="column-heading_browsed-page-converted">Browsed Page Converted (Visit Page) </td> 
    <td bgcolor="#FFFFFF" name="column-heading_browsed-page-converted">Browsed Page Converted (Check Stats) </td> 
    <td bgcolor="#FFFFFF" name="column-heading_referral-page-converted">Referral Page Converted (Visit Page) </td> 
    <td bgcolor="#FFFFFF" name="column-heading_referral-page-converted">Referral Page Converted (Check Stats) </td> 
    <td bgcolor="#FFFFFF" name="column-heading_username">Followee Username (Visit Page)</td> 
    <td bgcolor="#FFFFFF" name="column-heading_username">Followee Username (Check Stats)</td> 
    <td bgcolor="#FFFFFF" name="column-heading_username">Follower Username (Visit Page)</td> 
    <td bgcolor="#FFFFFF" name="column-heading_username">Follower Username (Check Stats)</td> 
    <td bgcolor="#FFFFFF" name="column-heading_gender">Gender</td> 
    <td bgcolor="#FFFFFF" name="column-heading_age-range">Age Range</td> 
    <td bgcolor="#FFFFFF" name="column-heading_date-of-birth">Date Of Birth</td> 
    <td bgcolor="#FFFFFF" name="column-heading_skin-complexion">Skin Complexion</td> 
    <td bgcolor="#FFFFFF" name="column-heading_height">Height</td> 
    <td bgcolor="#FFFFFF" name="column-heading_weight">Weight</td> 
    <td bgcolor="#FFFFFF" name="column-heading_sexual-orientation">Sexual Orientation</td> 
    <td bgcolor="#FFFFFF" name="column-heading_religion">Religion</td> 
    <td bgcolor="#FFFFFF" name="column-heading_education">Education</td> 
    <td bgcolor="#FFFFFF" name="column-heading_profession">Profession</td> 
    <td bgcolor="#FFFFFF" name="column-heading_marital-status">Marital Status</td> 
    <td bgcolor="#FFFFFF" name="column-heading_working-status">Working Status</td> 
    <td bgcolor="#FFFFFF" name="column-heading_country-of-birth">Country Of Birth</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-town">Home Town</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-neighbourhood">Home Neighbourhood</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-borough">Home Borough</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-city">Home City</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-county">Home County</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-district">Home District</td>         
    <td bgcolor="#FFFFFF" name="column-heading_home-region">Home Region</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-state">Home State</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-country">Home Country</td> 
    </tr> 
    <?php while($row = mysqli_fetch_array($result)) 
    { 
        ?> 
        <tr name="user-details"> 
        <td bgcolor="#FFFFFF" name="submission-number"><a href="following_histories_v1.php?followee_id=<?php echo $row['id']; ?>&page_number=1"><?php echo $row['id']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="logging-server-date-&-time"><a href="following_histories_v1.php?followee_date_and_time=<?php echo $row['date_and_time']; ?>&page_number=1"><?php echo $row['date_and_time']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="browsed-page-converted_visit-page"><a href="<?php echo $row['followed_page_converted']; ?>&page_number=1"><?php echo $row['followed_page_converted']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="browsed-page-converted_stats-page"><a href="following_histories_v1.php?followee_followed_page_converted=<?php echo $row['followed_page_converted']; ?>&page_number=1"><?php echo $row['followed_page_converted']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="referral-page-converted_visit-page"><a href="<?php echo $row['referral_page_converted']; ?>&page_number=1"><?php echo $row['referral_page_converted']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="referral-page-converted_stats-page"><a href="following_histories_v1.php?followee_referral_page_converted=<?php echo $row['referral_page_converted']; ?>&page_number=1"><?php echo $row['referral_page_converted']; ?></a></td>     
        <td bgcolor="#FFFFFF" name="profile-page-followee_visit-page"><a href="profile.php?followee_username=<?php echo $row['followee_username']; ?>&page_number=1"><?php echo $row['followee_username']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="profile-page-followee_stats-page"><a href="following_histories_v1.php?followee_username=<?php echo $row['followee_username']; ?>&page_number=1"><?php echo $row['followee_username']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="profile-page-follower_visit-page"><a href="profile.php?followee_username=<?php echo $row['follower_username']; ?>&page_number=1"><?php echo $row['follower_username']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="profile-page-follower_stats-page"><a href="following_histories_v1.php?followee_username=<?php echo $row['follower_username']; ?>&page_number=1"><?php echo $row['follower_username']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="gender"><a href="following_histories_v1.php?followee_gender=<?php echo $row['gender']; ?>&page_number=1"><?php echo $row['gender']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="age-range"><a href="following_histories_v1.php?followee_age_range=<?php echo $row['age_range']; ?>&page_number=1"><?php echo $row['age_range']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="date-of-birth"><a href="following_histories_v1.php?followee_date_of_birth=<?php echo $row['date_of_birth']; ?>&page_number=1"><?php echo $row['date_of_birth']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="skin-complexion"><a href="following_histories_v1.php?followee_skin_complexion=<?php echo $row['skin_complexion']; ?>&page_number=1"><?php echo $row['skin_complexion']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="height"><a href="following_histories_v1.php?followee_height=<?php echo $row['height']; ?>&page_number=1"><?php echo $row['height']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="weight"><a href="following_histories_v1.php?followee_height=<?php echo $row['weight']; ?>&page_number=1"><?php echo $row['weight']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="sexual-orientation"><a href="following_histories_v1.php?followee_sexual_orientation=<?php echo $row['sexual_orientation']; ?>&page_number=1"><?php echo $row['sexual_orientation']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="religion"><a href="following_histories_v1.php?followee_religion=<?php echo $row['religion']; ?>&page_number=1"><?php echo $row['religion']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="education"><a href="following_histories_v1.php?followee_education=<?php echo $row['education']; ?>&page_number=1"><?php echo $row['education']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="profession"><a href="following_histories_v1.php?followee_profession=<?php echo $row['profession']; ?>&page_number=1"><?php echo $row['profession']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="marital-status"><a href="following_histories_v1.php?followee_marital_status=<?php echo $row['marital_status']; ?>&page_number=1"><?php echo $row['marital_status']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="working-status"><a href="following_histories_v1.php?followee_working_status=<?php echo $row['working_status']; ?>&page_number=1"><?php echo $row['working_status']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="country-of-birth"><a href="following_histories_v1.php?followee_country_of_birth=<?php echo $row['country_of_birth']; ?>&page_number=1"><?php echo $row['country_of_birth']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-town"><a href="following_histories_v1.php?followee_home_town=<?php echo $row['home_town']; ?>&page_number=1"><?php echo $row['home_town']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-neighbourhood"><a href="following_histories_v1.php?followee_home_neighbourhood=<?php echo $row['home_neighbourhood']; ?>&page_number=1"><?php echo $row['home_neighbourhood']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-borough"><a href="following_histories_v1.php?followee_home_borough=<?php echo $row['home_borough']; ?>&page_number=1"><?php echo $row['home_borough']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-city"><a href="following_histories_v1.php?followee_home_city=<?php echo $row['home_city']; ?>&page_number=1"><?php echo $row['home_city']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-county"><a href="following_histories_v1.php?followee_home_county=<?php echo $row['home_county']; ?>&page_number=1"><?php echo $row['home_county']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-district"><a href="following_histories_v1.php?followee_home_district=<?php echo $row['home_district']; ?>&page_number=1"><?php echo $row['home_district']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-region"><a href="following_histories_v1.php?followee_home_region=<?php echo $row['home_region']; ?>&page_number=1"><?php echo $row['home_region']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-state"><a href="following_histories_v1.php?followee_home_state=<?php echo $row['home_state']; ?>&page_number=1"><?php echo $row['home_state']; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-country"><a href="following_histories_v1.php?followee_home_country=<?php echo $row['home_country']; ?>&page_number=1"><?php echo $row['home_country']; ?></a></td> 
        </tr> 
        <?php 
    } 
    ?> 
    <tr name="pagination"> 
    <td colspan="30" bgcolor="#FFFFFF"> Result Pages: 
    <?php 
    if($rows_num <= $page_size) 
    { 
        echo "Page 1"; 
    } 
    else 
    { 
        for($i=1;$i<=$page_count;$i++) 
        echo "<a href=\"{$_SERVER['PHP_SELF']}?$query_type=${$query_type}&page_number={$i}\">{$i}</a> "; 
    } 
    ?> 
    </td> 
    </tr> 
    <?php 
} 
else 
{ 
    ?> 
    <tr> 
    <td bgcolor="#FFFFFF">No record found! Try another time.</td> 
    </tr> 
    <?php 
} 
?> 
</table> 
<br> 
<br> 
<p align="center"><span style="font-weight:bold;"><?php echo "Search Result for:<br> $query_type_label = \"${$query_type}\""; ?></span></p> 
<br> 
<br> 
<br> 
</body> 
</html>
	

The ISSUE STARTS as soon as I try adding PREP STMT.

Here is my attempt so far:

	<?php 
//Required PHP Files. 
include 'header_account.php'; //Required on all webpages of the Account. 
?> 
	<?php 
if (!$conn) 
{ 
    $error = mysqli_connect_error(); 
    $errno = mysqli_connect_errno(); 
    print "$errno: $error\n"; 
    exit(); 
} 
	//Grab Username of who's Browsing History needs to be searched. 
	if (isset($_GET['followee_username']) && !empty($_GET['followee_username'])) 
{ 
    $followee_username = $_GET['followee_username']; 
    
    if($followee_username != 'followee_all' OR $followee_username != 'Followee_All') 
    { 
        //$query = "SELECT * FROM browsing_histories WHERE username = \"$followee_username\""; 
        $query_type = "followee_username"; 
        $followed_word = "$followee_username"; 
        //$followee_username = "$followee_username"; 
        
        $query = "SELECT id,date_and_time,query_type,followed_word,query_string,followed_page_original,followed_page_converted,referral_page_original,referral_page_converted,followee_username,follower_username,gender,age_range,date_of_birth,skin_complexion,height,weight,sexual_orientation,religion,education,profession,marital_status,working_status,home_town,home_neighbourhood,home_borough,home_council,home_city,home_county,home_district,home_region,home_state,home_country FROM following_histories WHERE followee_username = ?"; 
        $stmt = mysqli_prepare($conn,$query); 
        mysqli_stmt_bind_param($stmt,'s',$followee_username); 
        mysqli_stmt_execute($stmt); 
        //Check if User's details was successfully extracted or not from 'details_contact_home' tbl. 
        if (!$stmt) 
        { 
            echo "ERROR 3: Sorry! Our system is currently experiencing a problem logging you in!"; 
            exit(); 
        } 
        else 
        { 
            $result = mysqli_stmt_bind_result($stmt,$followee_browsing_history_submission_id,$followee_browsing_history_submission_date_and_time,$followee_query_type,$followee_followed_word,$followee_query_string,$followee_browsed_page_original,$followee_browsed_page_converted,$followee_referral_page_original,$followee_referral_page_converted,$followee_username,$followee_gender,$followee_age_range,$followee_date_of_birth,$followee_skin_complexion,$followee_height,$followee_weight,$followee_sexual_orientation,$followee_religion,$followee_education,$followee_profession,$followee_marital_status,$followee_working_status,$followee_country_of_birth,$followee_home_town,$followee_home_neighbourhood,$followee_home_borough,$followee_home_council,$followee_home_city,$followee_home_county,$followee_home_district,$followee_home_region,$followee_home_state,$followee_home_country);     
            mysqli_stmt_fetch($stmt); 
            mysqli_stmt_close($stmt); 
        }         
    } 
    else 
    { 
        $query = "SELECT * FROM following_histories"; 
        $query_type = "followee_all"; 
        $followed_word = "followee_all";         
        echo "all"; 
        echo "all search";
    }     
} 
	if (isset($_GET['follower_username']) && !empty($_GET['follower_username'])) 
{ 
    $follower_username = $_GET['follower_username']; 
    
    if($follower_username != 'follower_all' OR $follower_username != 'Follower_All') 
    { 
        //$query = "SELECT * FROM browsing_histories WHERE username = \"$follower_username\""; 
        $query_type = "follower_username"; 
        $followed_word = "$follower_username"; 
        
        $query = "SELECT id,date_and_time,query_type,followed_word,query_string,followed_page_original,followed_page_converted,referral_page_original,referral_page_converted,followee_username,follower_username,gender,age_range,date_of_birth,skin_complexion,height,weight,sexual_orientation,religion,education,profession,marital_status,working_status,followee_country_of_birth,home_town,home_neighbourhood,home_borough,home_council,home_city,home_county,home_district,home_region,home_state,home_country FROM browsing_histories WHERE followee_username = ?"; 
        $stmt = mysqli_prepare($conn,$query); 
        mysqli_stmt_bind_param($stmt,'s',$follower_username); 
        mysqli_stmt_execute($stmt); 
        //Check if User's details was successfully extracted or not from 'details_contact_home' tbl. 
        if (!$stmt) 
        { 
            echo "ERROR 3: Sorry! Our system is currently experiencing a problem logging you in!"; 
            exit(); 
        } 
        else 
        { 
            $result = mysqli_stmt_bind_result($stmt,$followee_browsing_history_submission_id,$followee_browsing_history_submission_date_and_time,$followee_query_type,$followee_followed_word,$followee_query_string,$followee_browsed_page_original,$followee_browsed_page_converted,$followee_referral_page_original,$followee_referral_page_converted,$followee_username,$followee_gender,$followee_age_range,$followee_date_of_birth,$followee_skin_complexion,$followee_height,$followee_weight,$followee_sexual_orientation,$followee_religion,$followee_education,$followee_profession,$followee_marital_status,$followee_working_status,$followee_country_of_birth,$followee_home_town,$followee_home_neighbourhood,$followee_home_borough,$followee_home_council,$followee_home_city,$followee_home_county,$followee_home_district,$followee_home_region,$followee_home_state,$followee_home_country);     
            mysqli_stmt_fetch($stmt); 
            mysqli_stmt_close($stmt); 
        }         
    } 
    else 
    { 
        $query = "SELECT * FROM following_histories"; 
        $query_type = "follower_all"; 
        $followed_word = "follower_all";         
        echo "all"; 
        echo "all search";
    }     
} 
	if (isset($_GET['followee_id']) && !empty($_GET['followee_id'])) 
{ 
    $followee_id = $_GET['followee_id']; 
    $query = "SELECT * FROM following_histories WHERE id = \"$followee_id\""; 
    $query_type = "followee_id"; 
    $followed_word = "$followee_id"; 
    echo "$followee_id";
} 
	if (isset($_GET['followee_date_and_time']) && !empty($_GET['followee_date_and_time'])) 
{ 
    $followee_date_and_time = $_GET['followee_date_and_time']; 
    $query = "SELECT * FROM following_histories WHERE date_and_time = \"$followee_date_and_time\""; 
    $query_type = "followee_date_and_time"; 
    $followed_word = "$followee_date_and_time"; 
} 
    
if (isset($_GET['followee_followed_page_converted']) && !empty($_GET['followee_followed_page_converted'])) 
{ 
    $followee_followed_page_converted = $_GET['followee_followed_page_converted']; 
    $query = "SELECT * FROM following_histories WHERE followed_page_converted = \"$followee_followed_page_converted\""; 
    $query_type = "followee_followed_page_converted"; 
    $followed_word = "$followee_followed_page_converted"; 
} 
    
if (isset($_GET['followee_referral_page_converted']) && !empty($_GET['followee_referral_page_converted'])) 
{ 
    $followee_referral_page_converted = $_GET['followee_referral_page_converted']; 
    $query = "SELECT * FROM following_histories WHERE referral_page_converted = \"$followee_referral_page_converted\""; 
    $query_type = "followee_referral_page_converted"; 
    $followed_word = "$followee_referral_page_converted";     
} 
    
if (isset($_GET['followee_gender']) && !empty($_GET['followee_gender'])) 
{ 
    $followee_gender = $_GET['followee_gender']; 
    $query = "SELECT * FROM following_histories WHERE gender = \"$followee_gender\""; 
    $query_type = "followee_gender"; 
    $followed_word = "$followee_gender";         
} 
    
if (isset($_GET['followee_age_range']) && !empty($_GET['followee_age_range'])) 
{ 
    $followee_age_range = $_GET['followee_age_range']; 
    $query = "SELECT * FROM following_histories WHERE age_range = \"$followee_age_range\""; 
    $query_type = "followee_age_range"; 
    $followed_word = "$followee_age_range"; 
} 
    
if (isset($_GET['followee_date_of_birth']) && !empty($_GET['followee_date_of_birth'])) 
{ 
    $followee_date_of_birth = $_GET['followee_date_of_birth']; 
    $query = "SELECT * FROM following_histories WHERE date_of_birth = \"$followee_date_of_birth\""; 
    $query_type = "followee_date_of_birth"; 
    $followed_word = "$followee_date_of_birth"; 
} 
    
if (isset($_GET['followee_skin_complexion']) && !empty($_GET['followee_skin_complexion'])) 
{ 
    $followee_skin_complexion = $_GET['followee_skin_complexion']; 
    $query = "SELECT * FROM following_histories WHERE skin_complexion = \"$followee_skin_complexion\""; 
    $query_type = "followee_skin_complexion"; 
    $followed_word = "$followee_skin_complexion";     
} 
    
if (isset($_GET['followee_height']) && !empty($_GET['followee_height'])) 
{ 
    $followee_height = $_GET['followee_height']; 
    $query = "SELECT * FROM following_histories WHERE height = \"$followee_height\""; 
    $query_type = "followee_height"; 
    $followed_word = "$followee_height"; 
} 
    
if (isset($_GET['followee_weight']) && !empty($_GET['followee_weight'])) 
{ 
    $followee_weight = $_GET['followee_weight']; 
    $query = "SELECT * FROM following_histories WHERE weight = \"$followee_weight\""; 
    $query_type = "followee_weight"; 
    $followed_word = "$followee_weight"; 
} 
    
if (isset($_GET['followee_sexual_orientation']) && !empty($_GET['followee_sexual_orientation'])) 
{ 
    $followee_sexual_orientation = $_GET['followee_sexual_orientation']; 
    $query = "SELECT * FROM following_histories WHERE sexual_orientation = \"$followee_sexual_orientation\""; 
    $query_type = "followee_sexual_orientation"; 
    $followed_word = "$followee_sexual_orientation"; 
} 
    
if (isset($_GET['followee_religion']) && !empty($_GET['followee_religion'])) 
{ 
    $followee_religion = $_GET['followee_religion']; 
    $query = "SELECT * FROM following_histories WHERE religion = \"$followee_religion\""; 
    $query_type = "followee_religion"; 
    $followed_word = "$followee_religion"; 
} 
    
if (isset($_GET['followee_education']) && !empty($_GET['followee_education'])) 
{ 
    $followee_education = $_GET['followee_education']; 
    $query = "SELECT * FROM following_histories WHERE education = \"$followee_education\""; 
    $query_type = "followee_education"; 
    $followed_word = "$followee_education"; 
} 
    
if (isset($_GET['followee_profession']) && !empty($_GET['followee_profession'])) 
{ 
    $followee_profession = $_GET['followee_profession']; 
    $query = "SELECT * FROM following_histories WHERE profession = \"$followee_profession\""; 
    $query_type = "followee_profession"; 
    $followed_word = "$followee_profession"; 
} 
    
if (isset($_GET['followee_marital_status']) && !empty($_GET['followee_marital_status'])) 
{ 
    $followee_marital_status = $_GET['followee_marital_status']; 
    $query = "SELECT * FROM following_histories WHERE marital_status = \"$followee_marital_status\""; 
    $query_type = "followee_marital_status"; 
    $followed_word = "$followee_marital_status"; 
} 
    
if (isset($_GET['followee_working_status']) && !empty($_GET['followee_working_status'])) 
{ 
    $followee_working_status = $_GET['followee_working_status']; 
    $query = "SELECT * FROM following_histories WHERE working_status = \"$followee_working_status\""; 
    $query_type = "followee_working_status"; 
    $followed_word = "$followee_working_status"; 
} 
    
if (isset($_GET['followee_country_of_birth']) && !empty($_GET['followee_country_of_birth'])) 
{ 
    $followee_country_of_birth = $_GET['followee_country_of_birth']; 
    $query = "SELECT * FROM following_histories WHERE country_of_birth = \"$followee_country_of_birth\""; 
    $query_type = "followee_country_of_birth"; 
    $followed_word = "$followee_country_of_birth"; 
} 
    
if (isset($_GET['followee_home_town']) && !empty($_GET['followee_home_town'])) 
{ 
    $followee_home_town = $_GET['followee_home_town']; 
    $query = "SELECT * FROM following_histories WHERE home_town = \"$followee_home_town\""; 
    $query_type = "followee_home_town"; 
    $followed_word = "$followee_home_town"; 
} 
    
if (isset($_GET['followee_home_neighbourhood']) && !empty($_GET['followee_home_neighbourhood'])) 
{ 
    $followee_home_neighbourhood = $_GET['followee_home_neighbourhood']; 
    $query = "SELECT * FROM following_histories WHERE home_neighbourhood = \"$followee_home_neighbourhood\""; 
    $query_type = "followee_home_neighbourhood"; 
    $followed_word = "$followee_home_neighbourhood"; 
} 
    
if (isset($_GET['followee_home_borough']) && !empty($_GET['followee_home_borough'])) 
{ 
    $followee_home_borough = $_GET['followee_home_borough']; 
    $query = "SELECT * FROM following_histories WHERE home_borough = \"$followee_home_borough\""; 
    $query_type = "followee_home_borough"; 
    $followed_word = "$followee_home_borough"; 
} 
    
if (isset($_GET['followee_home_city']) && !empty($_GET['followee_home_city'])) 
{ 
    $followee_home_city = $_GET['followee_home_city']; 
    $query = "SELECT * FROM following_histories WHERE home_city = \"$followee_home_city\""; 
    $query_type = "followee_home_city"; 
    $followed_word = "$followee_home_city"; 
} 
    
if (isset($_GET['followee_home_county']) && !empty($_GET['followee_home_county'])) 
{ 
    $followee_home_county = $_GET['followee_home_county']; 
    $query = "SELECT * FROM following_histories WHERE home_county = \"$followee_home_county\""; 
    $query_type = "followee_home_county"; 
    $followed_word = "$followee_home_county"; 
} 
    
if (isset($_GET['followee_home_district']) && !empty($_GET['followee_home_district'])) 
{ 
    $followee_home_district = $_GET['followee_home_district']; 
    $query = "SELECT * FROM following_histories WHERE home_district = \"$followee_home_district\""; 
    $query_type = "followee_home_district"; 
    $followed_word = "$followee_home_district"; 
} 
    
if (isset($_GET['followee_home_region']) && !empty($_GET['followee_home_region'])) 
{ 
    $followee_home_region = $_GET['followee_home_region']; 
    $query = "SELECT * FROM following_histories WHERE home_region = \"$followee_home_region\""; 
    $query_type = "followee_home_region"; 
    $followed_word = "$followee_home_region"; 
} 
    
if (isset($_GET['followee_home_state']) && !empty($_GET['followee_home_state'])) 
{ 
    $followee_home_state = $_GET['followee_home_state']; 
    $query = "SELECT * FROM following_histories WHERE home_state = \"$followee_home_state\""; 
    $query_type = "followee_home_state"; 
    $followed_word = "$followee_home_state"; 
} 
    
if (isset($_GET['followee_home_country']) && !empty($_GET['followee_home_country'])) 
{ 
    $followee_home_country = $_GET['followee_home_country']; 
    $query = "SELECT * FROM following_histories WHERE home_country = \"$followee_home_country\""; 
    $query_type = "followee_home_country"; 
    $followed_word = "$followee_home_country"; 
} 
	$referral_page_http = $_SERVER['HTTP_REFERRER']; 
$referral_page = "$referral_page_http"; 
$referral_page_original = "$referral_page"; 
	$query_string = $_SERVER['QUERY_STRING']; 
	$current_page_http = $_SERVER['PHP_SELF']; 
$current_page = "$current_page_http"; 
	$followed_page_original = "$current_page"; 
	$visiting_pages_count = "1"; 
if($visiting_pages_count == "") 
{ 
    $visiting_pages_count = "1"; 
} 
else 
{ 
    $visiting_pages_count++; 
} 
	if($visiting_pages_count == "1") 
{ 
    $current_page_converted = "$settings_user_first_quick_link.$current_page"; 
    $referral_page_converted = "$settings_user_first_quick_link.$referral_page";     
} 
elseif($visiting_pages_count == "2") 
{ 
    $current_page_converted = "$settings_admin_second_quick_link.$current_page"; 
    $referral_page_converted = "$settings_admin_second_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "3") 
{ 
    $current_page_converted = "$settings_user_third_quick_link.$current_page"; 
    $referral_page_converted = "$settings_user_third_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "4") 
{ 
    $current_page_converted = "$settings_admin_fourth_quick_link.$current_page"; 
    $referral_page_converted = "$settings_admin_fourth_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "5") 
{ 
    $current_page_converted = "$settings_user_fifth_quick_link.$current_page"; 
    $referral_page_converted = "$settings_user_fifth_quick_link.$referral_page"; 
} 
if($visiting_pages_count == "6") 
{ 
    $current_page_converted = "$settings_admin_first_quick_link.$current_page"; 
    $referral_page_converted = "$settings_admin_first_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "7") 
{ 
    $current_page_converted = "$settings_user_second_quick_link.$current_page"; 
    $referral_page_converted = "$settings_user_second_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "8") 
{ 
    $current_page_converted = "$settings_admin_third_quick_link.$current_page"; 
    $referral_page_converted = "$settings_admin_third_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "9") 
{ 
    $current_page_converted = "$settings_user_fourth_quick_link.$current_page"; 
    $referral_page_converted = "$settings_user_fourth_quick_link.$referral_page"; 
} 
elseif($visiting_pages_count == "10") 
{ 
    $current_page_converted = "$settings_admin_fifth_quick_link.$current_page"; 
    $referral_page_converted = "$settings_admin_fifth_quick_link.$referral_page"; 
} 
else 
{ 
    $visiting_pages_count = "1"; 
    $current_page_converted = "$settings_user_first_quick_link.$current_page"; 
    $referral_page_converted = "$settings_user_first_quick_link.$referral_page"; 
} 
	$followed_page_converted = "$current_page_converted"; 
	$follower_username = $user; 
$follower_browser = $_SERVER['HTTP_USER_AGENT']; 
	//Insert the User's Click Logs into Mysql Database using Php's Sql Injection Prevention Method "Prepared Statements". 
$stmt_2 = mysqli_prepare($conn,"INSERT INTO following_histories(query_type,followed_word,query_string,followed_page_original,followed_page_converted,referral_page_original,referral_page_converted,followee_username,follower_username,gender,age_range,date_of_birth,skin_complexion,height,weight,sexual_orientation,religion,education,profession,marital_status,working_status,country_of_birth,home_town,home_neighbourhood,home_borough,home_council,home_city,home_county,home_district,home_region,home_state,home_country) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); 
mysqli_stmt_bind_param($stmt_2,'ssssssssssiissssssssssssssssssss',$query_type,$followed_word,$query_string,$followed_page_original,$followed_page_converted,$referral_page_original,$referral_page_converted,$followee_username,$follower_username,$gender,$age_range,$date_of_birth,$skin_complexion,$height,$weight,$sexual_orientation,$religion,$education,$profession,$marital_status,$working_status,$country_of_birth,$home_town,$home_neighbourhood,$home_borough,$home_council,$home_city,$home_county,$home_district,$home_region,$home_state,$home_country); 
mysqli_stmt_execute($stmt_2); 
            
//Check if User's Click Logs have been successfully submitted or not. 
if (!$stmt_2) 
{ 
    echo "Sorry! Our system is currently experiencing a problem logging your following! We will continuously try logging your clicks!"; 
    exit(); 
} 
else 
{ 
    mysqli_stmt_fetch($stmt_2); 
    mysqli_stmt_close($stmt_2);
} 
	$query_type_label = str_replace("_"," ","$query_type"); //Removing underscores so they don't show-up on the html. 
$query_type_label = ucwords("$query_type_label"); //Upper Casing the first characters. 
?> 
	<!DOCTYPE html> 
<html> 
<head> 
<meta content="text/html; charset=ISO-8859-1" http-equiv=" content-type"> 
<title><?php echo "Browsing History in $server_time Time.";?></title> 
<meta name="viewport" content="width=device-width, initial-scale=1"> 
</head> 
<body> 
<br> 
<p align="center"><span style="font-weight:bold;"><?php echo "Search Result for:<br> $query_type_label = \"${$query_type}\""; ?></span></p> 
<br> 
<br> 
<?php     
$result = mysqli_query($conn,$query); 
$rows_num = mysqli_num_rows($result); 
    
//Total Number of Pages records are spread-over. 
$page_count = 100; 
$page_size = ceil($rows_num / $page_count); 
//Get the Page Number. Default is 1 (First Page). 
$page_number = $_GET["page_number"]; 
if ($page_number == "") $page_number = 1; 
    $offset = ($page_number -1) * $page_size; 
        
    $query .= " limit {$offset},{$page_size}"; 
    $result = mysqli_query($conn,$query); 
?> 
<table width="1500" border="0" cellpadding="5" cellspacing="2" bgcolor="#666666"> 
<?php 
if(!$rows_num) 
{ 
    ?> 
    <tr> 
    <td bgcolor="#FFFFFF">No record found! Try another time.</td> 
    </tr> 
    <?php 
} 
else  
{ 
    printf("<b> %d Result Found ...</b>\n",$rows_num); ?><br> 
    <br> 
    <tr name="headings"> 
    <td bgcolor="#FFFFFF" name="column-heading_submission-number">Submission Number</td> 
    <td bgcolor="#FFFFFF" name="column-heading_logging-server-date-and-time">Date & Time in <?php echo "$server_time";?></td> 
    <td bgcolor="#FFFFFF" name="column-heading_browsed-page-converted">Browsed Page Converted (Visit Page) </td> 
    <td bgcolor="#FFFFFF" name="column-heading_browsed-page-converted">Browsed Page Converted (Check Stats) </td> 
    <td bgcolor="#FFFFFF" name="column-heading_referral-page-converted">Referral Page Converted (Visit Page) </td> 
    <td bgcolor="#FFFFFF" name="column-heading_referral-page-converted">Referral Page Converted (Check Stats) </td> 
    <td bgcolor="#FFFFFF" name="column-heading_username">Followee Username (Visit Page)</td> 
    <td bgcolor="#FFFFFF" name="column-heading_username">Followee Username (Check Stats)</td> 
    <td bgcolor="#FFFFFF" name="column-heading_username">Follower Username (Visit Page)</td> 
    <td bgcolor="#FFFFFF" name="column-heading_username">Follower Username (Check Stats)</td> 
    <td bgcolor="#FFFFFF" name="column-heading_gender">Follower Gender</td> 
    <td bgcolor="#FFFFFF" name="column-heading_age-range">Follower Age Range</td> 
    <td bgcolor="#FFFFFF" name="column-heading_date-of-birth">Follower Date Of Birth</td> 
    <td bgcolor="#FFFFFF" name="column-heading_skin-complexion">Follower Skin Complexion</td> 
    <td bgcolor="#FFFFFF" name="column-heading_height">Follower Height</td> 
    <td bgcolor="#FFFFFF" name="column-heading_weight">Follower Weight</td> 
    <td bgcolor="#FFFFFF" name="column-heading_sexual-orientation">Follower Sexual Orientation</td> 
    <td bgcolor="#FFFFFF" name="column-heading_religion">Follower Religion</td> 
    <td bgcolor="#FFFFFF" name="column-heading_education">Follower Education</td> 
    <td bgcolor="#FFFFFF" name="column-heading_profession">Follower Profession</td> 
    <td bgcolor="#FFFFFF" name="column-heading_marital-status">Follower Marital Status</td> 
    <td bgcolor="#FFFFFF" name="column-heading_working-status">Follower Working Status</td> 
    <td bgcolor="#FFFFFF" name="column-heading_country-of-birth">Follower Country Of Birth</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-town">Follower Home Town</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-neighbourhood">Follower Home Neighbourhood</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-borough">Follower Home Borough</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-city">Follower Home City</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-county">Follower Home County</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-district">Follower Home District</td>         
    <td bgcolor="#FFFFFF" name="column-heading_home-region">Follower Home Region</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-state">Follower Home State</td> 
    <td bgcolor="#FFFFFF" name="column-heading_home-country">Follower Home Country</td> 
    </tr> 
    <?php while($row = mysqli_fetch_array($result)) 
    { 
        ?> 
        <tr name="user-details"> 
        <td bgcolor="#FFFFFF" name="submission-number"><a href="following_histories_v1.php?followee_id=<?php echo $followee_browsing_history_submission_id; ?>&page_number=1"><?php echo $followee_browsing_history_submission_id; ?></a></td> 
        <td bgcolor="#FFFFFF" name="logging-server-date-&-time"><a href="following_histories_v1.php?followee_date_and_time=<?php echo $followee_browsing_history_submission_date_and_time; ?>&page_number=1"><?php echo $followee_browsing_history_submission_date_and_time; ?></a></td> 
        <td bgcolor="#FFFFFF" name="followed-page-converted_visit-page"><a href="<?php echo "followee_browser.php?followee_username=$followee_username&followee_followed_page_converted=$followee_followed_page_converted"; ?>"><?php echo "$followee_followed_page_converted"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="followed-page-converted_stats-page"><a href="following_histories_v1.php?followee_followed_page_converted=<?php echo "$followee_followed_page_converted"; ?>&page_number=1"><?php echo "$followee_followed_page_converted"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="referral-page-converted_visit-page"><a href="<?php echo "followee_browser.php?followee_username=$followee_username&followee_referral_page_converted=$followee_referral_page_converted"; ?>"><?php echo "$followee_referral_page_converted"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="referral-page-converted_stats-page"><a href="following_histories_v1.php?followee_referral_page_converted=<?php echo "$followee_referral_page_converted"; ?>&page_number=1"><?php echo "$followee_referral_page_converted"; ?></a></td>     
        <td bgcolor="#FFFFFF" name="profile-page-followee_visit-page"><a href="profile.php?followee_username=<?php echo "$followee_username"; ?>"><?php echo "$followee_username"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="profile-page-followee_stats-page"><a href="following_histories_v1.php?followee_username=<?php echo "$followee_username"; ?>"><?php echo "$followee_username"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="profile-page-follower_visit-page"><a href="profile.php?followee_username=<?php echo "$follower_username"; ?>"><?php echo "$follower_username"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="profile-page-follower_stats-page"><a href="following_histories_v1.php?followee_username=<?php echo "$follower_username"; ?>"><?php echo "$follower_username"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="gender"><a href="following_histories_v1.php?followee_gender=<?php echo "$follower_gender"; ?>&page_number=1"><?php echo "$follower_gender"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="age-range"><a href="following_histories_v1.php?followee_age_range=<?php echo "$follower_age_range"; ?>&page_number=1"><?php echo "$followerage_range"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="date-of-birth"><a href="following_histories_v1.php?followee_date_of_birth=<?php echo "$follower_date_of_birth"; ?>&page_number=1"><?php echo "$follower_date_of_birth"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="skin-complexion"><a href="following_histories_v1.php?followee_skin_complexion=<?php echo "$follower_skin_complexion"; ?>&page_number=1"><?php echo "$follower_skin_complexion"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="height"><a href="following_histories_v1.php?followee_height=<?php echo "$follower_height"; ?>&page_number=1"><?php echo "$follower_height"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="weight"><a href="following_histories_v1.php?followee_height=<?php echo "$follower_weight"; ?>&page_number=1"><?php echo "$follower_weight"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="sexual-orientation"><a href="following_histories_v1.php?followee_sexual_orientation=<?php echo "$follower_sexual_orientation"; ?>&page_number=1"><?php echo "$follower_sexual_orientation"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="religion"><a href="following_histories_v1.php?followee_religion=<?php echo "$follower_religion"; ?>&page_number=1"><?php echo "$follower_religion"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="education"><a href="following_histories_v1.php?followee_education=<?php echo "$follower_education"; ?>&page_number=1"><?php echo "$follower_education"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="profession"><a href="following_histories_v1.php?followee_profession=<?php echo "$follower_profession"; ?>&page_number=1"><?php echo "$follower_profession"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="marital-status"><a href="following_histories_v1.php?followee_marital_status=<?php echo "$follower_marital_status"; ?>&page_number=1"><?php echo "$follower_marital_status"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="working-status"><a href="following_histories_v1.php?followee_working_status=<?php echo "$follower_working_status"; ?>&page_number=1"><?php echo "$follower_working_status"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="country-of-birth"><a href="following_histories_v1.php?followee_country_of_birth=<?php echo "$follower_country_of_birth"; ?>&page_number=1"><?php echo "$follower_country_of_birth"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-town"><a href="following_histories_v1.php?followee_home_town=<?php echo "$follower_home_town"; ?>&page_number=1"><?php echo "$follower_home_town"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-neighbourhood"><a href="following_histories_v1.php?followee_home_neighbourhood=<?php echo "$follower_home_neighbourhood"; ?>&page_number=1"><?php echo "$home_neighbourhood"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-borough"><a href="following_histories_v1.php?followee_home_borough=<?php echo "$follower_home_borough"; ?>&page_number=1"><?php echo "$follower_home_borough"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-city"><a href="following_histories_v1.php?followee_home_city=<?php echo "$follower_home_city"; ?>&page_number=1"><?php echo "$follower_home_city"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-county"><a href="following_histories_v1.php?followee_home_county=<?php echo "$follower_home_county"; ?>&page_number=1"><?php echo "$follower_home_county"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-district"><a href="following_histories_v1.php?followee_home_district=<?php echo "$follower_home_district"; ?>&page_number=1"><?php echo "$follower_home_district"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-region"><a href="following_histories_v1.php?followee_home_region=<?php echo "$follower_home_region"; ?>&page_number=1"><?php echo "$follower_home_region"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-state"><a href="following_histories_v1.php?followee_home_state=<?php echo "$follower_home_state"; ?>&page_number=1"><?php echo "$follower_home_state"; ?></a></td> 
        <td bgcolor="#FFFFFF" name="home-country"><a href="following_histories_v1.php?followee_home_country=<?php echo "$follower_home_country"; ?>&page_number=1"><?php echo "$follower_home_country"; ?></a></td> 
        </tr> 
        <?php 
    } 
    ?> 
    <tr name="pagination"> 
    <td colspan="30" bgcolor="#FFFFFF"> Result Pages: 
    <?php 
    if($rows_num <= $page_size) 
    { 
        echo "Page 1"; 
    } 
    else 
    { 
        for($i=1;$i<=$page_count;$i++) 
        echo "<a href=\"{$_SERVER['PHP_SELF']}?$query_type=${$query_type}&page_number={$i}\">{$i}</a> "; 
    } 
    ?> 
    </td&g

I'm getting this error for a blog script that is on my site :-

PHP Fatal error:  Uncaught TypeError: Unsupported operand types: string - int

The line in questions is this :-

$prev = $page - 1;

If I comment out this block of code the blog appears (with other errors, but I'll move on to those if I can fix this first!).

/* Setup page vars for display. */
    if (isset($page) and $page == 0) $page = 1;                    //if no page var is given, default to 1.
    $prev = $page - 1;                            //previous page is page - 1
    $next = $page + 1;                            //next page is page + 1
    $lastpage = ceil($total_pages/$limit);        //lastpage is = total pages / items per page, rounded up.
    $lpm1 = $lastpage - 1;                        //last page minus 1

Any idea's on what's needed to fix this script? I've contacted the original author but they haven't got back to me, I guess PHP8 maybe a little too new for them.

Thanks for any help....

<!DOCTYPE html>
<html>
<head>
    <title>Registered Users</title>
    <link rel="stylesheet" href="includes/style.css" type="text/css" media="screen"/>
    <link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.25/css/jquery.dataTables.min.css">
</head>
<body>
    <?php
    include('includes/header.html');
    ?>
    <center>
        <table id="records">
            <thead>
                <tr>
                    <th>ID</th>
                    <th>First Name</th>
                    <th>Last Name</th>
                    <th>Email</th>
                </tr>>
            </thead>
            <tbody>
                <?php
                    require_once('mysqli_connect.php');
                    $query = "SELECT * FROM users";
                    $result = mysqli_query($dbc,$query);
                    
                    if(mysqli_num_rows($result) > 0) -------------------------------------------------Line 28

                    {
                        while($row = mysqli_fetch_assoc($result))
                        {?>
                            <tr>
                                <td><?php echo $row["id"];?></td>
                                <td><?php echo $row["First Name"];?></td>
                                <td><?php echo $row["Last Name"];?></td>
                                <td><?php echo $row["Email"];?></td>
                            </tr>
                            <?php
                        }
                    }
                    mysqli_close($dbc);
                ?>
            </tbody>
        </table>
    </center>
</body>
<?php include('includes/footer.html');?>
</html>

I have a table with a list of users and an edit button and delete button.  When the edit button is pressed on a site it passes the user_id as p_id to the page that catches it and displays the data.  The problem is when I click on the "update user" button, I get the following error:

Warning: Undefined variable $the_user_id in C:\xampp\htdocs\3-19-21(2) - SafetySite\admin\edit_user.php on line 10

Fatal error: Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, bool given in C:\xampp\htdocs\3-19-21(2) - SafetySite\admin\edit_user.php:14 Stack trace: #0 C:\xampp\htdocs\3-19-21(2) - SafetySite\admin\edit_user.php(14): mysqli_fetch_assoc(false) #1 {main} thrown in C:\xampp\htdocs\3-19-21(2) - SafetySite\admin\edit_user.php on line 14

The weird thing is I had another update user page with a table I created that ran the query to update the table in the database just fine.  But as I created it, it didn't look all that great so I recreated the page and used a bootstrap table because of the much cleaner look.  Both pages have the exact same PHP code, the only difference is the bootstrap table I added in.  So I'm really at a loss with this.  Other than the table and PHP code, there is a script at the bottom of the page for the table itself to allow for searching within the table, i'll include that as well.  The PHP code is as follows:

<?php

//THE "p_id" IS BROUGHT OVER FROM THE EDIT BUTTON ON VIEW_ALL_USERS

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

    $the_user_id = $_GET['p_id'];

}

// QUERY TO PULL THE SITE INFORMATION FROM THE p_id THAT WAS PULLED OVER

$query = "SELECT * FROM users WHERE user_id = $the_user_id ";

$select_user = mysqli_query($connection,$query);

//SET VALUES FROM ARRAY TO VARIABLES

while($row = mysqli_fetch_assoc($select_user)) {

    $user_id = $row['user_id'];

    $user_firstname = $row['user_firstname'];

    $user_lastname = $row['user_lastname'];

    $username = $row['username'];

    $user_email = $row['user_email'];

    $user_phone = $row['user_phone'];

    //$user_image = $row['user_image'];

    $user_title_id = $row['user_title_id'];

    $user_role_id = $row['user_role_id'];

   }

THE UPDATE QUERY CODE....................................................................................................................

<?php

if(isset($_POST['update_user'])) {

    $user_id = $_POST['user_id'];

    $user_firstname = $_POST['user_firstname'];

    $user_lastname = $_POST['user_lastname'];

    $username = $_POST['username'];

    $user_email = $_POST['user_email'];

    $user_phone = $_POST['user_phone'];

    //$user_image = $_POST['user_image'];

    $user_title_id = $_POST['user_title_id'];

    $user_role_id = $_POST['user_role_id'];

    $query = "UPDATE users SET ";

    $query .= "user_id = '{$user_id}', ";

    $query .= "user_firstname = '{$user_firstname}', ";

    $query .= "user_lastname = '{$user_lastname}', ";

    $query .= "username = '{$username}', ";

    $query .= "user_email = '{$user_email}', ";

    $query .= "user_phone = '{$user_phone}', ";

    //$query .= "user_image = '{$user_image}', ";

    $query .= "user_title_id = '{$user_title_id}', ";

    $query .= "user_role_id = '{$user_role_id}' ";

    $query .= "WHERE user_id = '{$the_user_id}' ";

    $update_user = mysqli_query($connection,$query);

    if(! $update_user) {

        die("QUERY FAILED" . mysqli_error($connection));

    }

}

?>

THE "UPDATE USER" BUTTON THE USER CLICKS ON TO UPDATE....................................................................................................................

<div class="col-1">

<button class="btn btn-primary" type="submit" name="update_user">Update User</button>

</div>

Any Help is Greatly Appreciated!

<?php

/**
 * GUMP - A fast, extensible PHP input validation class
 *
 * @author		Sean Nieuwoudt (http://twitter.com/SeanNieuwoudt)
 * @copyright	Copyright (c) 2011 Wixel.net
 * @link		http://github.com/Wixel/GUMP
 * @version     1.0
 */

class GUMP
{	
	// Validation rules for execution
	protected $validation_rules = array();
	
	// Filter rules for execution
	protected $filter_rules = array(); 
	
	// Instance attribute containing errors from last run
	protected $errors = array();
	
	// ** ------------------------- Validation Data ------------------------------- ** //	
	
	public static $basic_tags	  = "<br><p><a><strong><b><i><em><img><blockquote><code><dd><dl><hr><h1><h2><h3><h4><h5><h6><label><ul><li><span><sub><sup>";				
		
	public static $en_noise_words = "about,after,all,also,an,and,another,any,are,as,at,be,because,been,before,
				  				  	 being,between,both,but,by,came,can,come,could,did,do,each,for,from,get,
				  				  	 got,has,had,he,have,her,here,him,himself,his,how,if,in,into,is,it,its,it's,like,
			      				  	 make,many,me,might,more,most,much,must,my,never,now,of,on,only,or,other,
				  				  	 our,out,over,said,same,see,should,since,some,still,such,take,than,that,
				  				  	 the,their,them,then,there,these,they,this,those,through,to,too,under,up,
				  				  	 very,was,way,we,well,were,what,where,which,while,who,with,would,you,your,a,
				  				  	 b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,$,1,2,3,4,5,6,7,8,9,0,_";
				
	// ** ------------------------- Validation Helpers ---------------------------- ** //	
	
	/**
	 * Shorthand method for inline validation 
	 *
	 * @param array $data The data to be validated
	 * @param array $validators The GUMP validators
	 * @return mixed True(boolean) or the array of error messages
	 */
	public static function is_valid(array $data, array $validators) 
	{
		$gump = new Gump();

		$gump->validation_rules($validators);

		if($gump->run($data) === false) {
			return $gump->get_readable_errors(false);
		} else {
			return true;
		}	
	}	
	
	/**
	 * Magic method to generate the validation error messages
	 *
	 * @return string
	 */
	public function __toString()
	{
		return $this->get_readable_errors(true);
	}
	
	/**
	 * Perform XSS clean to prevent cross site scripting
	 * 
	 * @static
	 * @access public
	 * @param  array $data
	 * @return array
	 */
	public static function xss_clean(array $data)
	{
		foreach($data as $k => $v)
		{
			$data[$k] = filter_var($v, FILTER_SANITIZE_STRING);		
		}
		
		return $data;
	}
	
	/**
	 * Getter/Setter for the validation rules
	 *
	 * @param array $rules
	 * @return array
	 */
	public function validation_rules(array $rules = array())
	{
		if(!empty($rules)) {
			$this->validation_rules = $rules;
		} else {
			return $this->validation_rules;
		}		
	}
	
	/**
	 * Getter/Setter for the filter rules
	 *
	 * @param array $rules
	 * @return array
	 */	
	public function filter_rules(array $rules = array())
	{
		if(!empty($rules)) {
			$this->filter_rules = $rules;
		} else {
			return $this->filter_rules;
		}
	}	
	
	/**
	 * Run the filtering and validation after each other
	 *
	 * @param array $data
	 * @return array
	 * @return boolean
	 */
	public function run(array $data)
	{
		$data = $this->filter($data, $this->filter_rules());
		
		$validated = $this->validate(
			$data, $this->validation_rules()
		);		
		
		if($validated !== true) {
			return false;
		} else {
		   return $data;
		}
	}
	
	/**
	 * Sanitize the input data
	 * 
	 * @access public
	 * @param  array $data
	 * @return array
	 */
	public function sanitize(array $input, $fields = NULL, $utf8_encode = true)
	{
		$magic_quotes = (bool)get_magic_quotes_gpc();
		
		if(is_null($fields))
		{
			$fields = array_keys($input);
		}

		foreach($fields as $field)
		{
			if(!isset($input[$field]))
			{
				continue;
			}
			else
			{
				$value = $input[$field]; 
				
				if(is_string($value))
				{
					if($magic_quotes === TRUE)
					{
						$value = stripslashes($value);
					}
					
					if(strpos($value, "\r") !== FALSE)
					{
						$value = trim($value);
					}
					
					if(function_exists('iconv') && function_exists('mb_detect_encoding') && $utf8_encode)
					{
						$current_encoding = mb_detect_encoding($value);
						
						if($current_encoding != 'UTF-8' && $current_encoding != 'UTF-16') {
							$value = iconv($current_encoding, 'UTF-8', $value);
						}
					}
					
					$value = filter_var($value, FILTER_SANITIZE_STRING);
				}
				
				$input[$field] = $value;
			}
		}
		
		return $input;		
	}
	
	/**
	 * Return the error array from the last validation run
	 *
	 * @return array
	 */
	public function errors()
	{
		return $this->errors;
	}
	
	/**
	 * Perform data validation against the provided ruleset
	 * 
	 * @access public
	 * @param  mixed $input
	 * @param  array $ruleset
	 * @return mixed
	 */
	public function validate(array $input, array $ruleset)
	{
		$this->errors = array();
		
		foreach($ruleset as $field => $rules)
		{
			#if(!array_key_exists($field, $input))
			#{
			#	continue;
			#}
			
			$rules = explode('|', $rules);

			foreach($rules as $rule)
			{
				$method = NULL;
				$param  = NULL;
				
				if(strstr($rule, ',') !== FALSE) // has params
				{
					$rule   = explode(',', $rule);
					$method = 'validate_'.$rule[0];
					$param  = $rule[1];
				}
				else
				{
					$method = 'validate_'.$rule;
				}

				if(is_callable(array($this, $method)))
				{
					$result = $this->$method($field, $input, $param);

					if(is_array($result)) // Validation Failed
					{
						$this->errors[] = $result;
					}
				}
				else
				{
					throw new Exception("Validator method '$method' does not exist.");
				}
			}
		}

		return (count($this->errors) > 0)? $this->errors : TRUE;
	}
	
	/**
	 * Process the validation errors and return human readable error messages
	 *
	 * @param bool $convert_to_string = false
	 * @param string $field_class
	 * @param string $error_class	
	 * @return array 
	 * @return string	
	 */
	public function get_readable_errors($convert_to_string = false, $field_class="field", $error_class="error-message")
	{
		if(empty($this->errors)) {
			return ($convert_to_string)? null : array();
		}
		
		$resp = array();
		
		foreach($this->errors as $e) {
		
			$field = ucwords(str_replace(array('_','-'), chr(32), $e['field']));
			$param = $e['param'];
			
			switch($e['rule']) {
				case 'validate_required':
					$resp[] = "The <span class=\"$field_class\">$field</span> field is required";
					break;
				case 'validate_valid_email':
					$resp[] = "The <span class=\"$field_class\">$field</span> field is required to be a valid email address";
					break;
				case 'validate_max_len':
					if($param == 1) {
						$resp[] = "The <span class=\"$field_class\">$field</span> field needs to be shorter than $param character";
					} else {
						$resp[] = "The <span class=\"$field_class\">$field</span> field needs to be shorter than $param characters";
					}
					break;
				case 'validate_min_len':
					if($param == 1) {
						$resp[] = "The <span class=\"$field_class\">$field</span> field needs to be longer than $param character";
					} else {
						$resp[] = "The <span class=\"$field_class\">$field</span> field needs to be longer than $param characters";
					}
					break;
				case 'validate_exact_len':
					if($param == 1) {
						$resp[] = "The <span class=\"$field_class\">$field</span> field needs to be exactly $param character in length";
					} else {
						$resp[] = "The <span class=\"$field_class\">$field</span> field needs to be exactly $param characters in length";
					}
					break;
				case 'validate_alpha':
					$resp[] = "The <span class=\"$field_class\">$field</span> field may only contain alpha characters(a-z)";
					break;
				case 'validate_alpha_numeric':
					$resp[] = "The <span class=\"$field_class\">$field</span> field may only contain alpha-numeric characters";
					break;
				case 'validate_alpha_dash':
					$resp[] = "The <span class=\"$field_class\">$field</span> field may only contain alpha characters &amp; dashes";
					break;
				case 'validate_numeric':
					$resp[] = "The <span class=\"$field_class\">$field</span> field may only contain numeric characters";
					break;
				case 'validate_integer':
					$resp[] = "The <span class=\"$field_class\">$field</span> field may only contain a numeric value";
					break;
				case 'validate_boolean':
					$resp[] = "The <span class=\"$field_class\">$field</span> field may only contain a true or false value";
					break;
				case 'validate_float':
					$resp[] = "The <span class=\"$field_class\">$field</span> field may only contain a float value";
					break;
				case 'validate_valid_url':
					$resp[] = "The <span class=\"$field_class\">$field</span> field is required to be a valid URL";
					break;
				case 'validate_url_exists':
					$resp[] = "The <span class=\"$field_class\">$field</span> URL does not exist";
					break;
				case 'validate_valid_ip':
					$resp[] = "The <span class=\"$field_class\">$field</span> field needs to contain a valid IP address";
					break;
				case 'validate_valid_cc':
					$resp[] = "The <span class=\"$field_class\">$field</span> field needs to contain a valid credit card number";
					break;
				case 'validate_valid_name':
					$resp[] = "The <span class=\"$field_class\">$field</span> field needs to contain a valid human name";
					break;
				case 'validate_contains':
					$resp[] = "The <span class=\"$field_class\">$field</span> field needs contain one of these values: ".implode(', ', $param);
					break;
				case 'validate_street_address':
					$resp[] = "The <span class=\"$field_class\">$field</span> field needs to be a valid street address";
					break;
			}
		}		
		
		if(!$convert_to_string) {
			return $resp;
		} else {
			$buffer = '';
			foreach($resp as $s) {
				$buffer .= "<span class=\"$error_class\">$s</span>";
			}
			return $buffer;
		}
	}
	
	/**
	 * Filter the input data according to the specified filter set 
	 * 
	 * @access public
	 * @param  mixed $input
	 * @param  array $filterset
	 * @return mixed
	 */
	public function filter(array $input, array $filterset)
	{
		foreach($filterset as $field => $filters)
		{
			if(!array_key_exists($field, $input))
			{
				continue;
			}

			$filters = explode('|', $filters);

			foreach($filters as $filter)
			{	
				$params = NULL;
				
				if(strstr($filter, ',') !== FALSE)
				{
					$filter = explode(',', $filter);
					
					$params = array_slice($filter, 1, count($filter) - 1);
					
					$filter = $filter[0];
				}
				
				if(is_callable(array($this, 'filter_'.$filter)))
				{
					$method = 'filter_'.$filter;
					$input[$field] = $this->$method($input[$field], $params);
				}
				else if(function_exists($filter))
				{
					$input[$field] = $filter($input[$field]);
				}
				else
				{
					throw new Exception("Filter method '$filter' does not exist.");
				}
			}
		}	
		
		return $input;
	}
	
	// ** ------------------------- Filters --------------------------------------- ** //
	
	/**
	 * Replace noise words in a string (http://tax.cchgroup.com/help/Avoiding_noise_words_in_your_search.htm)
	 * 
	 * Usage: '<index>' => 'noise_words'
	 *	
	 * @access protected
	 * @param  string $value
	 * @param  array $params
	 * @return string
	 */
	protected function filter_noise_words($value, $params = NULL)
	{
		$value = preg_replace('/\s\s+/u', chr(32),$value);
		
		$value = " $value ";
				
		$words = explode(',', self::$en_noise_words);
		
		foreach($words as $word)
		{
			$word = trim($word);
			
			$word = " $word "; // Normalize
			
			if(stripos($value, $word) !== FALSE)
			{
				$value = str_ireplace($word, chr(32), $value);
			}
		}

		return trim($value);
	}
	
	/**
	 * Remove all known punctuation from a string
	 * 
	 * Usage: '<index>' => 'rmpunctuataion'
	 *	
	 * @access protected
	 * @param  string $value
	 * @param  array $params
	 * @return string
	 */
	protected function filter_rmpunctuation($value, $params = NULL)
	{
		return preg_replace("/(?![.=$'€%-])\p{P}/u", '', $value);
	}
	
	/**
	 * Translate an input string to a desired language [DEPRECIATED]
	 *
	 * Any ISO 639-1 2 character language code may be used 
	 *
	 * See: http://www.science.co.il/language/Codes.asp?s=code2
	 *
	 * @access protected
	 * @param  string $value
	 * @param  array $params
	 * @return string
	 */
	/*
	protected function filter_translate($value, $params = NULL)
	{
		$input_lang  = 'en';
		$output_lang = 'en';
		
		if(is_null($params))
		{
			return $value;
		}
		
		switch(count($params))
		{
			case 1:
				$input_lang  = $params[0];
				break;
			case 2:
				$input_lang  = $params[0];
				$output_lang = $params[1];
				break;
		}
		
		$text = urlencode($value);

		$translation = file_get_contents(
			"http://ajax.googleapis.com/ajax/services/language/translate?v=1.0&q={$text}&langpair={$input_lang}|{$output_lang}" 
		);
		
		$json = json_decode($translation, true);
		
		if($json['responseStatus'] != 200)
		{
			return $value;
		}
		else
		{
			return $json['responseData']['translatedText'];
		}		
	}
	*/
		
	/**
	 * Sanitize the string by removing any script tags
	 * 
	 * Usage: '<index>' => 'sanitize_string'
	 *	
	 * @access protected
	 * @param  string $value
	 * @param  array $params
	 * @return string
	 */
	protected function filter_sanitize_string($value, $params = NULL)
	{
		return filter_var($value, FILTER_SANITIZE_STRING);
	}
	
	/**
	 * Sanitize the string by urlencoding characters
	 * 
	 * Usage: '<index>' => 'urlencode'
	 *	
	 * @access protected
	 * @param  string $value
	 * @param  array $params	
	 * @return string
	 */
	protected function filter_urlencode($value, $params = NULL)
	{
		return filter_var($value, FILTER_SANITIZE_ENCODED);  
	}
	
	/**
	 * Sanitize the string by converting HTML characters to their HTML entities
	 * 
	 * Usage: '<index>' => 'htmlencode'
	 *	
	 * @access protected
	 * @param  string $value
	 * @param  array $params
	 * @return string
	 */
	protected function filter_htmlencode($value, $params = NULL)
	{
		return filter_var($value, FILTER_SANITIZE_SPECIAL_CHARS);  
	}
	
	/**
	 * Sanitize the string by removing illegal characters from emails
	 * 
	 * Usage: '<index>' => 'sanitize_email'
	 *	
	 * @access protected
	 * @param  string $value
	 * @param  array $params
	 * @return string
	 */
	protected function filter_sanitize_email($value, $params = NULL)
	{
		return filter_var($value, FILTER_SANITIZE_EMAIL);  
	}
	
	/**
	 * Sanitize the string by removing illegal characters from numbers
	 * 
	 * @access protected
	 * @param  string $value
	 * @param  array $params
	 * @return string
	 */
	protected function filter_sanitize_numbers($value, $params = NULL)
	{
		return filter_var($value, FILTER_SANITIZE_NUMBER_INT);  
	}
	
	/**
	 * Filter out all HTML tags except the defined basic tags
	 * 
	 * @access protected
	 * @param  string $value
	 * @param  array $params
	 * @return string
	 */	
	protected function filter_basic_tags($value, $params = NULL)
	{
		return strip_tags($value, self::$basic_tags);
	}
	
	/**
	 * Filter out all SQL Valnurablities 
	 * 
	 * @access protected
	 * @param  string $value
	 * @param  array $params
	 * @return string
	 */	
	protected function filter_mysql_escape($value, $params = NULL)
	{
		return mysql_real_escape_string($value);
	}

	
	// ** ------------------------- Validators ------------------------------------ ** //	
	
	/**
	 * Verify that a value is contained within the pre-defined value set
	 * 
	 * Usage: '<index>' => 'contains,value value value'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_contains($field, $input, $param = NULL)
	{
		$param = trim(strtolower($param));
		
		$value = trim(strtolower($input[$field]));
		
		if (preg_match_all('#\'(.+?)\'#', $param, $matches, PREG_PATTERN_ORDER)) {
			$param = $matches[1];
		} else  {
			$param = explode(chr(32), $param);
		}

		if(in_array($value, $param)) { // valid, return nothing
			return;
		} else {
			return array(
				'field' => $field,
				'value' => $value,
				'rule'	=> __FUNCTION__,
				'param' => $param
			);			
		}
	}	
	
	/**
	 * Check if the specified key is present and not empty
	 * 
	 * Usage: '<index>' => 'required'
	 *
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_required($field, $input, $param = NULL)
	{
		if(isset($input[$field]) && trim($input[$field]) != '')
		{
			return;
		}
		else
		{
			return array(
				'field' => $field,
				'value' => NULL,
				'rule'	=> __FUNCTION__,
				'param' => $param
			);
		}
	}
	
	/**
	 * Determine if the provided email is valid
	 * 
	 * Usage: '<index>' => 'valid_email'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_valid_email($field, $input, $param = NULL)
	{
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
	
		if(!filter_var($input[$field], FILTER_VALIDATE_EMAIL))
		{
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param				
			);
		}
	}
	
	/**
	 * Determine if the provided value length is less or equal to a specific value
	 * 
	 * Usage: '<index>' => 'max_len,240'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_max_len($field, $input, $param = NULL)
	{
		if(!isset($input[$field]))
		{
			return;
		}
		
		if(function_exists('mb_strlen'))
		{
			if(mb_strlen($input[$field]) <= (int)$param)
			{
				return;
			}
		}
		else
		{
			if(strlen($input[$field]) <= (int)$param)
			{
				return;
			}
		}

		return array(
			'field' => $field,
			'value' => $input[$field],
			'rule'	=> __FUNCTION__,
			'param' => $param
		);		
	}
	
	/**
	 * Determine if the provided value length is more or equal to a specific value
	 * 
	 * Usage: '<index>' => 'min_len,4'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_min_len($field, $input, $param = NULL)
	{
		if(!isset($input[$field]))
		{
			return;
		}
		
		if(function_exists('mb_strlen'))
		{
			if(mb_strlen($input[$field]) >= (int)$param)
			{
				return;
			}
		}
		else
		{
			if(strlen($input[$field]) >= (int)$param)
			{
				return;
			}
		}

		return array(
			'field' => $field,
			'value' => $input[$field],
			'rule'	=> __FUNCTION__,
			'param' => $param			
		);
	}
	
	/**
	 * Determine if the provided value length matches a specific value
	 * 
	 * Usage: '<index>' => 'exact_len,5'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_exact_len($field, $input, $param = NULL)
	{
		if(!isset($input[$field]))
		{
			return;
		}

		if(function_exists('mb_strlen'))
		{
			if(mb_strlen($input[$field]) == (int)$param)
			{
				return;
			}
		}
		else
		{
			if(strlen($input[$field]) == (int)$param)
			{
				return;
			}
		}

		return array(
			'field' => $field,
			'value' => $input[$field],
			'rule'	=> __FUNCTION__,
			'param' => $param			
		);
	}
	
	/**
	 * Determine if the provided value contains only alpha characters
	 * 
	 * Usage: '<index>' => 'alpha'
	 *
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_alpha($field, $input, $param = NULL)
	{
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
		
		if(!preg_match("/^([a-zÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðòóôõöùúûüýÿ])+$/i", $input[$field]) !== FALSE)
		{
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param				
			);
		}
	}
	
	/**
	 * Determine if the provided value contains only alpha-numeric characters
	 * 
	 * Usage: '<index>' => 'alpha_numeric'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */	
	protected function validate_alpha_numeric($field, $input, $param = NULL)
	{	
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
		
		if(!preg_match("/^([a-z0-9ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðòóôõöùúûüýÿ])+$/i", $input[$field]) !== FALSE)
		{
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param				
			);
		}
	}
	
	/**
	 * Determine if the provided value contains only alpha characters with dashed and underscores
	 * 
	 * Usage: '<index>' => 'alpha_dash'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_alpha_dash($field, $input, $param = NULL)
	{
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
		
		if(!preg_match("/^([a-z0-9ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðòóôõöùúûüýÿ_-])+$/i", $input[$field]) !== FALSE)
		{
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param				
			);
		}
	}
	
	/**
	 * Determine if the provided value is a valid number or numeric string
	 * 
	 * Usage: '<index>' => 'numeric'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_numeric($field, $input, $param = NULL)
	{
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
		
		if(!is_numeric($input[$field]))
		{
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param				
			);
		}
	}
	
	/**
	 * Determine if the provided value is a valid integer
	 * 
	 * Usage: '<index>' => 'integer'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_integer($field, $input, $param = NULL)
	{
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
		
		if(!filter_var($input[$field], FILTER_VALIDATE_INT))
		{
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param				
			);
		}
	}
	
	/**
	 * Determine if the provided value is a PHP accepted boolean
	 * 
	 * Usage: '<index>' => 'boolean'
	 *
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_boolean($field, $input, $param = NULL)
	{
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
		
		$bool = filter_var($input[$field], FILTER_VALIDATE_BOOLEAN);
		
		if(!is_bool($bool))
		{
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param				
			);
		}
	}
	
	/**
	 * Determine if the provided value is a valid float
	 * 
	 * Usage: '<index>' => 'float'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_float($field, $input, $param = NULL)
	{
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
		
		if(!filter_var($input[$field], FILTER_VALIDATE_FLOAT))
		{
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param				
			);
		}
	}
	
	/**
	 * Determine if the provided value is a valid URL
	 * 
	 * Usage: '<index>' => 'valid_url'
	 *
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_valid_url($field, $input, $param = NULL)
	{
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
		
		if(!filter_var($input[$field], FILTER_VALIDATE_URL))
		{
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param				
			);
		}
	}
	
	/**
	 * Determine if a URL exists & is accessible
	 *
	 * Usage: '<index>' => 'url_exists'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_url_exists($field, $input, $param = NULL)
	{
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
		
		$url = str_replace(
			array('http://', 'https://', 'ftp://'), '', strtolower($input[$field])
		);

		if(function_exists('checkdnsrr'))
		{
			if(!checkdnsrr($url))
			{
				return array(
					'field' => $field,
					'value' => $input[$field],
					'rule'	=> __FUNCTION__,
					'param' => $param					
				);
			}	
		}
		else
		{
			if(gethostbyname($url) == $url)
			{
				return array(
					'field' => $field,
					'value' => $input[$field],
					'rule'	=> __FUNCTION__,
					'param' => $param					
				);
			}
		}
	}
	
	/**
	 * Determine if the provided value is a valid IP address
	 * 
	 * Usage: '<index>' => 'valid_ip'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_valid_ip($field, $input, $param = NULL)
	{
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
		
		if(!filter_var($input[$field], FILTER_VALIDATE_IP) !== FALSE)
		{
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param				
			);
		}
	}
	
	/**
	 * Determine if the provided value is a valid IPv4 address
	 * 
	 * Usage: '<index>' => 'valid_ipv4'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_valid_ipv4($field, $input, $param = NULL)
	{
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
		
		if(!filter_var($input[$field], FILTER_VALIDATE_IP, FILTER_FLAG_IPV4) !== FALSE)
		{
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param				
			);
		}
	}	
	
	/**
	 * Determine if the provided value is a valid IPv6 address
	 * 
	 * Usage: '<index>' => 'valid_ipv6'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_valid_ipv6($field, $input, $param = NULL)
	{
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
		
		if(!filter_var($input[$field], FILTER_VALIDATE_IP, FILTER_FLAG_IPV6) !== FALSE)
		{
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param				
			);
		}
	}	
	
	/**
	 * Determine if the input is a valid credit card number 
	 *
	 * See: http://stackoverflow.com/questions/174730/what-is-the-best-way-to-validate-a-credit-card-in-php
	 * Usage: '<index>' => 'valid_cc'	
	 * 
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_valid_cc($field, $input, $param = NULL)
	{
		if(!isset($input[$field]) || empty($input[$field]))
		{
			return;
		}
		
		$number = preg_replace('/\D/', '', $input[$field]);		
		
		if(function_exists('mb_strlen'))
		{
			$number_length = mb_strlen($input[$field]);
		}
		else
		{
			$number_length = strlen($input[$field]);
		}		
	
	  	$parity = $number_length % 2;
	
	 	$total = 0;
	
	  	for($i = 0; $i < $number_length; $i++) 
		{
	    	$digit = $number[$i];

	    	if ($i % 2 == $parity) 
			{
	      		$digit *= 2;
	
	      		if ($digit > 9) 
				{
	        		$digit -= 9;
	      		}
	    	}

	    	$total += $digit;
	  	}	
	
		if($total % 10 == 0)
		{
			return; // Valid
		}
		else
		{
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param				
			);
		}
	}
	
	/**
	 * Determine if the input is a valid human name [Credits to http://github.com/ben-s]
	 *
	 * See: https://github.com/Wixel/GUMP/issues/5
	 * Usage: '<index>' => 'valid_name'
	 * 
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_valid_name($field, $input, $param = NULL)
	{
		if(!isset($input[$field])|| empty($input[$field]))
		{
			return;
		}
		
	    if(!preg_match("/^([a-zÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïñðòóôõöùúûüýÿ '-])+$/i", $input[$field]) !== FALSE)
	    {
	        return array(
	            'field' => $field,
	            'value' => $input[$field],
	            'rule'  => __FUNCTION__,
				'param' => $param	
	        );
	    }
	}
	
	/**
	 * Determine if the provided input is likely to be a street address using weak detection
	 * 
	 * Usage: '<index>' => 'street_address'
	 *	
	 * @access protected
	 * @param  string $field
	 * @param  array $input
	 * @return mixed
	 */
	protected function validate_street_address($field, $input, $param = NULL)
	{	
		if(!isset($input[$field])|| empty($input[$field]))
		{
			return;
		}
		
		// Theory: 1 number, 1 or more spaces, 1 or more words
		$hasLetter = preg_match('/[a-zA-Z]/', $input[$field]);
		$hasDigit  = preg_match('/\d/'      , $input[$field]);
		$hasSpace  = preg_match('/\s/'      , $input[$field]);
		
		$passes = $hasLetter && $hasDigit && $hasSpace;
				
		if(!$passes) {
			return array(
				'field' => $field,
				'value' => $input[$field],
				'rule'	=> __FUNCTION__,
				'param' => $param
			);
		}
	}	
	
} // EOC

<?php
include_once("init.php");

?>
<!DOCTYPE html>

<html lang="en">
<head>
	<meta charset="utf-8">
	<title>POSNIC - Add Stock Category</title>
	
	<!-- Stylesheets -->
	<link href='http://fonts.googleapis.com/css?family=Droid+Sans:400,700' rel='stylesheet'>
	<link rel="stylesheet" href="css/style.css">
        <link rel="stylesheet" href="js/date_pic/date_input.css">
        <link rel="stylesheet" href="lib/auto/css/jquery.autocomplete.css">
	
	<!-- Optimize for mobile devices -->
	<meta name="viewport" content="width=device-width, initial-scale=1.0"/>
	
	<!-- jQuery & JS files -->
	<?php include_once("tpl/common_js.php"); ?>
	<script src="js/script.js"></script>  
        <script src="js/date_pic/jquery.date_input.js"></script>  
        <script src="lib/auto/js/jquery.autocomplete.js "></script>  
 
		<script>
	/*$.validator.setDefaults({
		submitHandler: function() { alert("submitted!"); }
	});*/
	$(document).ready(function() {
		$("#supplier").autocomplete("supplier1.php", {
		width: 160,
		autoFill: true,
		selectFirst: true
	});
		$("#category").autocomplete("category.php", {
		width: 160,
		autoFill: true,
		selectFirst: true
	});
		// validate signup form on keyup and submit
		$("#form1").validate({
			rules: {
				name: {
					required: true,
					minlength: 3,
					maxlength: 200
				},
				stockid: {
					required: true,
					minlength: 3,
					maxlength: 200
				},
				cost: {
					required: true,
					
				},
				sell: {
					required: true,
					
				}
			},
			messages: {
				name: {
					required: "Please Enter Stock Name",
					minlength: "Category Name must consist of at least 3 characters"
				},
				stockid: {
					required: "Please Enter Stock ID",
					minlength: "Category Name must consist of at least 3 characters"
				},
				sell: {
					required: "Please Enter Selling Price",
					minlength: "Category Name must consist of at least 3 characters"
				},
				cost: {
					required: "Please Enter Cost Price",
					minlength: "Category Name must consist of at least 3 characters"
				}
			}
		});
	
	});
function numbersonly(e){
        var unicode=e.charCode? e.charCode : e.keyCode
        if (unicode!=8 && unicode!=46 && unicode!=37 && unicode!=38 && unicode!=39 && unicode!=40 && unicode!=9){ //if the key isn't the backspace key (which we should allow)
        if (unicode<48||unicode>57)
        return false
    }
    }
	</script>
	</script>

</head>
<body>

	<!-- TOP BAR -->
	<?php include_once("tpl/top_bar.php"); ?>
	<!-- end top-bar -->
	
	
	
	<!-- HEADER -->
	<div id="header-with-tabs">
		
		<div class="page-full-width cf">
	
			<ul id="tabs" class="fl">
				<li><a href="dashboard.php" class="dashboard-tab">Dashboard</a></li>
				<li><a href="view_sales.php" class="sales-tab">Sales</a></li>
				<li><a href="view_customers.php" class=" customers-tab">Customers</a></li>
				<li><a href="view_purchase.php" class="purchase-tab">Purchase</a></li>
				<li><a href="view_supplier.php" class=" supplier-tab">Supplier</a></li>
				<li><a href="view_product.php" class="active-tab stock-tab">Stocks / Products</a></li>
				<li><a href="view_payments.php" class="payment-tab">Payments / Outstandings</a></li>
				<li><a href="view_report.php" class="report-tab">Reports</a></li>
			</ul> <!-- end tabs -->
			
			<!-- Change this image to your own company's logo -->
			<!-- The logo will automatically be resized to 30px height. -->
			<a href="#" id="company-branding-small" class="fr"><img src="<?php if(isset($_SESSION['logo'])) { echo "upload/".$_SESSION['logo'];}else{ echo "upload/posnic.png"; } ?>" alt="Point of Sale" /></a>
			
		</div> <!-- end full-width -->	

	</div> <!-- end header -->
	
	
	
	<!-- MAIN CONTENT -->
	<div id="content">
		
		<div class="page-full-width cf">

			<div class="side-menu fl">
				
				<h3>Stock Management</h3>
				<ul>
					<li><a href="add_stock.php">Add Stock/Product</a></li>
					<li><a href="view_product.php">View Stock/Product</a></li>
					<li><a href="add_category.php">Add Stock Category</a></li>
					<li><a href="view_category.php">view Stock Category</a></li>
                                        <li><a href="view_stock_availability.php">view Stock Available</a></li>
				
                                  
                                </ul>
                               
                                
			</div> <!-- end side-menu -->
                        
			<div class="side-content fr">
			
				<div class="content-module">
				
					<div class="content-module-heading cf">
					
						<h3 class="fl">Add Stock </h3>
						<span class="fr expand-collapse-text">Click to collapse</span>
                                                <div style="margin-top: 15px;margin-left: 150px"></div>
						<span class="fr expand-collapse-text initial-expand">Click to expand</span>
					
					</div> <!-- end content-module-heading -->
					
						<div class="content-module-main cf">
				
							
					<?php
					//Gump is libarary for Validatoin
					
					if(isset($_POST['name'])){
					$_POST = $gump->sanitize($_POST);
					$gump->validation_rules(array(
						'name'    	  => 'required|max_len,100|min_len,3',
						'stockid'     => 'required|max_len,200',
						'sell'     => 'required|max_len,200',
						'cost'     => 'required|max_len,200',
						'supplier'     => 'max_len,200',
						'category'     => 'max_len,200'

					));
				
					$gump->filter_rules(array(
						'name'    	  => 'trim|sanitize_string|mysql_escape',
						'stockid'     => 'trim|sanitize_string|mysql_escape',
						'sell'     => 'trim|sanitize_string|mysql_escape',
						'cost'     => 'trim|sanitize_string|mysql_escape',
						'category'     => 'trim|sanitize_string|mysql_escape',
						'supplier'     => 'trim|sanitize_string|mysql_escape'

					));
				
					$validated_data = $gump->run($_POST);
					$name 		= "";
					$stockid 	= "";
					$sell           = "";
					$cost    	= "";
					$supplier 	= "";
					$category 	= "";
			

					if($validated_data === false) {
							echo $gump->get_readable_errors(true);
					} else {
						
						
							$name=mysql_real_escape_string($_POST['name']);
							$stockid=mysql_real_escape_string($_POST['stockid']);
							$sell=mysql_real_escape_string($_POST['sell']);
							$cost=mysql_real_escape_string($_POST['cost']);
							$supplier=mysql_real_escape_string($_POST['supplier']);
							$category=mysql_real_escape_string($_POST['category']);
							
						
						$count = $db->countOf("stock_details", "stock_name ='$name'");
		if($count>1)
			{
	        $data='Dublicat Entry. Please Verify';
                                            $msg='<p style=color:red;font-family:gfont-family:Georgia, Times New Roman, Times, serif>'.$data.'</p>';//
                                            ?>
                                                    
 <script  src="dist/js/jquery.ui.draggable.js"></script>
<script src="dist/js/jquery.alerts.js"></script>
<script src="dist/js/jquery.js"></script>
<link rel="stylesheet"  href="dist/js/jquery.alerts.css" >
                                                  
                                            <script type="text/javascript">
	
					jAlert('<?php echo  $msg; ?>', 'POSNIC');
			
</script>
                                                        <?php
			}
			else
			{
				
			if($db->query("insert into stock_details(stock_id,stock_name,stock_quatity,supplier_id,company_price,selling_price,category) values('$stockid','$name',0,'$supplier',$cost,$sell,'$category')"))
			{ 
				$db->query("insert into stock_avail(name,quantity) values('$name',0)");
                                  $msg=" $name Stock Details Added" ;
				header("Location: add_stock.php?msg=$msg");
                        }else
			echo "<br><font color=red size=+1 >Problem in Adding !</font>" ;
			
			}
			
			
			}
							
							}
						
				if(isset($_GET['msg'])){
                                             $data=$_GET['msg'];
                                            $msg='<p style=color:#153450;font-family:gfont-family:Georgia, Times New Roman, Times, serif>'.$data.'</p>';//
                                            ?>
                                                    
 <script  src="dist/js/jquery.ui.draggable.js"></script>
<script src="dist/js/jquery.alerts.js"></script>
<script src="dist/js/jquery.js"></script>
<link rel="stylesheet"  href="dist/js/jquery.alerts.css" >
                                                  
                                            <script type="text/javascript">
	
					jAlert('<?php echo  $msg; ?>', 'POSNIC');
			
</script>
                                                        <?php
                                         }
				
				?>
				
				<form name="form1" method="post" id="form1" action="">
                  
                
                  <table class="form"  border="0" cellspacing="0" cellpadding="0">
                    <tr>
                          <?php
					  $max = $db->maxOfAll("id", "stock_details");
					  $max=$max+1;
					  $autoid="SD".$max."";
					  ?>
                      <td><span class="man">*</span>Stock ID:</td>
                      <td><input name="stockid" type="text" id="stockid" readonly maxlength="200"  class="round default-width-input" value="<?php echo $autoid; ?>" /></td>
                       
                      <td><span class="man">*</span>Name:</td>
                      <td><input name="name"placeholder="ENTER CATEGORY NAME" type="text" id="name" maxlength="200"  class="round default-width-input" value="<?php echo $name; ?>" /></td>
                       
                    </tr>
                    <tr>
                      <td><span class="man">*</span>Cost:</td>
                      <td><input name="cost" placeholder="ENTER COST PRICE" type="text" id="cost"  maxlength="200"  class="round default-width-input" onkeypress="return numbersonly(event)" value="<?php echo $cost; ?>" /></td>
                       
                      <td><span class="man">*</span>Sell:</td>
                      <td><input name="sell" placeholder="ENTER SELLING PRICE" type="text" id="sell" maxlength="200"  class="round default-width-input" onkeypress="return numbersonly(event)" value="<?php echo $sell; ?>" /></td>
                       
                    </tr>
                    <tr>
                      <td>Supplier:</td>
                      <td><input name="supplier" placeholder="ENTER SUPPLIER NAME" type="text" id="supplier"  maxlength="200"  class="round default-width-input" value="<?php echo $supplier; ?>" /></td>
                       
                      <td>Category:</td>
                      <td><input name="category" placeholder="ENTER CATEGORY NAME" type="text" id="category" maxlength="200"  class="round default-width-input" value="<?php echo $category; ?>" /></td>
                       
                    </tr>
                   
                    <tr>
                      <td>&nbsp;</td>
                      <td>&nbsp;</td>
                    </tr>
                    
                    
                    <tr>
                      <td>&nbsp;
					 
					  </td>
                      <td>
                        <input  class="button round blue image-right ic-add text-upper" type="submit" name="Submit" value="Add">
						(Control + S)
					  
					  <td align="right"><input class="button round red   text-upper"  type="reset" name="Reset" value="Reset"> </td>
                    </tr>
                  </table>
                </form>  
						
				
					</div> <!-- end content-module-main -->
							
				
				</div> <!-- end content-module -->
				
				
		
		</div> <!-- end full-width -->
		  	
	</div> <!-- end content -->
	
	
	
	<!-- FOOTER -->
	<div id="footer">
        
		<p>Any Queries email to <a href="mailto:sridhar.posnic@gmail.com?subject=Stock%20Management%20System">sridhar.posnic@gmail.com</a>.</p>
	
	</div> <!-- end footer -->

</body>
</html>