..:: MX Studio Fóruns ::..: caracteres errados - ..:: MX Studio Fóruns ::..

Jump to content

Publicidade




ATENÇÃO

Para evitar posts desnecessários e que não influam para o andamento e desenvolvimento do fórum, clique aqui e leia todas as regras.
Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

caracteres errados valor carregado no dropdown está com caracteres errados

#1 User is offline   ricardoelias 

  • Group: Membros
  • Posts: 153
  • Joined: 14-July 04

  Posted 29 May 2007 - 03:15 PM

Bom preciso de um grande força
deem uma olhada em:
www.ricardoelias.com/agendasalto/index.php

tem alguns drops ao lado... nem todos estão funcionando
e os que estão como imprensa os caracteres estão errados como.. o rádio por exemplo.

alguém sabe como resolve?
eu acredito que seja por causa da acentuação
obrigado
0

#2 User is offline   c0pp3rf13ld 

  • Group: Membros
  • Posts: 118
  • Joined: 09-February 05

Posted 29 May 2007 - 05:14 PM


setlocale(LC_CTYPE,"pt_BR");

Inclua no texto de saída utf8_encode
0

#3 User is offline   ricardoelias 

  • Group: Membros
  • Posts: 153
  • Joined: 14-July 04

Posted 30 May 2007 - 11:04 AM

os valores vão aparecer dentro de um drop... será que eh mais fácil.. eu definir a variavel fora... colocar esse comando e depois jogar o resultado no drop?
qual seria a melhor maneira?
Abraço
0

#4 User is offline   c0pp3rf13ld 

  • Group: Membros
  • Posts: 118
  • Joined: 09-February 05

Posted 30 May 2007 - 05:11 PM

Como vc mostra o conteúdo da drop? Não usa um loop? Não pesquisa no bd?


0

#5 User is offline   ricardoelias 

  • Group: Membros
  • Posts: 153
  • Joined: 14-July 04

  Posted 31 May 2007 - 09:12 AM

tenho loop e BD
imagina o BD assim

ID
CAT (de categoria)
SUBCAT (de subcategoria)

no começo do código eu criei 18 variavei (podia ter criado array mais preferi usar variavel msm)
por exemplo

$cat1 = "Alimentos e Bebidas"

Alimentos e bebidas é uma categoria

ai eu vo jogar isso no Drop

Conecto com o BD
Faz a busca com SQL e no Where eu procuro tudo onde CAT=$cat1
por exemplo
ai faço um loop pra alimenta o drop

que eu quero saber é se lá em cima onde tá
$cat1 = "Alimentos e Bebidas"
eu usa o setlocation resolve

ABRAÇO
0

#6 User is offline   c0pp3rf13ld 

  • Group: Membros
  • Posts: 118
  • Joined: 09-February 05

Posted 31 May 2007 - 05:46 PM

Usa ele no início do script
0

#7 User is offline   Djulian M. 

  • Group: Membros
  • Posts: 17
  • Joined: 18-April 07

Posted 01 June 2007 - 09:56 AM

substitui esse

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

pelo q vc tem no seu codigo.
0

#8 User is offline   ricardoelias 

  • Group: Membros
  • Posts: 153
  • Joined: 14-July 04

Posted 10 June 2007 - 02:10 PM

mudei a linha do meta... e o setlocate tbm coloquei o código fico assim

CODE
<?
setlocale(LC_CTYPE,"pt_BR");
$cat1  = "Alimentos e Bebidas";
$cat2  = "Animais / Agropecuária";
$cat3  = "Automóveis e Veículos";
$cat4  = "Casa e Construção";
$cat5  = "Educação e Cultura";
$cat6  = "Esporte, Lazer e Turismo";
$cat7  = "Festas e Eventos";
$cat8  = "Imprensa";
$cat9  = "Indústria";
$cat10 = "Instituições";
$cat11 = "Informática";
$cat12 = "Lojas / Comércio em Geral";
$cat13 = "Medicina e Saúde";
$cat14 = "Moda";
$cat15 = "Segurança";
$cat16 = "Saúde e Beleza";
$cat17 = "Serviços";
$cat18 = "Serviços Públicos";
?>





