$host,//'localhost',
'user' => $user,//'root',
'pass' => $pass,//''
'dbname' => $dbname//'hi'
);
//print_r($db);
//connecten met de database
$temp = mysql_connect($db['host'], $db['user'], $db['pass']);
if(!$temp)
{
return trigger_error('Fout bij verbinden: '.mysql_error());
}
elseif(!mysql_select_db($db['dbname']))
{
return trigger_error('Fout bij selecteren database: '.mysql_error());
}
return $temp;
}
//insert
function database_insert($table,$colum_names,$values)
{
$sql =
"
INSERT INTO $table (";
foreach($colum_names as $temp)
{ $sql = $sql . $temp . ",";
}
//laatste komma wissen
$sql = substr_replace($sql ,"",-1);
$sql = $sql . ") " . "VALUES(";
foreach($values as $temp)
{$sql = $sql . $temp . ",";
}
//laatste komma wissen
$sql = substr_replace($sql ,"",-1);
$sql = $sql . ")";
//echo($sql);
if(!$res = mysql_query($sql))
{ return trigger_error(mysql_error().'
In query: '.$sql);
}
else
{ $id = mysql_insert_id();
}
}
//read
function database_read($table,$collum_name,$order_collum,$up_down)
{
$sql = "
SELECT
$collum_name
FROM
$table
ORDER BY
$order_collum $up_down
";
if(!$res = mysql_query($sql))
{
trigger_error(mysql_error().'
In query: '.$sql);
}
elseif(mysql_num_rows($res) == 0)
{
echo 'Geen resultaat';
}
else
{ while($row = mysql_fetch_assoc($res))
{ $return_array[] = $row[$collum_name];
}
return $return_array;
}
}
//size
//delete
function database_delete($database,$table,$var_to_del)
{ $sql ="
DELETE FROM $database
WHERE $table = '$var_to_del'
";
if(!$res = mysql_query($sql))
{ return trigger_error(mysql_error().'
In query: '.$sql);
}
else
{ $id = mysql_insert_id();
}
}
function database_update($database,$table,$sampletijd)
{
$sql ="
UPDATE $database
SET sampletijd = $sampletijd
";
if(!$res = mysql_query($sql))
{ return trigger_error(mysql_error().'
In query: '.$sql);
}
else
{ $id = mysql_insert_id();
}
}
?>