Exemple #1
0
        <?php 
if (!isset($_GET['art'])) {
    ?>
            <div style="height:20px;"></div>
            <form method="GET" action="/">
                <center>
                    <input type="text" name="q" id="search" class="search-button-after" placeholder="Find someone to help">
                </center>
            </form>
        <?php 
}
?>

        <?php 
if (isset($_GET['q'])) {
    $busca = protege_busca($_GET['q']);
    $page = isset($_GET['page']) ? $_GET['page'] : 1;
    $sql = "SELECT * FROM artes WHERE nome_arte LIKE '%" . $busca . "%' ORDER BY id DESC";
    $query = mysqli_query($mysqli, $sql);
    $total_artes = mysqli_num_rows($query);
    $registros = 10;
    $numPaginas = ceil($total_artes / $registros);
    $inicio = $registros * $page - $registros;
    $sql2 = "SELECT * FROM artes WHERE nome_arte LIKE '%" . $busca . "%' ORDER BY id DESC LIMIT {$inicio}, {$registros} ";
    $artes_pagina = mysqli_query($mysqli, $sql2);
    $total = mysqli_num_rows($artes_pagina);
    $pagina_atual = isset($_GET['page']) ? $_GET['page'] : 1;
    $max_links = 6;
    $links_laterais = ceil($max_links / 2);
    $inicio = $pagina_atual - $links_laterais;
    $limite = $pagina_atual + $links_laterais;

		<div class="gallery">
            <div class="txtg" style="margin-top:20px;">Search: <?php 
echo protege_busca($_GET['q']);
?>
</div>
            <br>
            <div style="margin-left:-35px;">
            <ol style="width: 630px;">
                <?php 
while ($arte = mysqli_fetch_assoc($artes_pagina)) {
    ?>
                        <?php 
    $artista = buscar_dados_artista($mysqli, $arte['cadastro_id']);
    $usuario_artista = $artista['usuario'];
    $nome_artista = $artista['nome'];
    $foto_artista = buscar_foto($mysqli, $arte['cadastro_id']);
    ?>
                    <li align="center" style="display: inline-block; width: 300px;">
                        <div class="view view-fifth">
                            <img src="http://sharingdreams.url.ph/artes/<?php 
    echo $arte['nome'];
    ?>
" style="width:300px; height: 200px;"/>
                            <div class="mask">
                                <center>
                                    <br>Did you like it?
                                    <br>    <a href="#" style="margin-top:15px;" class="donate">
                                        Donate $1
                                    </a>