Hello Guys
I Have been working on this site of mine for quite some time now, and just uploaded til to my webhost.
then i get this error on my pagination, that i dont quite understand, so i hope you guys can help me, because its works perfectly fine on my localhost.
Localhost: http://i.imgur.com/COqcmHD.png
Webhost: http://i.imgur.com/KYxhAHY.png
Error Code:
Fatal error: Uncaught Error: Call to a member function fetch_array() on boolean in /var/www/eshooting.dk/public_html/nyheder.php:91 Stack trace: #0 {main} thrown in /var/www/eshooting.dk/public_html/nyheder.php on line 91
My Complete PHP File:
[php]
<?php
error_reporting(1);
session_start();
?>
<?php
require_once 'include/incl_db.php';
?>
<?php
require_once 'functions/functions.php';
?>
<?php
function myAutoloader($class) {
$class = strtolower($class);
require_once $class . '.php';
}
spl_autoload_register('myAutoloader');
?>
eShooting.dk - Nyheder
<?php
require_once 'include/modal_login.php';
?>
<?php
require_once 'include/menu.php';
?>
Nyheder!
<?php
$per_page=5;
if (isset($_GET["page"])) {
$page = $_GET["page"];
$prev = $page - 1;
$next = $page + 1;
}
else {
header('location:nyheder.php?page=1');
}
// Page will start from 0 and Multiple by Per Page
$start_from = ($page-1) * $per_page;
//Selecting the data from table but with limit
$sql = "SELECT * FROM es_nyheder LIMIT $start_from, $per_page";
$res = $objCon->query($sql);
?>
<?php
while ($row = $res-> fetch_array()) {
$id = $row['id'];
echo "
";
echo "
";
echo "
![]()
";
echo "
";
echo "
";
echo "
";
echo substr ($row['title'] , 0, 18) . "...";
echo "
";
echo "";
echo "
";
echo "
";
echo substr ($row['tekst'] , 0, 38) . ".....";
echo "
";
echo "
";
echo "
";
echo "
";
echo "D. ";
echo date('d-m-Y', strtotime($row['dato']));
echo "
";
echo "
";
echo "
";
echo "
";
};
?>
<?php
//Now select all from table
$sql = "SELECT * FROM es_nyheder";
$res = mysqli_query($objCon, $sql);
// Count the total records
$total_records = mysqli_num_rows($res);
//Using ceil function to divide the total records on per page
$total_pages = ceil($total_records / $per_page);
//Going to first page
echo "
";
?>
Sponsorer / Partnere!
Social!
<?php
$sql = "SELECT * FROM es_sponsorer ORDER BY id ASC";
$res = $objCon->query($sql);
while ($row = $res-> fetch_array()) {
echo '
!['.$row[]()
';
}
?>
<?php
$sql = "SELECT * FROM es_scoial ORDER BY id ASC";
$res = $objCon->query($sql);
while ($row = $res-> fetch_array()) {
echo '
!['.$row[]()
';
}
?>
Copyright © <?php $datetime = new DateTime(); echo $datetime->format('Y'); ?> eShooting.dk All Rights Reserved
[/php]
I hope you guys can help whit my problem, since i cant figure it out.
Best Regrads
Kevin P
