从各种格式中选择最好的php / mysql语法？

I come across with various type of format, here are them

mysqli_query($con,"UPDATE Persons SET Age=36
WHERE FirstName='Peter' AND LastName='Griffin'");

and

SELECT ALL FROM users WHERE user_id=:user_id

..and about mysql_query, it works without the $con parameter, explain? thanks

it works without the $con parameter, explain?

The former code is MySQLi and the latter is a PDO Statement.

Getting started with MySQLi
Getting started with PDO

PDO vs MySQLi

mysql_query detects the last connection to a database.