|
|
|
|||||||
 |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
07-21-2008, 12:46
|
||
|
Making a Signup and Login Database
hey everyone. having some problems setting up a php script for letting users signup and login to members area pages.
http://doverdragstrip.com/signup/signup.php/ once i sign up, it won't let me log in. if you have the opportunity, go and look, maybe you'll have better luck than me. and here's code for the: loginck.php Code:
<? //*************************************** // This is downloaded from www.plus2net.com // /// You can distribute this code with the link to www.plus2net.com /// // Please don't remove the link to www.plus2net.com /// // This is for your learning only not for commercial use. /////// //The author is not responsible for any type of loss or problem or damage on using this script.// /// You can use it at your own risk. ///// //***************************************** include "include/session.php"; $dbservertype='mysql'; $servername='nunya'; // username and password to log onto db server $dbusername='nunya'; $dbpassword='nunya'; // name of database $dbname='nunya'; //////////////////////////////////////// ////// DONOT EDIT BELOW ///////// /////////////////////////////////////// connecttodb($servername,$dbname,$dbusername,$dbpas sword); function connecttodb($servername,$dbname,$dbuser,$dbpasswor d) { global $link; $link=mysql_connect ("$servername","$dbuser","$dbpassword"); if(!$link){die("Could not connect to MySQL");} mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error()); } ////////////////////////////// ?> <!doctype html public "-//w3c//dtd html 3.2//en"> <html> <head> <title>(Type a title for your page here)</title> <meta name="GENERATOR" content="Arachnophilia 4.0"> <meta name="FORMATTER" content="Arachnophilia 4.0"> </head> <body bgcolor="#ffffff" text="#000000" link="#0000ff" vlink="#800080" alink="#ff0000"> <? $userid=mysql_real_escape_string($userid); $password=mysql_real_escape_string($password); if($rec=mysql_fetch_array(mysql_query("SELECT * FROM plus_signup WHERE userid='$userid' AND password = '$password'"))){ if(($rec['userid']==$userid)&&($rec['password']==$password)){ include "include/newsession.php"; echo "<p class=data> <center>Successfully,Logged in<br><br><a href='logout.php'> Log OUT </a><br><br><a href=welcome.php>Click here if your browser is not redirecting automatically or you don't want to wait.</a><br></center>"; print "<script>"; print " self.location='welcome.php';"; // Comment this line if you don't want to redirect print "</script>"; } } else { session_unset(); echo "<font face='Verdana' size='2' color=red>Wrong Login. Use your correct Userid and Password and Try <br><center><input type='button' value='Retry' onClick='history.go(-1)'></center>"; } ?> <center> <br><br><a href='http://www.plus2net.com'>PHP SQL HTML free tutorials and scripts</a></center> </body> </html> signupck.php Code:
//*************************************** // This is downloaded from www.plus2net.com // /// You can distribute this code with the link to www.plus2net.com /// // Please don't remove the link to www.plus2net.com /// // This is for your learning only not for commercial use. /////// //The author is not responsible for any type of loss or problem or damage on using this script.// /// You can use it at your own risk. ///// //***************************************** $dbservertype='mysql'; $servername='nunya'; // username and password to log onto db server $dbusername='nunya'; $dbpassword='nunya'; // name of database $dbname='nunya; //////////////////////////////////////// ////// DONOT EDIT BELOW ///////// /////////////////////////////////////// connecttodb($servername,$dbname,$dbusername,$dbpas sword); function connecttodb($servername,$dbname,$dbuser,$dbpasswor d) { global $link; $link=mysql_connect ("$servername","$dbuser","$dbpassword"); if(!$link){die("Could not connect to MySQL");} mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error()); } ////////////////////////////// ?> <!doctype html public "-//w3c//dtd html 3.2//en"> <html> <head> <title>(Type a title for your page here)</title> <meta name="GENERATOR" content="Arachnophilia 4.0"> <meta name="FORMATTER" content="Arachnophilia 4.0"> </head> <body bgcolor="#ffffff" text="#000000" link="#0000ff" vlink="#800080" alink="#ff0000"> <? if(isset($todo) and $todo=="post"){ $status = "OK"; $msg=""; // if userid is less than 3 char then status is not ok if(!isset($userid) or strlen($userid) <3){ $msg=$msg."User id should be =3 or more than 3 char length<BR>"; $status= "NOTOK";} if(mysql_num_rows(mysql_query("SELECT userid FROM plus_signup WHERE userid = '$userid'"))){ $msg=$msg."Userid already exists. Please try another one<BR>"; $status= "NOTOK";} if ( strlen($password) < 3 ){ $msg=$msg."Password must be more than 3 char legth<BR>"; $status= "NOTOK";} if ( $password <> $password2 ){ $msg=$msg."Both passwords are not matching<BR>"; $status= "NOTOK";} if ($agree<>"yes") { $msg=$msg."You must agree to terms and conditions<BR>"; $status= "NOTOK";} if($status<>"OK"){ echo "<font face='Verdana' size='2' color=red>$msg</font><br><input type='button' value='Retry' onClick='history.go(-1)'>"; }else{ // if all validations are passed. $query=mysql_query("insert into plus_signup(userid,password,email,name,hosting) values('$userid','$password','$email','$name','$ho sting')"); echo "<font face='Verdana' size='2' color=green>Welcome, You have successfully signed up<br><br><a href=login.php>Click here to login</a><br></font>"; } } ?> <center> <br><br><a href='http://www.plus2net.com'>PHP SQL HTML free tutorials and scripts</a></center> </body> </html> and here's a list of the files i have uploaded on the site(let me know if i need to post the code in any of them: Signup-> include-> newsession.php, session.php login.php logout.php loginck.php dump_signup.txt signupck.php welcome.php |
|
|
|
|
|
#2
07-22-2008, 01:14
|
||
|
ok...
|
|
|
|
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
