Ir para conteúdo
Fórum Script Brasil

hldr7

Membros
 Perfil  Explorar Conteúdo

  • Total de itens

    1

  • Registro em

  • Última visita

Sobre hldr7

hldr7's Achievements

0

Reputação

  1. hldr7

    ajuda php

    uma questão postou hldr7 PHP

    é o seguinte: criei um site onde coloco imagens. A galeria de imagens é de um script já feito. A esse script acrescentei um sistema de pesquisa, só que se existirem muitos resultados as imagens aparecem todas em fila na horizontal. O que eu queria era que os resultados aparecessem em filas de 4 imagens, como tenho na galeria. Esta é a minha galeria: <?php require_once('Connections/conAlbum.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $maxRows_rsFotos = 20; $pageNum_rsFotos = 0; if (isset($_GET['pageNum_rsFotos'])) { $pageNum_rsFotos = $_GET['pageNum_rsFotos']; } $startRow_rsFotos = $pageNum_rsFotos * $maxRows_rsFotos; mysql_select_db($database_conAlbum, $conAlbum); $query_rsFotos = "SELECT * FROM fotos ORDER BY IDfoto DESC"; $query_limit_rsFotos = sprintf("%s LIMIT %d, %d", $query_rsFotos, $startRow_rsFotos, $maxRows_rsFotos); $rsFotos = mysql_query($query_limit_rsFotos, $conAlbum) or die(mysql_error()); $row_rsFotos = mysql_fetch_assoc($rsFotos); if (isset($_GET['totalRows_rsFotos'])) { $totalRows_rsFotos = $_GET['totalRows_rsFotos']; } else { $all_rsFotos = mysql_query($query_rsFotos); $totalRows_rsFotos = mysql_num_rows($all_rsFotos); } $totalPages_rsFotos = ceil($totalRows_rsFotos/$maxRows_rsFotos)-1; mysql_select_db($database_conAlbum, $conAlbum); $query_rsAlbum = "SELECT * FROM Album ORDER BY IDalbum DESC"; $rsAlbum = mysql_query($query_rsAlbum, $conAlbum) or die(mysql_error()); $row_rsAlbum = mysql_fetch_assoc($rsAlbum); $totalRows_rsAlbum = mysql_num_rows($rsAlbum); ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel="stylesheet" href="images/Ablaze.css" type="text/css" /> <link rel="stylesheet" href="Css/lightbox.css" type="text/css" media="screen" /> &lt;script src="js/prototype.js" type="text/javascript"></script> &lt;script src="js/scriptaculous.js?load=effects" type="text/javascript"></script> &lt;script src="js/lightbox.js" type="text/javascript"></script> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Pop Art - Galeria</title> <link href="/Galeria/Css/principal.css" rel="stylesheet" type="text/css" /> <style type="text/css"> <!-- body { background-color: #0f0f0f; } .style1 {color: #999999} .Estilo1 { font-size: 12px; color: #0000FF; } --> </style> &lt;script src="../../Scripts/AC_RunActiveContent.js" type="text/javascript"></script> </head> <body> <table width="775" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td colspan="9"><img src="imagens/menu_top.jpg" width="775" height="50" /></td> </tr> <tr> <td width="151"><img src="imagens/menu_left.jpg" width="151" height="19" /></td> <td width="77"><a href="../index.html"><img src="imagens/pop_art.jpg" width="77" height="19" border="0" /></a></td> <td width="16"><img src="imagens/menu_center_1.jpg" width="16" height="19" /></td> <td width="77"><a href="../sobre_nos.html"><img src="imagens/sobre_nos.jpg" width="77" height="19" border="0" /></a></td> <td width="18"><img src="imagens/menu_center_2.jpg" width="18" height="19" /></td> <td width="77"><a href="index.php"><img src="imagens/galeria.jpg" width="77" height="19" border="0" /></a></td> <td width="18"><img src="imagens/menu_center_3.jpg" width="18" height="19" /></td> <td width="77"><a href="../contactos.html"><img src="imagens/contactos.jpg" width="77" height="19" border="0" /></a></td> <td width="264"><img src="imagens/menu_right.jpg" width="264" height="19" /></td> </tr> <tr> <td colspan="9"><img src="imagens/menu_bottom.jpg" width="775" height="18" /></td> </tr> <tr> <td colspan="9"><img src="imagens/index_image.jpg" width="775" height="223" /></td> </tr> </table> <table width="775" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><table width="100%" height="300" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="740" height="300" valign="top" class="table"><table width="775" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <th scope="col"> </th> <th scope="col"> </th> </tr> <tr> <th scope="col"><img src="imagens/barra_menu.jpg" width="170" height="25" border="0" /></th> <th scope="col"> </th> </tr> <tr> <th scope="col"><a href="../index.html"><img src="imagens/pop_art_lateral.jpg" width="170" height="22" border="0" /></a></th> <th scope="col"> </th> </tr> <tr> <th scope="col"><a href="../sobre_nos.html"><img src="imagens/sobre_nos_lateral.jpg" width="170" height="22" border="0" /></a></th> <th scope="col"> </th> </tr> <tr> <th scope="col"><a href="index.php"><img src="imagens/galeria_lateral.jpg" width="170" height="22" border="0" /></a></th> <th scope="col"> </th> </tr> <tr> <th scope="col"><a href="../contactos.html"><img src="imagens/contactos_lateral.jpg" width="170" height="22" border="0" /></a></th> <th scope="col"><form id="pesquisa2" name="pesquisa" method="post" action="pesquisa.php"> <label> <input type="text" name="pesquisa" id="pesquisa" /> </label> <label> <input type="submit" name="button2" id="button2" value="pesquisa" /> </label> </form></th> </tr> <tr> <th scope="col"> </th> <th scope="col"> </th> </tr> <tr> <th scope="col"><img src="imagens/barra_apoios.jpg" width="170" height="25" /></th> <th width="604" rowspan="13" scope="col"><table border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <?php do { // horizontal looper version 3 ?> <td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td> </td> <td> </td> <td> </td> </tr> <tr> <td> </td> <td align="right"><a href="http://domain2051310.sites.rumonet.org/fotos/<?php echo $row_rsFotos['Foto']; ?>" rel="lightbox[large]" title="<?php echo $row_rsFotos['Titulo']; ?> <br><?php echo $row_rsFotos['Descricao']; ?> "><img src="http://domain2051310.sites.rumonet.org/fotos/mini/<?php echo $row_rsFotos['Foto']; ?>" alt="<?php echo $row_rsFotos['Titulo']; ?>" border="0" /></a></td> <td> </td> </tr> <tr> <td> </td> <td align="right"></td> <td align="right"></td> </tr> </table></td> <?php $row_rsFotos = mysql_fetch_assoc($rsFotos); if (!isset($nested_rsFotos)) { $nested_rsFotos= 1; } if (isset($row_rsFotos) && is_array($row_rsFotos) && $nested_rsFotos++ % 4==0) { echo "</tr><tr>"; } } while ($row_rsFotos); //end horizontal looper version 3 ?> </tr> </table></th> </tr> <tr> <th width="171" scope="col">&lt;script type="text/javascript"> AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','170','height','290','src','../banner_dhk','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','../banner_dhk' ); //end AC code </script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="170" height="290"> <param name="movie" value="../banner_dhk.swf" /> <param name="quality" value="high" /> <embed src="../banner_dhk.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="170" height="290"></embed> </object></noscript></th> </tr> <tr> <th width="171" scope="col"> </th> </tr> <tr> <th scope="col"> </th> </tr> <tr> <th scope="col"> </th> </tr> <tr> <th scope="col"> </th> </tr> <tr> <th scope="col"> </th> </tr> <tr> <th scope="col"> </th> </tr> <tr> <th scope="col"> </th> </tr> <tr> <th scope="col"> </th> </tr> <tr> <th scope="col"> </th> </tr> <tr> <th scope="col"> </th> </tr> <tr> <th scope="col"> </th> </tr> </table> <p align="right" class="Estilo1"><a href="index.php">1</a> <a href="page2.php">2</a> <a href="page3.php">3</a> <a href="page2.php">Proxima</a> </p> <p align="right" class="Estilo1"> </p> <p align="right" class="Estilo1"> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p></td> </tr> </table></td> </tr> </table> <p> </p> <p align="right"> </p> </body> </html> <?php mysql_free_result($rsFotos); mysql_free_result($rsAlbum); ?> E esta a minha página de pesquisa: <?php require_once('Connections/conAlbum.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $colname_Recordset1 = "-1"; if (isset($_POST['pesquisa'])) { $colname_Recordset1 = $_POST['pesquisa']; } $text = GetSQLValueString("%" . $colname_Recordset1 . "%", "text"); mysql_select_db($database_conAlbum, $conAlbum); $query_Recordset1 = sprintf("SELECT * FROM fotos WHERE Titulo LIKE %s OR Descricao LIKE %s", $text, $text); $Recordset1 = mysql_query($query_Recordset1, $conAlbum) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel="stylesheet" href="images/Ablaze.css" type="text/css" /> <link rel="stylesheet" href="Css/lightbox.css" type="text/css" media="screen" /> &lt;script src="js/prototype.js" type="text/javascript"></script> &lt;script src="js/scriptaculous.js?load=effects" type="text/javascript"></script> &lt;script src="js/lightbox.js" type="text/javascript"></script> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Pop Art - Resultados</title> <link href="/Galeria/Css/principal.css" rel="stylesheet" type="text/css" /> <style type="text/css"> <!-- body { background-color: #0f0f0f; } .style1 {color: #999999} .Estilo1 { font-size: 12px; color: #0000FF; } --> </style> &lt;script src="../../Scripts/AC_RunActiveContent.js" type="text/javascript"></script> <body> <table width="777" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td colspan="9"><img src="../imagens/menu_top.jpg" width="775" height="50" /></td> </tr> <tr> <td width="151"><img src="../imagens/menu_left.jpg" width="151" height="19" /></td> <td width="77"><a href="../index.html"><img src="../imagens/pop_art.jpg" width="77" height="19" border="0" /></a></td> <td width="16"><img src="../imagens/menu_center_1.jpg" width="16" height="19" /></td> <td width="77"><a href="../sobre_nos.html"><img src="../imagens/sobre_nos.jpg" width="77" height="19" border="0" /></a></td> <td width="18"><img src="../imagens/menu_center_2.jpg" width="18" height="19" /></td> <td width="77"><a href="index.php"><img src="../imagens/galeria.jpg" width="77" height="19" border="0" /></a></td> <td width="18"><img src="../imagens/menu_center_3.jpg" width="18" height="19" /></td> <td width="77"><a href="../contactos.html"><img src="../imagens/contactos.jpg" width="77" height="19" border="0" /></a></td> <td width="266"><img src="../imagens/menu_right.jpg" width="264" height="19" /></td> </tr> <tr> <td colspan="9"><img src="../imagens/menu_bottom.jpg" width="775" height="18" /></td> </tr> <tr> <td colspan="9"><img src="../imagens/index_image.jpg" width="775" height="223" /></td> </tr> </table> <table width="775" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="171"> </td> <td width="604"> </td> </tr> <tr> <td><img src="../imagens/barra_menu.jpg" width="170" height="25" /></td> <td> </td> </tr> <tr> <td><a href="../index.html"><img src="../imagens/pop_art_lateral.jpg" width="170" height="22" border="0" /></a></td> <td> </td> </tr> <tr> <td><a href="../sobre_nos.html"><img src="../imagens/sobre_nos_lateral.jpg" width="170" height="22" border="0" /></a></td> <td> </td> </tr> <tr> <td><a href="index.php"><img src="../imagens/galeria_lateral.jpg" width="170" height="22" border="0" /></a></td> <td> </td> </tr> <tr> <th scope="col"><a href="../contactos.html"><img src="imagens/contactos_lateral.jpg" width="170" height="22" border="0" /></a></th> <th scope="col"><form id="pesquisa2" name="pesquisa" method="post" action="pesquisa.php"> <label> <input type="text" name="pesquisa" id="pesquisa" /> </label> <label> <input type="submit" name="button2" id="button2" value="pesquisa" /> </label> </form></th> <tr> <td> </td> <td> </td> </tr> <tr> <td><img src="../imagens/barra_apoios.jpg" width="170" height="25" /></td> <td> </td> </tr> <tr> <td rowspan="8">&lt;script type="text/javascript"> AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','170','height','290','src','../banner_dhk','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','../banner_dhk' ); //end AC code </script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="170" height="290"> <param name="movie" value="../banner_dhk.swf" /> <param name="quality" value="high" /> <embed src="../banner_dhk.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="170" height="290"></embed> </object></noscript></td> <td> </td> </tr> <tr> <td><table width="100" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <?php do { ?> <td><a href="http://domain2051310.sites.rumonet.org/fotos/<?php echo $row_Recordset1['Foto']; ?>" rel="lightbox[large]" title="<?php echo $row_Recordset1['Titulo']; ?> <br><?php echo $row_Recordset1['Descricao']; ?> "><img src="http://domain2051310.sites.rumonet.org/fotos/mini/<?php echo $row_Recordset1['Foto']; ?>" alt="<?php echo $row_Recordset1['Titulo']; ?>" border="0" /> </a></td> <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?></tr> </table></td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> </table> <table width="775" height="365" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td> </td> </tr> </table> </body> </html> <?php mysql_free_result($Recordset1); ?> Também podem ver a galeria em funcionamento na página http://popart-esfh.com/galeria/ O que eu queria era que me dissessem o que eu tenho que mudar na página pesquisa para ficar como na página galeria, ou seja, em filas de 4 imagens.
×
×
  • Criar Novo...