0

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;
    }
}
?>

Edited by jonlloydd: spelling error

4
Contributors
6
Replies
27
Views
3 Years
Discussion Span
Last Post by jonlloydd
0

You mean as text on the page in DW design view and/or live view, or just in the browser on your local machine? You will need to have a server environment on your local machine installed in order to execute PHP files. Look into WAMP for Windows or MAMP for Mac.

Edited by gentlemedia

0

I am already running WAMP and have already set it up in dreamweaver, would you have any other suggestions?

0

No sorry... it's been ages for me since I have used DW and perhaps this thread is better off in the PHP forum.

0

You have Apache running? Check to see. Often happens if webserver not running.

0

Ahh thankyou pzuurveen, problem solved. Thanks for the help guys

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.