Closed

Login to PHP with link to MySql

Project CS-A

The following functionality and php code neds to be finished, debugged and demonstrated

1. On a web page there will be link "demo" which opens a login window (I provide design/layout of the login window in html)

2. Submit of the login window activates and passes the userid and password fields to the execution of a [url removed, login to view] code in an app server. The functionality of the php code is provided below.

3. The php code checks the entry of userid and password fields against a mysql database and displays results of verification in the login window.

4. You must have access to a mysql database to debug the php code. The fields of demo db are also provided below.

5. You must be able to demonstrate the complete functionality of the project, before I accept the finished code.

//======login_verify.php==========

//

<?php

$userid = $HTTP_GET_VARS ["userid"]; // get caller id

$timestamp = $[url removed, login to view]; // get time stamp

$password = $HTTP_GET_VARS ["password"]; // get password

//

// query record from database demo

//

$db = mysql_connect("local host","userid", "password");

mysql_select_db("demo", $db);

$query = "SELECT * FROM demo WHERE userid=$userid OR pcallerid=$userid OR scallerid=$userid";

$result = mysql_query($query,$db);

//

// verify userid = userid or pcallerid or scallerid

//

//

// verify password

//

// verify time

<elseif cond=" '$timestamp - 60 seconds'

//

//

//

<?php

//

//------Demo db fields are: --------

//

sequence (int 4)

pcallerid (char 10), primary

scallerid (char 10)

userid (char 6)

pin char(4)

date (date)

password (char 6)

rpk (char 4)

timestamp (time)

Skills: Link Building, PHP, XML

See more: submit prototype, prototype web page design, prototype date, php verify, php id, php demo code, login to, login php code mysql, int i, design web page login, 13524, id verification, get php, timestamp, time stamp, prototype html, primary, pin, php server, php login, php debug, php db, php app, page login, mysql

About the Employer:
( 0 reviews ) Los Angeles, United States

Project ID: #7801

4 freelancers are bidding on average $80 for this job

CruzDelSur

Hi, i can get it working, but in fact i would recomend use others ways to login becouse the code provided by you is insecure. I have made a lot of logins. Pleas, contact me if you want to see them running in my server. More

$30 USD in 2 days
(27 Reviews)
5.6
tiamak

hehe this code you provided allows for sql injection attack :)

$90 USD in 2 days
(4 Reviews)
3.6
zeeshansyed

PM for further discussion please. Z

$100 USD in 2 days
(0 Reviews)
0.0
aquasofts

Dear Sir/Madam, We are happy to serve you our extraodinary work. We are in the IT Market for the past 4 years and done numerous successful projects. We assure you that we do the work to satisfy you to the best. So More

$100 USD in 6 days
(0 Reviews)
0.0