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).

Did you know?Explore Trending and Topic pages for more stories like this.

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

Trending TodaySee what people are reading

No comments posted yet

Your Answer:

Login to answer

227

52

Other forums

Gantt Chart Tool
Does anyone know of a good free gantt chart creator tool

Thanks

Multiple WHILE loops help
Hi there. I'm writing an application that is pulling and displaying results for real estate listing

What is SAP Avatar ?
Hi All,

This G.Satish , my boss asked me to explore on SAP Avatar. I searced in internet

Array becomes unset by itself?
Hi,

I have a bit of experience with PHP but not extensive. It seems I cannot store any items

user administration
Dear @all,

what I have to do to set the user defaults for new users. At the moment I woul

IF STATEMENT HELP
Hi
i have created a calendar from a table:

Code: Calendar: October 2009
<table w

formating when pulling data from a mysql database
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I

please hep to get values from a table row
can anyone tel me how I can select and get data from one row by pressing an Edit button in that row

Simple Question
I know this is a simple question, that if I knew what it was technically called i could probably loo

Why does my php page download images over and over
Can anybody please explain to me why my php page keeps downloading the images and other items every

Sign up now if you have flare of writing..

Login | Register

Indyaspeak

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

Your Answer:

Other forums

Follow Us