[Resolved] php works on computer but not on server

[avantbard]

Hi could anyone help me?

 I have created a simple php script to check password and email address for a login form - it works perfectly on my computer which has php 4.3.9 but on my server which has php4.3.2 it doesn't. I have many other php scripts which work both on my computer and the server. I've checked everything many times and still can't see what is wrong could any one help me?

Here is the script:-

require 'incLoc.php';
mysql_connect($DBhost,$DBuser,$DBpass);
mysql_select_db("$DBName");

$vars = array("email","pass");
foreach($vars as $var)
if(isset($REQUEST[$var]))
$$var = $REQUEST[$var];

// The SQL query

$query = "SELECT * FROM members WHERE Email = '$email' AND Password = '$pass'";
$result = mysql_query($query);

// Check
$numR = mysql_num_rows($result);

if ($numR == 1) { 
print "mess=You have successfully Loged in";
}
else {
print "mess=Login Failed - Either your login information was incorrect or you have not registered."; 
}

Many Thanks in Advance,
R.

[bradgrafelman]

I don't know what's being done in 'incLoc.php' but I have a couple of suggestions:

1. What do you mean "it doesn't work" ? What happens? What doesn't happen? What error messages are outputted?

2. What version of MySQL Server is your 'server' (not your computer, the remote server) running?

3. Depending on how you answer #1, it could be a MySQL error. Try debugging the connection:

mysql_connect($DBhost,$DBuser,$DBpass) or die('MySQL said: ' . mysql_error());

mysql_select_db("$DBName") or die('MySQL said: ' . mysql_error());

[avantbard]

Hi thanks for your response

I have MySQL 3.23.58 on the server as opposed to mysql 4.0.21-nt-max on my computer.

The script should send back a message to my swf - informing the user if their details were in the database - but at the moment it just freezes - I get no error messages nothing.

When I open the php file from the server it returns the bottom variable:-
mess=Login Failed - Either your login information was incorrect or you have not registered.

So I am assuming it is reaching mysql ?
I just tried your degubbing script in the php file and it made no change.
Any more ideas?
R.

[bradgrafelman]

Try echo'ing out the $query variable. Take a look at it and make sure it looks correct.

Otherwise, perhaps your MySQL 3.x server is getting confused on the column names and/or table name, try adding backticks:

$query = "SELECT * FROM `members` WHERE `Email` = '$email' AND `Password` = '$pass'"; 

First, though, I'd echo out the $query like I said and make sure it looks correct. Go into the database on the remote MySQL server and make sure the values exist and are what they should be.

[avantbard]

Thanks again,

I just echoed out the $query and it looked ok - I tried adding the back ticks - but it had no effect - the script still works on my computer but not on the server.

This is what appeared on the server:-

SELECT * FROM members WHERE Email = '' AND Password = ''mess=Login Failed - Either your login information was incorrect or you have not registered.

What I did notice was when I had a look at the PHP file on my computer - the message was login successful but on the server it was login failed.

I've double checked the database - it is fine - and all my other php scripts which use the same inc file and table on the same database work fine?

R.

[bradgrafelman]

Is this EXACTLY what you saw when outputting $query?

SELECT * FROM `members` WHERE `Email` = '' AND `Password` = ''

That means it's not filling in the $email and $pass variables correctly. Try this:

foreach($vars as $var) {
    if(isset($_REQUEST[$var])) {
        ${$var} = $_REQUEST[$var];
    }
}

instead of the code you have. See if that makes any difference. If not, do a print_r($_REQUEST); and make sure 'email' and 'pass' are being set properly.

[avantbard]

Cheers,

Just put your code in - to no avail - still works on my computer but not the server.
when I did the print_r($_REQUEST);

I got this result:-(copied and pasted directly from the page)

Array ( ) mess=Login Failed - Either your login information was incorrect or you have not registered.

So I guess it gave Array() - is that correct?

R.

[bradgrafelman]

Not really - it's saying that $_REQUEST is equal to Array ( ) which is, in other words, empty. null. blank. etc.

How are you supposedly getting these variables? Through a form submitted? Through the URL (i.e. 'myscript.php?email=[e-mail]&pass=mypass')?

