Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- date_default_timezone_set('Pacific/Honolulu');
- $sqlHost = 'localhost';
- $sqlUser = 'ckjk_muser';
- $sqlPass = '22044009';
- $sqlDatabase = 'ckjk_midterm';
- $conn = mysql_connect($sqlHost, $sqlUser, $sqlPass)
- or die("Couldn't connect to MySQL server on $sqlHost: " . mysql_error() . '.');
- $db = mysql_select_db($sqlDatabase, $conn)
- or die("Couldn't select database $sqlDatabase: " . mysql_error() . '.');
- $VID=$_REQUEST['VID']*1;
- $sql = "SELECT VID, Name, PFTV, PERM_ABS, MailAddress, MailCity, MailState, MailZip FROM KAKAINA_ST WHERE VID = $VID";
- $sqlTable = mysql_query($sql, $conn) or die("Couldn't perform query $sql ("._LINE_."): " . mysql_error() . '.');
- $output='';
- while($sqlRecord = mysql_fetch_assoc($sqlTable))
- {
- $output .= '"'.$sqlRecord['VID'].'","'.$sqlRecord['Name'].'","'.$sqlRecord['PFTV'].'","'.$sqlRecord['PERM_ABS'].'","'.$sqlRecord['MailAddress'].'","'.$sqlRecord['MailCity'].'","'.$sqlRecord['MailState'].'","'.$sqlRecord['MailZip'].'"'."\n";
- }
- header('Content-type: application/csv');
- header('Content-Disposition: attachment; filename=mail_addresses.csv');
- echo $output;
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement