mysql to mysqli wrapper-funcions for IIS

some IIS only have the mysqli-functions.
put this at the top of your script:
[php]
if(!function_exists(‘mysql_connect’) and function_exists(‘mysqli_connect’))
{
define(‘MYSQL_USE_RESULT’,MYSQLI_USE_RESULT);
define(‘MYSQL_STORE_RESULT’,MYSQLI_STORE_RESULT);
define(‘MYSQL_STORE_RESULT’,MYSQLI_STORE_RESULT);
define(‘MYSQL_ASSOC’,MYSQLI_ASSOC);
define(‘MYSQL_NUM’,MYSQLI_NUM);
define(‘MYSQL_BOTH’,MYSQLI_BOTH);

function mysql_connect($p1,$p2,$p3)
{
return $GLOBALS[‘msqlilink’]=mysqli_connect($p1,$p2,$p3);
}
function mysql_select_db($p1,$link=NULL)
{
if($link===NULL)$link=$GLOBALS[‘mysqlilink’];
return mysqli_select_db($link,$p1);
}
function mysql_query($p1,$p2=MYSQLI_STORE_RESULT,$link=NULL)
{
if($link===NULL)$link=$GLOBALS[‘mysqlilink’];
return mysqli_query($link,$p1);
}
function mysql_fetch_row($p1)
{
return mysqli_fetch_row($p1);
}
function mysql_fetch_array($p1,$p2=MYSQLI_BOTH)
{
return mysqli_fetch_array($p1,$p2);
}
function mysql_fetch_assoc($p1)
{
return mysqli_fetch_assoc($p1);
}
function mysql_insert_id($link=NULL)
{
if($link===NULL)$link=$GLOBALS[‘mysqlilink’];
return mysqli_insert_id($link);
}
function mysql_info($link=NULL)
{
if($link===NULL)$link=$GLOBALS[‘mysqlilink’];
return mysqli_info($link);
}
function mysql_affected_rows($link=NULL)
{
if($link===NULL)$link=$GLOBALS[‘mysqlilink’];
return mysqli_affected_rows($link);
}
function mysql_errno($link=NULL)
{
if($link===NULL)$link=$GLOBALS[‘mysqlilink’];
return mysqli_errno($link);
}
function mysql_error($link=NULL)
{
if($link===NULL)$link=$GLOBALS[‘mysqlilink’];
return mysqli_error($link);
}
function mysql_close($link=NULL)
{
if($link===NULL)$link=$GLOBALS[‘mysqlilink’];
return mysqli_close($link);
}
function mysql_escape_string($p1,$link=NULL)
{
if($link===NULL)$link=$GLOBALS[‘mysqlilink’];
return mysqli_real_escape_string($link,$p1);
}
}
[/php]

Sponsor our Newsletter | Privacy Policy | Terms of Service