Purchase Solution

PHP / AJAX Script to fetch member details and total purchases

Not what you're looking for?

Ask Custom Question

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.

Attachments
Purchase this Solution
Purchase this Solution
Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

View More Free Quizzes
Related BrainMass Solutions

  • principles of AJAX programming

    123734 principles of AJAX programming I need to apply a variant to the code files provided below utilising the PHP script provided.

  • AJAX Programming: Add and delete entry in database

    261881 AJAX Programming: Add and delete entry in database PHP Code to add a new product and delete a existing product Implement AJAX Programming based solutions to write a code to: 1. Add a new product to the database. 2.

  • A basic summary of AJAX

    When this happens the page is sent from the server and the entire page is refreshed. AJAX allows for JavaScript that is embedded in the page to make "behind the scenes" calls to the server to fetch small bits of data.

  • Future of the Internet

    Enter jQuery (amongst other online scripting languages such as PHP, AJAX, CSS3, and OWASP), which allows a programmer the ability to script and create more movement and security in their pages (jQuery, 2013).

  • Php Random Quote Generator

    257848 Php Random Quote Generator The PHP script should read quotes from a 'quotes.txt' data file and display one random quote on the web page each time the page is refreshed.

  • Php "Change Maker" script

    258278 Php "Change Maker" Script Write a "Change Maker" script in Php that will ask user for the price of the merchandise and the amount paid, and will calculate the change to be returned in terms of $1 bills, Quarters, Dimes and Pennies.

  • Php script to search for words in a string

    "; to something else in the script, the output will change.

  • The Logon and Forgotten Password Scripts for HTML and PHP

    Also create the server-side PHP script to which eislogin.html passes this information and allows connection to eisdb.mdb.

  • Analysis of AJAX Application Model

    The success stories of Google Suggest and Google Maps have only boosted the growth of Ajax. AJAX is not only browser independent but also perfectly compatible with any standard Web server and server-side language like PHP, ASP.

View More Related Solutions