class database{ function db_connect(){ global $db_host;/* servername */ global $db_user;/* username */ global $db_pwd;/* password */ global $db_name;/* name of database */ $connection=@mysql_connect($db_host,$db_user,$db_pwd);/* mit mysql verbinden */ $status=@mysql_select_db($db_name,$connection);/* datenbank auswaehlen */ if ($connection AND $status){ return ($connection);/* ja */ }else{ echo "Keine Verbindung zur Datenbank!"; die; } } function db_get_result($connection,$sql,$single=false){ $result=@mysql_query($sql,$connection);/* $sql -> database*/ $number=1;/*set $number to 1*/ while ($content[$number]=@mysql_fetch_object($result))/* get result in object $content */ { /* get result in object $content */ $number++;/* increase pointer $number */ } unset($content[count($content)]); /* unset the last nonexisting field of content */ if ($single==false){ return($content);/* return result in $content-object */ } else { if ( isset($content[1]) ){ return($content[1]); } } } function db_execute($connection,$sql){ $status=mysql_query($sql,$connection); return $status; } function db_close($connection){ $status=@mysql_close($connection);/* schliessen */ return($status);/* status zurueckgeben */ } function free_db_result($result){ mysql_free_result($result); } } ?>
