SKILL TEST

Question 1 of 30

1. Question

1 points

What is the best practice for running MySQL queries in PHP? Consider the risk of SQL injection.

Use mysql_query() and variables: for example: $input = $_POST[‘user_input’]; mysql_query(“INSERT INTO table (column) VALUES (‘” . $input . “‘)”);
Use PDO prepared statements and parameterized queries: for example: $input= $_POST[“user-input”] $stmt = $pdo->prepare(‘INSERT INTO table (column) VALUES (“:input”); $stmt->execute(array(‘:input’ => $input));
Use mysql_query() and string escaped variables: for example: $input= $_POST[“user-input”] $input_safe = mysql_real_escape_string($input); mysql_query(“INSERT INTO table (column) VALUES (‘” . $input. “‘)”);
Use mysql_query() and variables with a blacklisting check: for example: $blacklist = array(“DROP”,”INSERT”,”DELETE”); $input= $_POST[“user-input”] if (!$array_search($blacklist))) mysql_query(“INSERT INTO table (column) VALUES (‘” . $input. “‘)”);

Question 2 of 30

2. Question

1 points

Which of the following methods should be used for sending an email using the variables $to, $subject, and $body

mail($to,$subject,$body)
sendmail($to,$subject,$body)
mail(to,subject,body)
sendmail(to,subject,body)

Question 3 of 30

3. Question

1 points

Which of the following is used to maintain the value of a variable over different pages?

static
global
session_register()
None of these

Question 4 of 30

4. Question

1 points

Which of the following will check if a function exists?

function_exists()
has_function()
$a = “function to check”; if ($a ()) // then function exists
None of these

Question 5 of 30

5. Question

1 points

Which of the following is not a file-related function in PHP?

fclose
fopen
fwrite
fappend

Question 6 of 30

6. Question

1 points

Which of the following is true about the singleton design pattern?

A singleton pattern means that a class will only have a single method
A singleton pattern means that a class can have only one instance object.
A singleton pattern means that a class has only a single member variable.
Singletons cannot be implemented in PHP.

Question 7 of 30

7. Question

1 points

Which of the following characters are taken care of by htmlspecialchars?

<
>
Single quote
Double quote
All of these

Question 8 of 30

8. Question

1 points

Which of the following will read an object into an array variable?

$array_variable = get_object_vars($object);
$array_variable = (array)$object;
$array_variable = array $object;
$array_variable = g

HTML

Quiz-summary

Information

Results

Categories

PHP

Quiz-summary

Information

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

Average score
Your score