Publicado em 21 de set.

problemas na pagina em php

não estou a conseguir por a minha paginação a funcionar correctamente

segue-se o codigo

classe serviço.php

<?php
class servicos{

private $_db;
public function __construct(){

	$this->_db = new Database();
}
public function getservicos($page,$limit){
	$starting_limit = ($page-1)*$limit;

	$servicos = $this->_db->query("SELECT * FROM empresa ORDER BY id DESC LIMIT '$starting_limit, $limit';");
	return $servicos->fetch_assoc();

}
public function getservicos1(){

	$servicos1 = $this->_db->query("SELECT * FROM empresa");
	return $servicos1->fetchAll();

}
public function getcategorias($idcategoria){
	$categoria = $this->_db->query("SELECT categorias.nome FROM empresa INNER JOIN categoriasempresa ON categoriasempresa.id_empresa=empresa.id INNER JOIN categorias ON categorias.id=categoriasempresa.id_categoria WHERE empresa.id='$idcategoria';");
	return $categoria->fetchAll();

}
public function getactividades($idactivades){
	$activades = $this->_db->query("SELECT actividades.nome FROM empresa INNER JOIN actividadesempresa ON actividadesempresa.id_empresa=empresa.id INNER JOIN actividades ON actividades.id=actividadesempresa.id_activades WHERE empresa.id='$idactivades';");
	return $activades->fetchAll();

}

public function getcontaempresa(){
	$contaempresa = $this->_db->query("SELECT * FROM empresa ");
	return $contaempresa->rowCount();

}

}

	 

	index.php

<!DOCTYPE html>

<html lang="pt">
 <head>
 <meta charset="utf-8">
 <meta http-equiv="X-UA-Compatible" content="IE=edge">
 <meta name="viewport" content="width=device-width, initial-scale=1">
 <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
 <meta name="description" content="Site de Contrução">
 <meta name="author" content="Pedro Alves">
 <link rel="icon" href="favicon.ico">

 <title>Trabalho </title>
 <link href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
 <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/font-awesome/4.4.0/css/font-awesome.min.css">
 <link href="dist/css/star-rating.css" media="all" rel="stylesheet" type="text/css"/>
 <!-- Bootstrap core CSS -->
 <link href="dist/css/bootstrap.min.css" rel="stylesheet">
<link href="dist/css/menu.css" rel="stylesheet">
<link href="dist/css/styleimage.css" rel="stylesheet">
 <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
 <link href="dist/css/ie10-viewport-bug-workaround.css" rel="stylesheet">

 <!-- Custom styles for this template -->
 <link href="dist/css/starter-template.css" rel="stylesheet">

 <!-- Just for debugging purposes. Don't actually copy these 2 lines! -->
 <!--[if lt IE 9]><script src="../../assets/js/ie8-responsive-file-warning.js"></script><![endif]-->
 <script src="dist/js/ie-emulation-modes-warning.js"></script>

 <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
 <!--[if lt IE 9]>
 <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
 <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
 <![endif]-->
 </head>

 <body>

<?php

include ('includes/menu.php');
require_once('configurations/Database.php');
require_once('classes/servicos.php');
$servicos = new servicos();
?>

 <div id="page-content-wrapper" style="height:550px";>
 <div class="container-fluid">
 <div class="row">
 <div class="col-lg-12">
 <br>
 <h1> <img src="imagens/logo.ico">Trabalho</h1>

 </div>
 </div>
 <div class="row">
 <div class="col-lg-12">

 <ul class="nav nav-pills nav-justified" >
 <li class="active"><a data-toggle="pill" href="#home">Ferias</a></li>
 <li><a data-toggle="pill" href="#voos">Voos</a></li>
 <li><a data-toggle="pill" href="#hotel">Hotel</a></li>
 <li><a data-toggle="pill" href="#hotelvoos">Voos+Hotel</a></li>
 <li><a data-toggle="pill" href="#hotelvoos">Cruzeiros</a></li>
 <li><a data-toggle="pill" href="#hotelvoos">Cicuitos</a></li>
 </ul>

 <div class="tab-content">
 <div id="home" class="tab-pane fade in active">
 <?php
 $limit = 2;
 $ola= $servicos->getcontaempresa();

 $total_pages = ceil($ola/$limit);
 if (!isset($_GET['limit'])) {
 $page = 1;

} else{

 $page = $_GET['$limit'];
}

echo $total_pages;

while($res = $servicos->getservicos($page,$limit)):

?>
<h4><?php echo $res['id'];?></h4>
<p><?php echo $res['nome'];?></p>
<hr>
<?php
endwhile;

 foreach ($servicos->getservicos1()as $m):
	$d=$m['id'];
 ?>
 <button type="button" class="btn btn-info btn-lg" data-toggle="modal" data-target="#<?php echo $d;?>"><?php echo $m['nome']; ?></button>

