Keskustelu: Nettisivujen teko: ä ja ö +php +SQL

<p>

   <form action="henkhaku.php" method="post">
      Syötä hakusana:<br />
      <input type="text" name="keyword" size="20" maxlength="40" value="" /><br />
      <input type="submit" value="Etsi">
   </form>
</p>

<?php
   // If the form has been submitted with supplied keyword
   if (isset($_POST['keyword'])) {
      include "mysql.class.php";
      // Connect to server and select database
      $mysqldb = new mysql("localhost","***","***","kanta");
      $mysqldb->connect();
      $mysqldb->select();
      $keyword = $_POST['keyword'];

      // Create the query
      $mysqldb->query("SELECT *
FROM `kanta`.`employee`
WHERE `lastname` LIKE CONVERT( _utf8 '%$keyword%'
USING latin1 )
COLLATE latin1_general_ci
OR `firstname` LIKE CONVERT( _utf8 '%$keyword%'
USING latin1 )
COLLATE latin1_general_ci
OR `email` LIKE CONVERT( _utf8 '%$keyword%'
USING latin1 )
COLLATE latin1_general_ci");

      // Output retrieved rows or display appropriate message
      if ($mysqldb->numrows() > 0) {
         while ($row = $mysqldb->fetchobject())
            echo "$row->lastname, $row->firstname ($row->email)<br />";
      } else {
         echo "Henkilö puuttuu tietokannasta.";
      }
   }
?>