Jump to content

Fatal error: Uncaught mysqli_sql_exception:

phpsane

By phpsane
in PHP Coding Help

Recommended Posts

phpsane Advanced Member

phpsane

Posted
Posted

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> 
    </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>

I get:

Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?' at line 1 in C:\xampp\htdocs\test\following_histories_v1.php:418 Stack trace: #0 C:\xampp\htdocs\test\following_histories_v1.php(418): mysqli_query(Object(mysqli), 'SELECT id,date_...') #1 {main} thrown in C:\xampp\htdocs\test\following_histories_v1.php on line 418

What is wrong ? I don't see any syntax error in the QUERIES.

Anyway, can anyone be kind enough to edit my first script and turn it into PREP STMT script using mysqli procedural style like my attempt in my 2nd script so I can learn from you ? I don't know pdo or oop yet.

Link to comment
Share on other sites
phpsane Advanced Member

phpsane

Posted
  • Author
Posted
12 hours ago, kicken said:

You're apparently trying to call mysqli_query with a query that has placeholders.  You can't do that, if you want to use placeholders then you have to use mysqli_prepare then bind your parameters, then mysqli_stmt_execute.

 

Oh!

But I wrote the mysqli_prepare in the 2nd line. You saying that is incorrect as mysqli_prepare should be in the 1st line with the $query ? If so, then how come you aswell as others here and in other forums like the Devshed forum never brought this to my attention ever before ? Because what you see here is how I have been doing prepared statements in all my threads and posts on many forums including this one and DevShed for over a yr now and no-one said (not even Requinix and Barand who been helping me out here and Devshed like you) what you are saying now to bring this issue to my attention. How come everyone failed to spot it until you came along now ?

Look at the final block of code on this post (you been helping me out there) and you will see I did the same there back then too:

http://forums.devshed.com/php-development/980129-converting-pagination-procedural-style-code-prep-stmt-post2984322.html#post2984322

Yes, surprise surprise, I am continuing my works here on this forum now as I find my password doesn't work in Devhed any more. I smell Requinix banned me without an explanation there.

Anyway, do show me a sample code how it should be done and how you do it because what you see here and on Devshed is the only way I know how to do prepared statement.

I have a feeling you mean I should do something like this: 

$stmt = mysqli_prepare($conn,"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 = ?";); 

Right ?

@Requinix & @Barand: What are your inputs here ?

 

Thanks to all 3 of you!

Link to comment
Share on other sites
requinix Prolific Member

requinix

Posted
Posted
5 hours ago, phpsane said:

Yes, surprise surprise, I am continuing my works here on this forum now as I find my password doesn't work in Devhed any more. I smell Requinix banned me without an explanation there.

You were told to stop bringing that up. Clearly you need a stronger message...

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.