bicyleman9008
IS-IT--Management
- May 19, 2005
- 30
I have a database in which the credit card information is encrpyted.
I need to export the data to spreadsheet, save on a local pc & and decrypt the encrypted fields.
Here is the encrypt and decrypt code for the CC holder's name.
The table name is "orders"
How would I export the field "cc-holdername" to a spread sheet and decrypt it at the same time?
// *****************************************************************************
// Purpose encrypts cc_holdername field ( see ORDERS_TABLE in database_structure.xml )
// Inputs
// Remarks
// Returns
function cryptCCHoldernameCrypt( $cc_holdername, $key )
{
return base64_encode( $cc_holdername );
}
// *****************************************************************************
// Purpose decrypts cc_holdername field ( see ORDERS_TABLE in database_structure.xml )
// Inputs
// Remarks
// Returns
function cryptCCHoldernameDeCrypt( $cifer, $key )
{
return base64_decode( $cifer );
}
I need to export the data to spreadsheet, save on a local pc & and decrypt the encrypted fields.
Here is the encrypt and decrypt code for the CC holder's name.
The table name is "orders"
How would I export the field "cc-holdername" to a spread sheet and decrypt it at the same time?
// *****************************************************************************
// Purpose encrypts cc_holdername field ( see ORDERS_TABLE in database_structure.xml )
// Inputs
// Remarks
// Returns
function cryptCCHoldernameCrypt( $cc_holdername, $key )
{
return base64_encode( $cc_holdername );
}
// *****************************************************************************
// Purpose decrypts cc_holdername field ( see ORDERS_TABLE in database_structure.xml )
// Inputs
// Remarks
// Returns
function cryptCCHoldernameDeCrypt( $cifer, $key )
{
return base64_decode( $cifer );
}