Login prob

#1
Flezria

Posted 23 September 2009 - 07:44 AM

Learning Programmer

Members
55 posts

i got this problem with my loginsystem. its saying that there is a fail in the code that i cant see. im pretty new to php and i will like to get some help :) the code is:

<html>


<head>


</head>


<body>


<?php

$con = mysql_connect('localhost','*****','*****');

if (!$con) {

 die ('could not connect: ' . mysql_error());

 }


$select_db=mysql_select_db("*****", $con);


if(!$select_db) {

	die ('could not connect to db: ' . mysql_error());

}


$username =  $_POST['username'];

$password =  $_POST['password'];


$sql="SELECT username FROM LogIn WHERE username=".$username." and password=".$password;

$err=mysql_error();

$result=mysql_query($sql);


if(!$sql) {

	echo $err;

}


if(!mysql_num_rows($result)) {

echo "username or password is wrong";

}

else {

echo "Login successful";

}



?>


</body>


</html>

the problem is Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource. on line 32 wich is if(!mysql_num_rows($result)). thanks alot :)

#2
John

Posted 23 September 2009 - 08:39 AM

Writes binary right handed and hex left handed

Moderators
6,321 posts

Please read http://forum.codecal...issues-php.html.

Compiled Thoughts

#3
Flezria

Posted 23 September 2009 - 11:21 AM

Learning Programmer

Members
55 posts

Thanks alot for the link, i tryed the debugging but i can really not see the prob :crying:

#4
Jacki

Posted 23 September 2009 - 11:43 AM

Learning Programmer

Members
80 posts

try this:

<?php

$con = 	mysql_connect('localhost','root','') 

		or die ('could not connect: ' . mysql_error());


$db = 	mysql_select_db("dev", $con)

		or die ('could not connect to db: ' . mysql_error());


$query = "SELECT username FROM LogIn WHERE username='".$_POST['username']."' AND password='".$_POST['password']."'";

$result = mysql_query($query);


if(!mysql_num_rows($result)) {

	echo "username or password is wrong";

} else {

	echo "Login successful";

}

?>

I wrote it quickly and I don't know if it work correctly, let me know... bye!