Little help please with my project
Posted: Sat Oct 09, 2010 6:23 pm
HI
I'M MAKING SMALL PROJECT AND I HAVE SOME PROBLEM WITH MY PROJECT
THAT I WANT TO KNOW IF USER IN DATABASE AND IF THE USER IS IS
THE PHP PRINT SUCCESS MESSAGE AND GIVE ME INFO ABOUT THE USE
HERE MY CODING
AND THE SQL IS IN ATTACH
I'M MAKING SMALL PROJECT AND I HAVE SOME PROBLEM WITH MY PROJECT
THAT I WANT TO KNOW IF USER IN DATABASE AND IF THE USER IS IS
THE PHP PRINT SUCCESS MESSAGE AND GIVE ME INFO ABOUT THE USE
HERE MY CODING
Code: Select all
<?php
include("./db.php");
$link = mysql_connect($server, $user, $pass);
if(!mysql_select_db($database)) die(mysql_error());
$result = mysql_query("SELECT * FROM `members`");
$r = mysql_fetch_array($result);
$username = $r['username'];
$password = $r['password'];
$email = $r['email'];
//$keya=md5($_GET["key"]);
if (isset($_GET["key"])) {
$key = $_GET["key"];
$q = "SELECT username FROM `members` WHERE (username = '$key')";
if(!($result_set = mysql_query($q))) die(mysql_error());
$number = mysql_num_rows($result_set);
if ($number) {
print "USER FOUND !";
print "</br>";
print "Mr $username";
print "</br>";
print $password;
print "</br>";
print $email;
}
else {
print "Sorry ! User Not Found ";
}
}
?>