Ir para conteúdo

POWERED BY:

Arquivado

Este tópico foi arquivado e está fechado para novas respostas.

FKF Design

Porque caracteres com acento nao aparecem no site?

Por , em PHP

Recommended Posts

FKF Design    0

FKF Design
Postado

Galera aqui no meu site:www.ps2shop.vai.laeu usei php e mysql.só que os caracteres com acento dão tipo um erro, e quando eu vo adicionar um registro,se eu coloco um texto com caracteres com acento, ele mostra o texto até o primeiro caractere com acentoe depois nao mostra mais, ou seja, corta ele!Preciso de uma repsosta rapida porfavor, tenho que entregar esse website amanha!Obrigado!

Compartilhar este post

Link para o post
Compartilhar em outros sites

FKF Design    0

FKF Design
Postado

cara, latin_general_ci nao tem, mais tem latin1_general_ci, latin2_general_ci, ateh o 10 se ano me engano.Coloquei o um, e nada mudou.E nao sei como inserir seu codigo, nao entendo muito de banco de dados.PS: Banco = i4962966Tabelas = admin, jogosabraço.

Compartilhar este post

Link para o post
Compartilhar em outros sites

Anderson Mello    3

Anderson Mello
Postado

Quais dados você precisa exibir, que estão no banco e aparecem de forma errada quando acentuados?Posta o código PHP que exibe no site estes dados do banco ;)[]sAnderson Mello

Compartilhar este post

Link para o post
Compartilhar em outros sites

FKF Design    0

FKF Design
Postado

Nao creio que o problema seja no codigo php,

pois, quando utilizo no meu apache local, funciona perfeitamente.

 

mas vamos la:

 

