Using Hebrew with PHP and mySQL

Leao

Hi,

I have set up a database using collation utf8_bin and all the fields are utf8_bin. When I input Hebrew text on the mySQL database it appears fine on phpMyAdmin but when I try and retrieve this text and echo it on my php site it just comes out as a series of ????. What can I do about this? I searched for answers and many people have asked the same question as me on different PHP forums but I am yet to find a solution.

Many thanks,

Leao

dagon

Character Sets / Character Encoding Issues

Leao

Shalom!

I managed to partly resolve the problem. My web server is set to 'character_set_server: latin'. I cannot change this as I am on shared hosting so my hosting company suggested I try using PHP function 'mysql_set_charset' to set a utf8 collation for the viewer of my site's connection. I have put the following code on each page with Hebrew text after the </html> tag:

<?php
$link = mysql_connect('mysql2.steadfast.net', 'goatswi_leo', 'password') or die(mysql_error());
mysql_set_charset('utf8',$link);
?>

This seems to work perfectly. I am new to PHP so I guess I need to know whether putting the above code on every page with Hebrew after the </html> tag is a good idea or maybe I need to place it somewhere else in my code. Maybe I don't even need to put the code on every page or perhaps just the first page the viewer enters? I put the above code in the main body of the text at first to run each time the PHP retrieved some Hebrew from mySQL database and echoed it onto onto the main body of my site but while this worked while viewing the page the first time afterwards the Hebrew text turned into gibberish '◊ô◊¢◊ô◊®◊™ ◊ß◊©◊®'.

Any advice would be much appreciated!

Leao

dagon

you would need it on every page that you pull hebrew from the db, you can put it and the $link line in a file and just include that file in every other page if its easier for you.

Leao

Hi dagon, my only concern is that I don't really understand why the script works if I put at the end of a page after the </html> tag but if I put it anywhere else it just renders the Hebrew as gibberish. See [MOD EDIT: Link removed as per OP's request] where I put the script just before the </head> tag. Is there any logic to this? As it stands I can leave it after the </html> tag but I would prefer to understand how the script works a bit better.

Thanks a lot,

Leao

dagon

need to see the full script, to answer that.

Leao

Hi Dagon,

This is the script that renders the Hebrew as nonsense. The mysql_set_charset is placed just before the </head> tag.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Author" content="Leo Earle and Tal Glick">
<meta name="copyright" content="&copy; 2009 GOATS WITH THE WIND">
<meta http-equiv="Content-Language" content="he">
<meta name="keywords" lang="he" content="&#1490;&#1489;&#1497;&#1504;&#1492;, &#1488;&#1493;&#1512;&#1490;&#1504;&#1497;, &#1506;&#1497;&#1494;&#1497;&#1501;, &#1495;&#1493;&#1493;&#1492;, &#1502;&#1505;&#1506;&#1491;&#1492;, &#1497;&#1493;&#1490;&#1493;&#1512;&#1496;, &#1500;&#1489;&#1504;&#1492;, &#1512;&#1497;&#1511;&#1493;&#1496;&#1492;, &#1495;&#1500;&#1489;, &#1497;&#1497;&#1503;, &#1492;&#1512; &#1492;&#1513;&#1488;&#1489;&#1497;, &#1497;&#1493;&#1491;&#1508;&#1514;, &#1492;&#1490;&#1500;&#1497;&#1500;">
<meta name="robots" content="all">
<meta name="description" lang="he" content="&#1495;&#1493;&#1493;&#1514; &#1506;&#1497;&#1494;&#1497;&#1501; — &#1492;&#1502;&#1497;&#1497;&#1510;&#1512;&#1514; &#1490;&#1489;&#1497;&#1504;&#1493;&#1514; &#1502;&#1495;&#1500;&#1489; &#1506;&#1497;&#1494;&#1497;&#1501; &#1488;&#1493;&#1512;&#1490;&#1504;&#1497; &#1496;&#1492;&#1493;&#1512; &#1493;&#1497;&#1513; &#1489;&#1492; &#1490;&#1501; &#1502;&#1505;&#1506;&#1491;&#1492; &#1504;&#1505;&#1514;&#1512;&#1514; &#1489;&#1497;&#1503; &#1490;&#1489;&#1506;&#1493;&#1514;&#1497;&#1493; &#1492;&#1502;&#1500;&#1496;&#1508;&#1493;&#1514; &#1513;&#1500; &#1492;&#1512; &#1492;&#1513;&#1488;&#1489;&#1497;">

