PHP and PDO: How to perform SQL table creation and deletion operations

PHP and PDO: How to perform SQL table creation and deletion operations

Introduction:
In web application development, creating and deleting database tables is a common task. Using PHP and PDO (PHP Data Objects) extension we can perform these operations easily. This article will introduce how to use PHP and PDO to perform SQL table creation and deletion operations, with code examples.

1. Create Table:

To create a database table, we need to use the SQL CREATE TABLE statement. First, we need to establish a connection to the database server and select the database.

<?php
// 建立数据库连接
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

// 创建表的SQL语句
$sql = "CREATE TABLE users (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    firstname VARCHAR(30) NOT NULL,
    lastname VARCHAR(30) NOT NULL,
    email VARCHAR(50),
    reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)";

// 执行SQL语句
$conn->exec($sql);
echo "表 created successfully";
?>

In the above example, we created a table named users. The table has id, firstname, lastname and email columns, and the default value of the reg_date column is set.

2. Drop Table:

To delete a database table, we need to use the SQL DROP TABLE statement. Likewise, we need to establish a connection to the database server and select the database.

<?php
// 建立数据库连接
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

// 删除表的SQL语句
$sql = "DROP TABLE users";

// 执行SQL语句
$conn->exec($sql);
echo "表 dropped successfully";
?>

In the above example, we deleted the table named users. After executing this code, the table will be permanently deleted from the database.

Conclusion:
Using PHP and PDO, we can easily perform SQL table creation and deletion operations. In actual development, we can flexibly use these operations according to specific needs to achieve the management and maintenance of database tables.

Summary: This article introduces how to use PHP and PDO to create and delete SQL tables. We learned how to establish a connection to a database server and use the CREATE TABLE statement to create a table and the DROP TABLE statement to delete a table. Through these sample codes, we can better understand and apply these operations.

Reference materials:

• PHP PDO documentation: http://php.net/manual/en/book.pdo.php

The above is the detailed content of PHP and PDO: How to perform SQL table creation and deletion operations. For more information, please follow other related articles on the PHP Chinese website!