after a registration, you insert these data into a database.
its mysql table looks like this:
CREATE TABLE `users_table` (
`id` int(6) NOT NULL auto_increment,`username` varchar(255) NOT NULL default '',
UNIQUE KEY `username` (`username`), `password` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '',
UNIQUE KEY `email` (`email`)
,PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1;
it has a field, called id, which generated automatically, and htis will be your primary key, a unique number for each of your registered users.
On a login page, you select a username and password from your visitor, with a form,
and you can store these values in session
<?php
session_start();
function login_check($table,$fields)
{
$sql="SELECT * FROM $table WHERE ";
$fields=explode(",",$fields);
foreach($fields AS $var)
{
$sl=explode("+",$var);
$one_part=trim($sl[0]);
$sec_part=trim($sl[1]);
switch ($sec_part)
{
case "pass":
$sql.="AND `$one_part`='".md5($_POST["$one_part"])."'";
break;
case "":
$sql.="AND `$one_part`='".mysql_real_escape_string($_POST["$one_part"])."'";
break;
}
}
$sql=str_replace("WHERE AND","WHERE",$sql);
return($sql);
}
if(isset($_POST))
{
include_once("connect.php");
$sql=login_check("users_table","username,password+pass"); //that just gives you the sql query :)
$result=mysql_query($sql);
if(mysql_num_rows($result)>0)
{
$one_row=mysql_fetch_assco($result);
header("Location: welcome.php");
/*with this you can bring the visitor a page, where you show his/her profile */
$_SESSION["user_logged_in"]=1;
$_SESSION["user_id"]=$one_row["id"];
}
else
{
print "You failed to log in.<br>";
$_SESSION["user_logged_in"]=0;
}
}
?>
<form id="FormName" action="?" method="post" name="FormName">
<table width="448" border="0" cellspacing="2" cellpadding="0"><tr><td width = "150"><div align="right"><label for="username">username</label></div></td>
<td><input id="username" name="username" type="text" size="25" value="" maxlength="255"></td></tr><tr><td width = "150"><div align="right"><label for="password">password</label></div></td>
<td><input id="password" name="password" type="password" size="25" value="" maxlength="255"></td></tr><tr><td width="150"></td><td>
<input type="submit" name="submitButtonName" value="Add"></td>
</tr></table></form>
Thats it, now make the welcome.php and a link, to a profile.php.
You can make a form from the user's data.
Here is an example in zip file. You can see how to make an update page, ect...
http://phpcode.hu/phpgenerator2/8f14e45fceea167a5a36dedd4bea2543/c16a5320fa475530d9583c34fd356ef5/3295c76acbf4caaed33c36b1b5fc2cb1/php_programs_sql_create_www_phpcode_hu.zip
Hello,
jjozsi
