PHP Help for Registration and Login Page

finkrattaz · April 8, 2008

I am try to get the User Registration Validated and input the information throught the connection and then it opens it goes to the login page.

USER REGISTRATION

<?php

require_once('dbcon2.php');

if(isset($_POST['submit'])) {

}

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>Registration Page</title>

function validationregistration()

var frmvalidator = new Validator("registration");

frmvalidator.addValidation("name","req","Please enter your Name");

frmvalidator.addValidation("name");

frmvalidator.addValidation("name","alpha");

frmvalidator.addValidation("login","req","Please enter your Login");

frmvalidator.addValidation("login");

frmvalidator.addValidation("password","req","Please enter your Password");

frmvalidator.addValidation("password");

frmvalidator.addValidation("reenter","req","Please re-enter your Password");

frmvalidator.addValidation("reenter");

var frm = document.forms["registration"];

if(frm.password.value != frm.reenter.value)

{

alert('The Password and verified password does not match!');

return false;

}

else

{

return true;

}

</script>

</head>

<tr>

<td colspan="2" align="center"><font face="tahoma" size="3" color="white"><b>USER REGISTRATION</b></font></td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td><font face="tahoma" size="2" color="white">Dealership:</font></td>

</tr>

<tr>

</tr>

<tr>

<td><font face="tahoma" size="2" color="white">State:</font></td>

</tr>

<tr>

</tr>

<tr>

<td><font face="tahoma" size="2" color="white">Email:</font></td>

</tr>

<tr>

<td><font face="tahoma" size="2" color="white">Create Your Login:</font></td>

</tr>

<tr>

<td><font face="tahoma" size="2" color="white">Create Your Password:</font></td>

</tr>

<tr>

<td><font face="tahoma" size="2" color="white">Re-Enter Your Password:</font></td>

</tr>

<tr>

</tr>

</td>

</tr>

</table>

<p><div id="bk" align="center"><a href="index.php">back</a></div></p;

</form>

</center>

</body>

</html>

discomatt · April 8, 2008

Okay

finkrattaz · April 8, 2008

USER LOGIN

<?php

session_start();

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>Dealer Login Page</title>

<!--

#bk a:link,#bk a:visited {color: #FFFFFF; font-family: Arial, Helvetica, sans-serif; font-weight: bold; font-size: 18px;text-decoration:none; }

#bk a:hover {color:#CCFF00; font-family: Arial, Helvetica, sans-serif; font-weight: bold; font-size: 18px;text-decoration:underline; }