<HTML><HEAD><TITLE>Agenda Salto :: A agenda eletrônica + prática da cidade!</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<STYLE>TD {
    FONT-SIZE: 10px; FONT-FAMILY: verdana
}
list {
    FONT-SIZE: 9px; FONT-STYLE: normal
}
A.bot {
    PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-WEIGHT: 900; FONT-SIZE: 10px; COLOR: #ffffff; FONT-FAMILY: Verdana; TEXT-DECORATION: none
}
A:hover {
    COLOR: #a6b3bc
}
.copy {
    PADDING-RIGHT: 10px;
    PADDING-LEFT: 10px;
    FONT-SIZE: 10px;
    COLOR: #333333;
    FONT-FAMILY: verdana;
    TEXT-DECORATION: none;
    width: 175px;
    
}
.terms {
    PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE: 10px; COLOR: #5067af; FONT-FAMILY: verdana; TEXT-DECORATION: none
}
.style2 {
    FONT-SIZE: 9px; COLOR: #ffffff; FONT-FAMILY: Arial, Helvetica, sans-serif
}
</STYLE>

<script
src="images/AC_RunActiveContent.js"
type=text/javascript></SCRIPT>

<script type=text/JavaScript>
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</SCRIPT>

<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<BODY vLink=#00458b aLink=#00458b link=#00458b bgColor=#ffffff leftMargin=0
topMargin=0
onload="MM_preloadImages('images/b3_a.jpg','images/b1_a.jpg','images/b2_a.jpg')"
MARGINHEIGHT="0" MARGINWIDTH="0">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0><!--DWLayoutTable-->
  <TBODY>
  <TR>
    <TD vAlign=top width=260 height=171><IMG height=171
      src="images/top.jpg"
      width=260></TD>
    <TD vAlign=top width="100%">
      <TABLE cellSpacing=0 cellPadding=0 width="100%"
      background="images/tr.jpg"
      border=0><!--DWLayoutTable-->
        <TBODY>
        <TR>
          <TD width="100%" height=171>&nbsp;</TD></TR></TBODY></TABLE></TD>
    <TD vAlign=top width=512>
      <script type=text/javascript>
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0','width','511','height','171','src','images/topo','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','movie','images/topo' ); //end AC code
</SCRIPT></TD>
  </TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0><!--DWLayoutTable-->
  <TBODY>
  <TR>
    <TD vAlign=center align=left width=261
    background="images/search-fon.jpg"
    height=37><div align="center"><SPAN style="PADDING-LEFT: 70px; PADDING-TOP: 10px">
      <INPUT
      style="WIDTH: 100px" name=textfield>
      <INPUT type=image
      src="images/search.jpg"
      align=middle name=image>
    </SPAN></div></TD>
    <TD vAlign=top width=340><A
      onmouseover="MM_swapImage('botao1','','images/b1_a.jpg',1)"
      onmouseout=MM_swapImgRestore()
      href="http://www.sacinterativa.com.br/agendasalto/#"><IMG height=37
      src="images/b1.jpg"
      width=120 border=0 name=botao1></A><A
      onmouseover="MM_swapImage('botao2','','images/b2_a.jpg',1)"
      onmouseout=MM_swapImgRestore()
      href="http://www.sacinterativa.com.br/agendasalto/#"><IMG height=37
      src="images/b2.jpg"
      width=100 border=0 name=botao2></A><A
      href="http://www.sacinterativa.com.br/agendasalto/"></A><A
      onmouseover="MM_swapImage('botao3','','images/b3_a.jpg',1)"
      onmouseout=MM_swapImgRestore()
      href="http://www.sacinterativa.com.br/agendasalto/#"><IMG height=37
      src="images/b3.jpg"
      width=120 border=0 name=botao3></A></TD>
    <TD vAlign=top align=right
    background="images/h.gif">
      <script type=text/javascript>
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0','width','150','height','37','src','relogio','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','movie','relogio' ); //end AC code
      </SCRIPT>      <NOSCRIPT></OBJECT>
      </NOSCRIPT>
      
      </TD></TR></TBODY></TABLE>
