PHP - Php Fatal Error: Uncaught Error: Object Of Class Datetime Could Not Be Converted To String

Gett an error from some custom code I inherited in a WordPress installation.

Here is the error...

Code: [Select]
Fatal error: Uncaught exception 'Exception' with message 'DateTime::__construct() [<a href='datetime.--construct'>datetime.--construct</a>]: Failed to parse time string (--) at position 0 (-): Unexpected character' in /home2/history8/public_html/bee/wp-content/themes/makinghistoryblue/beeteachers.php:27 Stack trace: #0 /home2/history8/public_html/bee/wp-content/themes/makinghistoryblue/beeteachers.php(27): DateTime->__construct('--') #1 /home2/history8/public_html/bee/wp-includes/plugin.php(395): bee_teachers('') #2 /home2/history8/public_html/bee/wp-admin/admin.php(151): do_action('bee_teachers', Array) #3 {main} thrown in /home2/history8/public_html/bee/wp-content/themes/makinghistoryblue/beeteachers.php on line 27
Here is the code...

Code: [Select]
<?php
$teachers = $wpdb->get_results("SELECT * FROM bee_teachers,bee_postmeta WHERE bee_teachers.statebee=bee_postmeta.post_id and meta_key='regional_date' ORDER BY meta_value ASC");
$today = new DateTime();
foreach ($teachers as $teacher):
$site = get_post($teacher->statebee)->post_title;
$date = new DateTime($teacher->meta_value); // this is line 27, mentioned in the error
if($date<$today) $style=' style="color:#999"';
else $style='';
?>
If I remm out these lines, the query works, just no styling difference based upon date...

Code: [Select]
$date = new DateTime($teacher->meta_value); // this is line 27, mentioned in the error
if($date<$today) $style=' style="color:#999"';
else $style='';
Thoughts?

Hello all,   Appreciate if you folks could pls. help me understand (and more importantly resolve) this very weird error:     Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC, purchase_later_flag ASC, shopper1_buy_flag AS' at line 3' in /var/www/index.php:67 Stack trace: #0 /var/www/index.php(67): PDO->query('SELECT shoplist...') #1 {main} thrown in /var/www/index.php on line 67   Everything seems to work fine when/if I use the following SQL query (which can also be seen commented out in my code towards the end of this post) :  

$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
           FROM shoplist, store_master, item_master
           WHERE     shoplist.store_id = store_master.store_id
                   AND shoplist.item_id = item_master.item_id";

  However, the moment I change my query to the following, which essentially just includes/adds the ORDER BY clause, I receive the error quoted above:

$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name 
		FROM shoplist, store_master, item_master 
		ORDER BY purchased_flag ASC, 
				purchase_later_flag ASC, 
				shopper1_buy_flag ASC, 
				shopper2_buy_flag ASC, 
				store_name ASC) 
		WHERE 	shoplist.store_id = store_master.store_id 
				AND shoplist.item_id = item_master.item_id";

