程序代写代做代考 game Java html javascript jquery database Instructions:

) { // check whether the Submit button is clicked
) { // check whether input name is an empty string
;
echo “Hello
(f) !”;
}
?>
(a)
(b)
(c)
Internet & Multimedia Applications Development (ITP4513)
Main Examination
Semester 3 (2018/2019)
© Vocational Training Council

Information Technology Discipline Page 3 of 13 Programme/Year: IT114105/1
A3 Write the missing code for parts (a) to (f) in the PHP script A3.php which processes the product ID and order quantity data passed in the query string.
Assume the following two GET requests are sent to the web server, the PHP script A3.php will store the productid value and qty value in a session file and then create a cookie to store the last received productid value.
http://127.0.0.1/A3.php?productid=P003&qty=10 http://127.0.0.1/A3.php?productid=P008&qty=2
If there is no query string in the GET request and the stored cookie is not expired, the PHP script A3.php will output the information as shown in Figure A3.
IQ. 127,0,0.1/A3,php
Product ID iin your last transaction is Poo8 Product ID Poo3 with quantify 10
Product ID Poo8 with quantity 2
File: A3.php 0) { // if a query string is found
= $qty;
(b)
10.
11.
12.
13. (e)
(c)
;
} else {
if ( (d) ) // if a cookie named lastid has been sent to the server
14. (f) ; 15. }
16. ?>
17.
(a)
(b) (c)
(d) (e) (f)

Create a new session file if it does not exist, otherwise open the existing session file.
[1 mark] Store the qty value in the session file using productid value as the index. [1 mark]
Create a cookie named lastid to store the productid value found in the query string.
echo “Product ID in your last transaction is {$_COOKIE[‘lastid’]}
“;
The cookie should expire after 2 hours.
Check if a cookie named lastid has been sent to the server.
Write a foreach loop to output all session data as shown in Figure A3. Delete all session data.
[2 marks] [1 mark] [4 marks] [1 mark]
Internet & Multimedia Applications Development (ITP4513) Main Examination Semester 3 (2018/2019)
© Vocational Training Council

Information Technology Discipline Programme/Year: IT114105/1
return the JSON representation converted from the array $awardinfo: {
“student”: “Chan Tai Man”,
“AGPAobtained”: 3.2,
“classification”: [“Distinction”, “Credit”, “Pass”], “AGPArequired”: [3.5, 3, 1]
}
[4 marks]
File : A4JSON.php
Page 4 of 13
A4 (a)
Write the missing code for the code fragment of file A4JSON.php which creates the following JSON string from an associative array $awardinfo, and then use echo to
Line
1.
2.
3.
4.
5.
6.

(b)
Assume the URL of the PHP script A4JSON.php is http://127.0.0.1/A4JSON.php. Write the missing code for parts (i) to (iv) in the code fragment of file A4.html which executes the jQuery $.ajax() method by using GET type request to display following message in an alert message box of the web browser: [6 marks]
Student Chan Tai Man is awarded the Credit classification
Explanation to output :
The student obtained Award GPA (AGPAobtained) 3.2 which can only meet the minimum required AGPA (AGPArequired) 3 for the Credit award classification.
Line
1.
2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19.
File : A4,html



Internet & Multimedia Applications Development (ITP4513)
Main Examination
Semester 3 (2018/2019)
© Vocational Training Council

Information Technology Discipline Programme/Year: IT114105/1
Section B (60 marks)
This section contains THREE questions. Answer ALL questions.
Host address: 127.0.0.1
Login username: root
Database name: salesdb
Login Password: mysecret
Column
Format
Description
orderid
int
Order ID (Primary Key) e.g. 2
productid
varchar(5)
Product ID e.g. P1011, P2089
quantity
int
Order Quantity e.g. 5
deliverymode
varchar(15)
Delivery Method e.g. express, super express
orderid
productid
quantity
deliverymode
1
P1011
2
express
2
P2089
5
express
3
P1011
3
super express
4
P1011
1
express
B1 You are required to develop a PHP program B1b.php to add new order records to the MySQL database using form data submitted from file B1a.html.
_____...=,
Delivery Mode : 0 E.xpress I Create Order i
Figure 1A
Information of MySQL database
Schema of table custorders
Quantity '-4-1
Page 5 of 13
~ • I Q_ 127.0.0.1/81a.html
Money Saver Shop
Ordering System
name is productid name is quantity
Product ID P2089 name is deliverymode ,.......!::====::;-'.
form submits by post method to program B1b.php
Before the form data in Figure 1A is added to the database, there are four records in the custorders table:
[Question B1 continues on the next page.]
Internet & Multimedia Applications Development (ITP4513) Main Examination Semester 3 (2018/2019)
© Vocational Training Council

Information Technology Discipline
Programme/Year: IT114105/1
Page 6 of 13
[Question B1 continued from the last page.]
After a new record is added to the database, program B1b.php should display all records
and a summary of all records grouped by productid as shown in Figure 1B. ~ • IQ. 127.0.0.1/B1b.php
Y our Order Records
A total of 5 orders.
IOrder ID IIProduct ID IIQuantityIDelivery ModeI
11 IIP1011
12 ;1P 2 0 8 9
I3 II P1011
~ =-:J[fuiu :=][1 =-:J~ ess =-:J [ L = 7 1 P 2 0 8 9 1[ 4 l l s u p e r e x p r e s ~s
Product P2089, total order quantity =9 Product P1011, total order quantity =6
Figure 1B
Carefully study the program comments, and then provide the missing code for parts (a) to
(b) of file conn.php and parts (c) to (l) of file B1b.php. [20 marks] File: conn.php

File : B1b.php
function newID($conn) {
// this function returns the next primary key value for a new record to be added // assume this function is completely implemented
}
extract($_POST);
$newid = newID($conn);
$sqlInsert = (c) ; // store a SQL INSERT statement in $sqlInsert
11 2 ll s "3
IIexpress I II e x p r e s s I Isuper e>.'Press I
Line
1.
2.
(a)
(b)
3.
4.
5.
Line
1.
2.
3.
4.
5.
6.
7.

Your Order Records

";
echo "

";
Page 7 of 13
Line
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
if (
(e)
) // check if the database server fails to add a new record
// Display all order records
$sqlSelect =
(f)
; // store a SQL SELECT statement in $sqlSelect
(g)
or die(mysqli_error($conn)); // create a result set in variable $rs
$num =
(h)
; // find the number of records in the result set $rs
?>

31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44. (k) ; // release the memory used by the result set 45.
46. 47. 48. 49. 50. 51. 52. 53. 54. 55.

EOD;
echo $rowCode;
} // end of while-loop mysqli_close($conn);
?>

Product $productid, total order quantity = $total