<TABLE style="BACKGROUND-REPEAT: repeat-x" cellSpacing=0 cellPadding=0
width="100%" border=0><!--DWLayoutTable-->
  <TBODY>
  <TR>
    <TD vAlign=top width=248 bgColor=#f4ffd7 rowSpan=2>
      <TABLE height="100%" cellSpacing=0 cellPadding=0 width="90%" border=0><!--DWLayoutTable-->
        <TBODY>
        <TR>
          <TD vAlign=top width=247 height="100%"><IMG
            src="images/search-end.jpg"><A
            href="http://www.sacinterativa.com.br/agendasalto/"><BR></A>
            <TABLE cellSpacing=0 cellPadding=0 width=261 border=0>
              <TBODY>
              <TR>
                <TD><IMG height=21
                  src="images/c1.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top align=left width=261
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>
                      <select name="<? $cat1 ?>" class="copy" id="<? $cat1 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat1'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat1) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select>
                        </TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD height=14><IMG height=21
                  src="images/c2.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right><select name="<? $cat2 ?>" class="copy" id="<? $cat2 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat2'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat2) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']) ?></option>
                        <? } // fim do while ?>
                        </select></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"
                height=14><IMG height=21
                  src="images/c3.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>
                      <select name="<? $cat3 ?>" class="copy" id="<? $cat3 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat3'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat3) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select>
                        </TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"
                height=14><IMG height=21
                  src="images/c4.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>
                      <select name="<? $cat4 ?>" class="copy" id="<? $cat4 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat4'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat4) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"
                height=8><IMG height=21
                  src="images/c6.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>
                      <select name="<? $cat5 ?>" class="copy" id="<? $cat5 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat5'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat5) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select>
                        </TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"><IMG
                  height=21
                  src="images/c17.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>
                      <select name="<? $cat6 ?>" class="copy" id="<? $cat6 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat6'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat6) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select>
                        </TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"><IMG
                  height=21
                  src="images/c7.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>
                      <select name="<? $cat7 ?>" class="copy" id="<? $cat7 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat7'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat7) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"><IMG
                  height=21
                  src="images/c7.1.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>
                      <select name="<? $cat8 ?>" class="copy" id="<? $cat8 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat8'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat8) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"><IMG
                  src="images/c8.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>
                      <select name="<? $cat9 ?>" class="copy" id="<? $cat9 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat9'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat9) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"><IMG
                  height=21
                  src="images/c9.1.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>                      
                      <select name="<? $cat10 ?>" class="copy" id="<? $cat10 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat10'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat10) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"><IMG
                  height=21
                  src="images/c9.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>
                      <select name="<? $cat11 ?>" class="copy" id="<? $cat11 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat11'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat11) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"><IMG
                  height=21
                  src="images/c10.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>                      
                      <select name="<? $cat12 ?>" class="copy" id="<? $cat12 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat12'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat12) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"><IMG
                  height=21
                  src="images/c11.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>
                      <select name="<? $cat13 ?>" class="copy" id="<? $cat13 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat13'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat13) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select>
                        </TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"><IMG
                  height=21
                  src="images/c12.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>                      
                      <select name="<? $cat14 ?>" class="copy" id="<? $cat14 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat4'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat14) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"><IMG
                  height=21
                  src="images/c13.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>                      
                      <select name="<? $cat15 ?>" class="copy" id="<? $cat15 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat15'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat15) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"
                height=14><IMG height=21
                  src="images/c14.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>                      
                      <select name="<? $cat16 ?>" class="copy" id="<? $cat16 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat16'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat16) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"><IMG
                  height=21
                  src="images/c15.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>                      
                      <select name="<? $cat17 ?>" class="copy" id="<? $cat17 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat17'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat17) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select></TD></TR></TBODY></TABLE></TD></TR>
              <TR>
                <TD
                background="images/2.jpg"><IMG
                  height=21
                  src="images/c16.jpg"
                  width=247></TD></TR>
              <TR>
                <TD vAlign=top
                background="images/2.jpg"
                height=40>
                  <TABLE cellSpacing=0 cellPadding=0 width=220 border=0>
                    <TBODY>
                    <TR>
                      <TD width=55>&nbsp;</TD>
                      <TD align=right>
                      <select name="<? $cat18 ?>" class="copy" id="<? $cat18 ?>" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat18'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat18) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select>
                        </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD>
    <TD vAlign=top><p>&nbsp;</p>
      <table width="95%" border="0" align="center">
        <tr>
          <td><? if(!empty($pag))
                                    {
                                        include($pag.".php");
                                    } ?></td>
        </tr>
      </table>      <p>&nbsp;</p></TD>
    <TD class=style2 vAlign=top align=left width=130 bgColor=#f5f5f5
      rowSpan=2><STYLE type=text/css>BODY {
    MARGIN: 0px
}
.publicis {
    FONT-SIZE: 9px; COLOR: #999999; FONT-FAMILY: Arial, Helvetica, sans-serif
}
</STYLE>

      <script type=text/JavaScript>

