How to protect site from deleting database of php my admin?

Question

Hi friend I want to protect my website from deleting my databases from attacking to php my admin of my host and detele all my databases for example write delete * from database name  so could you please how can I protect my databases in php?

Vivek Kumar · Answer

Have a look into the below links. https://blogs.msdn.microsoft.com/brian_swan/2010/03/04/whats-the-right-way-to-prevent-sql-injection-in-php-scripts/ http://php.net/manual/en/security.database.sql-injection.php https://paragonie.com/blog/2015/05/preventing-sql-injection-in-php-applications-easy-and-definitive-guide https://www.phpjabbers.com/how-to-prevent-sql-injection-with-php-php71.html

Bryian Tan · Answer

I'm assuming there are SQL injection vulnerability? http://www.wikihow.com/Prevent-SQL-Injection-in-PHP

Joe Wilson · Answer

Hi I mean I want to protect my website database from inserting some query which remove all the data of the databases.

Kesavan Krishnan · Answer

Try to create two users one user for super admin with all access and another user with only select insert Alter.

Bryian Tan · Answer

how the attack happen? through the application?