need help i`m seeking a secure table

[niroshan]

Hi guys,
I’m going to develop a small shopping cart site using PHP and mySQL. So even though it’s small I like to have secure table structures. Because I’m trying to store credit card numbers making it very important for me to have a secure table. Normally I used myISAM tables. But I read an article stating that InnoDB tables are much secure than myISAM tables. But I really don’t understand why? (Article didn’t mention why).

Can anybody please help me with my problem? and tell me what is the different between these two tables and how can I take the advantage of InnoDB tables and why we say this InnoDB table is more secure?

What is the best table type to store secure data? And how should I store the credit card number in a database securely.
Please help me.

Thank you

[matt_4013]

Why are you actually storing the credit card number? That's a security risk that you just don't need. I'm pretty sure your users aren't going to complain about putting their CC number in everytime they want to buy something, especially if you have a FAQ page that explains your reasoning. Once you've made the transaction, you shouldn't need it again 🙂

[niroshan]

hi,
thankx Matt_4013 for replying.Yes you are right,I guss I dont want to store cc number.

But I still want to know the secure database which I can use in mySQL, If any body knows about it pls let me know. Pls explain the answers so i can get a good undestanding.

All answers are welcome and greatly appreciated.

thank you