<title lang="he" dir="rtl">&#1495;&#1500;&#1489; &#1506;&#1501; &#1492;&#1512;&#1493;&#1495; | 
<?php $goatswiththe=$_GET['goatswiththe'];
if ($goatswiththe=="intro") echo "&#1502;&#1489;&#1493;&#1488;";
if ($goatswiththe=="cheese") echo "&#1490;&#1489;&#1497;&#1504;&#1493;&#1514;";
if ($goatswiththe=="restaurant") echo "&#1502;&#1505;&#1506;&#1491;&#1492;";
if ($goatswiththe=="wine") echo "&#1497;&#1497;&#1503;";
if ($goatswiththe=="volunteer") echo "&#1502;&#1514;&#1504;&#1491;&#1489;&#1497;&#1501;";
if ($goatswiththe=="gallery") echo "&#1490;&#1500;&#1512;&#1497;&#1492;";
if ($goatswiththe=="map") echo "&#1502;&#1508;&#1492;";
if ($goatswiththe=="contactus") echo "&#1497;&#1506;&#1497;&#1512;&#1514; &#1511;&#1513;&#1512;";

?>
	  </title>
<link rel="stylesheet" type="text/css" href="goatsylesheet.css">
<script type="text/JavaScript">
  //<![CDATA[
  <!--
  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_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_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>
  <?php

$link = mysql_connect('MYSQLDB', 'USER', 'PASSWORD') or die(mysql_error());
mysql_set_charset('utf8',$link);
?>
</head>

<body onLoad="MM_preloadImages('pictures/hspinstar.gif')">

<div class="container">
<div class="center">  

 <div id="goats">
<?php
$goatswiththe=$_GET['goatswiththe'];

if ($goatswiththe=="intro") echo "
<object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' name=
      'goatanimation' width='884' height='234' id='goatanimation'>
        <param name='movie' value='playlogo.swf'>
        <object type='application/x-shockwave-flash' data='playlogo.swf'  width=
        '884' height='234'>
          Animation failed to load. Try viewing this site with an alternative
          browser or download the latest version of Flash Player.
        </object>
      </object>";

else echo "
<object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' name=
      'goatanimation' width='884' height='234' id='goatanimation'>
        <param name='movie' value='logo.swf'>
        <object type='application/x-shockwave-flash' data='logo.swf'  width=
        '884' height='234'>
          Animation failed to load. Try viewing this site with an alternative
          browser or download the latest version of Flash Player.
        </object>
      </object>";

?>	  

    </div>
    <div id="buttons"><ul><li>
      <a href="home.php?goatswiththe=intro"><img src="pictures/englishbut.jpg" alt="ENGLISH" id="english" onmouseover=
      "MM_swapImage('star1','','pictures/spinstar.gif',1)" onmouseout=
      "MM_swapImgRestore()"></a></li>
    <li><img src="pictures/star.jpg" alt="*" 
      id="star1"></li><li><a href="beit.php?goatswiththe=contactus"><img src="pictures/hcontactusbut.jpg"
      alt="&#1506;&#1497;&#1512;&#1514; &#1511;&#1513;&#1512;" id="hcontactus" onmouseover=
      "MM_swapImage('star1','','pictures/hspinstar.gif','star2','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li><li><img src="pictures/star.jpg" alt=
           "*" id="star2"></li><li><a href="beit.php?goatswiththe=map"><img src=
           "pictures/hmapbut.jpg" alt="&#1502;&#1508;&#1492;"
            id="hmap" onmouseover=
           "MM_swapImage('star2','','pictures/hspinstar.gif','star3','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li><li><img src="pictures/star.jpg" alt=
           "*" id="star3"></li><li><a href="beit.php?goatswiththe=gallery"><img src=
           "pictures/hgallerybut.jpg" alt="&#1490;&#1500;&#1512;&#1497;&#1492;" 
           id="hgallery" onmouseover=
           "MM_swapImage('star3','','pictures/hspinstar.gif','star4','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li>
    <li><img src="pictures/star.jpg" alt=
           "*" id="star4"></li><li><a href="beit.php?goatswiththe=volunteer"><img src=
           "pictures/hvolunteerbut.jpg" alt="&#1502;&#1514;&#1504;&#1491;&#1489;&#1497;&#1501;"
            id="hvolunteer" onmouseover=
           "MM_swapImage('star4','','pictures/hspinstar.gif','star5','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li><li><img src="pictures/star.jpg" alt=
           "*"  id="star5"></li><li><a href="beit.php?goatswiththe=wine"><img src=
           "pictures/hwinebut.jpg" alt="&#1497;&#1497;&#1503;"
            id="hwine" onmouseover=
           "MM_swapImage('star5','','pictures/hspinstar.gif','star6','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li><li><img src="pictures/star.jpg" alt=
           "*"  id="star6"></li><li><a href="beit.php?goatswiththe=restaurant"><img src=
           "pictures/hrestaurantbut.jpg" alt="&#1502;&#1505;&#1506;&#1491;&#1492;" id=
           "hrestaurant" onmouseover=
           "MM_swapImage('star6','','pictures/hspinstar.gif','star7','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li>
    <li><img src="pictures/star.jpg" alt=
           "*"  id="star7"></li><li><a href="beit.php?goatswiththe=cheese"><img src=
           "pictures/hcheesebut.jpg" alt="&#1497;&#1490;&#1489;&#1497;&#1504;&#1493;&#1514;"
            id="hcheese" onmouseover=
           "MM_swapImage('star7','','pictures/hspinstar.gif','star8','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li><li><img src="pictures/star.jpg" alt=
           "*" width="26"  height="26" id="star8"></li><li><a href="beit.php?goatswiththe=intro"><img src=
           "pictures/hintrobut.jpg" alt="&#1502;&#1489;&#1493;&#1488;" id="hintro" onmouseover=
           "MM_swapImage('star8','','pictures/hspinstar.gif',1)" onmouseout=
           "MM_swapImgRestore()"></a></li>
    </ul>
    </div>
    <div id="hgoattext"><p class='hebrew'><?php
