How to save data from MySQL database to excel using php?

Question

PHP

Wrote a simple script:

<?php
header('Content-Type: text/html; charset=utf-8');
$host='localhost';
$database='lalala';
$user='lalala_user';
$pswd='12345';
 
$dbh = mysql_connect($host, $user, $pswd) or die("Не могу соединиться с MySQL.");
mysql_select_db($database) or die("Не могу подключиться к базе.");

$query = "SELECT * FROM `oc_product`";
$res = mysql_query($query);

while($row = mysql_fetch_array($res)){
  echo "Номер: ".$row['product_id']."<br>\n";
  echo "Модель: ".$row['model']."<br>\n";
  echo "Артикул: ".$row['sku']."<br>\n";
  echo "Цена: ".$row['price']."<br>\n";
  echo "Картинка: ".$row['image']."<br>\n";
  echo "Производитель(id): ".$row['manufacturer_id']."<br><hr>\n";
}

mysql_close($dbh);
?>

But it simply displays this data on the screen, but it needs to be saved to an Excel table, preferably in the .xls format, or at least .csv.

Answer 1

https://habrahabr.ru/post/245233/

Answer 2

fputcsv

Answer 3

https://phpspreadsheet.readthedocs.io/en/develop/