<?php
   mysql_connect("localhost","root","");
   mysql_select_db("Restaurant");
   $myQuery = "SELECT LibPlat FROM Plats";
   $rs = mysql_query($myQuery);
   while ($row = mysql_fetch_array($rs)) {
        echo ($row['LibPlats']."<br />\n");
   }
?>

<?php
   $DB = new mysqli('localhost', 'user', 'root', 'dbname');
   $DB->query("SET NAMES 'utf8'");
   if (!empty($_POST['ta'])) {
        $DB->query("UPDATE document SET unicodeText='{$_POST['ta']}' WHERE ID=1");
   }
   $result = $DB->query("SELECT unicodeText FROM document WHERE ID=1");
   $return = $result->fetch_object();
   $result->close();
?>

header('content-type: text/html; charset=utf8');

<?php
    // Open a new MySQL connection
    $DB = new mysqli('localhost', 'user', 'root', 'dbname');
 
    // Execute a query that sets the charset to be used in the following queries.
    $DB->query("SET NAMES 'utf8'");
 
    // Checks if a POST value named 'ta' was passed or not.
    if (!empty($_POST['ta'])) {
        // Update a row in the 'document' table using the passed data.
        $DB->query("UPDATE document SET unicodeText='{$_POST['ta']}' WHERE ID=1");
    }
    // Fetch a row from the 'document', the same row we just updated.
    $result = $DB->query("SELECT unicodeText FROM document WHERE ID=1");
 
    // Assign the result from the previous query to the $return variable.
    // I assume it will be used later in the code. Otherwise this line is pointless.
    $return = $result->fetch_object();
 
    // Close the result set from the previous query.
    $result->close();
?>

echo utf8_encode($row['LibPlats']) ."<br />\n";

<?php
	mysql_connect("localhost", "root", "");
	mysql_select_db("restaurant");
	$myQuery = "SET NAMES 'utf8'";
	mysql_query($myQuery);
 
	if (!empty($_POST['ta'])) {
		mysql_query("UPDATE Plats SET LibPlats='{$_POST['ta']}'");
	}
	$myQuery = "SELECT LibPlats, PrixPlats FROM Plats";
	$rs = mysql_query($myQuery);
	while ($row = mysql_fetch_array($rs)) {
		print ($row['LibPlats']."<br />\n&euro;".$row['PrixPlats']."<br />\n");
	}
?>

<?php
	mysql_connect("localhost", "root", "");
	mysql_select_db("restaurant");
	$myQuery = "SELECT LibPlats, PrixPlats FROM Plats";
	$rs = mysql_query($myQuery);
	while ($row = mysql_fetch_array($rs)) {
		print utf8_encode($row['LibPlats']."<br />\n&euro;".$row['PrixPlats']."<br />\n");
	}
?>

-- phpMyAdmin SQL Dump
-- version 3.2.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 05, 2009 at 09:01 PM
-- Server version: 5.1.35
-- PHP Version: 5.3.0
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
 
--
-- Database: `restaurant`
--
CREATE DATABASE `restaurant` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `restaurant`;
 
-- --------------------------------------------------------
 
--
-- Table structure for table `categorie`
--
 
CREATE TABLE IF NOT EXISTS `categorie` (
  `IdCategorie` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `LibCategorie` varchar(255) NOT NULL,
  `OrdreCategorie` tinyint(3) unsigned DEFAULT NULL,
  PRIMARY KEY (`IdCategorie`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5;
 
--
-- Dumping data for table `categorie`
--
 
INSERT INTO `categorie` (`IdCategorie`, `LibCategorie`, `OrdreCategorie`) VALUES
(1, 'Entrées', 1),
(2, 'Plats', 2),
(3, 'Desserts', 3),
(4, 'Boissons', NULL);
 
-- --------------------------------------------------------
 
--
-- Table structure for table `plats`
--
 
CREATE TABLE IF NOT EXISTS `plats` (
  `IdPlats` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `LibPlats` varchar(255) NOT NULL,
  `PrixPlats` decimal(5,2) DEFAULT NULL,
  `IdCategorie` smallint(6) NOT NULL,
  PRIMARY KEY (`IdPlats`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
 
--
-- Dumping data for table `plats`
--
 
INSERT INTO `plats` (`IdPlats`, `LibPlats`, `PrixPlats`, `IdCategorie`) VALUES
(1, 'soup chinois', '2.99', 1),
(2, 'soup russe', '2.49', 1),
(3, 'bienenstich', '2.79', 3),
(4, 'steak haché', '6.99', 2),
(5, 'gratin dauphin', '6.39', 2),
(6, 'mohnpielen', '2.75', 3),
(7, 'canard aigre-doux', '7.29', 2),
(8, 'coca zéro', '1.59', 4),
(9, 'coca light', '1.59', 4),
(10, 'coca cola', '1.79', 4),
(11, 'perri-air', '18.99', 4),
(12, 'thé', '2.19', 4),
(13, 'café', '3.39', 4),
(14, 'eau plat', '1.29', 4);

<?php
	mysql_connect("localhost", "root", "");
	mysql_select_db("restaurant");
	$myQuery = "SET NAMES 'utf8'";
	mysql_query($myQuery);
 
	$myQuery = "SELECT LibPlats, PrixPlats FROM Plats";
	$rs = mysql_query($myQuery);
	while ($row = mysql_fetch_array($rs)) {
		print ($row['LibPlats']."<br />\n&euro;".$row['PrixPlats']."<br />\n");
	}
?>