What is the preprocessing statement of php PDO

This article mainly explains "php PDO's preprocessing statement is what", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's take a small series to take you to learn "what is the preprocessing statement of php PDO"!

1. Position parameters

Use the bindParam() function instead of providing values directly.

$tis = $conn->prepare("INSERT INTO STUDENTS(name, age) values(?, ?) ");$tis->bindValue(1,'mike');$tis->bindValue(2,22);$tis->execute();

2. Named parameters

Named parameters are also preprocessed sentences that map values/variables to named locations in the query. Because there is no positional binding, it works well in queries that use the same variable multiple times.

$name='Rishabh'; $age=20;$tis = $conn->prepare("INSERT INTO STUDENTS(name, age) values(?, ?) ");$tis->bindParam(1,$name);$tis->bindParam(2,$age);$tis->execute();php frames What php frames are there:

Laravel is a free and open source PHP application framework.

Phalcon is one of the fastest PHP frameworks.

Symfony is a PHP framework for Web projects.

Yii is a fast, secure and professional PHP framework.

CodeIgniter is a very agile open source PHP framework.

CakePHP is an old PHP framework.

Kohana is an agile but powerful PHP framework.

At this point, I believe that we have a deeper understanding of "php PDO's preprocessing statement is what", may wish to actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!