图书信息管理系统PhP代码总结

图书信息管理系统是一个用于管理图书信息的系统，它可以包括图书的添加、删除、修改和查询等功能。以下是一个简单的PHP代码示例，用于实现图书信息管理系统的基本功能：

```php

// 连接数据库

$servername = "localhost";

$username = "username";

$password = "password";

$dbname = "myDB";

try {

$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

// 设置PDO错误模式为异常

$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

} catch(PDOException $e) {

echo "Connection failed: " . $e->getMessage();

}

// 创建表格

$sql = "CREATE TABLE IF NOT EXISTS books (

id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

title VARCHAR(255) NOT NULL,

author VARCHAR(255) NOT NULL,

publisher VARCHAR(255),

publication_date DATETIME DEFAULT CURRENT_TIMESTAMP,

ISBN VARCHAR(13),

price DECIMAL(10,2)

)";

if ($conn->exec($sql)) {

echo "Table book created successfully.";

} else {

echo "Error creating table.";

}

// 添加图书信息

$sql = "INSERT INTO books (title, author, publisher, publication_date, ISBN, price) VALUES (?, ?, ?, ?, ?, ?)";

$stmt = $conn->prepare($sql);

$stmt->execute(array('John Doe', 'Jane Smith', 'Random House', '2005-01-01', '978-0-453-23723-0', 9.99));

echo "New record created successfully";

// 查询图书信息

$sql = "SELECT * FROM books";

$stmt = $conn->query($sql);

while($row = $stmt->fetch()){

echo "ID: " . $row["id"]. "
• Name: " . $row["title"]. " - Author: " . $row["author"]. " - Publisher: " . $row["publisher"]. " - Publication Date: " . $row["publication_date"]. " - ISBN: " . $row["ISBN"]. " - Price: " . $row["price"]. "
  ";

}

// 删除图书信息

$sql = "DELETE FROM books WHERE id = ?";

$stmt = $conn->prepare($sql);

$stmt->execute(array(1));

echo "Record deleted successfully";

// 更新图书信息

$sql = "UPDATE books SET title = ?, author = ?, publisher = ?, publication_date = ?, ISBN = ?, price = ? WHERE id = ?";

$stmt = $conn->prepare($sql);

$stmt->execute(array('New Book', 'New Author', 'New Publisher', '2005-02-01', '978-0-453-23724-0', 10.99, 1));

echo "Record updated successfully";

// 删除所有记录

$sql = "DELETE FROM books";

$stmt = $conn->prepare($sql);

$stmt->execute();

echo "All records deleted successfully";

$conn->close();

?>

```

这个示例中的代码首先连接到数据库，然后创建一个名为"books"的表来存储图书信息。接下来，它使用预编译的SQL语句插入、查询、删除和更新图书信息。最后，它关闭数据库连接。