Question $2$

$[17$ marks$]$

$($a$)$ The process of orenting a web service using PHP typically involves the following $5$ koy stops. Following these key steps, we can create a web service using PHP that meets requirements and provides a reliable and efficient means of communication between different systems or applications. Give$/$Explain the detail description of each step:

$[5$ marks$]$

$\backslash$table$[[$Step$,$Description$],[1.$ Designing the API,$],[\backslash$table$[[2.$ Setting up the$],[$Development$],[$Environment$]],],[\backslash$table$[[3.$ Implementing the$],[$Service$]],-],[\backslash$table$[[4.$ Testing and$],[$Debugging$]],\backslash$table$[[$Prepare the web service for deployment to a production environment.$],[$Create comprehensive documentation that explains the API endpoints,$],[$request$/$response formats, authentication requirements, and any$],[$additional guidelines for developers who will use the service$]]],[5.,]]$

$($b$)$ Tho following PII codo is intonded to procoss data from a clicnt$-$side application,

process it$,$ and store it into a databnso table. Pill in tho blank to complete the code. Do

not rowrito the ontire code. Instead, provide the correct statements for $(i-$vi$)$ in your

answer

prepare $($$sq$1)$;

$stmt$->$bind$\_$param

$(11$i $)$;

$//$ Execute the prepared statement

if $($$stmt$->$execute $())($

$//$ User data successfully inserted into the database

$response $=$ array $("$success$"=>$ true, "message" $=>$ "User data stored

in the database."$)$;

$\}$ else $1$

$//$ An error occurred while inserting the data

$response $=$

$iv{?}_{(})$

;

$1$

$//$ close the database connection

Sstrmt$->$close $()$;

$conn$->$close $()$;

r

$//$ Return the JSON response

header $(\text{'}$ Content$-$Type

echo joon$\_$encode $($

vi

I;

$($c$)$ The PHP code provided bolow serves a GITT request to retricve all user records from a

database table and roturns tho usors as JSON. Fill in the blank to complete the code. Do

not rewrite tho entire code. Instend, provide the correct statements for $(i-$ix$)$ in your

answer

$[6$ marks$]$

K$?$php

$//$ Assume a complete code for establishing a database connection here

if $(i_{?}[\text{'}$REQUEST$\_$METHOD'$]mm\text{'}11\text{'})($

$//$ Fetch all users

$connection $=$ $db$\_$connect $()$:

$statement $=$ $connection.query $("$SELECT $*$ FROM user"$)$;

$users $=$ $statement.fetchAll $($PDO:FETCH$\_$ASSOC$)$ ;

if $(1$ ii