FM / views

/data/sites/web/unidosporsectorespt/htdocs/public/www/template/views/

/data/sites/web/unidosporsectorespt/htdocs/public/www/template/views

Name	Size	Mode	Actions
clientes/	-	0755	rm
revistas/	-	0755	rm
clients.php	5436	0644	edit dl rm
contactos.php	2771	0644	edit dl rm
inicio.php	1996	0644	edit dl rm
revistas.php	1557	0644	edit dl rm
sobre.php	2008	0644	edit dl rm
temas.php	5400	0644	edit dl rm

Edit: /data/sites/web/unidosporsectorespt/htdocs/public/www/template/views/clients.php (5436B)

</div>
<div class="center" id="client_center">
    <div style="width:100%; height:40px; padding-top:10px; text-align:center;">
        <div class="clients_pages">
        	<?php        
				include ("../../config/connection.php");
				
				$section = $_GET['id'];
				
				$q = "SELECT * FROM clientes WHERE zona = '$section'";
				
				$r = mysqli_query($dbc, $q);
				
				$amount_clients = mysqli_num_rows($r);
				
				$amount_pages = ceil($amount_clients / 9);
				
				for($i = 0; $i < $amount_pages; $i++){
					if($i < 7){
						echo '
							<div class="clients_buttons">
								<button id="page_'.($i+1).'" class="btn-client
						'; 
						if($i == 0) 
							echo 'active"';
						else
							echo '"';
						echo '>'.($i+1).'</button>
							</div>
						';
					} else {
						echo '
							<div class="clients_buttons">
								<button id="page_'.($i+1).'" class="
						'; 
						if($i == 0) 
							echo 'active"';
						else
							echo '"';
						echo '>...</button>
							</div>
						';
						break;					
					}
				}
			?>
        </div>
    </div>   
    <div class="row" style="height: 810px; margin-top: 0px; margin-bottom: 0px; text-align:center;">
        <div class="center clients_list" style="height: auto; text-align:center;">
        	<?php
				$q = "SELECT * FROM clientes WHERE zona = '$section' ORDER BY nome ASC LIMIT 9";  // ALTERAR PARA POR NOME!!!!!!!!!!!!!!!!!!!!!!!!
				
				$r = mysqli_query($dbc, $q);
				$i = 4.5;
				$j = 0;
				while($cliente = mysqli_fetch_assoc($r)){					
					$query = "SELECT * FROM images WHERE id = $cliente[image]";
					
					$res = mysqli_query($dbc, $query);
					
					$image = mysqli_fetch_assoc($res);
					
					echo '
						<div style="float:left; width:30%; height: 250px; margin-left:'.$i.'%; margin-top:15px;">
							<div style="display: table; width:100%; height:20%;">
								<p class="clients_title"><a href="template/views/clientes/cliente.php?id='.$cliente['id'].'" target="_blank">'.$cliente['nome'].'</a></p>
							</div>
							<div class="clients_image">	
								<a href="template/views/clientes/cliente.php?id='.$cliente['id'].'" target="_blank"><img src="../../uploads/Clientes/'.$cliente['nome'].'/'.$image['file'].'" width="90%" height="100%" alt=""/></a>
							</div>
						</div>
					';
					$j++;
					if(($j % 3) != 0)
						$i = 0.5;
					else
						$i = 4.5;
				}
			 ?> 
        </div>
    </div> 
    <div style="width:100%; height:40px; padding-top:10px; text-align:center;">
        <div class="clients_pages">
        	<?php        
				include ("../../config/connection.php");
				
				$q = "SELECT * FROM clientes WHERE zona = '$section'";
				
				$r = mysqli_query($dbc, $q);
				
				$amount_clients = mysqli_num_rows($r);
				
				$amount_pages = ceil($amount_clients / 9);
				
				for($i = 0; $i < $amount_pages; $i++){
					if($i < 7){
						echo '
							<div class="clients_buttons">
								<button id="page_'.($i+1).'" class="btn-client
						'; 
						if($i == 0) 
							echo 'active"';
						else
							echo '"';
						echo '>'.($i+1).'</button>
							</div>
						';
					} else {
						echo '
							<div class="clients_buttons">
								<button id="page_'.($i+1).'" class="
						'; 
						if($i == 0) 
							echo 'active"';
						else
							echo '"';
						echo '>...</button>
							</div>
						';
						break;					
					}
				}
			?>
        </div>
    </div>   
</div>

'; } else { echo '

'; break; } } ?>

'.$cliente['nome'].'

'; $j++; if(($j % 3) != 0) $i = 0.5; else $i = 4.5; } ?>