In googling for this error I came across posts that suggested using "ORDER BY FIND_IN_SET()" and "ORDER BY FIELD()"...both of which I tried with no success.   Here's the portion of my code which seems to have a problem, and line # 67 is the 3rd from bottom (third last) statement in the code below:  

                    <?php
                        /*
                        $sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
                                FROM shoplist, store_master, item_master
                                WHERE     shoplist.store_id = store_master.store_id
                                        AND shoplist.item_id = item_master.item_id";
                        */
                    
                        $sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
                                FROM shoplist, store_master, item_master
                                ORDER BY FIND_IN_SET(purchased_flag ASC,
                                                 purchase_later_flag ASC,
                                                 shopper1_buy_flag ASC,
                                                 shopper2_buy_flag ASC,
                                                 store_name ASC)
                                WHERE     shoplist.store_id = store_master.store_id
                                        AND shoplist.item_id = item_master.item_id";
                        $result = $pdo->query($sql);                        
                        
                        // foreach ($pdo->query($sql) as $row) {
                        foreach ($result as $row) {
                            echo '<tr>';
                                print '<td><span class="filler-checkbox"><input type="checkbox" name="IDnumber[]" value="' . $row["idnumber"] . '" /></span></td>';

    Thanks  

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

 

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
 

I'm receiving the error "Object of class player could not be converted to string" yet I cannot find why what I'm inputting is an object and not a string. As far as I can see it is a string and this error shouldn't be happening, yet it is...

A form submits to a page which gets the data thus:
Code: [Select]
<?php
case "updplayer":
if(!isset($_GET['id']) || !isset($_POST['kit']) || !isset($_POST['level']) || !isset($_POST['group']) || !isset($_POST['state'])) {
header("location:admin.php?mode=settings&error=info&sid=$user->sid");
exit;
}
$var = "player" . $_GET['id'];
$$var->kit = mysql_real_escape_string($_POST['kit']);
$$var->level = mysql_real_escape_string($_POST['level']);
$$var->group = mysql_real_escape_string($_POST['group']);
$$var->state = mysql_real_escape_string($_POST['state']);
$$var->update();
header("location:admin.php?sid=$user->sid");
exit;
break;

The update function is:
Code: [Select]
<?php
function update() {
echo "Name: $this->name <br />
Kit: $this->kit <br />
Level: $this->level <br />
Group: $this->group <br />
State: $this->state <br />";
$sql = "UPDATE `players` SET `name` = '" . $this->name . "', `preferredKit` = '" . $this-kit . "', `gamingLevel` = '" . $this->level . "', `group` = '" . $this->group . "', `draftState` = " . $this->state;
if(!mysql_query($sql)) {
return mysql_error();
}
return TRUE;
}

I added the echo's in for error checking. They output exactly what was expected. What is wrong with this? Error occurs on the "$sql = " line.

why do i keep getting this error from line 7?

Object of class stdClass could not be converted to string
Code: [Select]
<?php
include_once"../includes/db_connect.php";
$item_number="2";
$custom="54298";
$query=mysql_query("SELECT `prodID`, `quanity` FROM `cart` WHERE `sessID`='$custom'") or mysql_error();
while($cart=mysql_fetch_object($query)){
mysql_query("INSERT INTO  `orderItems` (  `id` ,  `orderInfoID` ,  `productID` ,  `quanity` ) VALUES ('',  '$item_number',  '$cart-> prodID',  '$cart->quanity');");
}
mysql_query("UPDATE `cart` SET `show`='1' WHERE `sessID`='$custom'");

?>

The following is an extract of PHP code I have interacting with a MySQL database and I keep getting the "object of class mysqli_result could not be converted to string" error on the line of code inside my loop. This is my code.

 

#This is just storing a single integer, a moduleID

$sqlmodID = mysqli_query($con,"select moduleID from module_details WHERE moduleName = '$moduleName' AND lecturerID = '$lecturerID'");
            

#This is a query to get relevant idNumbers            

$sqlstudent = "select idNum from user_info WHERE courseCode = '$courseCode'";

 

#Running the previous statement

$result = mysqli_query($con, $sqlstudent);

 

#Storing the statements results in an array 

$row = mysqli_fetch_array($result);

 

#I'm not sure if this line is necessary but it converts the array values into a string (I'm storing the ID's as strings as they contain numbers and letters)

$studentArray = array_map('strval', $row);

 

#The error flashes on my condition of this loop. I'm trying to take each element of my array, and enter it to my table, assigning each variable the same ModuleID.

for($i=0; $i < count($studentArray); $i++){
                mysqli_query($con,"insert into student_classlist VALUES ('$sqlmodID', '$studentArray')");
 }

 

Any help would be much appreciated. I hope I've explained my code sufficiently.

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 am preparing $begin and $end for DatePeriod() but I can't get passed this error "getting the error Recoverable fatal error: Object of class DateTime could not be converted to string".

$today = date("Y-m-d");
$datestop=$_POST['datestop'];
//echo "$today<br /><br />$datestop<br /><br />";
$begin = new DateTime("$today");
$end = new DateTime("$datestop");

 

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

In drive.php   public function insert($postBody, $optParams = array())

I just ran into grief while trying to store a DateTime object in the SESSION variable. When I tried to use the stored value I got the error message "The DateTime object has not been correctly initialized by its constructor."

I initially assumed that objects can't be stored in SESSION because there's no way to serialize and deserialize them for storage between scripts. But I've found posts by other people who have done this with without problems.

If it works for others, why isn't it working for me? Is there something special about the DateTime class that prevents the PHP engine from serializing it?

Here's a little script that demonstrates the problem (in PHP 5.2.5 under Windows XP):

Code: [Select]
<?php
session_start();

if ( key_exists( 'd', $_SESSION ) ) {
   $d = $_SESSION['d'];
   echo "<br/>The value of 'd' is " . $d->format('m/d/Y');
}
else {
   echo "'d' has no value yet.";
}

$d = new DateTime('2011-08-01');
$_SESSION['d'] = $d;

$e = $_SESSION['d'];
echo "<br/>The value of 'd' has been set to  " . $e->format('m/d/Y');

?>
The first time the script is run it does not display "The value of 'd' is..." because $_SESSION['d'] does not exist. It sets the value, then retrieves it intact and displays it.

The second time the script is run it tries to retireve the value but apparently gets an invalid one and displays the error. Then it sets, retrieves, and displays the value again.

First i will show the code that activates the error:

Code: [Select]
if($current_host != null) {
print_r2("1");
print_r2($current_host);
print_r2($current_foundResult);
print_r2("2");
$current_host::addFoundResult($current_foundResult);
}

this is the output:

Quote

1

Host Object
(
    [hostname] => www.google.nl
    [foundResults] => Array
        (
        )

)

FoundResult Object
(
    [url] =>
    [title] =>
    [visits] =>
)

2


Fatal error: Using $this when not in object context in ~~~~~~~~~~~~~ on line 385



the error comes from this line:
      $this->foundResults[] = $foundResult;


Code: [Select]
class Host {

public $hostname;
public $foundResults;

public function __construct($hostname) {
$this->hostname = $hostname;
$this->foundResults = array();
}

public function addFoundResult($foundResult) {
$this->foundResults[] = $foundResult;
}
}
what i don't get about it is that both the Host Object and the FoundResult Object exist...

I get the error code "Fatal error: Using $this when not in object context in /home/feenetwo/public_html/language/english/mails/sale_third_party_notification.php on line 7" when I complete the form from the link in the screenshot atached...

the site is feenetwork.com and im getting really fustrated with it....

Can anyone help?

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!

Edited March 23 by Zserene