我们可以在php中使用和操纵mysql数据和google spreadsheet吗？

$servername = "数据库服务器地址";
$username = "用户名";
$password = "密码";
$dbname = "数据库名";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

$sql = "SELECT * FROM 表名";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        // 处理查询结果
    }
} else {
    echo "0 结果";
}

$conn->close();

require_once 'vendor/autoload.php';

$client = new Google_Client();
$client->setApplicationName('Google Sheets API PHP');
$client->setScopes([Google_Service_Sheets::SPREADSHEETS]);
$client->setAuthConfig('path/to/client_secret.json');
$service = new Google_Service_Sheets($client);

$spreadsheetId = 'Google Spreadsheet的ID';
$range = 'Sheet1!A1:B2';

$response = $service->spreadsheets_values->get($spreadsheetId, $range);
$values = $response->getValues();

if (empty($values)) {
    echo 'No data found.';
} else {
    foreach ($values as $row) {
        // 处理读取到的数据
    }
}

// 写入数据
$values = [
    ['Data 1', 'Data 2'],
    ['Data 3', 'Data 4'],
];
$body = new Google_Service_Sheets_ValueRange([
    'values' => $values
]);
$params = [
    'valueInputOption' => 'RAW'
];
$result = $service->spreadsheets_values->update($spreadsheetId, $range, $body, $params);