Read And Write csv file using PHP

<?php


print_r("mula");


$servername = "localhost";
$username = "root";
$password = "pass1234";
$dbname = "report";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}




$row = 1;
if (($handle = fopen(__DIR__.'\read.csv', 'r')) !== FALSE) {
    $fp = fopen(__DIR__.'\write.csv', 'a');
    while (($data = fgetcsv($handle, 100000, "|")) !== FALSE) {
        $num = count($data);
        

        
        if($row > 1){

           
            $email = $data[4] ; 
            $sql = "SELECT * FROM wp_posts a LEFT JOIN wp_postmeta b ON b.post_id = a.ID where 
            a.post_status NOT IN ('trash','wc-cancelled','wc-completed','wc-rejected') 
            AND a.post_type = 'shop_order' 
            AND b.meta_key = '_billing_email'
            AND b.meta_value = '{$email}'
            ";
            $result = $conn->query($sql);
            $row = $result->fetch_assoc();
            if($row){
                print_r("<pre>") ;print_r($row) ; 
                print_r("<pre>") ;print_r($data) ; 
                echo $row['meta_value']."<br>";
            }
            


        }

        $template[] = 'senarai_mertua' ;
        $template[] = 'wp_capabilities' ;
        $template[] = 'User Role' ;
        $template[] = 'User Pass' ;

        
        $fields = array() ;
        $fields = $template; 
        fputcsv($fp, $fields, "|");
					



        $row++;
       
    }
    fclose($fp);
    fclose($handle);
}


$conn->close();



print_r("tamat");
exit();


?>