Extended Ascii causing trouble after mysql_fetch_array()

Hi VGR,

The problem:

The flash has buttons that trigger the functions:  volgende(), vorige(), eerste() and laatste(), (Dutch for next, previous, first, last)
If one of the fields in a retrieved record contains an extended Ascii character (see my initial posting) the PHP class stops functioning.
For example if the name-field contains the name Aïda or René then the problem occurs, because of the the  "ï" and "é"


The class:


<?php


/**********

Fields in the database:

ID
user
password
userlevel
voornaam
achternaam
initialen
straat
postcode
plaats
telefoon
email
haar_naam
zijn_profiel
haar_profiel
burgerlijke_staat
beroep
branche
titel
fax_prive
mobiel
adres_zakelijk
telefoon_zakelijk
fax_zakelijk
email_zakelijk
foto_zijn
foto_haar

***********/

/*************************************************************************
 Zaken die veranderd moeten worden voor een andere server/directory:

 -> In de as file: setDefaultGatewayUrl
 -> database gegevens in de PHP classfile, user etc
 -> eventueel het aanroepen van de scripts in de flash zelf
 -> flash opnieuw compileren


***************************************************************************/



      class facetoface_class
      {

  var $story = "TEST";

/* LOCAL: */
  var $table_name      = "leden";
  var $Host           = "localhost"; // Hostname of our MySQL server.
  var $Database       = "audio5"; // Logical database name on that server.
  var $User           = "root"; // User und Password for login.
  var $Password       = "";


/* REMOTE
  var $table_name      = "leden";
  var $Host           = "*******"; // Hostname of our MySQL server.
  var $Database       = "audio5"; // Logical database name on that server.
  var $User           = "audio5"; // User und Password for login.
  var $Password       = "******";
*/


  var $Query_String = "SELECT ID FROM leden";
  var $connection;  // Result of mysql_connect().
  var $result;  // Result of most recent mysql_query().
  var $Record   = array();  // current mysql_fetch_array()-result.
  var $Row;           // current row number.
  var $msg = "";
  var $Errno    = 0;  // error state of query...
  var $Error    = "";
  var $num = 10;
  var $IDnummer;

// variabelen database fields
  var $ID = 0;
  var $voornaam = "";
  var $achternaam = "";
  var $initialen = "";
  var $straat = "";
  var $postcode = "";
  var $plaats = "";
  var $telefoon = "";
  var $email = "";
  var $haar_naam = "";
  var $zijn_profiel = "";
  var $haar_profiel = "";
  var $burgerlijke_staat = "";
  var $beroep = "";
  var $branche = "";
  var $titel = "";
  var $fax_prive = "";
  var $mobiel = "";
  var $adres_zakelijk = "";
  var $telefoon_zakelijk = "";
  var $fax_zakelijk = "";
  var $email_zakelijk = "";
  var $foto_zijn = "dummy.jpg";
  var $foto_haar = "dummy.jpg";

// samenstellen naam linksboven
  var $naam = "";

  var $rowarray = array();
  var $counter = 0;
  var $rowpointer = 0;
// het bewerkte zakelijk adres
  var $zakelijk_adres = ""; // CrLf vervangen

  var $aantal = 0; //aantal records
  var $CrLf = ""; //
            
  var $portret_dir = "portretten/"; // lokatie van de portretten
  var $dummy = "portretten/dummy.jpg"; // vervangend plaatje als portret ontbreekt

function Foo() {
      $this->init();
}
            
function init() {
      echo "GELUKT!!!\n";
      }

function recordnummer($n){
      $this->nummer = $n;
}
function initDb(){
//$this->rowpointer = 7;

    $this->connect();
    $this->result = mysql_query($this->Query_String,$this->connection);
    $this->Row = 0;
      while (    $this->Record = mysql_fetch_array($this->result)) {
         $this->rowarray[$this->Row ] = $this->Record['ID'];
         $this->Row   += 1;
      }
    $this->aantal = $this->num_rows();
//    mysql_close($this->connection);

    $this->showRecord($this->IDnummer);
    $this->rowpointer = $this->row_num()+1;
   
      
}

  function connect() {
    if ( 0 == $this->connection ) {
      $this->connection=mysql_connect($this->Host, $this->User, $this->Password);
      if (!$this->connection) {
      $this->msg="Link-ID == false, connect failed";
        $this->halt();
      }
      if (!mysql_query(sprintf("use %s",$this->Database),$this->connection)) {
      $this->msg="cannot use database ".$this->Database;
        $this->halt();
      }
    }
  }

/*********************************  lookup functie  ********************/
function showRecord($i) {


    $this->Query_String = "SELECT * FROM leden where ID = ".$i;
    $this->connect();
    $this->result = mysql_query($this->Query_String,$this->connection);
    $this->Record = mysql_fetch_array($this->result);
            $this->ID = $this->Record['ID'];
            $this->voornaam = $this->Record['voornaam'];
            $this->achternaam = $this->Record['achternaam'];
            $this->initialen = $this->Record['initialen'];
            $this->straat = $this->Record['straat'];
            $this->postcode = $this->Record['postcode'];
            $this->plaats = $this->Record['plaats'];
            $this->telefoon = $this->Record['telefoon'];
            $this->email = $this->Record['email'];
            $this->haar_naam = $this->Record['haar_naam'];
            $this->zijn_profiel = $this->Record['zijn_profiel'];
            $this->haar_profiel = $this->Record['haar_profiel'];
            $this->burgerlijke_staat = $this->Record['burgerlijke_staat'];
            $this->beroep = $this->Record['beroep'];
            $this->branche = $this->Record['branche'];
            $this->titel = $this->Record['titel'];
            $this->fax_prive = $this->Record['fax_prive'];
            $this->mobiel = $this->Record['mobiel'];
            $this->adres_zakelijk = $this->Record['adres_zakelijk'];
            $this->telefoon_zakelijk = $this->Record['telefoon_zakelijk'];
            $this->fax_zakelijk = $this->Record['fax_zakelijk'];
            $this->email_zakelijk = $this->Record['email_zakelijk'];
      mysql_close($this->connection);
      $this->naam = $this->achternaam.", ";
      $this->naam .= $this->initialen;

      // CrLf in adresvervangen door "\n"
      $this->CrLf .= chr(13);
      $this->CrLf .= chr(10);
      $this->zakelijk_adres = str_replace($this->CrLf, "\n", $this->adres_zakelijk);

      // naam en lokatie van de plaatjes
      $this->portret_base = $this->portret_dir;
      $this->portret_base .= "img".$this->ID; // eerste deel van plaatjesnaam
      
      $this->foto_zijn = $this->portret_base."a.jpg";
      if (!is_file ( $this->foto_zijn )){
            $this->foto_zijn = $this->dummy;
      }
      $this->foto_haar = $this->portret_base."b.jpg";
      if (!is_file ( $this->foto_haar )){
            $this->foto_haar = $this->dummy;


      }
// Just for testing::

/*
      echo "local variabe IDnummer = ".$this->IDnummer;
      echo "\nTEST2\n".$this->portret_base."a.jpg\n";
      //echo "aantal records: ".count($this->rowarray)."\n";
      echo "Aantal records: ".$this->aantal."\n";
      echo "row number : ";
      echo $this->row_num()+1;
      echo "\nID = ".$this->ID;
      echo "\n ID behorender bij ".$this->IDnummer." : ".$this->rowarray[$this->row_num()];
*/
}

function showarray(){ //for testing
      for ($i=0;$i<count($this->rowarray);$i++) {
            echo $i;
            echo " ID: ";
            echo $this->rowarray[$i];
            echo "\n";
      }
}



  function row_num(){ // row number ophalen
      for ($rn=0;$rn<count($this->rowarray);$rn++) {
            if ($this->rowarray[$rn] == $this->ID){
                     $myRow =  $rn;
                  return $myRow;
                  break;
            }
      }
//      return $myRow;
  }


  function seek($pos) {
    $status = mysql_data_seek($this->result, $pos);
    if ($status)
      $this->Row = $pos;
    return;
  }

  function num_rows() {
    return mysql_num_rows($this->result);
  }

  function num_fields() {
    return mysql_num_fields($this->result);
  }

  function f($Name) {
    return $this->Record[$Name];
  }

  function p($Name) {
    print $this->Record[$Name];
  }

  function affected_rows() {
    return @mysql_affected_rows($this->connection);
  }




            function volgende() { //next record
                  if ($this->rowpointer < $this->aantal){
                        $this->rowpointer += 1;
                        $this->IDnummer = $this->rowarray[$this->rowpointer - 1];
                        echo"Volgende rownummer = $this->rowpointer\n";
                        $this->showRecord($this->IDnummer);
                  }


            }

            function vorige() {//previous record
                  if ($this->rowpointer > 1){
                  $this->rowpointer -= 1;
                  $this->IDnummer = $this->rowarray[$this->rowpointer-1];
                  $this->showRecord($this->IDnummer);
                  }
            }

            function eerste() {//first record
                  //echo "DE EERSTE\n";
                  $this->IDnummer = $this->rowarray[0];
                  $this->showRecord($this->IDnummer);
                  $this->rowpointer =1;
            }

            function laatste() {//last record
                  //echo "LAATSTE\n";
                  $this->IDnummer = $this->rowarray[$this->aantal-1];
                  $this->showRecord($this->IDnummer);
                  $this->rowpointer =$this->aantal;
            }
      }
            
?>

I think it's a Flash problem  with the charset used in the DB data

Hi VGR,

Why do you think it is a Flash problem?
The characters are being displayed correctly by the Flash.

and your class seems more than OK

and you DB seems more than able to store the accents

so...

what happens exactly ?

this is not acceptable : "I Mean the whole script is being executed allright after the mysql_fetch_array() command, but next time the the PHP-class is called upon it does not function anymore."

I'm sure there is an error somewhere, in error.log, in my.err, whatever

couldn't you execute the same code the flash object executes, but from PHP ? Just to see if it works...

As long as records are being retrieved where none of the fields contain those "bad" characters, the Flash functions flawless.
Executing from the same code fro PHP gives no problem, because in that case the page / script is being reloaded each time.
Here is the URL:

http://www.audiovisueel.com/members/ledenlijst/ledenlijst.php (user = "lchoevelaken" password = "support")

It is a memberlist. Clicking on the small face at the right shows the details of that member.
When the Flash, with those details, is open, I want to be able to navigate with the buttons at the bottom.
But nearly all the records contain "bad" characters.

Some records without problems:
The first: Erik Batstra
Alwin Bijvoet (that's me)
Arend de Nooij

Hans Stad, (there you can go up and down, because these records do not contain all data yet.)

It's a great mystery to me.

NB : the label on the faces is always "smeolenboek ben"

true : the flash stops working after a while, but I don't see a single person in your list having accents naywhere

which kind of code is in the SWF ?

for instance it blocks on Beeres, M.P.J. while I don't see any "fancy " character in there. But I see a ` quote

perhaps you've a string escaping problem while in the Flash.

It would be necessary to look at Flash's code towards PHP, and how the SWF displays the data

Well, if you look at "Alec Bergsma" you will see under Branche:  "industriële drukkerijen" , others have "financiële".

The labels I don't understand. With me I see "Smoelenboek <firstname> ", so it changes wit each line.
If you look at the source you see at each record something like onmouseover="showTip('Smoelenboek Jacob');
Those values come from the database.

SWF compiled for Flashplayer 6.

The code from the Flash:



tmp = new PHPObject();
tmp.setDefaultGatewayKey("secret");
tmp.setDefaultGatewayUrl("http://www.audiovisueel.com/members/facetoface/Gateway.php");
delete tmp;
myFoo = new PHPObject("facetoface_class");

// **************************
// event handlers
// **************************
myFoo.onInit = function() {
      this.IDnummer = _root.recno;
        myFoo.initDb();



     months = new Array('Januari', 'Februari', 'Maart', 'April', 'Mei', 'Juni', 'Juli', 'Augustus', 'September',                    'October',  'November', 'December');
     days = new Array('Zondag', 'Maandag', 'Dinsdag', 'Woensdag', 'Donderdag', 'Vrijdag', 'Zaterdag');
     now = new Date();
     todayDate = now.getDate();
     thisDay = now.getDay();
     thisMonth = now.getMonth();
     thisYear = now.getFullYear();
     dayName = days[thisDay];
     monthName = months[thisMonth];
     datum_txt.text = todayDate + " " + monthName + " " + thisYear;
}

myFoo.onAbort = function() {

}

myFoo.onResult = function() {

 naam_txt.text = this.naam;
 adres_prive = this.straat + "\n" + this.postcode + "  " + this.plaats;
 adres_prive_txt.text = adres_prive;

 telefoon_txt.text = this.telefoon;
 email_txt.text = this.email;
 haar_naam_txt.text = this.haar_naam;
 zijn_profiel_txt.text = this.zijn_profiel;
 haar_profiel_txt.text = this.haar_profiel;

 burgerlijke_staat_txt.text = this.burgerlijke_staat;
 beroep_txt.text = this.beroep;
 branche_txt.text = this.branche;
 titel_txt.text = this.titel;
 fax_prive_txt.text = this.fax_prive;
 mobiel_txt.text = this.mobiel;
 adres_zakelijk_txt.text = this.zakelijk_adres;
 telefoon_zakelijk_txt.text = this.telefoon_zakelijk;
 fax_zakelijk_txt.text = this.fax_zakelijk;
 email_zakelijk_txt.text = this.email_zakelijk;

 num_txt.text = this.rowpointer;
 id_txt.text = this.IDnummer;

 loadMovie(this.foto_zijn, linkerfoto)
 loadMovie(this.foto_haar, rechterfoto);
}


// **************************
// button triggers
// **************************

_root.eerste_btn.onRelease = function() {
            myFoo.eerste();
}

_root.vorige_btn.onRelease = function() {
            myFoo.vorige();
}

_root.volgende_btn.onRelease = function() {
            myFoo.volgende();
}

_root.laatste_btn.onRelease = function() {
            myFoo.laatste();
}

Yes, the trouble with Beeres was caused by the quote character. I replaced it with ' (ascii 39) and now Beeres is OK.
The quote character was pasted from a word document.

this proves it's Flash having problems displaying the text.. I'll look at your SWF code. Give me soem time ;-)

well, it's the facetoface_class that would be interesting, but I found some data :

http://www-tcsn.experts-exchange.com/Web/WebDevSoftware/Flash/Q_20660922.html

perhaps you should urlencode() the text gotten from MySql... accents will become %E9 or the like

look also at this code I found :

onLoad(){
str = String.fromCharCode(233);
trace(str);   // returns the string "é"
}

You can try this.... in flash put the following actionscript line on top of all actions:

System.useCodepage = true;

The other alternative is to let PHP convert the special characters.

(ik hoop dat het werkt)

Hi,

dutchfoxer:
Unfortunately the System.useCodepage directive does not work.
On my local machine (winXP) the PHP class is not being blocked anymore, but the text shows unpredictable results.
Remote (Unix) PHP keeps blocking and the strange characters show too.
jammer!

VGR:
The problem occurs when the mysql_fetch_array() function is being executed.
So things go wrong before being able to manipulate the retrieved result.
Thanks anyway for spending so much time on my problem on Sunday!

it can't be the fetch_array()... It must be the internals of Flash - I don't knwo them - that process that result set...

Hi VGR,

In the showrecord() function: if I comment out everything after mysql_fetch_array(), things still go wrong.
So the error is not being caused in the lines after mysql_fetch_array().
If I comment out (you know what I mean: /* ... */) the mysql_fetch_array() line too, there is no problem anymore.
Hence my conclusion that mysql_fetch_array() is the critical line.

yes but no. You said that teh same code executed in PHP produces no error... Thus it HAS to do something with Flash or Flash's way of calling MySql...

The strange thing is that the PHP class is working outside the Flash and is only passing data to Flash
After the mysql_fetch_array() function  has been executed, nothing is being passed to the Flash yet.
But nevertheless no functions inside the PHP Class can be executed afterwards.

Do you know par hasard a different PHP/mysql code to retrieve data from a database?

well, it's just the best way...

you could use the non-associative way... mysql_getresult() or something

I will try something else, but in the weekend.
I have put links to this question in the Flash- and PHP- areas but no reactions so far.
So this problem stays unsolved.

Thanks for your support!

too bad I don't know anything about Flash :D

Never too old to learn ;-) (I'm 64 you saw my picture)

hello Alwin,

open the php file using notepad
save as the file and then choose utf-8 or unicode from the encoding option.

now try...

kanary.

Hi kanary, VGR,

The PHP class only functions when saved as ANSI.

I have the idea that problems will be solved when data are stored in utf-8 or unicode in the database but I don't know the routines needed for that and how to go about at retrieval of the data from the database.

Thanks kanary,

How do I store data as unicode in MySql database?
I think the nvarchar datatype is SQL server specific? In MySql I used varchar and don't know nvarchar.
What is collasion type? (Dumb question?)

Unfortunately I am leaving now and no be back before monday.
Monday I will read your answer.

Alwin