<?php
//export.php
require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

$connect = mysqli_connect("localhost", "root", "", "admin");
$connect->set_charset("utf8");
$output = '';
if(isset($_POST["export"]))
{
$query = "SELECT * FROM data";
$result = mysqli_query($connect, $query);
if(mysqli_num_rows($result) > 0)
{


$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Ad Soyad');
$sheet->setCellValue('B1', 'Telefon Numarası');
$sheet->setCellValue('C1', 'Yaş');
$sheet->setCellValue('D1', 'Meslek');
$sheet->setCellValue('E1', 'İl');
$sheet->setCellValue('F1', 'İp Adresi');
$counter = 1;
while($row = mysqli_fetch_array($result))
{
$counter ++;
$sheet->setCellValue('A'.$counter, $row["adsoyad"]);
$sheet->setCellValue('B'.$counter, $row["tel"]);
$sheet->setCellValue('C'.$counter, $row["yas"]);
$sheet->setCellValue('D'.$counter, $row["meslek"]);
$sheet->setCellValue('E'.$counter, $row["il"]);
$sheet->setCellValue('F'.$counter, $row["ipAdress"]);
}
$writer = new Xlsx($spreadsheet);
$writer->save('hello world.xlsx');
}
}
?>