If you said yes to one of the above, change $REQUEST to $POST or $GET (respectively) and give that a shot. Also try the print_r() command (the value will, once again, depend on which method you're using - $GET or $_POST) and let us know what it says.

[avantbard]

Cheers,

I am getting the variables from a flash form using the loadVariablesNum command - which I guess creates a string as you have said to send to the script.

I have tested the script by putting:-

$email= "[e-mail]";
$pass= "password";

into the script and both on the server and computer it appears to have communicated succesfully with MySQL and returned a successful result. When I use flash to send the variables it stops working but only on the server - I've tried absolute and relative paths to the php file and post, get and request commands - GET doesn't work on my computer.

When I put in the print_r command bit testing the $POST and $GET methods I still get Aray() - even when I put the variable at the top as above.

??

[thorpe]

I have tested the script by putting:-

$email= "[e-mail]";
$pass= "password";

into the script and both on the server and computer it appears to have communicated succesfully

.
if thats the case then it suggests there is something wrong with the way you are sending the form data from flash. nothing wrong with your php.

[bradgrafelman]

I'm no guru in flash, but... is there anyway you can pass the email & pw the user enters in the URL, instead of 'loadVariablesNum' ? For example, inside the flash script, you would load:

http://mysite.com/path/to/myscript.php?email=[e-mail]&pass=mypassword

And then use $GET in your PHP script to retrieve the variables, i.e. $GET['email'] and so on.

You should also urlencode the email and password, for example you would pass "email%40myhost.com" instead of "[e-mail]" in the URL. As I said, I'm no Flash guru so I don't know how to do this.

[videxx]

dear avantbard..

after i read thru ur posts... i jus need to know 1 question..

Why do u need to pass the password and the email into an array?

in normal method, u shud post them into URL either using POST or GET method, (depends on ur own choice..)

a user have to fill in their email n password in a page before and u will pass the variable into URL and check it with records in database.. if shud the user is existed, user can do bla bla bla... or else, a msg prompt out saying that the user is invalid..

am i right?

if so i'm right.. then u shud alter ur codes from scrath.. if u need my help, i can give u some advice later..

It's jus one of the normal way to accept variables from a page to be passed n checked with existed database record.. u jus made urself think in complicated way.. trust me, there is another easier way to do it..

have a gud day.. 🆒

Best Regards, videxx

[avantbard]

Hi Videxx,

I am sending the codes via the loadvariablesnum method from flash - I have tried both POST and GET methods and both work fine on my computer but as soon as I use the server it stops working - I just tried a new code for the php script and I still get the same result?
Now I am using:-

require 'incLoc.php';
$Connect = mysql_connect($DBhost,$DBuser,$DBpass);
mysql_select_db("$DBName");

$email = $GET['email'];
$pass = $GET['pass'];

$query = sprintf("SELECT * FROM members WHERE Email ='%s' AND Password ='%s'",
mysql_real_escape_string($email),
mysql_real_escape_string($pass));

$result = mysql_query($query);

if (!$result) {
$message = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $query;
die($message);
}

$numR = mysql_num_rows($result);

if ($numR == 1) { 
echo "mess=You have successfully Loged in";
}
else {
echo "mess=Login Failed - Either your login information was incorrect or you have not registered."; 
}

Any ideas would be greatly appreciated.
Cheers
R.

[avantbard]

Thanks for your help I have finally sorted the problem - I switched to the loadVars object in Flash and put my DB info directly into the php file and that has sorted it - the php scripts still behave differently on my PC to the Server - but at least it all works now!

[videxx]

since u have solved ur problem.. i jus want to give u my opinion on ur codes.. sorry to say this, but ur codes are quite messy.. here i paste urs..

require 'incLoc.php'; 
$Connect = mysql_connect($DBhost,$DBuser,$DBpass); 
mysql_select_db("$DBName"); 

$email = $_GET['email']; 
$pass = $_GET['pass']; 

//i dun understand y u need to use '%s' while u can directly use the variable 
$query = sprintf("SELECT * FROM members WHERE Email ='%s' AND Password ='%s'", 
mysql_real_escape_string($email), 
mysql_real_escape_string($pass)); 


$result = mysql_query($query); 

//there is a better way to make error checking tho~ :cool: 
if (!$result) { 
$message = 'Invalid query: ' . mysql_error() . "\n"; 
$message .= 'Whole query: ' . $query; 
die($message); 
} 

$numR = mysql_num_rows($result); 

if ($numR == 1) { 
echo "mess=You have successfully Loged in"; 
} 
else { 
echo "mess=Login Failed - Either your login information was incorrect or you have not registered."; 
} 

thus.. let me show u how i did for my page.. it's actually the same, but in a better way.. it might solve ur server problem.. coz my page run smoothly in both localhost and my server..
Here it goes..

if (@$HTTP_POST_VARS["submit"] <> "") {

  $bValidPwd = 0;
	$sEmail = @$HTTP_POST_VARS["email"];
	$sPassWd = @$HTTP_POST_VARS["password"];

  if ($bValidPwd == 0) {
			$conn = phpmkr_db_connect(HOST, USER, PASS,DB);
			$sEmail = (!get_magic_quotes_gpc()) ? addslashes($sEmail) : $sEmail;
			$sSql = "SELECT * FROM `account`";
			$sSql .= " WHERE `Email` = '" . $sEmail ;
			$rs = phpmkr_query($sSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);

//to check whether the user enter the correct information
			if (phpmkr_num_rows($rs) > 0) {
				$row = phpmkr_fetch_array($rs);
				$bValidPwd = 1;
			}		

phpmkr_free_result($rs);			
phpmkr_db_close($conn);
}

//if the login success, the user will be redirect to next page
	if ($bValidPwd == 1) {
		$HTTP_SESSION_VARS["project1_status"] = "login";
		ob_end_clean();
		header("Location: Main.php");
		exit();
	} 
	else {
//i have a variable call ewmsg - so-called my error message
		$HTTP_SESSION_VARS["ewmsg"] = "Incorrect Login or the account is not yet existed";
	}
}

I have authored my coding as per ur usage.. why not u try implement these on urs... I think it might solve ur server problem thingy.. Hope my code can solve ur problem clean..

by the way... i'm curios on this~

Thanks for your help I have finally sorted the problem

sorted? or u were trying to say that u have SOLVED it?

Have a gud day avantbard..

Regards, videxx :p