$goatswiththe=$_GET['goatswiththe'];
mysql_connect("MYSQLDB","USER","PASSWORD") or die(mysql_error());
mysql_select_db("goatswi_db") or die(mysql_error());
$result = mysql_query("SELECT * FROM goattext_heb") or die(mysql_error());
$row = mysql_fetch_array( $result );$goattext = $row[$goatswiththe];

function nl2p($goatfunction)
{
$goatfunction = str_replace("\r\n\r\n", "</p><p class='hebrew'>", $goatfunction);
$goatfunction = str_replace("\r\n", "<br>", $goatfunction);
$goatfunction = str_replace("</p><p class='hebrew'>", "</p>\n<p class='hebrew'>", $goatfunction);
$goatfunction = str_replace("\r", '', $goatfunction);
$goatfunction = str_replace("<p class='hebrew'></p>", '', $goatfunction);
return $goatfunction;
} 

echo nl2p($goattext); 

?></p>
    </div>

<div id="hgoatpic">
  <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" name=
  "pictures" width="546" height="546" id="pictures">
    <param name="movie" value="pictures.swf?goatswiththe=<?php echo $_GET["goatswiththe"]; ?>">
    <object type="application/x-shockwave-flash" data="pictures.swf?goatswiththe=<?php echo $_GET["goatswiththe"];?>" width=
    "546" height="546">
      Animation failed to load. Try viewing this site with an alternative
      browser or download the latest version of Flash Player.
    </object>
  </object>
</div>


  </div></div>
</body>
</html>

Leao

This is the script that shows the Hebrew correctly. The mysql_set_charset is placed just after the </html> tag.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Author" content="Leo Earle and Tal Glick">
<meta name="copyright" content="&copy; 2009 GOATS WITH THE WIND">
<meta http-equiv="Content-Language" content="he">
<meta name="keywords" lang="he" content="&#1490;&#1489;&#1497;&#1504;&#1492;, &#1488;&#1493;&#1512;&#1490;&#1504;&#1497;, &#1506;&#1497;&#1494;&#1497;&#1501;, &#1495;&#1493;&#1493;&#1492;, &#1502;&#1505;&#1506;&#1491;&#1492;, &#1497;&#1493;&#1490;&#1493;&#1512;&#1496;, &#1500;&#1489;&#1504;&#1492;, &#1512;&#1497;&#1511;&#1493;&#1496;&#1492;, &#1495;&#1500;&#1489;, &#1497;&#1497;&#1503;, &#1492;&#1512; &#1492;&#1513;&#1488;&#1489;&#1497;, &#1497;&#1493;&#1491;&#1508;&#1514;, &#1492;&#1490;&#1500;&#1497;&#1500;">
<meta name="robots" content="all">
<meta name="description" lang="he" content="&#1495;&#1493;&#1493;&#1514; &#1506;&#1497;&#1494;&#1497;&#1501; — &#1492;&#1502;&#1497;&#1497;&#1510;&#1512;&#1514; &#1490;&#1489;&#1497;&#1504;&#1493;&#1514; &#1502;&#1495;&#1500;&#1489; &#1506;&#1497;&#1494;&#1497;&#1501; &#1488;&#1493;&#1512;&#1490;&#1504;&#1497; &#1496;&#1492;&#1493;&#1512; &#1493;&#1497;&#1513; &#1489;&#1492; &#1490;&#1501; &#1502;&#1505;&#1506;&#1491;&#1492; &#1504;&#1505;&#1514;&#1512;&#1514; &#1489;&#1497;&#1503; &#1490;&#1489;&#1506;&#1493;&#1514;&#1497;&#1493; &#1492;&#1502;&#1500;&#1496;&#1508;&#1493;&#1514; &#1513;&#1500; &#1492;&#1512; &#1492;&#1513;&#1488;&#1489;&#1497;">