body {background-color: #000000;}

.style1 {color: #FFFFFF; font-weight: bold;}

-->

</style>

</head>

<body>

<td colspan="2"><font face="tahoma" size="3" color="white"><b>User Login Panel </b></font></td>

</tr>

<tr>

</tr>

<tr>

<td><p> <font face="tahoma" size="2" color="white">Login:</font></td>

</tr>

<tr>

<td><font face="tahoma" size="2" color="white">Password:</font></td>

</tr>

</tr>

</table>

<br>

<div id="bk" align="center"><a href="DealerReg.php">New User? Click here to Register.</a></div>

</form>

</center>

</body>

</html>

<?php

require_once('dbcon2.php');

$dbr = new db;$dbr->dbuser();

if(isset($_POST['Submit']))

{

if($_POST['user']=="" || $_POST['password']=="") {

?>

<strong><font face="tahoma" size="3">Please enter username and password.</font></strong>

</div>

<?php

}

$query = sprintf("SELECT * FROM dealership WHERE Login='%s' AND Password='%s'",

mysql_real_escape_string(trim($_POST['user'])),

mysql_real_escape_string(trim($_POST['password'])));

$dealername = mysql_fetch_array(mysql_query($query));

if(mysql_num_rows(mysql_query($query))<=0 && $_POST['user']!="" && $_POST['password']!="")

{

?>

<strong><font face="tahoma" size="3">Invalid input! or Incorrect Login Details</font> </strong>

</div>

<?php

}

else

{

$_SESSION['LoggedInD']= $dealername['DealerName'];

$_SESSION['LoggedInID']= $dealername['DealerID'];

if(mysql_num_rows(mysql_query($query))>0 )

{ $_SESSION['LoggedInDCnt']=1;

echo "<script>window.location='videoPage.php';</script>";

}

?>

finkrattaz · April 8, 2008

CONNECTION CODE

<?php

mysql_connect("localhost", "matts", "jordan") or die(mysql_error());

mysql_select_db("matts_videoportal") or die(mysql_error());

$custname = $_POST['custname'];;

$city = $_POST['city'];

$state = $_POST['state'];

$zip = $_POST['zip'];

$make = $_POST['make'];

$model = $_POST['model'];

$video_name = $_POST['videoname'];

$complete_video = $_POST['completevideo'];

$liked_video = $_POST['likedvideo'];

$purchased_video = $_POST['purchasedvideo'];

$comments = $_POST['comments'];

$customer_register_query = sprintf("INSERT INTO customer (custname, city, state, zip, make, model, videoname, completevideo, likedvideo, purchasedvideo, comments) VALUES (`$custname`, `$city`, `$state`, `$zip`, `$make`, `$model`, `$videoname`, `$completevideo`, `$likedvideo`, `$purchasedvideo`, `$comments`)");

$dealer_register_query = sprintf("INSERT INTO dealership (`DealerName`, `Dealership`, `City`, `State`,`Zip`,`Email`,`Login`,`Password`) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",$name,$dealership,$city,$state,$zip,$email,$login,$password);

function RegisterCustomer()

{

if (!mysql_query($customer_register_query))

{

echo "<script language=\"javascript\">\r\n";

echo "document.form1.RegisterCompletionNotifier.type=\"text\";\r\n";

echo "document.form1.RegisterCompletionNotifier.value=\"Registration was completed successfully. Thank You!\";\r\n";

echo "</script>";

}

else

{

echo "<script language=\"javascript\">\r\n";

echo "document.form1.RegisterCompletionNotifier.type=\"text\";\r\n";

echo "document.form1.RegisterCompletionNotifier.value=\"Registration Failed! Please contact site Administrator!\";\r\n";

echo "</script>";

}

function RegisterDealer()

{

if (!mysql_query($dealer_register_query))

{

echo "<script language=\"javascript\">\r\n";

echo "<!--";

echo "document.registration.DealerRegisterConfirmation.type=\"textarea\"";

echo "document.registration.DealerRegisterConfirmation.cols=\"10\" ";

echo "document.registration.DealerRegisterConfirmation.rows=\"10\" ";

echo "document.registration.DealerRegisterConfirmation.value=\"Sorry, your registration could not be saved!\" ";

echo "document.registration.DealerRegisterConfirmation.value+=\"Please contact the site administrator!!!!\" ";

echo "</script>";

}

else

{

echo "<script language=\"javascript\">\r\n";

echo "<!--";

echo "document.registration.DealerRegisterConfirmation.type=\"textarea\"";

echo "document.registration.DealerRegisterConfirmation.cols=\"10\" ";

echo "document.registration.DealerRegisterConfirmation.rows=\"10\" ";

echo "document.registration.DealerRegisterConfirmation.value=\"Registration received. Thank You!\" ";

echo "//-->";

echo "</script>";

}

?>

discomatt · April 8, 2008

That's a lot of source.

finkrattaz · April 8, 2008

I would like to make it smaller, maybe where the registration and login are on the same page.

the site is http://mattsdesigns.biz/dealership.

Sign In

PHP Help for Registration and Login Page

Recommended Posts

finkrattaz

Link to comment

Share on other sites

discomatt

Link to comment

Share on other sites

finkrattaz

Link to comment

Share on other sites

finkrattaz

Link to comment

Share on other sites

discomatt

Link to comment

Share on other sites

finkrattaz

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information