Montando Tabela de acordo com o retorno da consulta
18/12/2012
0
Bom Dia galera
Criando uma tabela e de 9x9 sendo que em cada celula eu retorno uma consulta mysql.
Eu ate consegui fazer porém em cada linha mostra o mesmo resultado
###############------#############---------############
###############------#############---------############
#####ID 1######------#####ID 1###----------#####ID 1###
###############------#############---------############
###############------#############---------############
###############------#############---------############
e eu queria que fosse tipo assim - eu quero usar um laço de repetição porém não to conseguindo chegar na lógica correta.
###############------#############---------############
###############------#############---------############
#####ID 1######------#####ID 2###----------#####ID 3###
###############------#############---------############
###############------#############---------############
###############------#############---------############
###############------#############---------############
###############------#############---------############
#####ID 4######------#####ID 5###----------#####ID 6###
###############------#############---------############
###############------#############---------############
###############------#############---------############
###############------#############---------############
###############------#############---------############
#####ID 7######------#####ID 8###----------#####ID 9###
###############------#############---------############
###############------#############---------############
###############------#############---------############
tem um site exemplo e o site da barrocarte
Segue o Codigo da tabela
ta ai o Código se alguém puder me ajudar serei grato. Moderador se eu tiver postado em local incorreto me desculpe e o meu primeiro post.
Criando uma tabela e de 9x9 sendo que em cada celula eu retorno uma consulta mysql.
Eu ate consegui fazer porém em cada linha mostra o mesmo resultado
###############------#############---------############
###############------#############---------############
#####ID 1######------#####ID 1###----------#####ID 1###
###############------#############---------############
###############------#############---------############
###############------#############---------############
e eu queria que fosse tipo assim - eu quero usar um laço de repetição porém não to conseguindo chegar na lógica correta.
###############------#############---------############
###############------#############---------############
#####ID 1######------#####ID 2###----------#####ID 3###
###############------#############---------############
###############------#############---------############
###############------#############---------############
###############------#############---------############
###############------#############---------############
#####ID 4######------#####ID 5###----------#####ID 6###
###############------#############---------############
###############------#############---------############
###############------#############---------############
###############------#############---------############
###############------#############---------############
#####ID 7######------#####ID 8###----------#####ID 9###
###############------#############---------############
###############------#############---------############
###############------#############---------############
tem um site exemplo e o site da barrocarte
Segue o Codigo da tabela
<?php include('Connections/conecao.php'); ?> <!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> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" align="top" valign="top"> <tr> <td height="90%"> <table width="100%" height="90%" border="0" cellpadding="0" cellspacing="10" align="center" valign="top"> <tr> <?php $sql = mysql_query("SELECT id,titulo,especificacoes,alt,diretorio FROM galeria WHERE id_album =19 LIMIT 21"); while($ln = mysql_fetch_array($sql)){ ?> <td valign="top" align="center" class="caixa_produto"> <div id="go"> <ul id="gop"> <h2 class="nome_produto"><?php echo utf8_encode( $ln['titulo']);?> (CÓD:<?php echo utf8_encode( $ln['id']);?>)</h2> <center> <a href="admin/galeria/<?php echo $ln['diretorio']?> <?php $ln['id']?>" class="lightbox" title="<?php echo $ln['titulo']?>"> <img src="admin/galeria/<?php echo utf8_encode( $ln['diretorio']);?> <?php $ln['id']?>" class="imagem_pqn" border="0" alt="<?php utf8_encode( $ln['alt']);?>" /></a> </center> <br> </li> </td> <td valign="top" align="center" class="caixa_produto"> <div id="go"> <ul id="gop"> <h2 class="nome_produto"><?php echo utf8_encode( $ln['titulo']);?> (CÓD:<?php echo utf8_encode( $ln['id']);?>)</h2> <center> <a href="admin/galeria/<?php echo $ln['diretorio']?> <?php $ln['id']?>" class="lightbox" title="<?php echo $ln['titulo']?>"> <img src="admin/galeria/<?php echo utf8_encode( $ln['diretorio']);?> <?php $ln['id']?>" class="imagem_pqn" border="0" alt="<?php utf8_encode( $ln['alt']);?>" /></a> </center> <br> </li> </td> <td valign="top" align="center" class="caixa_produto"> <div id="go"> <ul id="gop"> <h2 class="nome_produto"><?php echo utf8_encode( $ln['titulo']);?> (CÓD:<?php echo utf8_encode( $ln['id']);?>)</h2> <center> <a href="admin/galeria/<?php echo $ln['diretorio']?> <?php $ln['id']?> " class="lightbox" title="<?php echo $ln['titulo']?>"> <img src="admin/galeria/<?php echo utf8_encode( $ln['diretorio']);?> <?php $ln['id']?>" class="imagem_pqn" border="0" alt="<?php utf8_encode( $ln['alt']);?>" /></a> </center> <br> </li> </td> </tr> <?php }?> <tr> </tr> </table> </td> </tr> <tr height="30px"> <td align="center"><img src="images/pantanal_tema/linha.gif" height="1"> <div id="container_paginacao"> </div> </td> </tr> </table> <form method="POST" name="produto" action="carrinho.asp"> <input type="hidden" name="codigo_produto" value=""> <input type="hidden" name="codigo_categoria" value=""> <input type="hidden" name="ato" value="FIM"> <input type="hidden" name="mode" value="comprar"> </form> </td> </tr> </table> </body> </html>
ta ai o Código se alguém puder me ajudar serei grato. Moderador se eu tiver postado em local incorreto me desculpe e o meu primeiro post.
Jefferson Silva
Curtir tópico
+ 0
Responder
Posts
20/12/2012
Felipe Ribeiro
Boa tarde !
Tenta isso aí!
Qualquer dúvida é só falar.
Tenta isso aí!
<?php include('Connections/conecao.php'); ?> <!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> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" align="top" valign="top"> <tr> <td height="90%"> <table width="100%" height="90%" border="0" cellpadding="0" cellspacing="10" align="center" valign="top"> <tr> <?php $count = 0 $sql = mysql_query("SELECT id,titulo,especificacoes,alt,diretorio FROM galeria WHERE id_album =19 LIMIT 21"); while($ln = mysql_fetch_array($sql)){ ?> <td valign="top" align="center" class="caixa_produto"> <div id="go"> <ul id="gop"> <h2 class="nome_produto"> <?php echo utf8_encode( $ln['titulo']);?> (CÓD: <?php echo utf8_encode( $ln['id']);?> ) </h2> <center> <a href="admin/galeria/<?php echo $ln['diretorio']?> <?php $ln['id']?>" class="lightbox" title="<?php echo $ln['titulo']?>"> <img src="admin/galeria/<?php echo utf8_encode( $ln['diretorio']);?> <?php $ln['id']?>" class="imagem_pqn" border="0" alt="<?php utf8_encode( $ln['alt']);?>" /> </a> </center> <br> </li> </td> <?php if( ($count % 3) == 0){?> </tr> <tr> <?php }?> <?php $count++; } ?> </tr> </table> </td> </tr> <tr height="30px"> <td align="center"><img src="images/pantanal_tema/linha.gif" height="1"> <div id="container_paginacao"></div> </td> </tr> </table> <form method="POST" name="produto" action="carrinho.asp"> <input type="hidden" name="codigo_produto" value=""> <input type="hidden" name="codigo_categoria" value=""> <input type="hidden" name="ato" value="FIM"> <input type="hidden" name="mode" value="comprar"> </form> </td> </tr> </table> </body> </html>
Qualquer dúvida é só falar.
Responder
21/12/2012
Jefferson Silva
O Felipe Valeu maninho deu certinho so precisei mudar um pedaço do codigo.
mudei esse trecho.
para esse
Ou Muito Obrigado e valeu se tiver mais duvidas vou perguntar. rsrsrs
mudei esse trecho.
<?php $count = 0 $sql = mysql_query("SELECT id,titulo,especificacoes,alt,diretorio FROM galeria WHERE id_album =19 LIMIT 21"); while($ln = mysql_fetch_array($sql)){ ?>
para esse
<?php $count = 1; $sql = mysql_query("SELECT id,titulo,especificacoes,alt,diretorio FROM galeria WHERE id_album =19 LIMIT 21"); while($ln = mysql_fetch_array($sql)){ ?>
Ou Muito Obrigado e valeu se tiver mais duvidas vou perguntar. rsrsrs
Responder
Clique aqui para fazer login e interagir na Comunidade :)