Few Options to avoid this - Sanitize the input - Use prepared statement - Dont just Return true and false have an object return which can be checked before completing the circuit ORM is a good option but it is always not the answer when you are writing a backend in something like Go or C# its always good to understand why and how these problems can be avoided rather than just plain out ootb solutions
Solution: Use Body validation... Avoid special characters, and allow few
The easiest way to avoid this would be to not accept special characters. If you are just a student you can start there.
1st make credentials as encrypted (This make any sql injection to another shape) and then send data through response body (This makes data hidden through out the API)..
Prepared statements, parameterized queries used in those old php days. Today ORM is the solution in python and node, in Java spring JPA.
Just use the hash package. Or my solution is to create two modules 1) base64encode 2)base64decode Then make them a perfect encryptor with a random tokenization method and more layers. then receive the input values as encrypted, then SQL it then if matched decrypt them and show or store the state., When creating an account, make sure you encrypt values and store them in a table or database. That's easy, right?
If we use laravel then we can use htmlspecialchar function that filter the data if user enter any html data or any query then it will filter it and don't allow that
To say this in simple terms. Some tutorials teaches entire software engineering
That's why you should use body validation schemas
Esi liye mai login with Google use karta huu 😂😂😂😂 apne websites mai
bhai tu avi bhi 2020 mai jee rha 😅😅
Me follow kar chuka ho ,,,next video kab upload karogay
Sahchi abhi pata Chala, mein try karon gi
use parameterized query , removes special character using regex , input type checking , also remote access limitation( server accessible by only a certain host )
10 saal purana hacking technic... Ab to koi v esi mistake nhi karta...😅😅
If you are running direct SQL queries based on user input, you have bigger things to worry about
That's why in java Preparedstatement if using JDBC , else if using ORM , you don't even write queries :)
Thats why i use nosql
Road blocks, authentication, is one..
@MHGAMERZ369