<!--

function MM_openBrWindow(theURL,winName,features) { //v2.0

  window.open(theURL,winName,features);

}

//-->

</SCRIPT>

      <TABLE cellSpacing=0 cellPadding=0 width=130 border=0>
        <TBODY>
        <TR>
          <TD vAlign=center align=middle bgColor=#ffffff height=5></TD></TR>
        <TR>
          <TD vAlign=top align=middle bgColor=#ffffff><A class=style18
            href="http://www.mbarquiteto.com.br/" target=_blank><IMG
            alt="MᲣio Bortolucci"
            src="images/8d97d79811.jpg"
            align=absMiddle border=0></A></TD></TR>
        <TR>
          <TD vAlign=top align=middle bgColor=#ffffff height=10></TD></TR>
        <TR>
          <TD vAlign=top align=middle bgColor=#ffffff><A class=style18
            href="http://www.sacinterativa.com.br/agendasalto/"
            target=_blank><IMG alt="Retifica Tapera"
            src="images/7600ce3247.jpg"
            align=absMiddle border=0></A></TD></TR>
        <TR>
          <TD vAlign=top align=middle bgColor=#ffffff height=10></TD></TR>
        <TR>
          <TD vAlign=top align=middle bgColor=#ffffff><A class=style18
            href="http://sacinterativa.com.br/planos.php" target=_blank><IMG
            alt="Hospedagem - SAC Interativa"
            src="images/8092dcfa5a.gif"
            align=absMiddle border=0></A></TD></TR>
        <TR>
          <TD vAlign=top align=middle bgColor=#ffffff height=10></TD></TR>
        <TR>
          <TD vAlign=top align=middle bgColor=#ffffff><A class=style18
            href="http://www.sacinterativa.com.br/popups/master1.html"
            target=_blank><IMG alt="Master Pizza"
            src="images/7937deb752.gif"
            align=absMiddle border=0></A></TD></TR>
        <TR>
          <TD vAlign=top align=middle bgColor=#ffffff
      height=10></TD></TR></TBODY></TABLE></TD></TR>
  <TR>
    <TD vAlign=top><!--DWLayoutEmptyCell-->&nbsp;</TD>
  </TR></TBODY></TABLE>
<TABLE cellSpacing=0 cellPadding=0 width="100%"
background="images/niz-1.jpg"
border=0><!--DWLayoutTable-->
  <TBODY>
  <TR>
    <TD vAlign=top width="100%"
  height=30><!--DWLayoutEmptyCell-->&nbsp;</TD></TR></TBODY></TABLE></BODY></HTML>


mais ainda num tá legal
ve como tá ficando
Agendasalto

brigadão pela força e paciencia galera
0

#9 User is offline   ricardoelias 

  • Group: Membros
  • Posts: 153
  • Joined: 14-July 04

Posted 10 June 2007 - 02:25 PM

