$dsn = 'mysql:host=localhost;dbname=ltid';
$username = 'root';
$password = '';
$options = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);

try {
$db = new PDO($dsn, $username, $password, $options);
} catch (PDOException $e) {
$error_message = $e->getMessage();

}

header("Content-type: text/csv");
header("Content-Disposition: attachment; filename=LTID-RLBET.csv");
header("Pragma: no-cache");
header("Expires: 0");

$query = "SELECT * FROM rlbet";
try {
   $statement = $db->prepare($query);
   $statement->execute();
   $results = $statement->fetchAll();
   $statement->closeCursor();

   $content = '';
   $title = '';
   foreach ($results as $rs){
      $content .= stripslashes($rs["ID"]). ',';
       $content .= stripslashes($rs["Lot_Number"]). ',';
       $content .= stripslashes($rs["Survey_Number"]). ',';
       $content .= stripslashes($rs["Project_Number"]). ',';
       $content .= "n";
    }
    $title .= "ID,Lot_Number,Survey_Number,Project_Number"."n";

    echo $title;
    echo $content;

   } catch (PDOException $e) {
   echo $e->getMessage();
   exit;
   }