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

PHP header help!
Hi all I am trying to get this php page to refresh every 5 seconds on my phone which is an aastra 48

Hashing?
Hi, I was hoping to take a string value then convert it - consistently - across each of our pages in

Warehouse Management
Hi,

On our system, we have two storage locations ( A and B ) where A is the main factory

How to limit the calls to an API
Hello, in my simple script I call an api which effectively involves me getting an xml file.

H

php problem?
I don't think I'm stupid, but maybe I am.

I am working on a sit for a friend I am try to put

Simple MySQL query...
Hello,
How could I do a mysql query that does this: SELECT * WHERE date/time < 5minutes ag

Mouseover to edit (Ajax)
hi friends, can anyone help with the code behind to get this application working, please in VB (new

selectbox+database connection retrive problem
Code: [Select]
<tr>
<th align="left" scope="c

need to add "sizes" to shopping cart
Hey guys, I am trying to figure out a way to add a "size" selector on to this bit of code.

Operating System
How in PHP or other language can I detect Operating system, ie Windows XP Home, Windows 7 Ultimate,