0

Test PHP

[insert_php]

$dbhostname = “localhost”;
$dbusername = “canegrow_dbadmin”;
$dbpassword = “bl0ck1ps2017”;
$dbbase = “canegrow_sitedb”;

$root = “bdbcanegrowers.com.au”;

$connection = mysql_connect($dbhostname,$dbusername,$dbpassword) or die(“Couldn’t make connection.”);
$db = mysql_select_db(“$dbbase”, $connection) or die(“Couldn’t select database”);

$pagetextSQL = “SELECT * FROM pages WHERE pageID = 1”;
$textresults = mysql_query($pagetextSQL,$connection) or die(“Page Details Query Failed. – ” . mysql_error());

while ($arrRowp = mysql_fetch_assoc($textresults)) {

$pagetext = $arrRowp[‘pageText’];
$pagename = $arrRowp[‘pageName’];
$pageheading = $arrRowp[‘pageHeading’];
$pagetitle = $arrRowp[‘pageTitle’];
$pagemetadesc = $arrRowp[‘pageMetaDesc’];
$pagemetakeywords = $arrRowp[‘pageMetaKeywords’];
$pageshow = $arrRowp[‘pageShow’];
$pageorder = $arrRowp[‘pageOrder’];
}

echo $pagetext;
[/insert_php]