outra duvida.. vou ter de passar o valor da dropdown via url pra abrir a outra pagina...
baseado no codigo que postei anteriormente...
como faço isso?

ele tem que mostrar os 11 ultimos de cada categoria
e tem um campo chamado ordem no BD
pra ele ordenar a sequencia que ele quer...


0

#10 User is offline   ricardoelias 

  • Group: Membros
  • Posts: 153
  • Joined: 14-July 04

Posted 11 June 2007 - 06:41 PM

GALERA POR FAVOR PRECISO RESOLVER ESSE PROBLEMA MEIO RAPIDO
0

#11 User is offline   c0pp3rf13ld 

  • Group: Membros
  • Posts: 118
  • Joined: 09-February 05

Posted 11 June 2007 - 09:22 PM

Aqui está aparecendo normalmente os caracteres com a cento e tudo mais. Para mostrar os últimos 11 use a condição do Sql LIMIT, para passar o valor para outra página use o MÉTODO POST ou GET.
0

#12 User is offline   ricardoelias 

  • Group: Membros
  • Posts: 153
  • Joined: 14-July 04

Posted 13 June 2007 - 11:57 AM

QUOTE(c0pp3rf13ld @ 11/6/2007 20:06:47) View Post
Aqui está aparecendo normalmente os caracteres com a cento e tudo mais. Para mostrar os últimos 11 use a condição do Sql LIMIT, para passar o valor para outra página use o MÉTODO POST ou GET.


Então parceiro.. alguns drops ele mostra... outros não...
acredito que justamente por causa da acentuação
por exemplo o Drop de Alimentos ok... o de baixo não
o Drop de Imprensa tá tbm.. mais a maioria tem acentuação
e DENTRO dos drops os registros tbm aparecem com caracteres errados

como resolvo?
0

#13 User is offline   Wanderson Regis 

  • Group: Moderadores
  • Posts: 1275
  • Joined: 10-January 05

Posted 13 June 2007 - 02:20 PM

tente usar a função htmlentities antes de gravar no bd, assim todos os caracteres serão reonhecidos sem problemas por ele, e então quando for ler para criar os seus conjuntos de opções, lerá sem conflitos de linguagem, além de tornar a acentuação legível universalmente.
0

#14 User is offline   ricardoelias 

  • Group: Membros
  • Posts: 153
  • Joined: 14-July 04

  Posted 17 June 2007 - 08:53 AM

Nossa parcero valew pela dica.. eu num queria dar trabalho ai procurei no google como poderia aplicar essa função no meu código...
só que deu uns erro estranho ai voltei no que era...

meu cadastro ta simples.. mais num sei como colocar essa função nela

CODE
<? if (!empty($fcat)){
        include("conectabd.php");
        mysql_query("INSERT INTO categorias VALUES ('','$fsub','$fcat') ") or die ("Erro: ".mysql_error());
        ?>
        <script language="javascript">
        alert("incluso com sucesso")
        </script>
        <?    }  ?>

<head>
<style type="text/css">
<!--
body {
    margin-left: 0px;
    margin-top: 0px;
    margin-right: 0px;
    margin-bottom: 0px;
}
.texto {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size:10px;
}
.titulo{
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size:12px;
font-weight:bold;
}
-->
</style></head>

<body>
<form id="form1" name="form1" method="post" action="">
  <table width="620" border="0" align="center" class="texto">
    <tr>
      <td height="30" colspan="2" class="titulo">CADASTRO DE CATEGORIAS </td>
    </tr>
    <tr>
      <td width="77">CATEGORIA</td>
      <td width="533"><label>
        <input name="fcat" type="text" id="fcat" />
      </label></td>
    </tr>
    <tr>
      <td>SUBCATEGORIA</td>
      <td><label>
        <input name="fsub" type="text" id="fsub" />
      </label></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><label>
        <input type="submit" name="Submit" value="Gravar" />
      </label></td>
    </tr>
  </table>
</form>
</body>
</html>


valeu

0