<title lang="he" dir="rtl">&#1495;&#1500;&#1489; &#1506;&#1501; &#1492;&#1512;&#1493;&#1495; | 
<?php $goatswiththe=$_GET['goatswiththe'];
if ($goatswiththe=="intro") echo "&#1502;&#1489;&#1493;&#1488;";
if ($goatswiththe=="cheese") echo "&#1490;&#1489;&#1497;&#1504;&#1493;&#1514;";
if ($goatswiththe=="restaurant") echo "&#1502;&#1505;&#1506;&#1491;&#1492;";
if ($goatswiththe=="wine") echo "&#1497;&#1497;&#1503;";
if ($goatswiththe=="volunteer") echo "&#1502;&#1514;&#1504;&#1491;&#1489;&#1497;&#1501;";
if ($goatswiththe=="gallery") echo "&#1490;&#1500;&#1512;&#1497;&#1492;";
if ($goatswiththe=="map") echo "&#1502;&#1508;&#1492;";
if ($goatswiththe=="contactus") echo "&#1497;&#1506;&#1497;&#1512;&#1514; &#1511;&#1513;&#1512;";

?>
	  </title>
<link rel="stylesheet" type="text/css" href="goatsylesheet.css">
<script type="text/JavaScript">
  //<![CDATA[
  <!--
  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_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_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>
</head>

<body onLoad="MM_preloadImages('pictures/hspinstar.gif')">

<div class="container">
<div class="center">  

 <div id="goats">
<?php
$goatswiththe=$_GET['goatswiththe'];

if ($goatswiththe=="intro") echo "
<object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' name=
      'goatanimation' width='884' height='234' id='goatanimation'>
        <param name='movie' value='playlogo.swf'>
        <object type='application/x-shockwave-flash' data='playlogo.swf'  width=
        '884' height='234'>
          Animation failed to load. Try viewing this site with an alternative
          browser or download the latest version of Flash Player.
        </object>
      </object>";

else echo "
<object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' name=
      'goatanimation' width='884' height='234' id='goatanimation'>
        <param name='movie' value='logo.swf'>
        <object type='application/x-shockwave-flash' data='logo.swf'  width=
        '884' height='234'>
          Animation failed to load. Try viewing this site with an alternative
          browser or download the latest version of Flash Player.
        </object>
      </object>";

