Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

Insert operation of PHP PDO database class

WBOY
Release： 2016-07-25 08:54:33
Original
1297 people have browsed it

  3. //Data insertion

  4. //Prepare SQL statement
  5. $sql = "INSERT INTO `test`(`name`) VALUES (:name)";

  6. //Call the prepare method to prepare to query bbs.it-home.org

  7. $stmt = $pdo->prepare($sql);

  8. //Pass a The array binds values ​​to the named parameters in the preprocessed query and executes SQL

  9. $stmt->execute(array(':name' => '王五'));

  10. //Get the ID value of the last inserted data

  11. echo $pdo->lastInsertId() . '
    ';

Copy code


Related labels：
PHP PDO数据库类的insert操作
source：php.cn
Previous article：php custom array function array_column Next article：php recursive example php recursive function code
Statement of this Website
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
Latest Articles by Author
Latest Issues
Building an application using MongoDb and Laravel 8.83 I'm a beginner in php and Laravel, I'm trying to build this simple CRUD application using ...
From 2024-03-31 22:18:53
0
1
313
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template