Untitled

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Title here!</title>
</head>
<body>
<?php
 class MovieDatabase
 {
  public $dbconn;
  public $dbhost = 'localhost';
  public $dbuser = 'root';
  public $dbpass = 'xxxx';
  public $dbname = 'moviedb';

  public function __construct()
  {
   try
   {
    $this->dbconn = mysql_connect($this->dbhost, $this->dbuser, $this->dbpass);
   }
   catch (Exception $e) {
    die("Verbindung zur DB fehlgeschlagen");
   }
  }

  public function newEntry()
  {
   mysql_select_db($this->dbname);
   mysql_query("insert into moviedb values('','$_POST[titel]','$_POST[genre]','$_POST[fsk]','$_POST[laufzeit]','$_POST[jahr]')");
  }
  public function editEntry()
  {
   mysql_select_db($this->dbname);
   $sql=mysql_query("select * from moviedb where id=$_POST[action]");
   $data=mysql_fetch_array($sql);
  }
  public function updateEntry()
  {
   mysql_select_db($this->dbname);
   mysql_query("update moviedb set titel = '$_POST[titel]', genre = '$_POST[genre]', fsk = '$_POST[fsk]', laufzeit = '$_POST[laufzeit]', jahr = '$_POST[jahr]' where id = $_POST[update]");
  }
  public function deleteEntry()
  {
   mysql_select_db($this->dbname);
   mysql_query("delete from moviedb where id=$_POST[action]");
  }
 }

 if(isset($_POST['neu'])) {
     $mdb = new MovieDatabase();
     $mdb->newEntry();
 }
 if(isset($_POST['edit'])) {
     $mdb = new MovieDatabase();
     $mdb->editEntry();
 }
 if(isset($_POST['update'])) {
     $mdb = new MovieDatabase();
     $mdb->updateEntry();
 }
 if(isset($_POST['delete'])) {
     $mdb = new MovieDatabase();
     $mdb->editEntry();
 }


  if(isset($_GET['sortierung'])) {
      $sortierung=$_GET['sortierung'];
  }
  else {
      $sortierung="titel";
  }
  $sql=mysql_query("select * from moviedb order by $sortierung");
  $n=1;
  while($data=mysql_fetch_array($sql)) {
      if($data['laufzeit'] != "") {
          $data['laufzeit'] = $data['laufzeit']." Min.";
      }
      echo "<form action='$PHP_SELF' method='post' name='form$n'>
            <input type='hidden' name='action' value='$data[id]'>
            <tr style='background-color:#888888;' onmouseover=\"style.backgroundColor='#999999'\" onmouseout=\"style.backgroundColor='#888888'\">
            <td>$data[titel]</td>
            <td>$data[genre]</td>
            <td>$data[fsk]</td>
            <td>$data[laufzeit]</td>
            <td>$data[jahr]</td>
            <td>
            <input type='submit' value='Bearbeiten' name='edit' disabled>
            <input type='submit' value='Löschen' name='delete' disabled>
            </td>
            </tr>
            </form>";
      $n++;
   }
?>
</body>
</html>