php7数据库记录

在PHP7中，可以使用MySQLi或PDO扩展来连接和操作数据库。

使用MySQLi扩展的示例代码如下：

// 连接数据库
$mysqli = new mysqli('localhost', 'username', 'password', 'database');

// 检查连接是否成功
if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

// 插入记录
$sql = "INSERT INTO table_name (column1, column2, column3) VALUES ('value1', 'value2', 'value3')";
if ($mysqli->query($sql) === true) {
    echo "Record inserted successfully";
} else {
    echo "Error: " . $mysqli->error;
}

// 查询记录
$sql = "SELECT * FROM table_name";
$result = $mysqli->query($sql);

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "Column1: " . $row["column1"] . " - Column2: " . $row["column2"] . " - Column3: " . $row["column3"];
    }
} else {
    echo "No records found";
}

// 关闭连接
$mysqli->close();

使用PDO扩展的示例代码如下：

// 连接数据库
$dsn = 'mysql:host=localhost;dbname=database';
$username = 'username';
$password = 'password';

try {
    $pdo = new PDO($dsn, $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
    exit();
}

// 插入记录
$sql = "INSERT INTO table_name (column1, column2, column3) VALUES (?, ?, ?)";
$stmt = $pdo->prepare($sql);
$values = ['value1', 'value2', 'value3'];

if ($stmt->execute($values)) {
    echo "Record inserted successfully";
} else {
    echo "Error: " . $stmt->errorInfo()[2];
}

// 查询记录
$sql = "SELECT * FROM table_name";
$stmt = $pdo->query($sql);

if ($stmt->rowCount() > 0) {
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        echo "Column1: " . $row["column1"] . " - Column2: " . $row["column2"] . " - Column3: " . $row["column3"];
    }
} else {
    echo "No records found";
}

// 关闭连接
$pdo = null;

这些示例代码演示了如何连接数据库、插入记录和查询记录。你可以根据自己的需求进行修改和扩展。