Login Authentication Query

Login Authentication

The Safe Query

-- use a prepared statement (? placeholder)
SELECT id, name, password
FROM users
WHERE email = ?;

Verify the Password in Code

Summary

• Query by email with a prepared statement, then verify the hashed password in code.
• Never concatenate user input into the query.

Login Authentication

Safe Query

-- prepared statement use करें (? placeholder)
SELECT id, name, password
FROM users
WHERE email = ?;

Password Code में Verify करें

सारांश

• Email से prepared statement द्वारा query करें, फिर hashed password code में verify करें।
• User input को query में कभी concatenate न करें।