ya que antes he metido mis manos y lo he fastidiado varias veces con manual y sin manual... es que no entiendo muy bien...
van los codigos:
Código PHP:
CREATE TABLE IF NOT EXISTS `members` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
Código PHP:
<? ob_start(); session_start();
$db_host = "localhost";
$db_username = " root";
$db_password = " clave_root";
$db_name = " registros";
mysql_connect ("".$db_host."", "".$db_username."","".$db_password."") or die('Cannot connect to the database because: ' . mysql_error());
mysql_select_db ("".$db_name."");
$site_name = "Usuarios";
$site_email = "[email protected]";
?>
login.php
Código PHP:
<? ob_start();session_start();include_once"config.php";
if(isset($_SESSION['username']) || isset($_SESSION['password'])){
header("Location: membersarea.php");
}else{
if(isset($_POST['login'])){
$username= trim($_POST['username']);
$password = trim($_POST['password']);
if($username == NULL OR $password == NULL){
$final_report.="Please complete all the fields below..";
}else{
$check_user_data = mysql_query("SELECT * FROM `members` WHERE `username` = '$username'") or die(mysql_error());
if(mysql_num_rows($check_user_data) == 0){
$final_report.="This username does not exist..";
}else{
$get_user_data = mysql_fetch_array($check_user_data);
if($get_user_data['password'] != $password){
$final_report.="Your password is incorrect!";
}else{
$start_idsess = $_SESSION['username'] = "".$get_user_data['username']."";
$start_passsess = $_SESSION['password'] = "".$get_user_data['password']."";
$final_report.="You are about to be logged in, please wait a few moments.. <meta http-equiv='Refresh' content='2; URL=membersarea.php'/>";
}}}}}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title></title>
</head>
<body>
<form action="" method="post">
<table width="400" align="center" cellpadding="2" cellspacing="2">
<tr>
<td colspan="2" align="center" bgcolor="#0066CC" class="bglink"> </td>
</tr>
<tr>
<td colspan="2" align="center" class="title">.</td>
</tr>
<tr>
<td colspan="2"><? if(!isset($_POST['login'])){?>
Please use your username and password to login.
<? }else{ echo "".$final_report."";}?></td>
</tr>
<tr>
<td width="120">Username:</td>
<td width="180"><input type="text" name="username" size="30" maxlength="25"></td>
</tr>
<tr>
<td>Password:</td>
<td><input type="password" name="password" size="30" maxlength="25"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="login" value="Login" /></td>
</tr>
<tr>
<td colspan="2" align="center"> </td>
</tr>
<tr>
<td colspan="2" align="center" bgcolor="#0066CC" class="bglink"><a href="register.php">Register</a> - <a href="lostpassword.php">Lost Password</a></td>
</tr>
</tr>
</table>
</form>
</body>
</html>
settings.php
Código PHP:
<? ob_start(); session_start();include_once"config.php";
if(!isset($_SESSION['username']) || !isset($_SESSION['password'])){
header("Location: login.php");
}else{
$user_data = "".$_SESSION['username']."";
$fetch_users_data = mysql_fetch_object(mysql_query("SELECT * FROM `members` WHERE `username`='".$user_data."'"));
}
if(isset($_POST['update'])){
$oldp = $_POST['oldpass'];
$newp = $_POST['newpass'];
$conp = $_POST['conpass'];
if($oldp == NULL OR $newp == NULL OR $conp == NULL){
$final_report.="Please complete all the form fields!";
}else{
$check_pass = mysql_query("SELECT * FROM `members` WHERE `username`='".$user_data."'");
$check_data = mysql_fetch_array($check_pass);
if($check_data['password'] != $oldp){
$final_report.="Your old password does not match the database!";
}else{
if(strlen($newp) <= 5 || strlen($newp) >= 12){
$final_report.="Your password must be between 6 and 12 digits and characters!";
}else{
if($newp != $conp){
$final_report.="The confirmed password does not match your new password!";
}else{
$update_pass = mysql_query("UPDATE `members` SET `password` = '$newp' WHERE `username` = '".$user_data."' LIMIT 1");
$final_report.="Your password has been changed, you will need to login again.";
@session_destroy();
header( 'refresh: 3; url=login.php');
}}}}}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
<body>
<form method="post">
<table width="700" border="0" align="center" cellpadding="0" cellspacing="2">
<tr>
<td height="30" colspan="2" class="title"> </td>
</tr>
<tr>
<td width="170" bgcolor="#0066CC" class="header"> Members Menu</td>
<td width="524" bgcolor="#0066CC" class="header"> Settings</td>
</tr>
<tr>
<td valign="top"><table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td><a href="membersarea.php">Members Area</a> </td>
</tr>
<tr>
<td><a href="settings.php">Settings</a></td>
</tr>
<tr>
<td><a href="logout.php">Logout</a></td>
</tr>
<tr>
<td> </td>
</tr>
</table></td>
<td valign="top"><table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td colspan="2"><? if(!isset($_POST['update'])){ echo "".$user_data."";?>, this is where you can update your password, just enter your old and new password below and then click on the apply changes button.
<? }else{
echo"".$final_report."";
}?></td>
</tr>
<tr>
<td width="42%">Old Password: </td>
<td width="58%"><input name="oldpass" type="password" id="oldpass"></td>
</tr>
<tr>
<td>New Password: </td>
<td><input name="newpass" type="password" id="newpass"></td>
</tr>
<tr>
<td>Confirm Password: </td>
<td><input name="conpass" type="password" id="conpass"></td>
</tr>
<tr>
<td> </td>
<td><input name="update" type="submit" id="update" value="Apply Changes"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="16" colspan="2" align="center" valign="top" bgcolor="#0066CC"> </td>
</tr>
</table>
</form>
</body>
</html>
Código PHP:
<? include_once"config.php";
if(isset($_SESSION['username']) || isset($_SESSION['password'])){
header("Location: membersarea.php");
}else{
if(isset($_POST['register'])){
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
$memip = $_SERVER['REMOTE_ADDR'];
$date = date("d-m-Y");
if($username == NULL OR $password == NULL OR $email == NULL){
$final_report.= "Please complete the form below! Try again.";
}else{
if(strlen($username) <= 2 || strlen($username) >= 31){
$final_report.="Your username must be between 3 and 30 characters! Try again.";
}else{
$check_members = mysql_query("SELECT * FROM `members` WHERE `username` = '$username'");
if(mysql_num_rows($check_members) != 0){
$final_report.="The username is already in use! Try again.";
}else{
if(strlen($password) <= 5 || strlen($password) >= 12){
$final_report.="Your password must be between 6 and 12 digits and characters! Try again.";
}else{
if(!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $email)){
$final_report.="Your email address was not valid! Try again.";
}else{
$create_member = mysql_query("INSERT INTO `members` (`id`,`username`, `password`, `email`, `ip`, `date`)
VALUES('','$username','$password','$email','$memip','$date')");
$final_report.='Thank you for registering, you may <a href="login.php">login here</a>.';
}}}}}}}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
<body>
<form method="post">
<table width="400" border="0" align="center" cellpadding="2" cellspacing="2">
<tr>
<td colspan="2" bgcolor="#0066CC"> </td>
</tr>
<tr>
<td colspan="2" align="center" class="title"></td>
</tr>
<tr>
<td colspan="2"><? if(!isset($_POST['register'])){?>
Complete the form below to create your account.
<? }else{ echo "".$final_report."";}?></td>
</tr>
<tr>
<td width="37%">Username:</td>
<input name="username" type="text" id="username" size="30" />
Password:
<td><input name="password" type="password" id="password" value="" size="30" />
<td>Email:</td>
<input name="email" type="text" id="email" size="30" />
<input name="register" type="submit" id="register" value="Register" />
</form>
esto es lo que pretendo gracias....
Pagina de perfil:
Usuario:
nombre
apellido
clave:
mail:
edad: con <select>
ciudad:
pais:
DNI
direccion:
telefono:
movil:
etc:
registro.php
usuario:
Nombre:
Apellido:
email:
login.php
usuario:
mail: