plz fix the error

[lipun4u]

What is the error in the below code ???

<?php
		if(array_key_exists_r('email|password', $_POST)) {
			include_once('database.php');
			$sql = "SELECT user_id FROM login WHERE user_name = '" . trim($_POST['email']) . 
				"' AND password='" . trim($_POST['password']) . "')";
		 	$result = mysql_query($sql);  
			print_r($result);
		 	if (mysql_num_rows($result)>0){  
		 		$row = mysql_fetch_row($result);  
				session_start();    
				$_SESSION['user_id']=$row[0];  
				$_SESSION['user_name']=trim($_POST['email']);
			}
		}
?>

[cbolson]

What errors are you getting?

 

[Mchl]

Nothing, unless you didn't define array_key_exists_r() function.

 

Oh... and $result is not an array, so you cannot print_r() it

[mrMarcus]

edit: my bad .. thought i saw something that wasn't really there;

[lipun4u]

the error is...

Parse error: syntax error, unexpected '<' in F:\Program Files\Apache Software Foundation\Apache2.2\htdocs\submit.php on line 44

 

line 44 is $_SESSION['user_id']=$row[0];

[lipun4u]

the required function is defined...

 

<?php
function array_key_exists_r($keys, $search_r) {
    $keys_r = split('\|',$keys);
    foreach($keys_r as $key)
    if(!array_key_exists($key,$search_r))
    return false;
    return true;
}
?>

[Mchl]

You're sure this is the line? As you can see there's no < in it or near it...

[cbolson]

A parse error often referrs to a previous line to the one indicated in the php warning (simply because it doesn't *know* there is an error until it gets to that line)

 

I can't see a "<" in the code that you posted so it is probably happening somewhere else on the page or even in database.php

 

Chris

[lipun4u]

That's the problem, I also don't see any '<'.

 

Before this, I am also including 2 include_once(), will this affect the line number ???

[mrMarcus]

post your script from 'F:\Program Files\Apache Software Foundation\Apache2.2\htdocs\submit.php' starting at the very first line down to line 44.

 

edit: and yes, every line counts .. start from the very, very top of submit.php

[lipun4u]

Give me some minutes...to make a strip-down-version as it contains some legacy code...

[Mark Baker]

				$sql = "SELECT user_id FROM login WHERE user_name = '" . trim($_POST['email']) . 
				"' AND password='" . trim($_POST['password']) . "')";

Count the opening and closing brackets

[Mchl]

Good one. It's a MySQL error however, and not responsible for the warning message.