CS310 Quiz 2 Solution and Discussion

[zaasmi]

_______ statement is used to create database named MyDatabase in MySQL.

CREATE DATABASE databasename;

[zaasmi]

What SQL clause is used to restrict the rows returned by a query?

[zaasmi]

Use …… to add table in the database

[zaasmi]

Which of the following PHP function is used to validate and sanitize the data?

[zaasmi]

In PHP, in order to access MySQL database you will use:

[zaasmi]

Which of the following PHP syntax is used to remove all illegal characters from a URL?

[zaasmi]

_______ statement is used to add a new record to a MySQL table

[zaasmi]

How will we retrieve the value of session variable set in the following PHP code?
$_SESSION[“color”] = “green”;

[zaasmi]

Which of the following PHP syntax is used to remove all HTML tags from a string? CS310

[zaasmi]

If we want to show all the session variable values for a user session then following code will be used.

print_r($_SESSION);