Jump to content

phpsane

Members
  • Content Count

    320
  • Joined

  • Last visited

Community Reputation

0 Neutral

About phpsane

  • Rank
    Advanced Member

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

573 profile views
  1. phpsane

    Mysqli - Can You Not Do These Short-Cuts ?

    I did not find these shortcuts I mention in the FM. Did you ?
  2. phpsane

    Fatal error: Uncaught mysqli_sql_exception:

    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!
  3. Long Version Associative Array: /* associative array */ $row = mysqli_fetch_array($result, MYSQLI_ASSOC); echo $row["name"]." ".$row["author_name"]." ".$row['price']; Short Version Associative Array: ($row = mysqli_fetch_assoc($result)) As in: while ($row = mysqli_fetch_assoc($result)) { echo $row["name"]." ".$row["class"]." ".$row['roll_no']."<br />"; Q1. Correct ? Q2. Long Version Numeric Array: /* numeric array */ $row = mysqli_fetch_array($result, MYSQLI_NUM); echo $row[0]." ".$row[1]." ".$row[2]; Can you not do short Version like this : ($row = mysqli_fetch_num($result)) As in: while ($row = mysqli_fetch_num($result)) { echo $row["name"]." ".$row["class"]." ".$row['roll_no']."<br />"; Q3. Long Version "Both": /* associative and numeric array */ $row = mysqli_fetch_array($result, MYSQLI_BOTH); echo $row[0]." ".$row["author_name"]." ".$row[2]; Can you not do short Version like this: ($row = mysqli_fetch_both($result)) As in: while ($row = mysqli_fetch_both($result)) { echo $row["name"]." ".$row["class"]." ".$row['roll_no']."<br />";
  4. I think this line found in the tutorial is an error: $total_pages = $conn->query('SELECT * FROM browsing_histories')->num_rows; It should not have been $total_pages but $total_records. Correct ? Tutorial here: https://codeshack.io/how-to-create-pagination-php-mysql/
  5. If you look closely then you will see I originally did what you suggested. However, saying all this, I am stuck on this line and so care to help me convert that ? $total_pages = $conn->query('SELECT * FROM browsing_histories')->num_rows; //I NEED HELP TO SUBSTITUTE THIS TO PROCEDURAL STYLE
  6. I commented-out their lines and added mine beneath their lines that I substituted.
  7. Folks, Look what I found here: https://codeshack.io/how-to-create-pagination-php-mysql/ It is oop pagination using mysqli. I only know mysqli and procedural. So, teach me to convert it to procedural. My procedural style code is this alongside their OOP: <?php if (!$conn) { $error = mysqli_connect_error(); $errno = mysqli_connect_errno(); print "$errno: $error\n"; exit(); } // Get the total number of records from our table "students". $total_pages = $conn->query('SELECT * FROM browsing_histories')->num_rows; //I NEED HELP TO SUBSTITUTE THIS TO PROCEDURAL STYLE // Check if the page number is specified and check if it's a number, if not return the default page number which is 1. $page = isset($_GET['page']) && is_numeric($_GET['page']) ? $_GET['page'] : 1; // Number of results to show on each page. $num_results_on_page = 5; // if ($stmt = $conn->prepare('SELECT * FROM following_histories ORDER BY id LIMIT ?,?')) { if($query = "SELECT id,date_and_time,query_type,followed_word,query_string,browsed_page_original,browsed_page_converted,referral_page_original,referral_page_converted,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 FROM browsing_histories WHERE username = ? ORDER BY id LIMIT ? OFFSET ?"){ //my substitution of above line $stmt = mysqli_prepare($conn,$query); //MY SUBSTITUTION OF ABOVE LINE // Calculate the page to get the results we need from our table. $calc_page = ($page - 1) * $num_results_on_page; //$stmt->bind_param('ii', $calc_page, $num_results_on_page); mysqli_stmt_bind_param($stmt,'sii',$followee_username,$calc_page,$num_results_on_page); //MY SUBSTITUTION OF ABOVE LINE //$stmt->execute(); mysqli_stmt_execute($stmt); //MY SUBSTITUTION OF ABOVE LINE // Get the results... //$result = $stmt->get_result(); $result = mysqli_stmt_get_result($stmt) //MY SUBSTITUTION OF ABOVE LINE ?> <!DOCTYPE html> <html> <head> <title>PHP & MySQL Pagination by CodeShack</title> <meta charset="utf-8"> <style> html { font-family: Tahoma, Geneva, sans-serif; padding: 20px; background-color: #F8F9F9; } table { border-collapse: collapse; width: 500px; } td, th { padding: 10px; } th { background-color: #54585d; color: #ffffff; font-weight: bold; font-size: 13px; border: 1px solid #54585d; } td { color: #636363; border: 1px solid #dddfe1; } tr { background-color: #f9fafb; } tr:nth-child(odd) { background-color: #ffffff; } .pagination { list-style-type: none; padding: 10px 0; display: inline-flex; justify-content: space-between; box-sizing: border-box; } .pagination li { box-sizing: border-box; padding-right: 10px; } .pagination li a { box-sizing: border-box; background-color: #e2e6e6; padding: 8px; text-decoration: none; font-size: 12px; font-weight: bold; color: #616872; border-radius: 4px; } .pagination li a:hover { background-color: #d4dada; } .pagination .next a, .pagination .prev a { text-transform: uppercase; font-size: 12px; } .pagination .currentpage a { background-color: #518acb; color: #fff; } .pagination .currentpage a:hover { background-color: #518acb; } </style> </head> <body> <table> <tr> <th>Name</th> <th>Age</th> <th>Join Date</th> </tr> <?php while ($row = $result->fetch_assoc()): ?> <tr> <td><?php echo $row['id']; ?></td> <td><?php echo $row['followee_username']; ?></td> <td><?php echo $row['follower_username']; ?></td> </tr> <?php endwhile; ?> </table> <?php if (ceil($total_pages / $num_results_on_page) > 0): ?> <ul class="pagination"> <?php if ($page > 1): ?> <li class="prev"><a href="pagination.php?page=<?php echo $page-1 ?>">Prev</a></li> <?php endif; ?> <?php if ($page > 3): ?> <li class="start"><a href="pagination.php?page=1">1</a></li> <li class="dots">...</li> <?php endif; ?> <?php if ($page-2 > 0): ?><li class="page"><a href="pagination.php?page=<?php echo $page-2 ?>"><?php echo $page-2 ?></a></li><?php endif; ?> <?php if ($page-1 > 0): ?><li class="page"><a href="pagination.php?page=<?php echo $page-1 ?>"><?php echo $page-1 ?></a></li><?php endif; ?> <li class="currentpage"><a href="pagination.php?page=<?php echo $page ?>"><?php echo $page ?></a></li> <?php if ($page+1 < ceil($total_pages / $num_results_on_page)+1): ?><li class="page"><a href="pagination.php?page=<?php echo $page+1 ?>"><?php echo $page+1 ?></a></li><?php endif; ?> <?php if ($page+2 < ceil($total_pages / $num_results_on_page)+1): ?><li class="page"><a href="pagination.php?page=<?php echo $page+2 ?>"><?php echo $page+2 ?></a></li><?php endif; ?> <?php if ($page < ceil($total_pages / $num_results_on_page)-2): ?> <li class="dots">...</li> <li class="end"><a href="pagination.php?page=<?php echo ceil($total_pages / $num_results_on_page) ?>"><?php echo ceil($total_pages / $num_results_on_page) ?></a></li> <?php endif; ?> <?php if ($page < ceil($total_pages / $num_results_on_page)): ?> <li class="next"><a href="pagination.php?page=<?php echo $page+1 ?>">Next</a></li> <?php endif; ?> </ul> <?php endif; ?> </body> </html> <?php //$stmt->close(); mysqli_stmt_close($stmt); //MY SUBSTITUTION OF ABOVE LINE } ?>
  8. 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.
  9. I spotted my error the other day. Should've been: if($followee_username != "followee_all" OR $followee_username != "followee_All"")
  10. Correction: This url should work: browsing_histories_v1.php?followee_username=followee_all&page_number=1 It should trigger: $query = "SELECT * FROM browsing_histories"; It should show all rows from the tbl. Correct ? What's wrong ? Puzzled!
  11. Neither the IF from here shows all rows: if($followee_username == "followee_all" OR "Followee_All") { $query = "SELECT * FROM following_histories"; echo "all"; $query_type = "followee_all"; $followed_word = "followee_all"; $follower_username = "$user"; } else { $query = "SELECT * FROM following_histories WHERE username = \"$followee_username\""; echo "$followee_username"; $query_type = "$followee_username"; $followed_word = "$followee_username"; $follower_username = "$user"; } Why it fails ? Puzzled!
  12. Hi, I want to pull data from db, where sometimes all rows and sometimes rows matching given "username". Here is my code: //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_All") { $query = "SELECT * FROM browsing_histories WHERE username = \"$followee_username\""; $query_type = "followee_username"; $followed_word = "$followee_username"; $follower_username = "$user"; echo "$followee_username"; } else { $query = "SELECT * FROM browsing_histories"; $query_type = "followee_all"; $followed_word = "followee_all"; $follower_username = "$user"; echo "all"; } } When I specify a "username" in the query via the url: browsing_histories_v1.php?followee_username=requinix&page_number=1 I see result as I should. So far so good. Now, when I specify "all" as username then I see no results. Why ? All records from the tbl should be pulled! browsing_histories_v1.php?followee_username=all&page_number=1 This query shouldv'e worked: $query = "SELECT * FROM browsing_histories";
  13. Cos, I thought maybe what I thought the answer was probably was not correct somewhere as I was still getting the error. I think I forgot to refresh my browser. You got a grip like a vice, haven't ya ? Yaa, won't let it go! Lol! May my backside be excused from your rottweiler bite ? Lol! But don't go away as I want to complete this script I have been working on since feb 2017 and release it tomorrow. I might have more questions on upcoming new threads. Stay tuned with me tonight.
  14. Yeah. I know. If you notice my scripts, the variables get created for first time in the bind_result. Anyway, good thing you still mentioned it to make sure I am aware of it. Am sure other newbies, who aren't aware of this, will learn from your comment.
  15. Error gone on my original script now. Thanks! $stmt_1 = mysqli_prepare($conn,"SELECT COUNT(sponsor_username) from users WHERE sponsor_username = ?"); mysqli_stmt_bind_param($stmt_1,'s',$sponsor_username); mysqli_stmt_execute($stmt_1); //Show error if 'users' tbl was not successfully queried". if (!$stmt_1) { echo "ERROR 1: Sorry! Our system is currently experiencing a problem loading this page!"; exit(); } else { mysqli_stmt_bind_result($stmt_1,$sponsor_username_count); mysqli_stmt_fetch($stmt_1); mysqli_stmt_close($stmt_1); //Check if Sponsor Username in Url ($_GET) is already registered or not. If not then show "Invalid Url" or Link message. if ($sponsor_username_count < 1) { echo "<b>Invalid Url or Link!<br> Invalid Sponsor: \"$sponsor_username\"!</b><?php "; exit(); } }
×

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.