Advertisement
Guest User

asdfasdfasfddsf

a guest
Oct 15th, 2016
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. <?php
  2. date_default_timezone_set('Pacific/Honolulu');
  3.  
  4. $sqlHost = 'localhost';
  5. $sqlUser = 'ckjk_muser';
  6. $sqlPass = '22044009';
  7. $sqlDatabase = 'ckjk_midterm';
  8.  
  9.  
  10. $conn = mysql_connect($sqlHost, $sqlUser, $sqlPass)
  11. or die("Couldn't connect to MySQL server on $sqlHost: " . mysql_error() . '.');
  12.  
  13. $db = mysql_select_db($sqlDatabase, $conn)
  14. or die("Couldn't select database $sqlDatabase: " . mysql_error() . '.');
  15.  
  16. $VID=$_REQUEST['VID']*1;
  17.  
  18. $sql = "SELECT VID, Name, PFTV, PERM_ABS, MailAddress, MailCity, MailState, MailZip FROM KAKAINA_ST WHERE VID = $VID";
  19.  
  20. $sqlTable = mysql_query($sql, $conn) or die("Couldn't perform query $sql ("._LINE_."): " . mysql_error() . '.');
  21.  
  22. $output='';
  23.  
  24. while($sqlRecord = mysql_fetch_assoc($sqlTable))
  25. {
  26.  
  27. $output .= '"'.$sqlRecord['VID'].'","'.$sqlRecord['Name'].'","'.$sqlRecord['PFTV'].'","'.$sqlRecord['PERM_ABS'].'","'.$sqlRecord['MailAddress'].'","'.$sqlRecord['MailCity'].'","'.$sqlRecord['MailState'].'","'.$sqlRecord['MailZip'].'"'."\n";
  28. }
  29.  
  30. header('Content-type: application/csv');
  31. header('Content-Disposition: attachment; filename=mail_addresses.csv');
  32. echo $output;
  33.  
  34. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement