Untitled

<!doctype html public "-//W3C//DTD HTML 4.0 //EN">
<html>
<head>
       <title>Title here!</title>
<style type="text/css">
<!--
* {
    color:#000000;
    font-family:Arial;
    font-size:10pt;
}
body {
    background-color:#888888;
}
table {
    border-style:solid;
    border-width:1px;
    border-color:#000000;
    border-collapse:collapse;
}
td {
    padding:3px;
}
-->
</style>
</head>
<body>
<table>
 <tr>
  <td>
   <b><a href="index.php?sortierung=titel">Titel</a></b>
  </td>
  <td>
   <b><a href="index.php?sortierung=genre">Genre</a></b>
  </td>
  <td>
   <b><a href="index.php?sortierung=fsk">FSK</a></b>
  </td>
  <td>
   <b><a href="index.php?sortierung=laufzeit">Laufzeit</a></b>
  </td>
  <td>
   <b><a href="index.php?sortierung=jahr">Jahr</a></b>
  </td>
  <td>
   <b>Aktion</b>
  </td>
 </tr>
<?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]");
  }
  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'>
            <input type='submit' value='Löschen' name='delete'>
            </td>
            </tr>
            </form>";
      $n++;
   }
?>
</table>
</body>
</html>