Code to prevent SQL injection attacks_PHP tutorial
SQL injection attacks refer to exploiting design vulnerabilities to run Sql commands on the target server and conduct other attacks. Failure to verify the data entered by the user when dynamically generating Sql commands is the main reason why Sql injection attacks succeed. For example:
If your query statement is select * from admin where username='"&user&"' and password='"&pwd&"'"
Then, if my username is: 1' or '1' ='1
Then, your query statement will become:
select * from admin where username='1 or '1'='1' and password='"&pwd&"'"
Your query statement has passed, and you can enter your management interface.
Therefore, user input needs to be checked when taking precautions. Convert or filter some special characters, such as single quotes, double quotes, semicolons, commas, colons, connection numbers, etc.
The special characters and strings that need to be filtered are:
net user
xp_cmdshell
/add
exec master.dbo.xp_cmdshell
net localgroup administrators
select
count
Asc
char
mid
'
:
"
insert
delete from
drop table
update
truncate
from
%
The following are two prevention codes I wrote about solving injection attacks for your reference!
The js version of the code to prevent SQL injection attacks~:
[CODE START]
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
SublimeText3 Chinese version
Chinese version, very easy to use
WebStorm Mac version
Useful JavaScript development tools
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver Mac version
Visual web development tools
