How to use php and sql to check if values match the ones in a table (for logins)

Posted on 16th Feb 2014 07:03 pm by admin

How would I code it that the script takes two variables that are passed to it (UserID and PIN), and checks the table to see if the PIN matches the one in the table. If it does it should assign the value "1" to a variable, if not a value "2".

This variable should then be passed back to the original calling script. (In a different PHP file).

What I have so far is:
$ID = $_SERVER["argv"][1];
$ID = trim($ID);
$ID = ltrim($ID);

$PIN = $_SERVER["argv"][2];
$PIN = trim($STATUS);
$PIN = ltrim($STATUS);

$link = mysql_connect("localhost", "root", "passw0rd")
or die("Data base connection failed");
mysql_select_db("test")
or die("data base open failed");

I dont know the sql command to compare if the value passed on matches the current record.

Thanks

Your Answer:

Login to answer

Other forums

send message to the java application
Oracle 10g with Windows platform.

I have a java application that periodically pings the d

FTP Programs
Here is a list of commonly suggested FTP Programs to use:

FileZilla
SmartFTP
CuteFTP

Undefined offset
The following script checks to see if the user answer matches the correct answer.

Form Fiel

Check Digits and extracting digits
I think I can figure out the code for this but I am having a very hard time getting past the first s

php call servlet
I have done a php backup application .
So there is a form that user pick some files to zip and d

Display last record first.
I need some help how put the last record first and first record last.

Thanks

Code: &am

Checkbox info wont include in Mailto
Hey, im new to php.
Basically I have made a form to request which type of job(s) are needed, whic

array empty
Hiya peeps,

Ok here is the codes.

order.php

Code:

Confused with Loop
guys, i got confused with Looping...this is the case

I have 3 stocks, let say "Stock A&q

Coefficient of a Restitution Hints
Hello. I was wondering if anyone can give me hints on how to write this program...

The coeffi