使用PHP将mysql表导出到.txt或.doc文件

<?php
// 连接MySQL数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}

// 查询数据
$sql = "SELECT id, name, email FROM MyGuests";
$result = $conn->query($sql);

// 处理数据
if ($result->num_rows > 0) {
  $output = fopen("myfile.txt", "w") or die("Unable to open file!");
  while($row = $result->fetch_assoc()) {
    $line = implode(",", $row) . "\n";
    fwrite($output, $line);
  }
  fclose($output);
  echo "Data exported to myfile.txt";
} else {
  echo "0 results";
}
$conn->close();
?>