I have just built a custom coded opencart-based ecommerce site. I have several registration forms on the site for different types of users and I am saving their info in the database which is also used by a custom Customer Relationship Management system I have built in OpenCart (to track user purchases and behaviour on the website).
What I am worried about is that the data related to all my users is in text format in the database - if I open the db in a text editor or in phpmyadmin I can read anything I want. How do I encrypt this data in the database so that even if there were to be a hack attempt, this data would be safe.
By the way I already have an EV SSL Certificate installed on the website so traffic itself should be protected from prying eyes. My concerns are purely database related.
thanks in advance