Webmaster Forum - Making a Signup and Login Database

papasmurf

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
<?
//***************************************
// 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,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
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 " <center>Successfully,Logged in <a href='logout.php'> Log OUT </a> <a href=welcome.php>Click here if your browser is not redirecting automatically or you don't want to wait.</a> </center>";
print "<script>";
print " self.location='welcome.php';"; // Comment this line if you don't want to redirect
print "</script>";

}
}
else {

session_unset();
echo "Wrong Login. Use your correct Userid and Password and Try <center><input type='button' value='Retry' onClick='history.go(-1)'></center>";

}
?>
<center>
 <a href='http://www.plus2net.com'>PHP SQL HTML free tutorials and scripts</a></center>

</body>

</html>

signupck.php
//***************************************
// 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,$dbpassword);
function connecttodb($servername,$dbname,$dbuser,$dbpassword)
{
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 ";
$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 ";
$status= "NOTOK";}

if ( strlen($password) < 3 ){
$msg=$msg."Password must be more than 3 char legth ";
$status= "NOTOK";}

if ( $password <> $password2 ){
$msg=$msg."Both passwords are not matching ";
$status= "NOTOK";}

if ($agree<>"yes") {
$msg=$msg."You must agree to terms and conditions ";
$status= "NOTOK";}

if($status<>"OK"){
echo "$msg <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','$hosting')");
echo "Welcome, You have successfully signed up <a href=login.php>Click here to login</a> ";
}
}
?>
<center>
 <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