Questions about databases in PHP

PHP Database

This is the database I built.

What I want to do is: the front-desk customer enters the user name (username) and password (password), then I go to user_table table, find and username matching items, if not, then return, if any, then compare the password match.

Trouble writing pseudo-code;

Reply to discussion (solution)

As long as the use of SQL for the pair is good, for example:

SELECT Count (*) user_table WHERE username= ' user name ' and password= ' password ' LIMIT 1

If the return is 1 at this point, it means that it has been matched and the user name or password is incorrect.

The upstairs has already said

As long as the use of SQL for the pair is good, for example:

SELECT Count (*) user_table WHERE username= ' user name ' and password= ' password ' LIMIT 1

If the return is 1 at this point, it means that it has been matched and the user name or password is incorrect.
It's missing a from.
Select COUNT (*) from user_table where username= "username" and password= "password"

As long as the use of SQL for the pair is good, for example:

SELECT Count (*) user_table WHERE username= ' user name ' and password= ' password ' LIMIT 1

If the return is 1 at this point, it means that it has been matched and the user name or password is incorrect.
What is this, a compiler? I'm using Notepad Plus.

As long as the use of SQL for the pair is good, for example:

SELECT Count (*) user_table WHERE username= ' user name ' and password= ' password ' LIMIT 1

If the return is 1 at this point, it means that it has been matched and the user name or password is incorrect.
What is this, a compiler? I'm using Notepad Plus.

This is Csdn's own bar ...