<?php require_once('Connections/connPS2_Shop.php'); ?><?phpif (!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_rsExibirJogo = "-1";if (isset($_GET['id'])) {  $colname_rsExibirJogo = $_GET['id'];}mysql_select_db($database_connPS2_Shop, $connPS2_Shop);$query_rsExibirJogo = sprintf("SELECT * FROM jogos WHERE id = %s", GetSQLValueString($colname_rsExibirJogo, "int"));$rsExibirJogo = mysql_query($query_rsExibirJogo, $connPS2_Shop) or die(mysql_error());$row_rsExibirJogo = mysql_fetch_assoc($rsExibirJogo);$totalRows_rsExibirJogo = mysql_num_rows($rsExibirJogo);?><!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><style type="text/css"><!--body,td,th {	font-family: Verdana, Arial, Helvetica, sans-serif;	font-size: 12px;	color: #CCCCCC;}body {	margin-top: 0px;	margin-bottom: 0px;	background-color: #000000;}a:link {	text-decoration: none;	color: #FFFFFF;}a:visited {	text-decoration: none;	color: #FFFFFF;}a:hover {	text-decoration: underline;	color: #003366;}a:active {	text-decoration: none;	color: #FFFFFF;}a {	font-family: Verdana, Arial, Helvetica, sans-serif;	font-size: 12px;}.style2 {color: #FFFFFF}.style7 {font-size: 24px}.style9 {color: #FFFFFF; font-size: 14px; }.style10 {color: #000000}--></style></head><body><table width="790" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#333333" style="border-collapse:collapse">  <tr>	<th scope="col"><table width="790" border="0" cellspacing="0" cellpadding="0">	  <tr>		<th width="100%" align="center" scope="col"><img src="layout/topo.jpg" width="790" height="128" border="0" usemap="#Map4" /></th>	  </tr>	  <tr>		<td><table width="790" border="0" cellspacing="0" cellpadding="0">		  <tr>			<th width="100" align="center" valign="middle" scope="col"><table width="8%" border="0" cellspacing="0" cellpadding="0">				<tr>				  <th align="right" scope="col"><img src="design/botao_esq.jpg" width="26" height="34" /></th>				  <th background="design/botao_centro.jpg" scope="col"><span class="style2"><a href="index.php">INICIO</a></span></th>				  <th align="left" scope="col"><img src="design/botao_dir.jpg" width="26" height="34" /></th>				</tr>			</table></th>			<th width="111" align="right" valign="middle" scope="col"><table width="8%" border="0" cellspacing="0" cellpadding="0">				<tr>				  <th align="right" scope="col"><img src="design/botao_esq.jpg" width="26" height="34" /></th>				  <th background="design/botao_centro.jpg" scope="col"><span class="style2"><a href="jogos.php">JOGOS</a></span></th>				  <th align="left" scope="col"><img src="design/botao_dir.jpg" width="26" height="34" /></th>				</tr>			</table></th>			<th width="136" align="center" valign="middle" scope="col"><table width="8%" border="0" cellspacing="0" cellpadding="0">				<tr>				  <th align="right" scope="col"><img src="design/botao_esq.jpg" width="26" height="34" /></th>				  <th background="design/botao_centro.jpg" scope="col"><span class="style2"><a href="frete.php">CALCULE O FRETE</a></span></th>				  <th align="left" scope="col"><img src="design/botao_dir.jpg" width="26" height="34" /></th>				</tr>			</table></th>			<th width="119" align="center" valign="middle" scope="col"><table width="8%" border="0" cellspacing="0" cellpadding="0">				<tr>				  <th align="right" scope="col"><img src="design/botao_esq.jpg" width="26" height="34" /></th>				  <th background="design/botao_centro.jpg" scope="col"><span class="style2"><a href="comprar.php">COMPRAR</a></span></th>				  <th align="left" scope="col"><img src="design/botao_dir.jpg" width="26" height="34" /></th>				</tr>			</table></th>			<th width="124" align="right" valign="middle" scope="col"><table width="8%" border="0" cellspacing="0" cellpadding="0">				<tr>				  <th align="right" scope="col"><img src="design/botao_esq.jpg" width="26" height="34" /></th>				  <th background="design/botao_centro.jpg" scope="col"><span class="style2"><a href="contato.php">CONTATO</a></span></th>				  <th align="left" scope="col"><img src="design/botao_dir.jpg" width="26" height="34" /></th>				</tr>			</table></th>			<th width="200" align="center" valign="middle" scope="col"><form id="form1" name="form1" method="post" action="busca_show.php">				<label> <img src="layout/procurar.jpg" width="82" height="21" /><br />				<input name="busca" type="text" id="busca" size="12" />				<input type="submit" name="button" id="button" value="Ok" />				</label>			</form></th>		  </tr>		</table></td>	  </tr>	  <tr>		<td> </td>	  </tr>	  <tr>		<td align="center"><table width="565" border="0" align="center" cellpadding="0" cellspacing="3">		  <tr>			<th colspan="3" scope="col"><span class="style7 style2"><?php echo $row_rsExibirJogo['titulo']; ?></span></th>		  </tr>		  <tr>			<th colspan="3" scope="col"> </th>		  </tr>		  <tr>			<th colspan="3" valign="top" scope="col"><img src="imagens/veja_imagens.jpg" width="165" height="64" border="0" usemap="#Map5" /><span class="style10">	 <img src="imagens/veja_youtube.jpg" width="145" height="54" border="0" usemap="#Map6" /></span></th>		  </tr>		  <tr>			<th colspan="3" scope="col"> </th>			</tr>		  <tr>			<td width="237" rowspan="6"><img src="<?php echo $row_rsExibirJogo['capa']; ?>" width="218" height="311" /></td>			<td> </td>			<td> </td>		  </tr>		  <tr>			<td width="99" align="left" valign="top"><span class="style9">Titulo:</span></td>			<td width="217" align="left" valign="top"><?php echo $row_rsExibirJogo['titulo']; ?></td>			</tr>		  <tr>			<td align="left" valign="top"><span class="style9">Produtora:</span></td>			<td align="left" valign="top"><?php echo $row_rsExibirJogo['produtora']; ?></td>			</tr>		  <tr>			<td align="left" valign="top"><span class="style9">Genero:</span></td>			<td align="left" valign="top"><?php echo $row_rsExibirJogo['genero']; ?></td>			</tr>		  <tr>			<td align="left" valign="top"><span class="style9">Descricao:</span></td>			<td align="left" valign="top"> </td>			</tr>		  <tr>			<td height="220" colspan="2" align="left" valign="top"><br />			  <?php echo $row_rsExibirJogo['descricao']; ?></td>			</tr>		  		  <tr>			<td> </td>			<td> </td>			<td> </td>			</tr>		  <tr>			<td colspan="3" align="center"><img src="imagens/barra_imagens.jpg" width="577" height="41" /></td>		  </tr>		  		  <tr>			<td colspan="3" align="center"><table width="400" border="0" cellspacing="20" cellpadding="0">			  <tr>				<th scope="col"><a name="img" id="img"></a><a href="<?php echo $row_rsExibirJogo['imagem1']; ?>" target="_blank"><img src="<?php echo $row_rsExibirJogo['imagem1']; ?>" width="150" height="131" /></a></th>				<th scope="col"><a href="<?php echo $row_rsExibirJogo['imagem2']; ?>" target="_blank"><img src="<?php echo $row_rsExibirJogo['imagem2']; ?>" width="150" height="131" /></a></th>				<th scope="col"><a href="<?php echo $row_rsExibirJogo['imagem3']; ?>" target="_blank"><img src="<?php echo $row_rsExibirJogo['imagem3']; ?>" width="150" height="131" /></a></th>			  </tr>			</table></td>			</tr>		  <tr>			<td colspan="3" align="center"><img src="imagens/barra_youtube.jpg" width="577" height="43" /></td>			</tr>		  		  <tr>			<td colspan="3" align="center"><a name="youtube" id="youtube"></a><?php echo $row_rsExibirJogo['youtube']; ?> </td>			</tr>		</table>		</td>		</tr>	  	  <tr>		<td align="center"><img src="layout/rodape.jpg" width="783" height="160" border="0" usemap="#Map" />		  <map name="Map" id="Map7">			<area shape="poly" coords="158,21,161,69,221,108,464,113,462,64,357,22" href="index.php" />			<area shape="rect" coords="370,121,761,142" href="mailto:nando.ferr4ri@gmail.com" alt="Clique Aqui!" />		  </map>		  <map name="Map" id="Map">			<area shape="poly" coords="158,21,161,69,221,108,464,113,462,64,357,22" href="index.php" />		  </map></td>	  </tr>	</table></th>  </tr></table><map name="Map2" id="Map2">  <area shape="rect" coords="0,3,339,77" href="contato.php" /></map><map name="Map3" id="Map3"><area shape="rect" coords="3,2,340,97" href="contato.php" /></map><map name="Map4" id="Map4"><area shape="rect" coords="32,24,64,57" href="index.php" /><area shape="rect" coords="31,68,63,99" href="admin/index.php" /></map><map name="Map5" id="Map5"><area shape="rect" coords="5,6,161,62" href="#img" /></map><map name="Map6" id="Map6">  <area shape="rect" coords="3,5,178,53" href="#youtube" /></map></body></html><?phpmysql_free_result($rsExibirJogo);?>

Compartilhar este post

Link para o post
Compartilhar em outros sites
Ir para a lista de tópicos PHP
×

Informação importante

Ao usar o fórum, você concorda com nossos Termos e condições.

  Aceito