[RESOLVED] Echo error message if no info is found in database

Sacreed

Am knew to sql so I need help with making it where when the user logs it checks the database to see if the information they entered is right if not echo: We do not have that information in our database. But if its right it sends them to another page, here is my code:


<?php
$username="****";
$password="****";
$database="****";

$username=$_POST['user'];
$password=$_POST['pass'];
$email=$_POST['email'];

$con = mysql_connect("*****","****","****");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

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

$result = mysql_query("SELECT * FROM userslogin");

while($row = mysql_fetch_array($result))

mysql_close($con);
?>

Addiction information:
1. Yes I do have a database that works when a person registers.

Thanks in advance,just figured out how to get my database to connect umm...like 10 minutes ago 😃

Krik

Use [man]mysql_num_rows[/man] to count the returned results and "if" the number of rows returned in not 1 then give an error message "else" process the rows.

$result = mysql_query("SELECT * FROM `userslogin` WHERE `username` = '" . $username . "' AND `password`= '" . $password . "'");

$num_rows = mysql_num_rows($result);

if ($num_rows != 1 ) {
   echo "We do not have that information in our database";
}
else {
    while($row = mysql_fetch_array($result)) {
         // do something with the results
    }
}

I should note that you should do some additional checks on the $_POST data to make sure no one is trying to do an injection attack or enter some other malicious code that could cause harm. Obviously getting the basics working first is the best if your just learning but then you need to work on security. This includes doing a hash on the password.

Sacreed

This is why I love you XD I was hoping you would reply to my post lol, seeing your the main one that does =D Well, thanks for the reply. I will test it out and tell you what I get, I should be able to work out the errors if there is any, plus I was kinda thinking on the lines of what you said just a tad bit off. Thanks again =D Your awesome.

Sacreed

Aww =D I love you even more now XD It works. No one should ever doubt your awesomeness!

Krik

This is why I love you XD I was hoping you would reply to my post lol, seeing your the main one that does =D Well, thanks for the reply. I will test it out and tell you what I get, I should be able to work out the errors if there is any, plus I was kinda thinking on the lines of what you said just a tad bit off. Thanks again =D Your awesome.

Glad I could help.

I will note that most the moderators and admin here as well as several other are way more knowledgeable than myself. Some of the guys here practically taught me PHP, as well as Javascript, many years ago. And I figure the least I can do is return the favor. I actually participate in few forums and it reality is the least I can do for all the frustration I caused in my early days of programing.

But I should note that any ability I have to answer questions isn't in that I know the answers. In fact most times I don't. My ability to answer question is primarily found in being able to easily break down code and knowing how to search the online manuals to find the answer. On occasion I will actually know the answer.

Of course the side effect of answering questions is I learn more. So actually you may be contributing to me becoming a better programmer. I know its selfish of me 😃