?>	  

    </div>
    <div id="buttons"><ul><li>
      <a href="home.php?goatswiththe=intro"><img src="pictures/englishbut.jpg" alt="ENGLISH" id="english" onmouseover=
      "MM_swapImage('star1','','pictures/spinstar.gif',1)" onmouseout=
      "MM_swapImgRestore()"></a></li>
    <li><img src="pictures/star.jpg" alt="*" 
      id="star1"></li><li><a href="beit.php?goatswiththe=contactus"><img src="pictures/hcontactusbut.jpg"
      alt="&#1506;&#1497;&#1512;&#1514; &#1511;&#1513;&#1512;" id="hcontactus" onmouseover=
      "MM_swapImage('star1','','pictures/hspinstar.gif','star2','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li><li><img src="pictures/star.jpg" alt=
           "*" id="star2"></li><li><a href="beit.php?goatswiththe=map"><img src=
           "pictures/hmapbut.jpg" alt="&#1502;&#1508;&#1492;"
            id="hmap" onmouseover=
           "MM_swapImage('star2','','pictures/hspinstar.gif','star3','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li><li><img src="pictures/star.jpg" alt=
           "*" id="star3"></li><li><a href="beit.php?goatswiththe=gallery"><img src=
           "pictures/hgallerybut.jpg" alt="&#1490;&#1500;&#1512;&#1497;&#1492;" 
           id="hgallery" onmouseover=
           "MM_swapImage('star3','','pictures/hspinstar.gif','star4','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li>
    <li><img src="pictures/star.jpg" alt=
           "*" id="star4"></li><li><a href="beit.php?goatswiththe=volunteer"><img src=
           "pictures/hvolunteerbut.jpg" alt="&#1502;&#1514;&#1504;&#1491;&#1489;&#1497;&#1501;"
            id="hvolunteer" onmouseover=
           "MM_swapImage('star4','','pictures/hspinstar.gif','star5','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li><li><img src="pictures/star.jpg" alt=
           "*"  id="star5"></li><li><a href="beit.php?goatswiththe=wine"><img src=
           "pictures/hwinebut.jpg" alt="&#1497;&#1497;&#1503;"
            id="hwine" onmouseover=
           "MM_swapImage('star5','','pictures/hspinstar.gif','star6','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li><li><img src="pictures/star.jpg" alt=
           "*"  id="star6"></li><li><a href="beit.php?goatswiththe=restaurant"><img src=
           "pictures/hrestaurantbut.jpg" alt="&#1502;&#1505;&#1506;&#1491;&#1492;" id=
           "hrestaurant" onmouseover=
           "MM_swapImage('star6','','pictures/hspinstar.gif','star7','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li>
    <li><img src="pictures/star.jpg" alt=
           "*"  id="star7"></li><li><a href="beit.php?goatswiththe=cheese"><img src=
           "pictures/hcheesebut.jpg" alt="&#1497;&#1490;&#1489;&#1497;&#1504;&#1493;&#1514;"
            id="hcheese" onmouseover=
           "MM_swapImage('star7','','pictures/hspinstar.gif','star8','','pictures/hspinstar.gif',1)"
           onmouseout="MM_swapImgRestore()"></a></li><li><img src="pictures/star.jpg" alt=
           "*" width="26"  height="26" id="star8"></li><li><a href="beit.php?goatswiththe=intro"><img src=
           "pictures/hintrobut.jpg" alt="&#1502;&#1489;&#1493;&#1488;" id="hintro" onmouseover=
           "MM_swapImage('star8','','pictures/hspinstar.gif',1)" onmouseout=
           "MM_swapImgRestore()"></a></li>
    </ul>
    </div>
    <div id="hgoattext"><p class='hebrew'><?php
$goatswiththe=$_GET['goatswiththe'];
mysql_connect("MYSQLDB","USER","PASSWORD") or die(mysql_error());
mysql_select_db("goatswi_db") or die(mysql_error());
$result = mysql_query("SELECT * FROM goattext_heb") or die(mysql_error());
$row = mysql_fetch_array( $result );$goattext = $row[$goatswiththe];

function nl2p($goatfunction)
{
$goatfunction = str_replace("\r\n\r\n", "</p><p class='hebrew'>", $goatfunction);
$goatfunction = str_replace("\r\n", "<br>", $goatfunction);
$goatfunction = str_replace("</p><p class='hebrew'>", "</p>\n<p class='hebrew'>", $goatfunction);
$goatfunction = str_replace("\r", '', $goatfunction);
$goatfunction = str_replace("<p class='hebrew'></p>", '', $goatfunction);
return $goatfunction;
} 

echo nl2p($goattext); 

?></p>
    </div>

<div id="hgoatpic">
  <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" name=
  "pictures" width="546" height="546" id="pictures">
    <param name="movie" value="pictures.swf?goatswiththe=<?php echo $_GET["goatswiththe"]; ?>">
    <object type="application/x-shockwave-flash" data="pictures.swf?goatswiththe=<?php echo $_GET["goatswiththe"];?>" width=
    "546" height="546">
      Animation failed to load. Try viewing this site with an alternative
      browser or download the latest version of Flash Player.
    </object>
  </object>
</div>


  </div></div>
</body>
</html>
<?php

$link = mysql_connect('MYSQLDB', 'USER', 'PASSWORD') or die(mysql_error());
mysql_set_charset('utf8',$link);
?>

THANK YOU FOR YOUR TIME 🙂

Leao

dagon

in effect in your working version your not using mysql_set_charset at all, it will have no effect when you have set it after finishing outputting from the db. Nor do you need to connect again.

Leao

ehhh? So why did the Hebrew begin working only when I started playing with this script??

Thanks again mr dagon,

Leao

dagon

Leao;10929300 wrote:
ehhh? So why did the Hebrew begin working only when I started playing with this script??

Thanks again mr dagon,

Leao

you perhaps changed something else in the php or html with out realising its impact. There are circumstances where a single space will make the difference between working and not.