Keskustelu: Nettisivujen teko: Toimii intrassa, netissä ei

<p>
   HAKEMISTO<br />
   <form action="haku.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","root","kirja","kuva");
      $mysqldb->connect();
      $mysqldb->select();
      $keyword = $_POST['keyword'];
      $keyword = utf8_encode($keyword);

      // Create the query
      $mysqldb->query("SELECT *
FROM `kuva`.`kuvakanta`
WHERE `NRO` LIKE CONVERT( _utf8 '%$keyword%'
USING latin1 )
COLLATE latin1_general_ci
OR `KOHDE` LIKE CONVERT( _utf8 '%$keyword%'
USING latin1 )
COLLATE latin1_general_ci
OR `TAPAHTUMA` LIKE CONVERT( _utf8 '%$keyword%'
USING latin1 )
COLLATE latin1_general_ci
OR `AIHE` LIKE CONVERT( _utf8 '%$keyword%'
USING latin1 )
COLLATE latin1_general_ci
OR `PAIKKA` LIKE CONVERT( _utf8 '%$keyword%'
USING latin1 )
COLLATE latin1_general_ci
OR `AIKA` LIKE CONVERT( _utf8 '%$keyword%'
USING latin1 )
COLLATE latin1_general_ci
OR `KUVAAJA` LIKE CONVERT( _utf8 '%$keyword%'
USING latin1 )
COLLATE latin1_general_ci
OR `ORIGINAALI` LIKE CONVERT( _utf8 '%$keyword%'
USING latin1 )
COLLATE latin1_general_ci
OR `KUVATIEDOSTO` 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 "Nro: $row->NRO,<br>
	    Kohde: $row->KOHDE,<br>
  	    Tapahtuma: $row->TAPAHTUMA,<br>
	    Aihe: $row->AIHE,<br>
	    Paikka: $row->PAIKKA,<br>
	    Aika: $row->AIKA,<br>
	    Kuvaaja: $row->KUVAAJA,<br>
	    Originaali: $row->ORIGINAALI,<br>
	    Kuvatiedosto: $row->KUVATIEDOSTO
            <p>
            <br />";
      } else {
         echo "Haku ei tuottanut tulosta";
      }
   }

?>

<?php
   class mysql {
      private $linkid; // MySQL link identifier
      private $host; // MySQL server host
      private $user; // MySQL user
      private $pswd; // MySQL password
      private $db; // MySQL database
      private $result; // Query result
      private $querycount; // Total queries executed

      /* Class constructor. Initializes the $host, $user, $pswd and $db fields. */
      function __construct($host, $user, $pswd, $db) {
         $this->host = $host;
         $this->user = $user;
         $this->pswd = $pswd;
         $this->db = $db;
      }

      /* Connects to the MySQL database server. */
      function connect() {
         try {
            $this->linkid = @mysql_connect($this->host,$this->user,$this->pswd);
            if (! $this->linkid)
               throw new Exception("Could not connect to the MySQL server.");
         }
         catch (Exception $e) {
            die($e->getMessage());
         }
      }

      /* Selects the MySQL database. */
      function select() {
         try {
            if (! @mysql_select_db($this->db, $this->linkid))
               throw new Exception("Could not connect to the MySQL database.");
            }
         catch (Exception $e) {
            die($e->getMessage());
         }
      }

      /* Execute database query. */
      function query($query) {
         try {
            $this->result = @mysql_query($query,$this->linkid);
            if (! $this->result)
               throw new Exception("The database query failed.");
         }
         catch (Exception $e) {
            echo($e->getMessage());
         }
         $this->querycount++;
         return $this->result;
      }

      /* Determine total rows affected by query. */
      function affectedRows() {
         $count = @mysql_affected_rows($this->linkid);
         return $count;
      }

      /* Determine total rows returned by query. */
      function numRows() {
         $count = @mysql_num_rows($this->result);
         return $count;
      }

      /* Return query result row as an object. */
      function fetchObject() {
         $row = @mysql_fetch_object($this->result);
         return $row;
      }

      /* Return query result row as an indexed array. */
      function fetchRow() {
         $row = @mysql_fetch_row($this->result);
         return $row;
      }

      /* Return query result row as an associative array. */
      function fetchArray() {
         $row = @mysql_fetch_array($this->result);
         return $row;
      }

      /* Return total number queries executed during lifetime of this object. Not required, but interesting nonethless. */
      function numQueries() {
         return $this->querycount;
      }

       /* Return the number of fields in a result set. */
       function numberFields() {
          return @mysql_num_fields($this->result);
       }

       /* Return a field name given an integer offset. */
       function fieldName($offset) {
          return @mysql_field_name($this->result, $offset);
       }

       function getResultAsTable($actions) {

          if ($this->numrows() > 0) {

             // Start the table
             $resultHTML = "<table border='1'>\n<tr>\n";

             // Output the table header
             $fieldCount = $this->numberFields();

             for ($i=1; $i < $fieldCount; $i++) {
                $rowName = $this->fieldName($i);
                $resultHTML .= "<th>$rowName</th>\n";
             } # end for

             $resultHTML .= "<th>actions</th></tr>\n";

             // Output the table data
             while ($row = $this->fetchRow()) {
                $resultHTML .= "<tr>\n";
                for ($i = 1; $i < $fieldCount; $i++)
                   $resultHTML .= "<td>".htmlentities($row[$i])."</td>\n";

                // Replace VALUE with the correct primary key
                $action = str_replace("VALUE", $row[0], $actions);

                // Add the action cell to end of the row
                $resultHTML .= "<td nowrap>&nbsp;$action</td>\n</tr>\n";

             } # end while

             // Close the table
             $resultHTML .= "</table>\n";
          } else {
             $resultHTML = "No results found";
          }
          return $resultHTML;

       } #end getResultAsTable()

   }
?>