Shulou(Shulou.com)06/02 Report--

This article mainly explains the "PHP database learning how to use PDO to execute SQL statements", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "PHP database learning how to use PDO to execute SQL statements" bar!

Exec () method

When we execute SQL statements such as INSERT, UPDATE, and DELETE that do not need to return a result set, we can use the exec () method in the PDO object. After successful execution, the result is the number of rows affected.

The syntax format of the exec () method is as follows:

PDO::exec (string $sql)

It should be noted that:

$sql is the SQL statement to be executed.

The exec () method does not get the corresponding results from the SELECT query statement.

Then we try to add a piece of data to the database through an example, as shown below:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.