convert a mysql function to mysqli
hey there just a quickie (hopefully)
I have the following function that works on an old website and I want to update it to use MySQi
php:
<?php
function CMS($db,$connection,$element) {
$basefile = basename ( $_SERVER['PHP_SELF'] );
mysql_select_db($db, $connection);
$query_rsCMS = "SELECT CMSContent FROM cms WHERE CMSLocale = '$basefile' AND CMSElement = '$element'";
$rsCMS = mysql_query($query_rsCMS, $connection);
$row_rsCMS = mysql_fetch_assoc($rsCMS);
mysql_free_result($rsCMS);
return $row_rsCMS["CMSContent"];
}
?>
and then to use that function:
php:
<h1><?php echo CMS($database_dinkydb, $dinkydb,'Header'); ?></h1>
or
<div><?php echo CMS($database_dinkydb, $dinkydb,'Content'); ?></div>
the updated MySQLi version is as follows:
php:
<?php
function CMS($db,$element) {
$rsCMS = new WA_MySQLi_RS("rsCMS",$db,1);
$rsCMS->setQuery("SELECT * FROM cms WHERE CMSLocale = '".((isset($_SERVER["PHP_SELF"]))?$_SERVER["PHP_SELF"]:"") ."' AND CMSElement = '$element'");
$rsCMS->execute();
return $rsCMS->getColumnVal("CMSContent");
}
?>php:
<h1><?php echo CMS($ecartdb,'Header'); ?></h1>
or
<div><?php echo CMS($ecartdb,'Content'); ?></div>
