'; $db_host = ''; $db_username = ''; $db_password = ''; $databasename = 'otrs'; function log_message($filename, $message){ global $debug; $timestamp = time(); $logstring = date("d.m.Y H:i:s ",time()).$message.PHP_EOL; file_put_contents($filename, $logstring, FILE_APPEND); if ($debug == true) { print 'Log debug '.$logstring; } } function execute_sp_read_single_value($query, $result_colname){ global $conn, $own_path, $logfile_name; global $db_host, $db_username, $db_password, $databasename; $success = true; $result = ''; $mysqli = new mysqli($db_host, $db_username, $db_password, $databasename); if ($mysqli->connect_errno) { log_message($own_path.$logfile_name,'database-error: '.$mysqli->connect_error); $success=false; } else { if ($row = $mysqli->query($query)->fetch_array()) { $success = true; $result = trim($row[$result_colname]); $mysqli->close(); } } return array ($success, $result); } ?>