Portals powered by Own Casino Portal.
"SET NAMES 'utf8'")); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { echo "Connection failed: " . $e->getMessage(); die; } // The DB table for Portals. $portalsTable = 'portals'; // The params that you select from the Portals table. $portalParams = [ 'portal_name', // {{portalName}} 'portal_domain', // {{portalDomain}} 'portal_logo', // {{portalLogo}} 'portal_site_intro_text', // {{portalSiteIntroText}} 'portal_site_intro_text_title', // {{portalSiteIntroTextTitle}} 'portal_site_bottom_text', // {{portalSiteBottomText}} 'portal_site_bottom_text_title', // {{portalSiteBottomTextTitle}} ]; foreach ($portalParams as &$portalParam) { $portalParam = $portalsTable . '.' . $portalParam; } unset($portalParam); $portalSelect = implode(", ", $portalParams); // The Where element (Only active portals). $portalStatusActive = 1; $stmt = $conn->prepare('SELECT ' . $portalSelect . ' FROM portals' . ' WHERE portal_status = :portalStatus'); $stmt->execute(['portalStatus' => $portalStatusActive]); // Replace the placeholders. function replace_tags($template, $placeholders) { $placeholders = array_merge($placeholders, array('' => '', '?>' => '')); return str_replace(array_keys($placeholders), $placeholders, $template); } // Fetch data. while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $vars = array( '{{portalName}}' => $row['portal_name'], '{{portalDomain}}' => $row['portal_domain'], '{{portalLogo}}' => $row['portal_logo'], '{{portalSiteIntroText}}' => $row['portal_site_intro_text'], '{{portalSiteIntroTextTitle}}' => $row['portal_site_intro_text_title'], '{{portalSiteBottomText}}' => $row['portal_site_bottom_text'], '{{portalSiteBottomTextTitle}}' => $row['portal_site_bottom_text_title'], ); $template = file_get_contents('template.phtml', true); echo replace_tags($template, $vars); } ?>