PHP - Moved: Ajax With Php Login

Hi there, I am using the jQuery, Ajax PHP code which is given at http://roshanbh.com.np/2008/04/ajax-login-validation-php-jquery.html

The form I am using, which is in index.html, is:
Code: [Select]
<form method="post" action="" name="login" id="login_form">
                    <div class="field_row">
                        <div class="label_container">
            <label>Email</label>                       
                        </div>
                        <div class="field_container">
            <input type="text" placeholder="login with your email address..." name="email_address" id="email_address" value="" class="large" />                       
                        </div>
        <div class="clear"><span class="nodisp">&nbsp;</span></div>
        </div>

        <div class="field_row">
            <div class="label_container">
            <label>Password</label>         
            </div>
            <div class="field_container">
            <input type="password" placeholder="...and password" name="password" id="password" value="" class="large" />         
            </div>
        <div class="clear"><span class="nodisp">&nbsp;</span></div>
        </div>
               
                    <div class="final_row">
                        <input type="image" src="images/login_blue.gif" id="user_login_button" name="user_login_button" value="login" id="submit" class="submit_button" />
                        <div class="final_row_text_container" >
<a href="/login/forgot_password" style="color: #008ee8;" class="small_text">Forgot your Password?</a>
                        <br />
<span id="msgbox" style="display:none"></span>
</div>
                    </div>
<div class="clear"><span class="nodisp">&nbsp;</span></div>

                </form>

The Javascript, which is situated in the head of index.html. is:
Code: [Select]
<script language="javascript">
$(document).ready(function()
{
$("#login_form").submit(function()
{
//remove all the class add the messagebox classes and start fading
$("#msgbox").removeClass().addClass('messagebox').text('Validating....').fadeIn(1000);
//check the email address exists or not from ajax
$.post("login_ajax.php",{ email_address:$('#email_address').val(),password:$('#password').val(),rand:Math.random() } ,function(data)
        {
  if(data=='yes') //if correct login detail
  {
  $("#msgbox").fadeTo(200,0.1,function()  //start fading the messagebox
{
  //add message and change the class of the box and start fading
  $(this).html('Logging in.....').addClass('messageboxok').fadeTo(900,1,
              function()
  {
  //redirect to secure page
document.location='secure.php';
  });
 
});
  }
  else
  {
  $("#msgbox").fadeTo(200,0.1,function() //start fading the messagebox
{
  //add message and change the class of the box and start fading
  $(this).html('Your login details are incorrect.').addClass('messageboxerror').fadeTo(900,1);
});
          }

        });
  return false; //not to post the  form physically
});
//now call the ajax also focus move from
$("#password").blur(function()
{
$("#login_form").trigger('submit');
});
});
</script>

And the PHP, in login_ajax.php, is:

<?php session_start();

$host =  "localhost";
$user = "bford";
$pass = "bford";
$db = "bford";

$link = mysql_connect($host, $user, $pass);
if (!link) 
{
die('<strong>Error(s) occured:</strong> Could not connect: ' . mysql_error());
}

$db_selected = mysql_select_db($db, $link);
if (!db_selected) 
{
die ('<strong>Error(s) occured:</strong> Cant use bford: ' . mysql_error());
}

//get the posted values
$email_address=$_GET['emailaddress'];
$pass=$_GET['password'];

//now validating the username and password
$sql="SELECT * FROM users WHERE email_address='".$email_address."'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

//if username exists
if(mysql_num_rows($result)>0)
{
//compare the password
if($row["password"],$pass)==1
{
echo "yes";
//now set the session from here if needed
$_SESSION["user_name"]=$userID; 
}
else
echo "no"; 
}
else
echo "no"; //Invalid Login


?>


I have been working on this for days now, changing around the form names, database table names, php variables, allsorts! I still cannot get it functioning properly. When I input a correct email_address and password combination, the 'Your login details are incorrect.' message still appears.

Help would be much appreciated.

Ben.

Hi y'all. It's been forever and a day since I've dealt with cookies, and I can't get through the cobwebs in my brain about them. I know that cookies have to be set before any output goes to the browser, but if I'm not mistaken, it's the same with sessions and sessions work in this situation. Unfortunately, the client needs cookies for integration with an existing piece of software.   Basically, what's happening is this: You load a page, click the 'login' button, which uses JQuery to change the display on the login screen from 'none' to 'block'. Use the newly-visible login form to enter username and password, which are passed via ajax to my login function. If the login is successful, I set the cookie variable and redirect the user to the protected page. However, despite the ajax reporting a successful login and redirecting the browser as expected, the check on the protected page is kicking the user back to the beginning because the cookie was never actually set.   FunctionsClass.php:

/**
 *	Logs in the requesting user with the agent and email values supplied via AJAX.
 *	@return		string					JSON-encoded array
 */
	public function agentLogin(){
		$ret['success'] = $this->_site->login($_POST['username'],$_POST['password']);
		$ret['location'] = '/protected-page';
 		print(json_encode($ret));
 		die();
	 }

Site.php (that's $_site in FunctionsClass):

/**
 *	Logs in the agent.
 *	Checks to see if the user is already logged in, if not, attempts to do so.
 *	@param		string		$un				username
 *	@param		string		$pw				password
 *	@return		boolean
 */
	public function logIn($un, $pw){
		if($this->isLoggedIn()){
			return true;
		}
		return $this->logAgentIn($un,$pw);
	}

/**
 *	Check to see if the cookie set so we know if the user has logged in.
 *	@return		boolean
 */
	public function isLoggedIn(){
//		return !empty($_SESSION['mycheckvariable']);
		return !empty($_COOKIE['mycheckvariable']);
	}

/**
 *	Log the user in.
 *	@param		string		$un				username
 *	@param		string		$pw				password
 *	@return		boolean
 */
	private function logAgentIn($un,$pw){
//		$_SESSION['mycheckvariable']['email'] = 'me@notmyemail.com';
		setcookie('mycheckvariable','me@notmyrealemail.com',time()+60*60*8,'/');
		return true;
	}

It's not as though I'm even actually checking a database - just trying to stub this out for client presentation. And, if I uncomment the two lines using sessions and comment out the cookies, it all works perfectly. I'm not at all sure what I'm missing and would very much appreciate some other eyes on this - any takers?   I'm using WordPress, if that matters at all...   Thanks in advance!

I'm trying to login and scrape a page 4 pages deep.  I can get to the fourth page...but that page only returns AJAX ERROR:0.  I know NOTHING about AJAX calls via Curl.  Can someone please help me with what to look for in the source code of the 4th page (when using a browser) to what I'm supposed to pass along via CURL?

If you need the source code or login credentials to see what's happening in the background, I can generate a temp password for you.

Thanks!

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=333348.0

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=312841.0