?
Sanitizing Inputs , .
SQL Injection, , / . , , .
SELECT * FROM `users` WHERE `username`='$user' AND `pass`='$pass'
$user $pass - , .
, - :
username -> admin' AND 1=1 OR 1='1
password -> pass
:
SELECT * FROM `users` WHERE `username`='admin' AND 1=1 OR 1='1' AND `pass`='pass'
admin admin.
, :
SELECT * FROM `users` WHERE `username`='admin\' AND 1=1 OR 1=\'1' AND `pass`='pass'
, .
Validation
- , , .
, Android IOS , . , , , .
ANDROID & IOS n, ANDROID & IOS.
Express API?
, , API , . , - . (: wink:)
Joi - , Express?
Joi
validate(value, schema, {escapeHtml: true}, [callback])