1 results
Other
PHP Exam Answered 2024.
PHP Test 
1. What is the best practice for running MySQL queries in PHP? 
Consider the risk of SQL injection. 
Answers: 
1. Use mysql_query() and variables: for example: $input = 
$_POST[‘user_input’]; mysql_query(“INSERT INTO table (column) 
VALUES (‘” . $input . “‘)”); 
2. 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(...