diff options
Diffstat (limited to 'includes/sys_mysql.php')
-rw-r--r-- | includes/sys_mysql.php | 61 |
1 files changed, 61 insertions, 0 deletions
diff --git a/includes/sys_mysql.php b/includes/sys_mysql.php new file mode 100644 index 00000000..c076be7c --- /dev/null +++ b/includes/sys_mysql.php @@ -0,0 +1,61 @@ +<?php +function sql_connect($host, $user, $pw, $db) { + global $con; + global $host; + + @ $con = mysql_connect($host, $user, $pw); + + if ($con == null) + die("no mysql-connection"); + + if (!mysql_select_db($db, $con)) + die("mysql db-selection failed"); + + mysql_query("SET CHARACTER SET utf8;", $con); + mysql_query("SET NAMES 'utf8'", $con); +} + +// Do select query +function sql_select($query) { + global $con; + $start = microtime(true); + if ($result = mysql_query($query, $con)) { + $data = array (); + while ($line = mysql_fetch_assoc($result)) { + array_push($data, $line); + } + return $data; + } else { + die('MySQL-query error: ' . $query . ", " . mysql_error($con)); + } +} + +// Execute a query +function sql_query($query) { + global $con; + $start = microtime(true); + if ($result = mysql_query($query, $con)) { + return $result; + } else { + die('MySQL-query error: ' . $query . ", " . mysql_error($con)); + } +} + +function sql_id() { + global $con; + return mysql_insert_id($con); +} + +function sql_escape($query) { + return mysql_real_escape_string($query); +} + +function sql_num_query($query) { + return mysql_num_rows(sql_query($query)); +} + +function sql_error() { + global $con; + return mysql_error($con); +} +?> |