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(...
-
78pages
Written in2024/2025
Topscorer
$14.89
-sold
Want to regain your expenses?
How much did you already spend on Stuvia? Imagine there are plenty more of you out there paying for study notes, but this time YOU are the seller. Ka-ching!