/**\r
* @license http://nucleuscms.org/license.txt GNU General Public License\r
* @copyright Copyright (C) 2002-2012 The Nucleus Group\r
- * @version $Id$\r
+ * @version $Id: mysql.php 1750 2012-04-13 14:41:10Z sakamocchi $\r
*/\r
-\r
/*\r
* complete sql_* wrappers for mysql functions\r
*\r
* functions moved from globalfunctions.php: sql_connect, sql_disconnect, sql_query\r
*/\r
\r
-\r
$MYSQL_CONN = 0;\r
\r
-if (function_exists('mysql_query') && !function_exists('sql_fetch_assoc'))\r
+if ( function_exists('mysql_query') && !function_exists('sql_fetch_assoc') )\r
{\r
/**\r
* Errors before the database connection has been made\r
*/\r
function startUpError($msg, $title)\r
{\r
-?>\r
-<html xmlns="http://www.w3.org/1999/xhtml">\r
- <head><title><?php echo Entity::hsc($title)?></title></head>\r
- <body>\r
- <h1><?php echo Entity::hsc($title)?></h1>\r
- <?php echo $msg?>\r
- </body>\r
-</html>\r
-<?php\r
+ echo "<html xmlns=\"http://www.w3.org/1999/xhtml\">\n";\r
+ echo '<head><title>' . Entity::hsc($title) . "</title></head>\n";\r
+ echo "<body>\n";\r
+ echo '<h1>' . Entity::hsc($title) . "</h1>\n";\r
+ echo "<p>{$msg}</p>\n";\r
+ echo "</body>\n";\r
+ echo "</html>\n";\r
exit;\r
}\r
-\r
+ \r
/**\r
* Connects to mysql server with arguments\r
*/\r
function sql_connect_args($mysql_host = 'localhost', $mysql_user = '', $mysql_password = '', $mysql_database = '', $new_link = FALSE)\r
{\r
$CONN = @mysql_connect($mysql_host, $mysql_user, $mysql_password, $new_link);\r
-\r
+ \r
if ( $mysql_database )\r
{\r
mysql_select_db($mysql_database,$CONN);\r
sql_set_charset('utf8');\r
}\r
-\r
+ \r
/*\r
// For debugging\r
$result = sql_query('SHOW VARIABLES LIKE \'char%\';');\r
echo "{$row[0]}: {$row[1]}\n";\r
}\r
*/\r
-\r
+ \r
return $CONN;\r
}\r
-\r
-\r
+ \r
/**\r
* Connects to mysql server\r
*/\r
function sql_connect()\r
{\r
global $MYSQL_HOST, $MYSQL_USER, $MYSQL_PASSWORD, $MYSQL_DATABASE, $MYSQL_CONN;\r
-\r
+ \r
$MYSQL_CONN = @mysql_connect($MYSQL_HOST, $MYSQL_USER, $MYSQL_PASSWORD) or startUpError('<p>Could not connect to MySQL database.</p>', 'Connect Error');\r
mysql_select_db($MYSQL_DATABASE) or startUpError('<p>Could not select database: ' . mysql_error() . '</p>', 'Connect Error');\r
-\r
+ \r
sql_set_charset('utf8');\r
-\r
+ \r
/*\r
// For debugging\r
$result = sql_query('SHOW VARIABLES LIKE \'char%\';');\r
echo "{$row[0]}: {$row[1]}\n";\r
}\r
*/\r
-\r
+ \r
return $MYSQL_CONN;\r
}\r
-\r
-\r
+ \r
/**\r
- * disconnects from SQL server\r
- */\r
+ * disconnects from SQL server\r
+ */\r
function sql_disconnect($conn = false)\r
{\r
global $MYSQL_CONN;\r
}\r
@mysql_close($conn);\r
}\r
-\r
+ \r
function sql_close($conn = false)\r
{\r
global $MYSQL_CONN;\r
}\r
@mysql_close($conn);\r
}\r
-\r
+ \r
/**\r
- * executes an SQL query\r
- */\r
+ * executes an SQL query\r
+ */\r
function sql_query($query,$conn = false)\r
{\r
global $SQLCount,$MYSQL_CONN;\r
$res = mysql_query($query,$conn) or print("mySQL error with query $query: " . mysql_error($conn) . '<p />');\r
return $res;\r
}\r
-\r
+ \r
/**\r
- * executes an SQL error\r
- */\r
+ * executes an SQL error\r
+ */\r
function sql_error($conn = false)\r
{\r
global $MYSQL_CONN;\r
}\r
return mysql_error($conn);\r
}\r
-\r
+ \r
/**\r
- * executes an SQL db select\r
- */\r
- function sql_select_db($db, $conn = false)\r
+ * executes an SQL db select\r
+ */\r
+ function sql_select_db($db,$conn = false)\r
{\r
global $MYSQL_CONN;\r
if ( !$conn )\r
{\r
$conn = $MYSQL_CONN;\r
}\r
- return mysql_select_db($db, $conn);\r
+ return mysql_select_db($db,$conn);\r
}\r
-\r
- /*\r
+ \r
+ /**\r
* executes an SQL real escape\r
*/\r
function sql_real_escape_string($val, $conn = false)\r
{\r
global $MYSQL_CONN;\r
- if ( !$conn )\r
+ if (!$conn)\r
{\r
$conn =& $MYSQL_CONN;\r
}\r
return mysql_real_escape_string($val, $conn);\r
}\r
-\r
+ \r
/**\r
- * executes an PDO::quote() like escape, ie adds quotes arround the string and escapes chars as needed\r
- */\r
+ * executes an PDO::quote() like escape, ie adds quotes arround the string and escapes chars as needed\r
+ */\r
function sql_quote_string($val, $conn = false)\r
{\r
global $MYSQL_CONN;\r
{\r
$conn = $MYSQL_CONN;\r
}\r
- return "'" . mysql_real_escape_string($val, $conn) . "'";\r
+ return "'".mysql_real_escape_string($val,$conn)."'";\r
}\r
-\r
+ \r
/**\r
- * executes an SQL insert id\r
- */\r
+ * executes an SQL insert id\r
+ */\r
function sql_insert_id($conn = false)\r
{\r
global $MYSQL_CONN;\r
}\r
return mysql_insert_id($conn);\r
}\r
-\r
+ \r
/**\r
- * executes an SQL result request\r
- */\r
+ * executes an SQL result request\r
+ */\r
function sql_result($res, $row, $col)\r
{\r
return mysql_result($res,$row,$col);\r
}\r
-\r
+ \r
/**\r
- * frees sql result resources\r
- */\r
+ * frees sql result resources\r
+ */\r
function sql_free_result($res)\r
{\r
return mysql_free_result($res);\r
}\r
-\r
+ \r
/**\r
- * returns number of rows in SQL result\r
- */\r
+ * returns number of rows in SQL result\r
+ */\r
function sql_num_rows($res)\r
{\r
return mysql_num_rows($res);\r
}\r
-\r
+ \r
/**\r
- * returns number of rows affected by SQL query\r
- */\r
+ * returns number of rows affected by SQL query\r
+ */\r
function sql_affected_rows($conn = false)\r
{\r
global $MYSQL_CONN;\r
}\r
return mysql_affected_rows($conn);\r
}\r
-\r
+ \r
/**\r
- * Get number of fields in result\r
- */\r
+ * Get number of fields in result\r
+ */\r
function sql_num_fields($res)\r
{\r
return mysql_num_fields($res);\r
}\r
-\r
+ \r
/**\r
- * fetches next row of SQL result as an associative array\r
- */\r
+ * fetches next row of SQL result as an associative array\r
+ */\r
function sql_fetch_assoc($res)\r
{\r
return mysql_fetch_assoc($res);\r
}\r
-\r
+ \r
/**\r
- * Fetch a result row as an associative array, a numeric array, or both\r
- */\r
+ * Fetch a result row as an associative array, a numeric array, or both\r
+ */\r
function sql_fetch_array($res)\r
{\r
return mysql_fetch_array($res);\r
}\r
-\r
+ \r
/**\r
- * fetches next row of SQL result as an object\r
- */\r
+ * fetches next row of SQL result as an object\r
+ */\r
function sql_fetch_object($res)\r
{\r
return mysql_fetch_object($res);\r
}\r
-\r
+ \r
/**\r
- * Get a result row as an enumerated array\r
- */\r
+ * Get a result row as an enumerated array\r
+ */\r
function sql_fetch_row($res)\r
{\r
return mysql_fetch_row($res);\r
}\r
-\r
+ \r
/**\r
- * Get column information from a result and return as an object\r
- */\r
- function sql_fetch_field($res, $offset = 0)\r
+ * Get column information from a result and return as an object\r
+ */\r
+ function sql_fetch_field($res,$offset = 0)\r
{\r
- return mysql_fetch_field($res, $offset);\r
+ return mysql_fetch_field($res,$offset);\r
}\r
-\r
+ \r
/**\r
- * Get current system status (returns string)\r
- */\r
- function sql_stat($conn = false)\r
+ * Get current system status (returns string)\r
+ */\r
+ function sql_stat($conn=false)\r
{\r
global $MYSQL_CONN;\r
if ( !$conn )\r
}\r
return mysql_stat($conn);\r
}\r
-\r
+ \r
/**\r
- * Returns the name of the character set\r
- */\r
- function sql_client_encoding($conn = false)\r
+ * Returns the name of the character set\r
+ */\r
+ function sql_client_encoding($conn=false)\r
{\r
global $MYSQL_CONN;\r
if ( !$conn )\r
}\r
return mysql_client_encoding($conn);\r
}\r
-\r
+ \r
/**\r
- * Get SQL client version\r
- */\r
+ * Get SQL client version\r
+ */\r
function sql_get_client_info()\r
{\r
return mysql_get_client_info();\r
}\r
-\r
+ \r
/**\r
- * Get SQL server version\r
- */\r
- function sql_get_server_info($conn = false)\r
+ * Get SQL server version\r
+ */\r
+ function sql_get_server_info($conn=false)\r
{\r
global $MYSQL_CONN;\r
if ( !$conn )\r
}\r
return mysql_get_server_info($conn);\r
}\r
-\r
+ \r
/**\r
- * Returns a string describing the type of SQL connection in use for the connection or FALSE on failure\r
- */\r
- function sql_get_host_info($conn = false)\r
+ * Returns a string describing the type of SQL connection in use for the connection or FALSE on failure\r
+ */\r
+ function sql_get_host_info($conn=false)\r
{\r
global $MYSQL_CONN;\r
if ( !$conn )\r
}\r
return mysql_get_host_info($conn);\r
}\r
-\r
+ \r
/**\r
- * Returns the SQL protocol on success, or FALSE on failure.\r
- */\r
- function sql_get_proto_info($conn = false)\r
+ * Returns the SQL protocol on success, or FALSE on failure.\r
+ */\r
+ function sql_get_proto_info($conn=false)\r
{\r
global $MYSQL_CONN;\r
if ( !$conn )\r
}\r
return mysql_get_proto_info($conn);\r
}\r
-\r
+ \r
/**\r
* Get the name of the specified field in a result\r
*/\r
{\r
return mysql_field_name($res, $offset);\r
}\r
-\r
+ \r
/**\r
* Set character encodings in each fields related to MySQL connection.\r
*/\r
function sql_set_charset($charset)\r
{\r
global $MYSQL_CONN;\r
-\r
+ \r
/*\r
* NOTE:\r
*\r
*/\r
$charset = strtolower($charset);\r
$mysql_version = preg_replace('#^([0-9]{1,2})\.([0-9]{1,2})\.([0-9]{1,2})(.*)$#', '$1.$2.$3', sql_get_server_info($MYSQL_CONN));\r
-\r
+ \r
if ( version_compare($mysql_version, '5.0.7', '>=') && function_exists('mysql_set_charset') )\r
{\r
$result = mysql_set_charset($charset);\r
{\r
$result = sql_query("SET NAMES {$charset};");\r
}\r
-\r
+ \r
return $result;\r
}\r
\r
# mysql_ tablename (deprecated)\r
\r
*******************************************************************/\r
-\r
}\r