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

SAP Management Console is blank
Dear All ,

I am facing problem in my des sever suddely in SAP Management Console is blank and

What's wrong with my code
sobbing for many days, still don't know why please Help. Why my page isn't posted correctly. In a

Wierd echo error?
Hi, i got the most wierd php error ever and i don't know why..
Code: echo "<t

Can anyone give me some link on .htaccess tutorial
i wish to have friendly url using .htaccess, but no idea yet about this

Hope that anyone cou

Request.UrlReferrer
I need to make it so that a page can only be loaded when a button is clicked on a specific page. I d

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

Socket programming
Hello all,

I have a PHP socket script. GPS trackers connect to this socket. IMEI verification

Ajax not working on IE 6 for Windows CE
I've created a webpage which uses the classis Ajax in following format:view plaincopy to clipboardpr

Update Database
Hi All,


I have a problem with this:

Code: [Select]<?php
session_start();

image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai