<?php
// Carsten Stensgaard Rasmussen

class opskrift
{
    var $host = "localhost";
    var $user = "root";
    var $pass = "dbtest";
    var $dbase = "opskrifter";
    var $db;

    function __construct() {
            $this->db = mysql_connect($this->host,$this->user,$this->pass);
            mysql_select_db($this->dbase);
        }

    function ret($navn) {
            $query = mysql_query("select * from `{$navn}`", $this->db);
            $row = Array();
            while ($rows = mysql_fetch_row($query)) {
                for ($j = 0; $j <= count($rows); $j++ ) {
                        $row[$j] = $rows[$j];
                    }
                }

            $html_table = "<h2>{$navn}</h2>\n";

            for ($i = 0; $i <= count($row) - 3; $i++) {
                    $data = explode("@", $row[$i]);
                    $html_table .= "<u>Mængde</u>: " . $data[0] . " <u>Vare</u>: " . $data[1] . "<br/>\n";
                }
            $html_table .= "<b>Opskrift beskrivelse</b>: " . $row[count($row)-2];

            return $html_table;
        }

    function __destruct() {
            mysql_close($this->db);
        }
}

$opskrift = new opskrift;
print $opskrift->ret("Svensk Pølseret");

?>