用PHP语言写一个在图书数据库中统计相同编著的图书个数
时间: 2024-03-13 18:43:47 浏览: 13
好的,可以使用PHP语言和MySQL数据库来实现该功能。以下是代码示例:
首先,需要连接到MySQL数据库:
```
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
```
然后,可以编写SQL查询语句来统计相同编著的图书个数:
```
$sql = "SELECT author, COUNT(*) as count FROM books GROUP BY author";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出每行数据
while($row = $result->fetch_assoc()) {
echo "编著者: " . $row["author"]. " - 图书个数: " . $row["count"]. "<br>";
}
} else {
echo "0 结果";
}
```
最后,记得关闭数据库连接:
```
$conn->close();
```
完整代码示例:
```
<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
$sql = "SELECT author, COUNT(*) as count FROM books GROUP BY author";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出每行数据
while($row = $result->fetch_assoc()) {
echo "编著者: " . $row["author"]. " - 图书个数: " . $row["count"]. "<br>";
}
} else {
echo "0 结果";
}
$conn->close();
?>
```
需要根据实际情况修改数据库连接信息和SQL查询语句。