#15 User is offline   Wanderson Regis 

  • Group: Moderadores
  • Posts: 1275
  • Joined: 10-January 05

Posted 18 June 2007 - 09:41 AM

A função deve ser aplicada de forma a modificar a variável antes de ela ser enviada para o banco de dados, o uso é simples:
PHP
<?
$variavel = htmlentities($_POST['variavel']);
mysql_query('INSERT INTO tabela VALUES '.$variavel);
?>
<?
$variavel = htmlentities($_POST['variavel']);
mysql_query('INSERT INTO tabela VALUES '.$variavel);
?>

0

#16 User is offline   ricardoelias 

  • Group: Membros
  • Posts: 153
  • Joined: 14-July 04

Posted 18 June 2007 - 10:50 PM

H4ck3r

TO TE DEVENDO UAM CERVEJA BROTHER!!!

na verdade eu mudei o select
CODE
<select name="pag" class="copy" id="pag" onChange="submit()">
                      <option>Selecione uma categoria</option>
                        <?
                          include "adm/conectabd.php";
                        $sql = "select * from categorias where cat='$cat18'";
                        $result = mysql_query($sql);
                        while ($linha = mysql_fetch_array($result)) {
                        ?>
                          <option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $pag) { echo "SELECTED"; } ?>>
                        <? print strtoupper ($linha['subcat']); ?></option>
                        <? } // fim do while ?>
                        </select>

e resolveu!!!
mais agradeço muito a paciencia!!!
assim que pude me avisa pra eu te pagar a cerveja... valew!!!
0

#17 User is offline   Wanderson Regis 

  • Group: Moderadores
  • Posts: 1275
  • Joined: 10-January 05

Posted 19 June 2007 - 05:25 PM

Quando vc vier pra Belo Horizonte a gente resolve isso!!! XD
0

#18 User is offline   ricardoelias 

  • Group: Membros
  • Posts: 153
  • Joined: 14-July 04

Posted 10 July 2007 - 09:04 AM

E ae Galera ai ai ai.. to com outro problema!
os drop down não dão refresh na pagina...
é como se não tivesse enviando a variavel pra URL.

ve lá como tá

AgendaSalto

o código é esse mesmo ai em cima!

Não sei o que acontece .. já fiz isso outras vezes e deu cero a diferença é que antes tinha um drop só agora sã ovarios

como arrumo isso?

OBRIGADOOOO
0

#19 User is offline   Wanderson Regis 

  • Group: Moderadores
  • Posts: 1275
  • Joined: 10-January 05

Posted 10 July 2007 - 01:05 PM

Procurei mas não achei no código que vc enviou a declaração em nenhum trecho javascript a declaração da função submit. Ela está incluida em algum código externo?
0

#20 User is offline   ricardoelias 

  • Group: Membros
  • Posts: 153
  • Joined: 14-July 04

Posted 10 July 2007 - 05:26 PM

Cada Drop tem o Seu onChange="submit()" , eu pensava que Submit() era uma função interna, nunca precisei definir ele, pelo menos não me lembro de precisar defini-lo.

CODE
<select name="<? $cat18 ?>" class="copy" id="<? $cat18 ?>" onChange="submit()">
<option>Selecione uma categoria</option>
<?
include "adm/conectabd.php";
$sql = "select * from categorias where cat='$cat18'";
$result = mysql_query($sql);
while ($linha = mysql_fetch_array($result)) {
?>
<option value="<? echo $linha['id']; ?>" <? if ($linha['id'] == $cat18) { echo "SELECTED"; } ?>>
<? print strtoupper ($linha['subcat']); ?></option>
<? } // fim do while ?>
</select>


e troque tbm

<? print strtoupper ($linha['subcat']); ?></option>

por

<? echo ($linha['subcat']); ?></option>

pode ter sido isso? Acho que não né?
0

#21 User is offline   Wanderson Regis 

  • Group: Moderadores
  • Posts: 1275
  • Joined: 10-January 05

Posted 10 July 2007 - 06:44 PM

Esquece..foi viagem minha, é uma função javascript, não precisa ser definida mesmo.

