kjc
09-30-2002, 12:10 PM
I have created an ecommerce site which accepts credit cards. They are encrypted into MySQL using the password function.
I am now designing an admin interace for my client, and I need to be able to display the credit card information on a secure page which he views. I am having trouble decrypting the card number though. Any ideas...
The code I am using to insert is
$query="insert into payment_details values
('','$Customer_ID','','$total_price','$delivery','$final_price','$card_name',password('card_number') , '$card_start_month','$card_start_year','$card_expiry_month','$card_expiry_year','$card_type','$card_ issue')";
$result=mysql_query($query);
Probably be a simple solution
I am now designing an admin interace for my client, and I need to be able to display the credit card information on a secure page which he views. I am having trouble decrypting the card number though. Any ideas...
The code I am using to insert is
$query="insert into payment_details values
('','$Customer_ID','','$total_price','$delivery','$final_price','$card_name',password('card_number') , '$card_start_month','$card_start_year','$card_expiry_month','$card_expiry_year','$card_type','$card_ issue')";
$result=mysql_query($query);
Probably be a simple solution