Menu
Community /Pin to ProfileBookmark
@NogDogAug 17.2018 — #Firstly: yes, just give us the relevant code.
Secondly: as a first step, try some defensive coding and crude error-handling:
@NogDogAug 17.2018 — #You may need to turn on all error reporting for now:
@NogDogAug 18.2018 — #I think you need some more parentheses so that the "=" assignment is done _before_ the "==" comparison:
PS: Ultimately, I often like to define a function (or class method) that does the prepare (and another for the execute), throwing an exception when it fails, to avoid duplicate code; then you can just call that function/method whenever you do those actions.
Why Query Fails To Pull data From Data Base ?
Folks,
Why are my $query_1 failing to pull data from mysql db ?
I created a condition to get alert if no result is found but I do not get the alert. That means result is found. But if found, then why the following code fails to display or echo the result through html ?
Trying to pull the data with these urls:
[php]
<?php
//Required PHP Files.
include ‘config.php’;
include ‘header.php’;
include ‘account_header.php’;
if (!$conn)
{
$error = mysqli_connect_error();
$errno = mysqli_connect_errno();
print “$errno: $errorn”;
exit();
}
else
{
?>
<body bgcolor=’blue’>
<?php
//Get the Page Number. Default is 1 (First Page).
$Result_PageNumber = $_GET[“Result_PageNumber”];
if ($Result_PageNumber == “”)
{
$Result_PageNumber = 1;
}
$Result_LinksPerPage = $_GET[“Result_LinksPerPage”];
if ($Result_LinksPerPage == “”)
{
$Result_LinksPerPage = 1;
}
$max_result = 100;
//$offset = ($Result_PageNumber*$Result_LinksPerPage)-$Result_LinksPerPage;
$offset = ($Result_PageNumber-1)*$Result_LinksPerPage;
if ($_GET[“Result_SearchType”] == “Keywords”)
{
//Grabbing these: $_GET[“Result_PageType”],$_GET[“Result_Keywords”].
$first_param = $_GET[“Result_PageType”];
$second_param = $_GET[“Result_Keywords”]; echo “$second_param”;
$query_1 = “SELECT COUNT(*) FROM submissions_index WHERE page_type = ? AND description = ? LIMIT ?”;
$stmt_1 = mysqli_prepare($conn,$query_1);
mysqli_stmt_bind_param($stmt_1,’ssi’,$first_param,$second_param,$Result_LinksPerPage);
mysqli_stmt_execute($stmt_1);
$result_1 = mysqli_stmt_bind_result($stmt_1,$matching_rows_count);
mysqli_stmt_fetch($stmt_1);
mysqli_stmt_free_result($stmt_1);
$total_pages = ceil($matching_rows_count/$Result_LinksPerPage);
$query_2 = “SELECT id,date_and_time,domain,page_type,page,title,description FROM submissions_index WHERE page_type = ? AND description = ? LIMIT ?”;
$stmt_2 = mysqli_prepare($conn,$query_2);
mysqli_stmt_bind_param($stmt_1,’ssi’,$first_param,$second_param,$Result_LinksPerPage);
$result_2 = mysqli_stmt_bind_result($stmt_2,$Result_Id,$Result_LinkSubmissionDateAndTime,$Result_Domain,$Result_PageType,$Result_Page,$Result_PageTitle,$Result_PageDescription);
mysqli_stmt_fetch($stmt_2);
}
elseif ($_GET[“Result_SearchType”] == “Domain”)
{
//Grabbing these: $_GET[“Result_Domain”], $_GET[“Result_PageType”].
$first_param = $_GET[“Result_PageType”];
$second_param = $_GET[“Result_Domain”]; echo “$second_param”;
$query_1 = “SELECT COUNT(*) FROM submissions_index WHERE page_type = ? AND domain = ? LIMIT ?”;
$stmt_1 = mysqli_prepare($conn,$query_1);
mysqli_stmt_bind_param($stmt_1,’ssi’,$first_param,$second_param,$Result_LinksPerPage);
mysqli_stmt_execute($stmt_1);
$result_1 = mysqli_stmt_bind_result($stmt_1,$matching_rows_count);
mysqli_stmt_fetch($stmt_1);
mysqli_stmt_free_result($stmt_1);
$total_pages = ceil($matching_rows_count/$Result_LinksPerPage);
$query_2 = “SELECT id,date_and_time,domain,page_type,page,title,description FROM submissions_index WHERE page_type = ? AND domain = ? LIMIT ?”;
$stmt_2 = mysqli_prepare($conn,$query_2);
mysqli_stmt_bind_param($stmt_1,’ssi’,$first_param,$second_param,$Result_LinksPerPage);
$result_2 = mysqli_stmt_bind_result($stmt_2,$Result_Id,$Result_LinkSubmissionDateAndTime,$Result_Domain,$Result_PageType,$Result_Page,$Result_PageTitle,$Result_PageDescription);
mysqli_stmt_fetch($stmt_2);
}
elseif ($_GET[“Result_SearchType”] == “PageTitle”)
{
//Grabbing these: $_GET[“Result_Domain”], $_GET[“Result_PageType”].
$first_param = $_GET[“Result_PageType”];
$second_param = $_GET[“Result_PageTitle”]; echo “$second_param”;
$query_1 = “SELECT COUNT(*) FROM submissions_index WHERE page_type = ? AND title = ? LIMIT ?”;
$stmt_1 = mysqli_prepare($conn,$query_1);
mysqli_stmt_bind_param($stmt_1,’ssi’,$first_param,$second_param,$Result_LinksPerPage);
mysqli_stmt_execute($stmt_1);
$result_1 = mysqli_stmt_bind_result($stmt_1,$matching_rows_count);
mysqli_stmt_fetch($stmt_1);
mysqli_stmt_free_result($stmt_1);
$total_pages = ceil($matching_rows_count/$Result_LinksPerPage);
$query_2 = “SELECT id,date_and_time,domain,page_type,page,title,description FROM submissions_index WHERE page_type = ? AND title = ? LIMIT ?”;
$stmt_2 = mysqli_prepare($conn,$query_2);
mysqli_stmt_bind_param($stmt_1,’ssi’,$first_param,$second_param,$Result_LinksPerPage);
$result_2 = mysqli_stmt_bind_result($stmt_2,$Result_Id,$Result_LinkSubmissionDateAndTime,$Result_Domain,$Result_PageType,$Result_Page,$Result_PageTitle,$Result_PageDescription);
mysqli_stmt_fetch($stmt_2);
}
elseif ($_GET[“Result_SearchType”] == “Page”)
{
//Grabbing these: $_GET[“Result_Domain”], $_GET[“Result_PageType”].
$first_param = $_GET[“Result_PageType”];
$second_param = $_GET[“Result_Page”]; echo “$second_param”;
$query_1 = “SELECT COUNT(*) FROM submissions_index WHERE page_type = ? AND page = ? LIMIT ?”;
$stmt_1 = mysqli_prepare($conn,$query_1);
mysqli_stmt_bind_param($stmt_1,’ssi’,$first_param,$second_param,$Result_LinksPerPage);
mysqli_stmt_execute($stmt_1);
$result_1 = mysqli_stmt_bind_result($stmt_1,$matching_rows_count);
mysqli_stmt_fetch($stmt_1);
mysqli_stmt_free_result($stmt_1);
$total_pages = ceil($matching_rows_count/$Result_LinksPerPage);
$query_2 = “SELECT id,date_and_time,domain,page_type,page,title,description FROM submissions_index WHERE page_type = ? AND page = ? LIMIT ?”;
$stmt_2 = mysqli_prepare($conn,$query_2);
mysqli_stmt_bind_param($stmt_1,’ssi’,$first_param,$second_param,$Result_LinksPerPage);
$result_2 = mysqli_stmt_bind_result($stmt_2,$Result_Id,$Result_LinkSubmissionDateAndTime,$Result_Domain,$Result_PageType,$Result_Page,$Result_PageTitle,$Result_PageDescription);
mysqli_stmt_fetch($stmt_2);
}
elseif ($_GET[“Result_SearchType”] == “PageDescription”)
{
//Grabbing these: $_GET[“Result_Domain”], $_GET[“Result_PageType”].
$first_param = $_GET[“Result_PageType”];
$second_param = $_GET[“Result_PageDescription”]; echo “$second_param”;
$query_1 = “SELECT COUNT(*) FROM submissions_index WHERE page_type = ? AND description = ? LIMIT ?”;
$stmt_1 = mysqli_prepare($conn,$query_1);
mysqli_stmt_bind_param($stmt_1,’ssi’,$first_param,$second_param,$Result_LinksPerPage);
mysqli_stmt_execute($stmt_1);
$result_1 = mysqli_stmt_bind_result($stmt_1,$matching_rows_count);
mysqli_stmt_fetch($stmt_1);
mysqli_stmt_free_result($stmt_1);
$total_pages = ceil($matching_rows_count/$Result_LinksPerPage);
$query_2 = “SELECT id,date_and_time,domain,page_type,page,title,description FROM submissions_index WHERE page_type = ? AND description = ? LIMIT ?”;
$stmt_2 = mysqli_prepare($conn,$query_2);
mysqli_stmt_bind_param($stmt_1,’ssi’,$first_param,$second_param,$Result_LinksPerPage);
$result_2 = mysqli_stmt_bind_result($stmt_2,$Result_Id,$Result_LinkSubmissionDateAndTime,$Result_Domain,$Result_PageType,$Result_Page,$Result_PageTitle,$Result_PageDescription);
mysqli_stmt_fetch($stmt_2);
}
elseif ($_GET[“Result_SearchType”] == “AnchorText”)
{
//Grabbing these: $_GET[“Result_Domain”], $_GET[“Result_PageType”].
$first_param = $_GET[“Result_PageType”];
$second_param = $_GET[“Result_AnchorText”]; echo “$second_param”;
$query_1 = “SELECT COUNT(*) FROM submissions_index WHERE page_type = ? AND anchor_text = ? LIMIT ?”;
}
$stmt_1 = mysqli_prepare($conn,$query_1);
mysqli_stmt_bind_param($stmt_1,’ssi’,$first_param,$second_param,$Result_LinksPerPage);
mysqli_stmt_execute($stmt_1);
$result_1 = mysqli_stmt_bind_result($stmt_1,$matching_rows_count);
mysqli_stmt_fetch($stmt_1);
mysqli_stmt_free_result($stmt_1);
$total_pages = ceil($matching_rows_count/$Result_LinksPerPage);
$query_2 = “SELECT id,date_and_time,domain,page_type,page,title,description FROM submissions_index WHERE page_type = ? AND anchor_text = ? LIMIT ?”;
$stmt_2 = mysqli_prepare($conn,$query_2);
mysqli_stmt_bind_param($stmt_1,’ssi’,$first_param,$second_param,$Result_LinksPerPage);
$result_2 = mysqli_stmt_bind_result($stmt_2,$Result_Id,$Result_LinkSubmissionDateAndTime,$Result_Domain,$Result_PageType,$Result_Page,$Result_PageTitle,$Result_PageDescription);
mysqli_stmt_fetch($stmt_2);
if(!$stmt_2)
{
?>
<tr>
<td bgcolor=”#FFFFFF”>No record found! Try another time.</td>
</tr>
<?php
}
else
{
if(($offset+1)<=$max_result)
{
?>
<p align=”left”>
<?php echo “<font color=’white’><b>LINK SUBMISSION ID:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_Id</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>LINK SUBMISSION DATE & TIME:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_LinkSubmissionDateAndTime</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>DOMAIN:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_Domain</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>PAGE:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_Page</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>PAGE TYPE:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_PageType</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>PAGE TITLE:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_PageTitle</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>PAGE DESCRIPTION:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_PageDescription</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>PAGE SEARCH STATISTICS:</b></font>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Current&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’gold’><b>Current Visitor</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Last&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’silver’><b>Last Visitor</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Latest&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’bronze’><b>Latest Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Lost&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’grey’><b>Lost Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Unhappy&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’yellow’><b>Unhappy Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Happy&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’green’><b>Happy Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Competing&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’red’><b>Competing Visitors</font></b></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=All&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’blue’><b>All Visitors</font></b></a>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>DOMAIN SEARCH STATISTICS:</b></font>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Current&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’gold’><b>Current Visitor</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Last&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’silver’><b>Last Visitor</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Latest&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’bronze’><b>Latest Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Lost&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’grey’><b>Lost Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Unhappy&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’yellow’><b>Unhappy Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Happy&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’green’><b>Happy Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Competing&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’red’><b>Competing Visitors</font></b></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=All&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’blue’><b>All Visitors</font></b></a>”; ?><br>
<br>
<br>
</align>
<?php
//Use this technique: http://php.net/manual/en/mysqli-stmt.fetch.php
while(mysqli_stmt_fetch($stmt_2))
{
?>
<p align=”left”>
<?php echo “<font color=’white’><b>LINK SUBMISSION ID:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_Id</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>LINK SUBMISSION DATE & TIME:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_LinkSubmissionDateAndTime</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>DOMAIN:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_Domain</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>PAGE:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_Page</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>PAGE TYPE:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_PageType</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>PAGE TITLE:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_PageTitle</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>PAGE DESCRIPTION:</b></font>”; ?><br>
<?php echo “<font color=’white’><i>$Result_PageDescription</i></font>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>PAGE SEARCH STATISTICS:</b></font>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Current&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’gold’><b>Current Visitor</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Last&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’silver’><b>Last Visitor</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Latest&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’bronze’><b>Latest Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Lost&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’grey’><b>Lost Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Unhappy&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’yellow’><b>Unhappy Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Happy&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’green’><b>Happy Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=Competing&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’red’><b>Competing Visitors</font></b></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Keywords&Result_PageType=$Result_PageType&Result_Page=$Result_Page&Result_VisitorType=All&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’blue’><b>All Visitors</font></b></a>”; ?><br>
<br>
<br>
<?php echo “<font color=’white’><b>DOMAIN SEARCH STATISTICS:</b></font>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Current&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’gold’><b>Current Visitor</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Last&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’silver’><b>Last Visitor</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Latest&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’bronze’><b>Latest Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Lost&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’grey’><b>Lost Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Unhappy&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’yellow’><b>Unhappy Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Happy&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’green’><b>Happy Visitors</b></font></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=Competing&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’red’><b>Competing Visitors</font></b></a>”; ?><br>
<?php echo “<a href=”visits_stats.php?Result_StatsType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_VisitorType=All&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber=”><font color=’blue’><b>All Visitors</font></b></a>”; ?><br>
<br>
<br>
</align>
<tr name=”pagination”>
<td colspan=”10″ bgcolor=”#FFFFFF”> Result Pages:
<?php
if($Result_PageNumber<$total_pages)
{
for($i=1;$i<=$total_pages;$i++) //Show Page Numbers in Serial Order. Eg. 1,2,3.
echo “<a href=”{$_SERVER[‘PHP_SELF’]}?user=$user&Result_SearchType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber={$i}”>{$i}</a> “;
}
else
{
for($i=$total_pages;$i>=1;$i–) //Show Page Numbers in Reverse Order. Eg. 3,2,1.
echo “<a href=”{$_SERVER[‘PHP_SELF’]}?user=$user&Result_SearchType=Domain&Result_PageType=$Result_PageType&Result_Domain=$Result_Domain&Result_LinksPerPage=$Result_LinksPerPage&Result_PageNumber={$i}”>{$i}</a> “;
}
?>
</td>
</tr>
<?php
}
}
}
?>
</table>
<br>
<br>
<p align=”center”><span style=”font-weight:bold;”><?php echo “Search Result: <br>Searching for …”$second_param” <br>Page Type: $first_param<br> Matches: $matching_rows_count <br>”; ?></span></align>
<br>
</div>
<br>
</body>
</html>
<?php
//Free Result Set.
mysqli_stmt_free_result($stmt_2);
//Close Statement Connection.
mysqli_stmt_close($stmt_2);
//Close Database Connection.
mysqli_close($conn);
}
?>
[/php]
Sign in
to post a comment24 Comments(s) ↴
0
@NogDogAug 17.2018 — #Firstly: yes, just give us the relevant code.Secondly: as a first step, try some defensive coding and crude error-handling:
``php<i>
</i>$query_1 = "SELECT COUNT(*) FROM submissions_index WHERE page_type = ? AND description = ? LIMIT ?";
if(($stmt_1 = mysqli_prepare($conn,$query_1) == false) {
throw new Exception(mysqli_error($conn));
}
mysqli_stmt_bind_param($stmt_1,'ssi',$first_param,$second_param,$Result_LinksPerPage);
if(mysqli_stmt_execute($stmt_1) == false) {
throw new Exception(mysqli_stmt_error($stmt_1));
}
$result_1 = mysqli_stmt_bind_result($stmt_1,$matching_rows_count); <i>
</i>``0
@NogDogAug 17.2018 — #You may need to turn on all error reporting for now:``php<i>
</i><?php
ini_set('display_errors', true);
error_reporting(E_ALL);
// rest of code...<i>
</i>``0
@NogDogAug 18.2018 — #I think you need some more parentheses so that the "=" assignment is done _before_ the "==" comparison:``<i>
</i>if ( ( $stmt_1 = mysqli_prepare($conn,$query_1 ) ) == false) {<i>
</i>`</CODE>
You could make it less confusing using multiple statements. (I was just being lazy and merging it into a one-liner, but performance-wise it doesn't really matter, just personal preference.)
<CODE>`<i>
</i>$stmt_1 = mysqli_prepare($conn,$query_1);
if($stmt_1 == false) {
throw new Exception(mysqli_stmt_error($stmt_1));
}<i>
</i>``PS: Ultimately, I often like to define a function (or class method) that does the prepare (and another for the execute), throwing an exception when it fails, to avoid duplicate code; then you can just call that function/method whenever you do those actions.