Php Simple Login Tutorial Learn how to make a simple login

[elevenmil 0]

Hmmz, I adjusted my code and the error went away, but when I went to try it out and register, yep, I hit another roadblock...it says...

Error: User not added to database.

...frustrating...

what do you make of this?

[elevenmil 0]

Sorry about the double post...but its 4 AM and I'm goin to bed but I saw somethin else...in addition to my previous post whenever I registered to check what would happen and it said user not added to database...I went to my phpMyAdmin and looked at my table....and my username WAS added...this just adds to my confusionAny help?

[HmmZ 0]

I think I see the problem, its checking a wrong query, try the following (old code first to see where you can find it)

// Fields are clear, add user to database //  Setup query $q = "INSERT INTO `dbUsers` (`username`,`password`,`email`) "  ."VALUES ('".$_POST["username"]."', "  ."PASSWORD('".$_POST["password"]."'), "  ."'".$_POST["email"]."')"; //  Run query $r = mysql_query($q);  // Make sure query inserted user successfully if ( !mysql_insert_id() )  {  die("Error: User not added to database.");  }

replace if(!mysql_insert_id()) with this:

if(!$r)

let me know if that fixes your problem

[elevenmil 0]

I inserted your code, but nothing changed, still got the error user not added to database thingy....What else can you suggest? Thanks...I'll keep messin around with it

[rambo406 0]

i am noob in PHP so i just follow the instruction thanks man

[elevenmil 0]

Hey guys I found a tutorial that fixed my problem...thanks to all that tried to help...I believe the tutorial link I found is under the hosted members area, it is a really easy step by step guide that include improvements to the original php codes, thanks again everyone.

[nickmealey 0]

I like that alot! I'm trying to lurn php and mySql, and that help. Two thumbs up!

[Garath 0]

Whenever I try this, it always says "ERROR:Not added to the database."

<?php// dbConfig.php is a file that contains your// database connection information. This// tutorial assumes a connection is made from// this existing file.include ("dbconfig.php");//Input vaildation and the dbase codeif ( $_GET["op"] == "reg" ) { $bInputFlag = false; foreach ( $_POST as $field )  {  if ($field == "")   {   $bInputFlag = false;   }  else   {   $bInputFlag = true;   }  } // If we had problems with the input, exit with error if ($bInputFlag == false)  {  die( "Problem with your registration info. "   ."Please go back and try again.");  } // Fields are clear, add user to database //  Setup query $q = "INSERT INTO `dbUsers` (`username`,`password`,`email`) "  ."VALUES ('".$_POST["username"]."', "  ."PASSWORD('".$_POST["password"]."'), "  ."'".$_POST["email"]."')"; //  Run query $r = mysql_query($q);  // Make sure query inserted user successfully if ( !mysql_insert_id() )  {  die("Error: User not added to database.");  } else  {  // Redirect to thank you page.  Header("Location: register.php?op=thanks");  } } // end if//The thank you pageelseif ( $_GET["op"] == "thanks" ) { echo "<h2>Thanks for registering!</h2>"; } //The web form for input abilityelse { echo "<form action=\"?op=reg\" method=\"POST\">\n"; echo "Username: <input name=\"username\" MAXLENGTH=\"16\"><br />\n"; echo "Password: <input type=\"password\" name=\"password\" MAXLENGTH=\"16\"><br />\n"; echo "Email Address: <input name=\"email\" MAXLENGTH=\"25\"><br />\n"; echo "<input type=\"submit\">\n"; echo "</form>\n"; }// EOF?>

[Mr-Slowly 0]

nice tut man thanx

[MCSESubnet 0]

Here is the MD5 alternative:

<?PHP $user_name = $_POST['u_name']; $password = $_POST['pass']; //db connection string $db = mysql_connect("localhost","root","pass"); mysql_select_db("my_database",$db); //replace the above values with your actual database val //We will now retrive the password from the database $sql_query = mysql_query("SELECT password FROM user_data WHERE user_name='$user_name'",$db); $rs = mysql_fetch_row($sql_query); //comparing passwords Note before we can compare the password we use md5() to encrypt the $password becuase the password that we retrive from the database is in the encrypted form. if(md5($password) != $rs[0]) echo "ERROR: Invalid User"; else echo "Congrats, Password is correct!"; ?>

( I pulled this off http://www.phpbuddy.com/ ) Although this shows you how fast and easy it is to use MD5 and personally I prefer it over PEAR

[xelynn 0]

thx for the tut this helps =]

[studentaugustow 0]

Nice.Thx

[d0n0t.p4n1c 0]

Everything except the login worked for me here. It says "Sorry, could not log you in. Wrong login information." when I try to login, even when I KNOW I'm using the right username/password combo. Any help?

[GamerGlitch 0]

Thank you, man. Good tutorial. However, on my site I just use my PHPBB Forum's login as the membership / login system. This still may come in handy if I ever drop that forum, though.

[sro-gaming 0]

That's about it!. I used many simple examples hoping that you will learn how the internal systems work so you can expand on them and design a system that's just right for your needs. Have fun!
hey dude i have a question. I followed your tutorial. See when i add the code it is previewed before you go back to the the contraol center(using freehostingnow.com). When it previews in shows it all but when i go to http://www.sro-gaming.freehostingnow.com/register/login.php the pages are blank. if you know what's weong email me at sro-gaming@hotmail.com
Subject: login trouble
thnx

Notice from jlhaslip:

No need to quote the whole Original Posting into your reply