<?php
//Daten um sich mit der Datenbank zuverbinden
function getdbconndata(&$dbserver,&$dbuser,&$password,&$dbname){
$dbserver="SERVER"; // meistens localhost
$dbuser="DEINNAME";
$password="DEINPASSWORT";
$dbname="DATENBANKNAME";
}
function DBCONNECT($autocommit)
{
getdbconndata($dbserver,$dbuser,$password,$dbname);
$link = mysqli_connect($dbserver,$dbuser,$password, $dbname);
mysqli_set_charset($link,"utf8");
mysqli_autocommit($link, $autocommit);
return $link;
}
function DBEXECUTE($link,$sql)
{
$retval=false;
if (mysqli_query($link, $sql)) {
$retval=true;
}
return $retval;
}
function DBGET($link,$sql,&$data=0)
{
unset($_SESSION['dbdata']);
if(($data==0))
$_SESSION['countdbdata']=0;
if ($result = mysqli_query($link, $sql)) {
if(($data==0))
$_SESSION['countdbdata'] = mysqli_num_rows($result);
/* fetch associative array */
if($data!=0){
while ($row = mysqli_fetch_assoc($result)) {
$data[] = $row;
}
}
else{
while ($row = mysqli_fetch_assoc($result)) {
$_SESSION['dbdata'][] = $row;
}
}
/* free result set */
mysqli_free_result($result);
}
}
function DBAFFECTEDROWS($link)
{
$retval=mysqli_affected_rows($link);
return $retval;
}
function DBCOMMIT($link)
{
mysqli_commit($link);
}
function DBROLLBACK($link)
{
mysqli_rollback($link);
}
function DBCLOSE($link)
{
mysqli_close($link);
}
function EXECUTESQL($sql)
{
$retval=false;
getdbconndata($dbserver,$dbuser,$password,$dbname);
$link = mysqli_connect($dbserver,$dbuser,$password, $dbname);
mysqli_set_charset($link,"utf8");
/* check connection */
if (!$link) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
if (mysqli_query($link, $sql)===TRUE) {
$retval=true;
}
/* close connection */
mysqli_close($link);
}
function GETDATA($sql,&$data=0)
{
getdbconndata($dbserver,$dbuser,$password,$dbname);
$link = mysqli_connect($dbserver,$dbuser,$password, $dbname);
mysqli_set_charset($link,"utf8");
/* check connection */
if (!$link) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
if(($data==0)){
unset($_SESSION['dbdata']);
$_SESSION['countdbdata']=0;
}
if ($result = mysqli_query($link, $sql)) {
if(($data==0))
$_SESSION['countdbdata'] = mysqli_num_rows($result);
/* fetch associative array */
if($data!=0){
while ($row = mysqli_fetch_assoc($result)) {
$data[] = $row;
}
}
else{
while ($row = mysqli_fetch_assoc($result)) {
$_SESSION['dbdata'][] = $row;
}
}
/* free result set */
mysqli_free_result($result);
}
//else echo "----".mysqli_error($link)."------";
/* close connection */
mysqli_close($link);
}
?>