pdo连接数据库MySQL

$dsn = 'mysql:host=localhost;dbname=mydatabase';
$username = 'myusername';
$password = 'mypassword';
try {
    $pdo = new PDO($dsn, $username, $password);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

// 查询数据
$stmt = $pdo->query('SELECT * FROM mytable');
while ($row = $stmt->fetch()) {
    echo $row['column1'] . ' ' . $row['column2'];
}

// 插入数据
$affectedRows = $pdo->exec("INSERT INTO mytable (column1, column2) VALUES ('value1', 'value2')");
echo 'Affected rows: ' . $affectedRows;

$stmt = $pdo->prepare('SELECT * FROM mytable WHERE column1 = :value');
$stmt->bindParam(':value', $value);
$stmt->execute();
$result = $stmt->fetchAll();

try {
    // 连接数据库和执行SQL语句的代码
} catch (PDOException $e) {
    echo 'Error: ' . $e->getMessage();
}