Mas isso me chamou a atenção pra um detalhe, ela serve pra submeter (enviar) um formulário, mas não há formulários entre as caixas de seleção, então, o que seria submetido?
0

#22 User is offline   ricardoelias 

  • Group: Membros
  • Posts: 153
  • Joined: 14-July 04

Posted 12 July 2007 - 01:21 AM

QUE MANCADA... vo testar e te dou a resposta
0

#23 User is offline   Energy 

  • Group: Membros
  • Posts: 57
  • Joined: 14-July 07

Posted 14 July 2007 - 03:51 PM

sei que nao tem nada a ver cmo php (acho que sua resposta para o seu problema ja esta ali em cima) mas oq vc acha de dar uma lida sobre tableless? biggrin.gif
0

#24 User is offline   Energy 

  • Group: Membros
  • Posts: 57
  • Joined: 14-July 07

Posted 14 July 2007 - 03:57 PM

ps2: seu menu overmouse, esta faltando as imagens
e mesmo fazendo o seu site em tabela, teria como vc estruturar ele melhor para ao menos aguentar um redimencionamento de tela? (nao quero nem testar em outras resolucoes)

enfim, sorte que aqui eh php.. mas acho que as dicas vao ser uteis para vc biggrin.gif
0

#25 User is offline   nagash 

  • Group: Membros
  • Posts: 15
  • Joined: 20-August 06

Posted 16 July 2007 - 12:08 AM

Ae galera... agora eu q to com um probleminha aqui.... desenvolvo em CF e agora to tentando aprender PHP .... e brincando aqui com os controles e variáveis, percebi q o meu PHP não tah mostrando os acentos corretamente.... tenho esse código aqui:

<?
	$nome = ("João");
	
	if($nome == "João"){
		echo("seu nome é João");
	}else{
		echo("seu nome não é João");
	}
?>


e ele me retorna assim no navegador:
seu nome não é João



já li e tentei esse lance do htmlentities e do locale e do metatag e tals... mas não funcionou.. ou, eu não soube colocar.... alguém ae pode alterar me dar um help por favor? o/
0

#26 User is offline   Energy 

  • Group: Membros
  • Posts: 57
  • Joined: 14-July 07

Posted 16 July 2007 - 05:52 AM

QUOTE(nagash @ 15/7/2007 23:07:59) View Post
Ae galera... agora eu q to com um probleminha aqui.... desenvolvo em CF e agora to tentando aprender PHP .... e brincando aqui com os controles e variáveis, percebi q o meu PHP não tah mostrando os acentos corretamente.... tenho esse código aqui:

<?
	$nome = ("João");
	
	if($nome == "João"){
		echo("seu nome é João");
	}else{
		echo("seu nome não é João");
	}
?>


e ele me retorna assim no navegador:
seu nome não é João



já li e tentei esse lance do htmlentities e do locale e do metatag e tals... mas não funcionou.. ou, eu não soube colocar.... alguém ae pode alterar me dar um help por favor? o/


<html lang="pt-br">
<meta http-equiv="content-type" content="text/html;charset=iso-8859-1" />

talvez seja o apache verifica o accept_language (pelo phpinfo()wink.gif
0

#27 User is offline   Wanderson Regis 

  • Group: Moderadores
  • Posts: 1275
  • Joined: 10-January 05

Posted 16 July 2007 - 04:34 PM

Algumas vezes os navegadores dão esse tipo de problema: Não exibem corretamente acentos do nosso e outros idiomas. A solução ou usar caracteres especiais HTML (o htmlentities faz isso) ou declarar o idioma da página (em marcas HTML), como foi feita nessa ultima mensagem.
0

#28 User is offline   nagash 

  • Group: Membros
  • Posts: 15
  • Joined: 20-August 06

Posted 16 July 2007 - 10:07 PM

opa! .. agora deu certo aki com essa dica... vlw mesmo o/
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic



Publicidade




1 User(s) are reading this topic
0 membro(s), 1 visitante(s) e 0 membros anônimo(s)