Requirements
PHP-Fusion Core 7 Edition
PHP5 with mysqli extension installed
Note: The mysqli extension is designed to work with MySQL version 4.1.13 or newer, or 5.0.7 or newer. For previous versions, please see the MySQL extension documentation.
Modifying file themes/templates/footer.php
Search for:
 Codemysql_close();
And replace with:
Code mysqli_close;
Modifying file maincore.php
Search for:
Code function dbquery($query) {
$result = @mysql_query($query);
if (!$result) {
echo mysql_error();
return false;
} else {
return $result;
}
}
And replace with:
Code function dbquery($query) {
global $link;
$result = $link->query($query);
if (!$result) {
echo $link->error;
return false;
} else {
return $result;
}
}
Search for:
Code function dbcount($field, $table, $conditions = "") {
$cond = ($conditions ? " WHERE ".$conditions : "");
$result = @mysql_query("SELECT Count".$field." FROM ".$table.$cond);
if (!$result) {
echo mysql_error();
return false;
} else {
$rows = mysql_result($result, 0);
return $rows;
}
}
And replace with:
Code function dbcount($field, $table, $conditions = "") {
global $link;
$cond = ($conditions ? " WHERE ".$conditions : "");
$result = $link->query("SELECT Count".$field." AS Total FROM ".$table.$cond);
if (!$result) {
echo $link->error;
return false;
} else {
$rows = $result->fetch_assoc();
return $rows["Total"];
}
}
Search for:
Code function dbresult($query, $row) {
$result = @mysql_result($query, $row);
if (!$result) {
echo mysql_error();
return false;
} else {
return $result;
}
}
And replace with:
Code function dbresult($result, $row) {
if (!$result) {
return false;
} else {
$result->data_seek($row);
$row = $result->fetch_row();
return $row[0];
}
}
Search for:
Code function dbrows($query) {
$result = @mysql_num_rows($query);
return $result;
}
And replace with:
Code function dbrows($result) {
if (!$result) {
return false;
} else {
$result = $result->num_rows;
return $result;
}
}
Search for:
Code function dbarray($query) {
$result = @mysql_fetch_assoc($query);
if (!$result) {
echo mysql_error();
return false;
} else {
return $result;
}
}
And replace with:
Code function dbarray($result) {
if (!$result) {
return false;
} else {
$result = $result->fetch_assoc();
return $result;
}
}
Search for:
Code function dbarraynum($query) {
$result = @mysql_fetch_row($query);
if (!$result) {
echo mysql_error();
return false;
} else {
return $result;
}
}
And replace with:
Code function dbarraynum($result) {
if (!$result) {
return false;
} else {
$result = $result->fetch_row();
return $result;
}
}
Search for:
Code function dbconnect($db_host, $db_user, $db_pass, $db_name) {
$db_connect = @mysql_connect($db_host, $db_user, $db_pass);
$db_select = @mysql_select_db($db_name);
if (!$db_connect) {
die("<div style='font-family:Verdana;font-size:11px;text-align:center;'><b>Unable to establish connection to MySQL</b><br />".mysql_errno()." : ".mysql_error()."</div>");
} elseif (!$db_select) {
die("<div style='font-family:Verdana;font-size:11px;text-align:center;'><b>Unable to select MySQL database</b><br />".mysql_errno()." : ".mysql_error()."</div>");
}
}
And replace with:
Code function dbconnect($db_host, $db_user, $db_pass, $db_name) {
$mysqli = new mysqli($db_host, $db_user, $db_pass, $db_name);
if (mysqli_connect_error()) {
die("<div style='font-family:Verdana;font-size:11px;text-align:center;'><b>Unable to establish connection to MySQL</b><br />".mysqli_connect_errno()." : ".mysqli_connect_error()."</div>");
} else return $mysqli;
}
Edited by MvE Community on 06-06-2010 11:28 |
