con = new mysqli("", "root", ""); /* Falls keine DB vorhanden: mit Tabelle erstellen */ if(!$this->con->select_db("kopfzeit")) { $this->con->query("CREATE DATABASE kopfzeit"); $this->con->select_db("kopfzeit"); $this->con->query("CREATE TABLE highscore" . " (id INT(11) NOT NULL AUTO_INCREMENT," . " name VARCHAR(20) NOT NULL, zeit DOUBLE NOT NULL," . " PRIMARY KEY (id)" . " ) ENGINE=InnoDB DEFAULT CHARSET=UTF8"); } /* Datensatz einfügen */ $ps = $this->con->prepare( "INSERT INTO highscore (name, zeit) VALUES (?, ?)"); $ps->bind_param("sd", $spieler, $dauer); $ps->execute(); $ps->close(); /* Datensätze anzeigen */ $this->anzeigen(); } function anzeigen() { /* Datensätze anzeigen */ echo "

Highscore:

"; echo "

"; echo "" . " "; $res = $this->con->query( "SELECT * FROM highscore ORDER BY zeit LIMIT 10"); while($dsatz = $res->fetch_assoc()) echo ""; $res->close(); echo "
Name Zeit
" . $dsatz["name"] . " " . number_format($dsatz["zeit"], 1) . " Sek.

"; } function __destruct() { $this->con->close(); } } ?>

Name	Zeit
" . $dsatz["name"] . "	" . number_format($dsatz["zeit"], 1) . " Sek.