<?php
/**
* @author Ronny Teufert Software Developer ©2005
*/
class DbConnection {
var $user="Benutzername";
var $passwd="Passwort";
var $db="Datenbankname";
var $host="localhost";
function DbConnection(){
}
//Datenbank öffnen
function OpenDB(){
//DB Connect
$link=mysql_connect($this->host,$this->user,$this->passwd) or die(mysql_error());
$db=mysql_select_db($this->db) or die("Selection to database failed!");
return $link;
}
//aus DAtenbank lesen
function Query($cmd,$dblink){
$result=mysql_query($cmd,$dblink) or die(mysql_error()."\nErrorCode = QUERY");
return $result;
}
//in datenbank schreiben
function SetSqlData($cmd,$dblink){
$result=mysql_query($cmd,$dblink) or die(mysql_error()."\nErrorCode = SetSqlData");
return $result;
}
//Datenbank schließen
function CloseDB(){
mysql_close();
}
}
$dbconnection=new DbConnection();
$Empfaenger = $_POST["Empfaenger"];
$email = $_POST["email"];
$vorname = $_POST["vorname"];
$nachname = $_POST["nachname"];
$website = $_POST["website"];
$nickname = $_POST["nickname"];
$Nachricht = $_POST["Nachricht"];
//einfügen
$dblink=$dbconnection->OpenDB();
//SQL Anweisung
$cmd="INSERT INTO `user` ( `empfaenger` , `email` , `vorname` , `nachname` , `website` , `nickname`,'nachricht') VALUES ('".$Empfaenger."' , '".$email."' , '".$vorname."' , '".$nachname."' , '".$website."' , '".$nickname."','".$Nachricht."');";
$dbconnection->SetSqlData($cmd,$dblink);
//die userid die zuletzt verwendet wurde
$number= mysql_insert_id();
$dbconnection->CloseDB();
//Auslesn
//SQL Anweisung
$cmd="SELECT `id` , `empfaenger` , `email` , `vorname` , `nachname` , `website` , `nickname`, `nachricht` FROM `user` ORDER BY `id` ASC";
$dblink=$dbconnection->OpenDB();
$res=$dbconnection->Query($cmd,$dblink);
// Ausgabe
while ( $zeile = mysql_fetch_array($res, MYSQL_NUM))
{
echo $zeile[0].",".$zeile[1].",".$zeile[2].",".$zeile[3].",".$zeile[4].",".$zeile[5].",".$zeile[6].",".$zeile[7];
}
$dbconnection->CloseDB();
?>
