<? require_once("scripts/error_handler.php"); require_once("scripts/mysql.php"); require_once("scripts/display_nav.php"); require_once("scripts/get_dynamic_pages.php"); require_once("scripts/process_action.php"); require_once("sitemanager/scripts/get_template_info.php"); my_sql_start(); // GLOBAL SETTINGS require_once("scripts/globals.php"); // validate any variables that are passed in // (note that this changes many $_GET variables and sets default values) if ($DEBUG) echo "Validating input...<br>"; require_once("scripts/validate.php"); // pass form post variables into actions $parms["POST"] = $_POST; // if we have an action, perform that action if ($DEBUG) echo "Processing Action ".$parms["action"]."...<br>"; if ($parms["action"]) process_action($page, $parms, $target); // Load page to display. NOTE: navTitle must be unique $info = my_sql_query("SELECT fileOrTemplateName,pageTitle,usesTemplate,templates.filename FROM pages LEFT JOIN templates ON templates.name = pages.fileOrTemplateName WHERE navTitle='$page'"); // Set the page's title from DB if ($info[0]["pageTitle"]) $title = $info[0]["pageTitle"]; else $title = ":-) Bank – Home"; // Display css, javascript, title, header, and nav require_once("header.php"); // Default to home page if (!$info[0]["fileOrTemplateName"]) { require_once("level1/Home.php"); // If template handle as template } else if($info[0]["usesTemplate"]) { $time = microtime(); my_sql_query("INSERT INTO template_bio_temp(header,description) VALUES('".$info[0]["filename"]."','REQUIRING')"); require_once($info[0]["filename"]); // If not, just include the PHP file here } else { require_once($info[0]["fileOrTemplateName"]); } // Display footer require_once("footer.php");?>bios.php:<?$mainData = my_sql_query("SELECT * FROM template_bio WHERE navTitle='$page'");$bioData = my_sql_query("SELECT * FROM template_bio_bios WHERE navTitle='$page'");// display main templateecho '<h2>'. $mainData[0]["header"] .'</h2><p>'. $mainData[0]["description"] .'</p>';// display each bioforeach ($bioData as $bio) { echo '<h3>'. $bio["name"] .'</h3>'; echo '<img src="'. $bio["image"] .'" alt="Bio Image">';}?>