Checkout
checkout
view
Your Cart Your Cart: item(s)
Subjects -> Computer Science -> Web Design -> Posting #138777
Add to Shopping Cart
$2.19 Instant Download
Computer Science, Web Design
Other

PHP / AJAX Script to fetch member details and total purchases


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
Images of the Masters.htm  View File
ImageMastersTest.mdb  View File

By OTA:  Ramesh Palipi, MSc (IP)

OTA Rating:  4.7/5

Your Price:  $2.19  (original value ~$39.90)

What's included:

  • Plain text response
  • Attachment(s):
    • ImageMasters.zip
$2.19 Download Add to Cart

Add to Shopping Cart
$2.19 Instant Download
Database Concept - What are the main components when designing an ERD?
Network Protocols - Why are network protocols needed? How do you decide which protocol is more suitable for a network implementation?
Storing three-dimensional homogeneous arrays - Describe a method for storing three-dimensional homogeneous arrays. What addressing formula would be used to locate the entry in the ith plane, jth row, and the kth column?
Artificial Intelligence - In the text we briefly discussed the problems of understanding natural languages as opposed to formal programming languages. As an example of the complexities involved in the case of natural languages, identify situations in which the question “Do you know what time it is?” has different meanings. Describe how the problem of traveling from one city to another could be...
Artificial Intelligence - Q1. Give some examples of declarative knowledge. Give some examples of procedural knowledge. Q2. In the context of a production system, what is the difference between a state graph and a search tree?

Page generated in 0.0467 seconds

About Us ·  Contact Us ·  Samples ·  Solutions ·  Legal Terms and Conditions ·  Privacy Policy

©2008 SolutionLibrary.com

Search for Solutions About Us Samples