PHP code not being interpreted by DW and appearing as text on webpage. My Php code is below, this code is bolted into a html site(PHP file). However the code is not being executed and it is appearing as text on the webpage. Any help would be really appreciated.
<?php
include_once("includes/session.php");
confirm_logged_in();
include_once("../includes/masterinclude.php");
$preferences = getPreferences();
$email_setup = getEmailSetup();
//note this will also refresh the page after amending it
$pageTitle = "Site Administration: Confirm Members";
$pageMetaDescription = $preferences->PREF_META_DESC;
$pageMetaKeywords = $preferences->PREF_META_KEYWORDS;
$message = "";
$logincount = 1;
$new = 1;
$errors = 0;
$errors_array = array();
$scrolltobottom = "";
//initialise screen fields
$selected_member = "";
$id = "";
$username = ""; $username_original = "";
$password = ""; $password_original = "";
$password_test = "";
$title = "MR"; $first_name = ""; $last_name = ""; $company_name = "";
$address1 = ""; $address2 = ""; $town = ""; $county = ""; $country = ""; $postcode = ""; $phone = ""; $mobile = ""; $email = ""; $category = "";
$member_confirmed = "N"; $justconfirmed = 0;
$ast_first = 0; $ast_last = 0; $ast_company = 0; $ast_add1 = 0; $ast_add2 = 0; $ast_town = 0; $ast_county = 0; $ast_country = 0; $ast_post = 0; $ast_phone = 0;
$ast_mobile = 0; $ast_email = 0; $ast_category = 0;
$ast_user = 0; $ast_pass = 0; $ast_passconf = 0;
?>
<?php
if($_POST['JUST_CONFIRMED'] == 0){
$rows = Delete_Member($_POST['ID'], $_POST['USERNAME']);
$message = "";
if ($rows == 1){
$message = "Member successfully DELETED";
$warning = "green";
}
if ($rows == 0){
$message = "WARNING ! ! ! - RECORD NOT DELETED";
$warning = "orange";
}
if ($rows > 1){
$message = "ERROR ! ! ! - MORE THAN ONE (" . $rows . ") RECORD DELETED - PLEASE CONTACT SHOPFITTER";
$warning = "red";
}
//initialise all fields
$selected_member = "";
$id = "";
$username = ""; $username_original = "";
$password = ""; $password_original = "";
$password_test = "";
$title = "MR"; $first_name = ""; $last_name = ""; $company_name = "";
$address1 = ""; $address2 = ""; $town = ""; $county = ""; $country = ""; $postcode = ""; $phone = ""; $mobile = ""; $email = "";
$member_confirmed = "N";
$ast_first = 0; $ast_last = 0; $ast_company = 0; $ast_add1 = 0; $ast_add2 = 0; $ast_town = 0; $ast_county = 0; $ast_country = 0; $ast_post = 0; $ast_phone = 0;
$ast_mobile = 0; $ast_email = 0;
$ast_user = 0; $ast_pass = 0; $ast_passconf = 0;
if($message != ""){$scrolltobottom = "onLoad=\"scrollTo(0,2000)\" ";}
}
else{
// refresh input details
$title = $_POST['TITLE'];
$first_name = $_POST['FIRST_NAME'];
$last_name = $_POST['LAST_NAME'];
$company_name = $_POST['COMPANY_NAME'];
$address1 = $_POST['ADDRESS1'];
$address2 = $_POST['ADDRESS2'];
$town = $_POST['TOWN'];
$county = $_POST['COUNTY'];
$country = $_POST['COUNTRY'];
$postcode = $_POST['POSTCODE'];
$phone = $_POST['PHONE'];
$mobile = $_POST['MOBILE'];
$email = $_POST['EMAIL'];
$member_confirmed = $_POST['MEMBER_CONFIRMED'];
$username = $_POST['USERNAME_ORIGINAL']; $username_original = $username;
$id = $_POST['ID'];
$password = ""; $password_original = $_POST['PASSWORD_ORIGINAL'];
$login_name = isset($_SESSION['username']) ? $_SESSION['username'] : "";
$message = "Member now confirmed - Please choose another";
$warning = "red";
$just_confirmed = 1;
$scrolltobottom = "onLoad=\"scrollTo(0,2000)\" ";
}
if (isset($_GET['searchmember'])) {
//NEW MEMBER SELECTED from search dropdown so get member deatils for display
$u = Get_Member($_GET['searchmember']);
$id = $u->MB_ID;
$selected_member = $u->MB_USERNAME;
$id = $u->MB_ID;
$username = $u->MB_USERNAME; $username_original = $username;
$password = ""; $password_original = $u->MB_PASSWORD; //encrypted
$title = $u->MB_TITLE;
$first_name = $u->MB_FIRSTNAME;
$last_name = $u->MB_LASTNAME;
$company_name = $u->MB_COMPANY;
$address1 = $u->MB_ADDRESS1;
$address2 = $u->MB_ADDRESS2;
$town = $u->MB_TOWN;
$county = $u->MB_COUNTY;
$country = $u->MB_COUNTRY;
$postcode = $u->MB_POSTCODE;
$phone = $u->MB_PHONE;
$mobile = $u->MB_MOBILE;
$email = $u->MB_EMAIL;
$category = $u->MB_CATEGORY;
$member_confirmed = $u->MB_CONFIRMED;
$_POST['SEARCH'] = "search";
$_POST['SEARCH_DATA'] = $_GET['searchdata'];
$_POST['SELECTED_MEMBER'] = $_GET['searchmember'];
$just_confirmed = 0;
}
if (isset($_POST['UPDATE']) or isset($_POST['CONFIRM'])) {
if($_POST['JUST_CONFIRMED'] == 0){
if(isset($_POST['CREATE'])){$new = 1;}else{$new = 0;}
if ($_POST['FIRST_NAME'] == ""){
$errors_array[] = "Please enter a first name";
$warning = "red";
$ast_first = 1;
$errors = 1;
}
if ($_POST['LAST_NAME'] == ""){
$errors_array[] = "Please enter a last name";
$warning = "red";
$ast_last = 1;
$errors = 1;
}
if ($_POST['ADDRESS1'] == ""){
$errors_array[] = "Please enter an address";
$warning = "red";
$ast_add1 = 1;
$errors = 1;
}
if ($_POST['TOWN'] == ""){
$errors_array[] = "Please enter a Town";
$warning = "red";
$ast_town = 1;
$errors = 1;;
}
if ($_POST['COUNTRY'] == ""){
$errors_array[] = "Please enter a Country";
$warning = "red";
$ast_country = 1;
$errors = 1;
}
if ($_POST['POSTCODE'] == ""){
$errors_array[] = "Please enter a Postcode";
$warning = "red";
$ast_post = 1;
$errors = 1;
}
if ($_POST['EMAIL'] == ""){
$errors_array[] = "Please enter a valid email address";
$warning = "red";
$ast_email = 1;
$errors = 1;
}
if ($_POST['CATEGORY'] == ""){
$errors_array[] = "Please enter a valid Price Category Code";
$warning = "red";
$ast_email = 1;
$errors = 1;
}
if ($_POST['USERNAME'] == ""){
$errors_array[] = "Please enter a User Name";
$warning = "red";
$ast_user = 1;
$errors = 1;
}else{
$m = Confirm_Member($_POST['USERNAME'],"");
if ($_POST['USERNAME'] !== $_POST['USERNAME_ORIGINAL']){
$errors_array[] = "Cannot amend User Name";
$warning = "red";
$errors = 1;
$ast_user = 1;
}
}
if (isset($_POST['CONFIRM']) and $_POST['PASSWORD'] == ""){
$errors_array[] = "Please enter a Password";
$warning = "red";
$ast_pass = 1;
$errors = 1;
}
if (isset($_POST['CONFIRM']) and $_POST['PASSWORD'] != $_POST['PASSWORD_TEST']){
$errors_array[] = "Password and confirmation do not match";
$warning = "red";
$errors = 1;
$ast_pass = 1; $ast_passconf = 1;
}
if($errors == 0){
//create / amend table member
if($new == 1){$hashed_password = sha1($_POST['PASSWORD']);}
if($new == 0){
if($_POST['PASSWORD'] != $_POST['PASSWORD_ORIGINAL']){
//password has been changed
$hashed_password = sha1($_POST['PASSWORD']);
}else{
//password is unchanged so it's already in encrypted format
$hashed_password = $_POST['PASSWORD'];
}
}
if (isset($_POST['UPDATE'])){
$fields = array("id"=>$_POST['ID'], "username"=>$_POST['USERNAME'], "password"=>sha1($_POST['PASSWORD']), "datecreated"=>date("d F l, Y, h:i:s"),
"lastlogin"=>date("l F d, Y, h:i:s"), "logincount"=>$logincount, "category"=>$_POST['CATEGORY'], "title"=>$_POST['TITLE'], "firstname"=>$_POST['FIRST_NAME'], "lastname"=>$_POST['LAST_NAME'],
"company"=>$_POST['COMPANY_NAME'], "address1"=>$_POST['ADDRESS1'], "address2"=>$_POST['ADDRESS2'], "town"=>$_POST['TOWN'], "county"=>$_POST['COUNTY'],
"country"=>$_POST['COUNTRY'], "postcode"=>$_POST['POSTCODE'], "phone"=>$_POST['PHONE'], "mobile"=>$_POST['MOBILE'],
"email"=>$_POST['EMAIL'], "confirmed"=>$member_confirmed);
$rows = Rewrite_Member($fields);
}else{
$fields = array("id"=>$_POST['ID'], "category"=>$_POST['CATEGORY'], "username"=>$_POST['USERNAME'], "password"=>sha1($_POST['PASSWORD']), "confirmed"=>"Y");
$rows = Accept_Member($fields);
}
$message = "";
if ($rows == 1){
if (isset($_POST['UPDATE'])){
$message = "Member successfully UPDATED";
}else{
//send confirmational email
$email_it_to = $_POST['EMAIL'];
$email_it_to_cc = $email_setup->EM_CONF_CC;
$email_it_to_bcc = $email_setup->EM_CONF_BCC;
$email_it_from = $preferences->PREF_EMAIL;
$email_subject = $email_setup->EM_CONF_SUBJECT;
$email_confirmation = $email_setup->EM_CONF_HEADER;
$email_confirmation .= $email_setup->EM_CONF_CONTENT;
$email_confirmation .= "Name: " . $_POST['USERNAME'] . " Password: " . $_POST['PASSWORD'] . "\r\n\r\n";
$email_confirmation .= $email_setup->EM_CONF_FOOTER;
$failure_page = "confirm_members.php?email=fail";
include_once("../mailer/_process_from_cms.php");
$message = "User " . $_POST['USERNAME'] . " now CONFIRMED as a member";
}
$warning = "green";
}
if ($rows == 0){
$message = "WARNING ! ! ! - NO RECORDS UPDATED";
$warning = "orange";
}
if ($rows > 1){
$message = "ERROR ! ! ! - MORE THAN ONE (" . $rows . ") RECORDS UPDATED - PLEASE CONTACT SHOPFITTER";
$warning = "red";
}
$error = null;
$error = mysql_error();
if ($error != null) {
$message .= " - ERRORS FOUND ! ! ! - " . mysql_error() . " ";
}
if(isset($_POST['UPDATE'])){
//refresh details
$username = $_POST['USERNAME']; $username_original = $username;
$id = $_POST['ID'];
$password = $_POST['PASSWORD']; $password_original = $password;
$u = Get_Member($username);
$category = $u->MB_CATEGORY;
$title = $u->MB_TITLE;
$first_name = $u->MB_FIRSTNAME;
$last_name = $u->MB_LASTNAME;
$company_name = $u->MB_COMPANY;
$address1 = $u->MB_ADDRESS1;
$address2 = $u->MB_ADDRESS2;
$town = $u->MB_TOWN;
$county = $u->MB_COUNTY;
$country = $u->MB_COUNTRY;
$postcode = $u->MB_POSTCODE;
$phone = $u->MB_PHONE;
$mobile = $u->MB_MOBILE;
$email = $u->MB_EMAIL;
$member_confirmed = $u->MB_CONFIRMED;
$login_name = $username;
$login_password = $password;
if($message != ""){$scrolltobottom = "onLoad=\"scrollTo(0,2000)\" ";}
}else{
// refresh input details
$category = $_POST['CATEGORY'];
$title = $_POST['TITLE'];
$first_name = $_POST['FIRST_NAME'];
$last_name = $_POST['LAST_NAME'];
$company_name = $_POST['COMPANY_NAME'];
$address1 = $_POST['ADDRESS1'];
$address2 = $_POST['ADDRESS2'];
$town = $_POST['TOWN'];
$county = $_POST['COUNTY'];
$country = $_POST['COUNTRY'];
$postcode = $_POST['POSTCODE'];
$phone = $_POST['PHONE'];
$mobile = $_POST['MOBILE'];
$email = $_POST['EMAIL'];
$member_confirmed = $_POST['MEMBER_CONFIRMED'];
$username = $_POST['USERNAME_ORIGINAL']; $username_original = $username;
$id = $_POST['ID'];
$password = ""; $password_original = $_POST['PASSWORD_ORIGINAL'];
$login_name = isset($_SESSION['username']) ? $_SESSION['username'] : "";
if($message != ""){$scrolltobottom = "onLoad=\"scrollTo(0,2000)\" ";}
$just_confirmed = 1;
}
}else{
// refresh input details
$category = $_POST['CATEGORY'];
$title = $_POST['TITLE'];
$first_name = $_POST['FIRST_NAME'];
$last_name = $_POST['LAST_NAME'];
$company_name = $_POST['COMPANY_NAME'];
$address1 = $_POST['ADDRESS1'];
$address2 = $_POST['ADDRESS2'];
$town = $_POST['TOWN'];
$county = $_POST['COUNTY'];
$country = $_POST['COUNTRY'];
$postcode = $_POST['POSTCODE'];
$phone = $_POST['PHONE'];
$mobile = $_POST['MOBILE'];
$email = $_POST['EMAIL'];
$member_confirmed = $_POST['MEMBER_CONFIRMED'];
$username = $_POST['USERNAME_ORIGINAL']; $username_original = $username;
$id = $_POST['ID'];
$password = ""; $password_original = $_POST['PASSWORD_ORIGINAL'];
$login_name = isset($_SESSION['username']) ? $_SESSION['username'] : "";
/*
$message = "";
foreach($errors_array as $e){
$message .= $e . "<br/>";
}
$warning = "red";
*/
}
}else{
$message = "Member now confirmed - Please choose another";
$warning = "red";
$scrolltobottom = "onLoad=\"scrollTo(0,2000)\" ";
// refresh input details
$category = $_POST['CATEGORY'];
$title = $_POST['TITLE'];
$first_name = $_POST['FIRST_NAME'];
$last_name = $_POST['LAST_NAME'];
$company_name = $_POST['COMPANY_NAME'];
$address1 = $_POST['ADDRESS1'];
$address2 = $_POST['ADDRESS2'];
$town = $_POST['TOWN'];
$county = $_POST['COUNTY'];
$country = $_POST['COUNTRY'];
$postcode = $_POST['POSTCODE'];
$phone = $_POST['PHONE'];
$mobile = $_POST['MOBILE'];
$email = $_POST['EMAIL'];
$member_confirmed = $_POST['MEMBER_CONFIRMED'];
$username = $_POST['USERNAME_ORIGINAL']; $username_original = $username;
$id = $_POST['ID'];
$password = ""; $password_original = $_POST['PASSWORD_ORIGINAL'];
$login_name = isset($_SESSION['username']) ? $_SESSION['username'] : "";
$just_confirmed = 1;
}
}
?>
