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

Javascript using window.location seems to lose state
Not sure what forum so let me know if I'm in the wrong place. I have a main window with a ajax grid

Is there a quick way to do this?
Hi all,

I need to create a mysql table from php that goes a little something like this

getting Vars to pass to next page.
Hello all,
I have a confusing situation on my hands, i am a member of a gaming community and we

Looking for help reading a .txt or .ini file and outputting the info.
I have a file called Info.ini and It has the following info:
Code: [General]
Online=0
I wou

Is there a way to override built in php functions without APD?
I am trying to use the
rename_function()
override_function()
options that are built into

ALV grid with 2 headers
Hi Gurus,

I need to display ALV GRID as below.

Header1

some questions
Hello,

I am looking for the answers for following questions:

1) Does PHP support overl

Add weeks in a query?
I have a SQL that summarizes the quantity per week. The weeks that has no value does not exist in th

trouble printing an array....
I'm having some trouble printing out an array forwards. I'm figuring out the high and low of an arra

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see