Failed to execute sql query:
  $sql", E_USER_ERROR); return $result; } function QueryDbTrans($sql, &$success) { global $mysqlconnection; $result = @mysqli_query($mysqlconnection, $sql); $success = ($result && 1); //&& (mysqli_affected_rows($mysqlconnection) > 0)); return $result; } function OpenDbEx() { global $db_host, $db_user, $db_pass, $db_name, $mysqlconnection; $mysqlconnection = @mysqli_connect($db_host, $db_user, $db_pass); if (mysqli_errno($mysqlconnection) > 0) throw new Exception(mysqli_error($mysqlconnection), mysqli_errno($mysqlconnection)); $select = @mysqli_select_db($mysqlconnection, $db_name); if (mysqli_errno($mysqlconnection) > 0) throw new Exception(mysqli_error($mysqlconnection), mysqli_errno($mysqlconnection)); return $mysqlconnection; } function QueryDbEx($sql) { global $mysqlconnection; $result = @mysqli_query($mysqlconnection, $sql); if (mysqli_errno($mysqlconnection) > 0) throw new Exception(mysqli_error($mysqlconnection), mysqli_errno($mysqlconnection)); return $result; } function BeginTrans() { global $mysqlconnection; @mysqli_query($mysqlconnection, "SET AUTOCOMMIT=0"); @mysqli_query($mysqlconnection, "BEGIN"); } function CommitTrans() { global $mysqlconnection; @mysqli_query($mysqlconnection,"COMMIT"); @mysqli_query($mysqlconnection,"SET AUTOCOMMIT=1"); } function RollbackTrans() { global $mysqlconnection; @mysqli_query($mysqlconnection,"ROLLBACK"); @mysqli_query($mysqlconnection,"SET AUTOCOMMIT=1"); } function GetValue($tablename, $column, $where) { $sql = "SELECT $column FROM $tablename WHERE $where"; $result_get_value = QueryDb($sql); $row_get_value = mysqli_fetch_row($result_get_value); return $row_get_value[0]; } ?>