PHP Web服务mySQL查询 - 一般说明

Question

Wanting to get some clarity for the below code, I have made comments next to each line and question marks where I am need some assistance please

$sql = 'SELECT * FROM users';                    // Select all data

$query = $this -> conn -> prepare($sql);         // Connects to server and executes select all query
$query -> execute(array(':email' => $email));    // ????
$data = $query -> fetchObject();                 // Stores the results on the executed query in $data??

Answer 1

$email substitutes your ':email' with $email variable.

See examples here

In your case, since you don't have any parameter marker, you can directly execute the query without any parameter binding.

$sql = 'SELECT * FROM users';                   
$query = $this -> conn -> prepare($sql);         
$query -> execute();   
$data = $query -> fetchObject();