图书信息管理系统PhP代码，图书信息管理系统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 Doe', 'Random Press', '2000-01-01', '978-0-321-54741-0', 9.99));

echo "New record created successfully";

// 查询数据

$sql = "SELECT * FROM books";

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

while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

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 = "UPDATE books SET title = ?, author = ?, publisher = ?, publication_date = ?, ISBN = ?, price = ? WHERE id = ?";

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

$stmt->execute(array('New Book', 'New Author', 'New Press', '2001-01-01', '978-0-321-54742-0', 10.99, 1));

echo "Record updated successfully";

// 删除数据

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

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

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

echo "Record deleted successfully";

$conn->close();

?>

```

这个代码首先创建了一个名为"books"的表，然后插入了一些数据，接着查询了所有的数据，最后更新和删除了一些数据。