<div id="<?php echo $d;?>" class="modal fade" role="dialog">
 <div class="modal-dialog">

 <!-- Modal content-->
 <div class="modal-content">
 <div class="modal-header">
 <button type="button" class="close" data-dismiss="modal">&times;</button>
 </div>
 <div class="modal-body">
 <p> LogoTipo</p>
 <p><?php echo"Nif:",$m['nif']," "; echo"CAE:",$m['CAE']; ?>
 </p>
 <p><?php echo"Nome da Empresa:",$m['nome'];?>
 </p>
 <p><?php echo"Morada:",$m['morada'];?>
 </p>

 <p><?php echo"Localidade:",$m['Localidade'];?>
 </p>
 <p><?php echo"CodigoPostal:",$m['codigopostal'];?>
 </p>
 <p><?php echo"Telefone:",$m['telefone']," "; echo"Fax:",$m['fax']," ";echo"Telemovel:",$m['telemovel']; ?>
 </p>
 <p><?php echo"Webmail:",$m['email'];?>
 </div>
 <div class="modal-footer">
 <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
 </div>
 </div>

 </div>
</div>
<?php endforeach;?>
 </div>
 <div id="voos" class="tab-pane fade">
 <div class="container" align="center">

<div class="well">
<div class="form-group" >
 <div class="input-group input-daterange">
 <form class="well form-horizontal">
 <input id="origems" name="origems" type="text" list="origem" placeholder="Origem" />
 <datalist id="origem">
 <option value="Internet Explorer">
 <option value="Firefox">
 <option value="Chrome">
 <option value="Opera">
 <option value="Safari">
</datalist>
<input type="text" list="destino" class="form-horizontal" id="destinos" name="destinos" placeholder="destino"/>
 <datalist id="destino">
 <option value="Internet Explorer">
 <option value="Firefox">
 <option value="Chrome">
 <option value="Opera">
 <option value="Safari">
</datalist>
 <input id="DateBox1" class="form-horizontal" type="text" placeholder="Partida">
 <input id="DateBox2" class="form-horizontal" type="text" placeholder="Chegada">
 <input class="form-horizontal" data-toggle="modal" data-target="#myModal" type="text" placeholder="1 Adulto" readonly>
</div>
<div class="check">
<input id="endDay" type="checkbox">
<label for="endDay">Include end date in calculation (1 day is added)</label>
</div>

<div class="col-xs-4">
<button type="button" class="btn btn-primary" id="submit">Calculate Intervals</button>
</div>

 <div class="col-xs-4 col-xs-offset-2">
<div class="current-date">
<span></span>
</div>
 </div>
<br><br>
 <hr>

<table width="100%">
 <tbody><tr><td class="table_left" width="33%">Number of Full years</td><td class="table_right"><span class="years-between"></span></td></tr>
<tr><td class="table_left" width="33%">Number of Months</td><td class="table_right"><span class="months-between"></span></td></tr>
<tr><td class="table_left" width="33%">Number of Weeks</td><td class="table_right"><span class="weeks-between"></span></td></tr>
<tr><td class="table_left" width="33%">Number of Days</td><td class="table_right"><span class="days-between"></span></td></tr>
 </tbody></table>
</div>
</div>

 <div id="push"></div>
 </form>
 </div>
 </div>
 <div id="hotel" class="tab-pane fade">
 <h3>Hotel</h3>
 <input id="input-21e" value="1" type="text" class="rating" data-min=0 data-max=5 data-step=1 data-size="xs"
 title="">
 </div>

 </div>
</div>
<br>
<br>

 </div>
</div>

</div>
<?php
include ('includes/footer.php');
 ?>

<div id="myModal" class="modal fade" role="dialog">
 <div class="modal-dialog">

 <!-- Modal content-->
 <div class="modal-content">
 <div class="modal-header">
 <button type="button" class="close" data-dismiss="modal">&times;</button>
 <h4 class="modal-title">Modal Header</h4>
 </div>
 <div class="modal-body">
 <p>Some text in the modal.</p>
 </div>
 <div class="modal-footer">
 <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
 </div>
 </div>

 </div>
</div>

 <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
 <script>window.jQuery || document.write('<script src="dist/js/jquery.min.js"><\/script>')</script>
 <script src="dist/js/bootstrap.min.js"></script>
 <!-- Just to make our placeholder images work. Don't actually copy the next line! -->
 <script src="dist/js/holder.min.js"></script>

 <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
 <script src="dist/js/ie10-viewport-bug-workaround.js"></script>

 <script src="dist/js/bootstrapValidator.js"></script>
 <script src="dist/js/bootstrapValidator.min.js"></script>
 <script src="dist/js/model.js"></script>
 <script src="dist/js/star-rating.js"></script>
 <script src="dist/js/pick.js"></script>

 </body>
</html>

	da me o seguinte erro

 **Fatal error**: Uncaught Error: Call to a member function fetch_assoc() on boolean in C:\wamp\www\trabalho\classes\servicos.php:13 Stack trace: #0 C:\wamp\www\trabalho\index.php(85): servicos->getservicos(1, 2) #1 {main} thrown in **C:\wamp\www\trabalho\classes\servicos.php** on line **13**

 **alguem me pode ajudar**

Discussão (1)

Entre ou cadastre-se para participar da discussão

Entrar Criar conta

Carregando comentários...