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

Create a form of 2 numbers input and find the greatest.
Hi, everybody.

I have a homework in my training of php, which ask you to make a form that ask

empty() error
Why does

Code: empty($USER_ID = $_SESSION["USER_ID"])
create this error...

show the direct link into href
I want to display link on the page. i am fetching the data(URL) from database,actually before that i

Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba

Is it possible to stop reservation creation in PM Order?
Hi All,

Is it possible to stop reservation creation in PM Order?

Thanks in adv

Echo Tweaking help!
HI. I would like to have the output of the entered variables repeat forever, but it's stopping at th

Upload Code Help
Hi everyone I need some help with a bit of code ive been working with for a while. I am completely s

Gerenate tabel in Php
I whant to generate a tabel takeing data from database like this one so the results to be display on

Delete Client 066 Earlywatch
Hi all,

in former times client earlywatch was required for SAPs remote access to SAP inst

Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.

I