Ir para conteúdo
Fórum Script Brasil
  • 0

ajuda php

hldr7

Perguntado por hldr7,

 Share

Pergunta

hldr7

hldr7

Postado
Postado (editado)

é 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.

Editado por hldr7
Link para o comentário
Compartilhar em outros sites

0 respostass a esta questão

Posts Recomendados

Até agora não há respostas para essa pergunta

Participe da discussão

Você pode postar agora e se registrar depois. Se você já tem uma conta, acesse agora para postar com sua conta.

Visitante
Responder esta pergunta...

×   Você colou conteúdo com formatação.   Remover formatação

  Apenas 75 emoticons são permitidos.

×   Seu link foi incorporado automaticamente.   Exibir como um link em vez disso

×   Seu conteúdo anterior foi restaurado.   Limpar Editor

×   Você não pode colar imagens diretamente. Carregar ou inserir imagens do URL.

×
 Share
Ir para lista de Perguntas


  • Estatísticas dos Fóruns

    • Tópicos
      152,2k
    • Posts
      652k
×
×
  • Criar Novo...