Can't retrieve info from MySQL DB...

[CrazeD]

I have installed PHPTriad on my computer, which is PHP, Apache, and MySQL all in one. I made a couple scripts for a login system and made a database. The script works fine...offline. It doesn't work on my hosting, the username/password don't match. It's the EXACT same code, EXACT same database...yet it doesn't work?! How can that be?

 

Any help is great...thanks.

[redarrow]

where the code to see the problam are you using the $_POST and $_GET correctly.

 

cross match php.ini on yours and the hosting?

[JasonLewis]

inserted all the correct data in the database. double check everything.

[CrazeD]

Here's my code;

 

<?php

require_once('mysql.php');

if (isset ($_POST['submit'])) { 

	if ( (!empty ($_POST['username'])) && (!empty ($_POST['password'])) ) {

	$query = "SELECT * FROM pr0n_members WHERE username='$username' AND password='$password'";
	$result=mysql_query($query);
	$num=mysql_num_rows($result);

	if($num > 0) {

			session_start();
			$_SESSION['username'] = $username;
			$_SESSION['loggedin'] = time();
			header ('Location: loggedin.php');

			exit();

} else { 

	print '<p>An error has occured:<b> That username/password combination was not found, please try again!</b></p>';

	}

		} else { 

				print '<p>An error has occured:<b> Please enter both a username and a password!</b></p>';

				}

			} else { 

				print '<form action="login_page.php" method="post">

							<p>Username: <input type="text" name="username" /><br />
								Password: <input type="password" name="password" /><br /><br />
									<input type="submit" name="submit" value="Login" /></p></form>';	

					}

?>

 

 

[hitman6003]

Change:

 

$result=mysql_query($query);

 

to:

 

$result=mysql_query($query) or die(mysql_error());

 

See if you are getting an error.

[CrazeD]

The error is the fact that that both the username and password do not match, defined in my code:

 

} else { 

				print '<p>An error has occured:<b> Please enter both a username and a password!</b></p>';

				}

[redarrow]

<?php session_start();

require_once('mysql.php');


if ( (empty ($_POST['username'])) || (empty ($_POST['password'])) ) {


print '<p>An error has occured:<b> That username/password combination was not found, please try again!</b></p>';

} 

if (isset ($_POST['submit'])) { 


$query = "SELECT * FROM pr0n_members WHERE username='$username' AND password='$password'";
$result=mysql_query($query);
$num=mysql_num_rows($result);

if($num > 0) {

$_SESSION['username'] = $username;
$_SESSION['loggedin'] = time();
header ('Location: loggedin.php');

exit();

}
  }else{

echo"<p>An error has occured:<b> please register! ";

}


echo '<form action="login_page.php" method="post">

<p>Username: <input type="text" name="username" /><br />
Password: <input type="password" name="password" /><br /><br />
<input type="submit" name="submit" value="Login" /></p></form>';
   
?>

[CrazeD]

That doesn't work either....

 

Here, so you guys can see what's happening: http://crazed.110mb.com/login_page.php

 

Username is 1, password is 1

[redarrow]

did you make the page loggedin.php for the header to use.?

 

 

$num >0

 

to

 

$num ==1

[redarrow]

try this should goto google when logged in.

 

 

so add this to yours ok

 

 

or die(mysql_error());

 

<?php session_start();

require_once('mysql.php');


if (isset ($_POST['submit'])) { 


$query = "SELECT * FROM pr0n_members WHERE username='$username' AND password='$password'";
$result=mysql_query($query) or die(mysql_error());
$num=mysql_num_rows($result);

if($num > 0) {

$_SESSION['username'] = $username;
$_SESSION['loggedin'] = time();

header ('Location: http://www.goole.com');

exit();

}
  }


echo '<form action="login_page.php" method="post">

<p>Username: <input type="text" name="username" /><br />
Password: <input type="password" name="password" /><br /><br />
<input type="submit" name="submit" value="Login" /></p></form>';
   
?>

[CrazeD]

Your script doesn't do anything when I click login, it just refreshes the page pretty much.

 

I don't understand though... this exact script works on my machine but not on my hosting.

 

How can I export an SQL table with PHPMyAdmin? I didn't see any export button despite looking for quite some time. Maybe if I upload the exact SQL table it might work....

[JasonLewis]

it shouldnt make a difference if you copy the database information exactly the same.

[ted_chou12]

I cant even seem to login...:http://crazed.110mb.com/login_page.php

[CrazeD]

I cant even seem to login...:http://crazed.110mb.com/login_page.php

 

Yeah...that's the problem.

[JasonLewis]

here try this:

 

<?php
session_start();

require_once('mysql.php');

if(isset($_POST['submit'])){ 
$username = $_POST['username'];
$password = $_POST['password'];

if($username != "" && $password != ""){
	$query = "SELECT * FROM pr0n_members WHERE username='$username' AND password='$password'";
	$result=mysql_query($query);
	$num=mysql_num_rows($result);
	if($num > 0) {
		$_SESSION['username'] = $username;
		$_SESSION['loggedin'] = time();
		header('Location: loggedin.php');
		exit();

	}else{ 
		print '<p>An error has occured:<b> That username/password combination was not found, please try again!</b></p>';
	}

}else{ 

	print '<p>An error has occured:<b> Please enter both a username and a password!</b></p>';
}

}else{ 
echo <<<html
<form action="login_page.php" method="post">
<p>Username: <input type="text" name="username" /><br />
Password: <input type="password" name="password" /><br /><br />
<input type="submit" name="submit" value="Login" /></p>
</form>
html;	
}

?>

[The_Assistant]

ProjectFear's script should do the trick. Thats pretty much how i do my logins when i need to code one.

[CrazeD]

YES! That worked, thank you. 

[The_Assistant]

ProjectFear sure knows his stuff.