Explore BrainMass

Explore BrainMass

    PHP / AJAX Script to fetch member details and total purchases

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    1. There is an Access database called ImageMasters (that tracks the sales of a photo-selling company) with the tables (all fields text unless noted):
    - T_Members (MemberId - autonumber, Surname, Forename, PTown, Pcode, Country)
    - T_Images (Image_category, Image_price - number)
    - T_Orders (DateOfOrder, ImageCategory, NoOfImages, OrderValue)

    2. An orders web page has been written that needs to:
    - fetch the member details (Forename, Firstname, PTown, Country) from the table T_Members when the memberid is provided and the button "Lookup Details" is clicked
    - fetch the price of an image, multiply by the number of images and update the field labelled "$0.00 each" with the total price when the button "refresh total" is clicked

    Required: Write a PHP and / or AJAX script that performs these functions, and appends a member's order to the table T_Orders. The orders web page and the database are attached.

    © BrainMass Inc. brainmass.com October 9, 2019, 8:05 pm ad1c9bdddf