Computer Science · May / June 2023 · Paper 2 SL · Question 8
Adapt for 2027Only part (a)(i) on the SQL INSERT statement is on the syllabus (A3.3.3); CGI, search engine optimisation, web crawlers and the deep web are no longer taught.
IBCS
As printed in the paper
The question as text
8. Below is a fragment of the code from a web page. $sql = "INSERT INTO GuestsTable (FirstName,Surname,Email,Cellphone) VALUES('Sonia','Smith','sonia@smith.com','+61231456789')"; if ($conn->query($sql) === TRUE) { echo "New record created successfully"; } else { Echo "Error.".$sql."<br>".$conn->error; }
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
8(a)(i)[3]
8(a)(ii)[3]
8(b)(i)[2]
8(b)(ii)[4]
8(c)[3]
8(d)[4]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.