Home  >  Article  >  Backend Development  >  Is it okay to use pdo for php?

Is it okay to use pdo for php?

(*-*)浩
(*-*)浩Original
2019-09-12 11:54:553041browse

PDO - The abbreviation of PHP Data Object (PHP Data Object), as a way to provide a unified connection interface for multiple databases, the bottom layer of PDO needs to cooperate with the PDO data driver of the corresponding database to operate the database. PDO is the database connection method officially recommended by PHP today. Its advantages are:

Is it okay to use pdo for php?

1. PDO is a truly unified interface database operation implemented at the bottom layer. Interface, no matter what kind of database is used in the backend, if the code is encapsulated, the application layer calls are basically the same. When the backend database is changed, the application layer code basically does not need to be modified. (Recommended learning:

PHP Programming from entry to proficiency)

2. PDO supports more advanced DB feature operations, such as: scheduling of stored procedures, etc., which is not supported by the mysql native library.

3. PDO is the official PECL library of PHP. Its compatibility and stability must be higher than MySQL Extension. You can directly use the pecl upgrade pdo command to upgrade.

4. PDO can prevent SQL injection and ensure that the database is more secure. The principle of PDO preventing SQL injection

After PHP 5.1.0, PDO is enabled by default. You can check the opening status of PDO through the phpinfo() function:

Is it okay to use pdo for php?PDO Preset Processing

When we use the database to execute a query, the database management system (DBMS) will compile the query and optimize the query. Using PDO preprocessing can make this process only happen when the first query is made. In subsequent identical queries, only the bound parameters need to be replaced, thus saving the time of repeated compilation. In addition, using PDO parameter binding can also avoid security issues such as SQL injection.

Code demonstration:

<?phptry{
    $dbh=new PDO(&#39;mysql:host=localhost;dbname=testDB&#39;,&#39;root&#39;,&#39;&#39;);
    $stmt=$dbh->prepare("INSERT users (user_name,sex) VALUES (:user_name,:sex)");

    $stmt->bindParam(&#39;:user_name&#39;,$name);
    $stmt->bindParam(":sex",$sex);    //插入一行
    $name="yang001";
    $sex="M";
    $stmt->execute();    //再次插入一行
    $name="yang002";
    $sex="F";
    $stmt->execute();

}catch (PDOException $e){    print "Error ! : ".$e->getMessage();    die();
}

View the database results as follows:

We use preprocessed query statements to retrieve the results: Is it okay to use pdo for php?

<?phptry{
    $dbh=new PDO(&#39;mysql:host=localhost;dbname=testDB&#39;,&#39;root&#39;,&#39;&#39;);
    $stmt=$dbh->prepare("SELECT * FROM users WHERE user_name=:user_name ");

    $stmt->bindParam(&#39;:user_name&#39;,$name);    //插入一行
    $name="yang001";    if($stmt->execute()){        while ($row=$stmt->fetch(PDO::FETCH_ASSOC)){
            print_r($row);
        }
    }


}catch (PDOException $e){    print "Error ! : ".$e->getMessage();    die();
}

The results are as follows :

##

The above is the detailed content of Is it okay to use pdo for php?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:ecshop supports phpNext article:ecshop supports php