[سؤال] لخبراء ال PHP سؤال بخصوصExport

PHP كود :

<?php  
$connect = mysqli_connect("localhost", "AA", "2", "AAS");   
$query ="SELECT * FROM log ORDER BY timek desc";  
$result = mysqli_query($connect, $query);  
?>  
<!DOCTYPE html>  
<html>  
     <head>  
          <title>Webslesson Tutorial | Export Mysql Table Data to TXT file in PHP</title>  
          <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>  
          <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />  
          <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>  
     </head>  
     <body>  
          <br /><br />  
          <div class="container" style="width:900px;">  
               <h2 align="center">Export Mysql Table Data to CSV or TXT file in PHP</h2>  
               <h3 align="center">Employee Data</h3>                 
               <br />  
               <form method="post" action="csvexport.php" align="center">  
                    <input type="submit" name="csvexport" value="CSV Export" class="btn btn-success" />  
               </form>  
               </br>
               <form method="post" action="txtexport.php" align="center">  
                    <input type="submit" name="txtexport" value="TXT Export" class="btn btn-success" />  
               </form>  
               <br />  
               <div class="table-responsive" id="employee_table">
                    <table class="table table-bordered">  
                         <tr>  

<th width="5%">Qso_id</th> 
<th width="5%">CALLop</th> 
<th width="5%">qso_date</th> 
<th width="5%">timek</th> 
<th width="5%">bands</th> 


                         </tr>  
                    <?php  

                    while($row = mysqli_fetch_array($result))  
                    {
                    ?>  
                         <tr>  
<td><?php echo $row["Qso_id"]; ?></td> 
<td><?php echo $row["CALLop"]; ?></td> 
<td><?php echo $row["qso_date"]; ?></td> 
<td><?php echo $row["timek"]; ?></td> 
<td><?php echo $row["bands"]; ?></td> 

                         </tr>  
                    <?php       
                    }  
                    ?>  
                    </table>  
               </div>  
          </div>  
     </body>  
</html> 

PHP كود :

<?php  
     //csvexport.php  
    if(isset($_POST["export"]))  
    {  
        $connect = mysqli_connect("localhost", "AA", "2", "AAS"); 
        header('Content-Type: text/csv; charset=utf-8');  
        header('Content-Disposition: attachment; filename=data.csv');  
        $output = fopen("php://output", "w");  
        fputcsv($output, array('Qso_id', 'CALLop', 'qso_date', 'timek', 'bands')); 

        $query ="SELECT * FROM log ORDER BY timek desc"; 
        $result = mysqli_query($connect, $query);  
        while($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
        {  
            fputcsv($output, $row);  
        }  
        fclose($output);  
    }  
?>

PHP كود :

<?php  
     //txtexport.php  
    if(isset($_POST["export"]))  
    {  
        $connect = mysqli_connect("localhost", "AA", "2", "AAS"); 
        header('Content-Type: text/csv; charset=utf-8');  
        header('Content-Disposition: attachment; filename=data.txt');  
        $output = fopen("php://output", "w");  

        $query ="SELECT CONCAT('<CALLop:', LENGTH(CALLop), '>',CALLop, ' <qso_date:', LENGTH(qso_date), '>',qso_date, ' <timek:', LENGTH(timek), '>',timek, ' <bands:', LENGTH(bands), '>',bands, ' <eor>') AS x FROM log ORDER BY timek desc"; 
        $result = mysqli_query($connect, $query);  
        fwrite($output, 'ADIF Export from BKLOG, conforming to ADIF standard specification V 2.00'."\r\n");
        fwrite($output, '<PROGRAMID:3>LOG <PROGRAM VERSION:1>6 '."\r\n");
        fwrite($output, '<eoh>'."\r\n");
        while($row = mysqli_fetch_array($result))  
        {  
            fwrite($output, $row['x']."\r\n");
        }  
        fclose($output);  
    }  
?>