i am designing a site.I created users registration and login forms and also created users database!
While i checkd the form whether its working or not.. the informations from the form is properly sent its show no sql or php error. while i checked my database the Form data is not updated..! the following is the simple code of my form:
Code: Select all
Name--> reg.php
<form action="process.php" method="post">
<table width="80%" border="0">
<tr>
<td><b>First Name * </b> <br><br></td>
<td><input type="text" name="fname"><br><br></td>
</tr>
<tr>
<td><b>Last Name * </b> <br><br></td>
<td><input type="text" name="lname"><br><br></td>
</tr>
<tr>
<td><b>Username * </b> <br><br></td>
<td><input type="text" name="username"><br><br></td>
</tr>
<tr>
<td><b>Password * </b> <br><br></td>
<td><input type="password" name="pass"><br><p>minimum 6 charectors. "_ - . " are allowed</p></td>
</tr>
<tr>
<td><b>Re-type * </b> <br><br></td>
<td><input type="password" name="pass2"><br></td>
</tr>
<tr>
<tr>
<td><b>Email </b> <br><br></td>
<td><input type="text" name="email"><br><br></td>
</tr>
<tr>
<td><b>Phone </b> <br><br></td>
<td><input type="text" name="phone"><br><br></td>
</tr>
<--- etc including country, address, date of birth -->
<td>
<input type=submit value=submit>
<br><br>
<input type=reset value=reset></td>
</tr>
</form>
Code: Select all
<?php
$fname=$_POST['fname'];
$lname=$_POST['lname'];
$username=$_POST['username'];
$password=$_POST['pass];
$email=$_POST['email'];
$address=$_POST['address'];
$city=$_POST['city'];
$state=$_POST['state'];
$country=$_POST['country'];
$phone=$_POST['phone'];
mysql_connect("localhost", "mydatabase", "(mypassword)") or die(mysql_error());
mysql_select_db("202457") or die(mysql_error());
mysql_query("INSERT INTO `forms` VALUES ('$fname', '$lname', '$email', '$address', '$city', '$state', '$phone','$country','$username,'$password')");
Print "Your information has been successfully added to the database. please click back to Home";
?>
Code: Select all
CREATE TABLE `forms` (
`fname` VARCHAR( 255 ) NOT NULL ,
`lname` VARCHAR( 255 ) NULL ,
`address` VARCHAR( 255 ) NULL ,
`city` VARCHAR( 255 ) NULL ,
`state` VARCHAR( 255 ) NULL ,
`phone` VARCHAR( 255 ) NULL ,
`email` MEDIUMINT( 255 ) NOT NULL ,
`country` VARCHAR( 255 ) NULL
) ENGINE = MYISAM
and cant process during login
My login code is:
Code: Select all
<?php
// Connects to your Database
mysql_connect("localhost", "my database", "my password") or die(mysql_error());
mysql_select_db("my database") or die(mysql_error());
//Checks if there is a login cookie
if(isset($_COOKIE['ID_my_site']))
//if there is, it logs you in and directes you to the members page
{
$username = $_COOKIE['ID_my_site'];
$pass = $_COOKIE['Key_my_site'];
$check = mysql_query("SELECT * FROM forms WHERE username = '$username'")or die(mysql_error());
while($info = mysql_fetch_array( $check ))
{
if ($pass != $info['password'])
{
}
else
{
header("Location: members.php");
}
}
}
//if the login form is submitted
if (isset($_POST['submit'])) { // if form has been submitted
// makes sure they filled it in
if(!$_POST['username'] | !$_POST['pass']) {
die('You did not fill in a required field.');
}
// checks it against the database
if (!get_magic_quotes_gpc()) {
$_POST['email'] = addslashes($_POST['email']);
}
$check = mysql_query("SELECT * FROM forms WHERE username = '".$_POST['username']."'")or die(mysql_error());
//Gives error if user dosen't exist
$check2 = mysql_num_rows($check);
if ($check2 == 0) {
die('That user does not exist in our database. <a href=reg.php>Click Here to Register</a>');
}
while($info = mysql_fetch_array( $check ))
{
$_POST['pass'] = stripslashes($_POST['pass']);
$info['password'] = stripslashes($info['password']);
$_POST['pass'] = md5($_POST['pass']);
//gives error if the password is wrong
if ($_POST['pass'] != $info['password']) {
die('Incorrect password, please try again.');
}
else
{
// if login is ok then we add a cookie
$_POST['username'] = stripslashes($_POST['username']);
$hour = time() + 3600;
setcookie(ID_my_site, $_POST['username'], $hour);
setcookie(Key_my_site, $_POST['pass'], $hour);
//then redirect them to the members area
header("Location: members.php");
}
}
}
else
{
// if they are not logged in
header("Location: reg.php");
}
?>
ikingmaker@ymail.com and also reply here!! Send the code soon to mu email!! please its urgent
[/b]