Jump to content


This topic is now archived and is closed to further replies.


help needed with me log on script

Recommended Posts

hello folks i am new to php
i have created a log on script to check userid and password from mysql database, but even if i enter correct uesrname and password it doesnt display correct message
plse help me

    include 'database_connect.private'; 



header("Cache-control: private");

$connection = mysql_connect($hostname,$username,$password);
      mysql_select_db($databaseName, $connection);
/* $result = mysql_query ("SELECT * FROM staff", $connection);

while ($row = mysql_fetch_row($result))
echo "hello";
if($pid==$row[0] && $passwrd==$row[1])
{echo "hello";


$query="SELECT * FROM staff WHERE staff_Id ='$pid' AND password='$passwrd' ";
//or die(mysql_error());
echo "try";

if (mysql_num_rows($result)==1)
echo "user logged in";
echo "Successful login ... Click Here to ";
//redirect ("http://stuweb.cms.gre.ac.uk/~fj330/home.html")
echo "<p> Sorry Unauthorized Access is not Allowed</p>";




Share this post

Link to post
Share on other sites
test your query in phpmyadmin or similar and see what is returned...
(echo out your query string before you run the query - then you can copy and paste into your favorite db app!)

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.