so I have set up a database and established a connection. Up until here I know everything.
The issue is:
I can’t seem to figure out how I can for example if somebody types in a password and a username how to check if these two were given together.
like in a row: User:John Pswd:Smith
If somebody types in U:John and then Pswd:Smith that it is validated as right but
U:John Pswd:John as wrong.
Can someone please help me? How to update certain info on like a profile page to select the right person would be nice too.
// terrible query, but just to give you an idea
// DON'T USE THIS, its not secure (SQL injection)
"SELECT * FROM table WHERE User = ".$username." AND Pswd = ".$password
the WHERE clause can also be used for profile pages
now, i haven’t used PHP in ages, you will have to check how to make the code i provided secure.
just look into what WHERE and AND do, that should help you further