try { $conn = new PDO("mysql:host=$servername;dbname=db_1", $username, $password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); }catch(PDOException $e) { echo "Connection failed: " . $e->getMessage(); }$query = $conn->prepare("SELECT * FROM csv_filds order by id asc");$query->execute();$data = ""; while($row=$query->fetch(PDO::FETCH_BOTH)){ $data .= $row['id'].",".$row['Name'].",".$row['father_name'].",".$row['address']."\n";}header('Content-Type: application/csv');header('Content-Disposition: attachment; filename="csvfile.csv"');echo $data; exit();