PHP ?? ?? ??? ?? ??
?? ??? ??
sql ?
1. sql ?? ??? ?????. = or ???? ??? ? ????! = ?? LINK ?? NOT LINK ???? ?????.
2. MYSQL? ? ?? ????? ??? ?????. %? ?? ??(0 ??)? ?????.
_? ?? ??? ?????.
3 ?? ??? ??? ???? ?? ?? SQL ?? ??? ?????. ?? 2? ????? ?? ? ???? ??? ?? ??? = ??! =
sql ?? ??
#?? ??? ???? ??? ??
l ??? ???? ??? ??
1%
select*from user where username like 'l%';
#?? ??? ??? ??? ??
?? e? ??? ??? ?? with
%e
select*from user where username like '%e';
# ?? ??? ??? ??? ??
??? ??? '0' ??? ??? ??? ??
%o%
select*from user where username like '%o%';
??? ??? 3
? ??? ??____
select*from user where username like '___';
? ?? ????? ??
? ?? ??? o
_O%
select*from user where username like '_O%';
? ???? ?????. ?? ?? ?? sql ?? LIKE ?? ???? ???? ????.