sign-in and sign-up pages are required to develop good iterative dynamic website that store the information of users. In this post we do sign up sign in profile info access update point on signin and signout.
onsubmit="return validate(); is user define JavaScript function that validate the field .
Find the validate() function in register.php page . Php code :
extract($_POST) function is add $ in all the post field.(city , $city )(name , $name ).
Database :- user
Website Previews
Required Languages :-
PHP MYSQL CSS JAVASCRIPT HTML.
Site directory chart :-
Explanation :- Index.php
Html code : In index.php file we only link the signin page and signup page.<table width="50%" border="0" align="center" cellpadding="2" cellspacing="10">
<tr>
<td colspan="2" align="center" bgcolor="#0000FF"><h2><a href="http://www.eaglexwebs.blogspot.com" style="text-decoration:none;"><span class="style1">eaglexwebs.blogspot.com</span></a></h2></td>
</tr>
<tr>
<td width="46%" align="center"><a href="login.php"><div class="box" onmouseover="this.className='box1'" onmouseout="this.className='box'">Sign In</div></a></td>
<td width="54%" align="center"><a href="register.php"><div class="box" onmouseover="this.className='box1'" onmouseout="this.className='box'">Sign Up</div></a></td>
</tr></table>
Php code : session code (required to change language ) <?php
session_start();ob_start();
if($_SESSION['lang']=='')
{
$_SESSION['lang'] = "en";
}
include 'languages/lang.'.$_SESSION['lang'].'.php';
?>
register.php
<form action="" id="form1" method="post" name="form1" onsubmit="return validate();"> </form>
onsubmit="return validate(); is user define JavaScript function that validate the field .
Find the validate() function in register.php page . Php code :
<?php session_start();ob_start();
if($_SESSION['lang']=='')
{
$_SESSION['lang'] = "en";
}
include 'languages/lang.'.$_SESSION['lang'].'.php';
include("include/db.inc.php");
include("include/bit_functions.inc.php");
include("include/function.register.php");
$db1=new db;
$db1->open();
$headermsg= _CREATE_ACCOUNT_;
$str=randamString();
?>
<?
if(isset($_POST['submit_reg']))
{
echo "submit button is post :";
} ?><input name="submit_reg" type="submit" class="inputsubmit" value="<?=_REGS_NOW_?>">
extract($_POST) function is add $ in all the post field.(city , $city )(name , $name ).
extract($_POST);
mysql_query("insert into city set stateid='$state',city='$other',status='1'");
$city=mysql_insert_id();
}
$sql="insert INTO user(id,uname,email,password, bday, state, city, time_zone, question, answar, ccode) values('','$name','$email','$pwd','$bday','$state','$city', '$time_zone','$question','$ans','$ccode')";
$res=mysql_query($sql) or die(mysql_error());
$i_id=mysql_insert_id();
$profile_set="insert into profile_setting set uid='$i_id',basic_info='1',contact_info='1',personal='1',
educational='1',course='1',wall='1',photo='1',friends='1',share='1',
notes='1',groups='1'";
mysql_query($profile_set);
Login :-
$query1=mysql_fetch_array(mysql_query("SELECT id FROM user WHERE email='$email' and password='$password' and confirm='1' and blocked='1' and deactive='0'"));
$query2=mysql_fetch_array(mysql_query("SELECT id FROM user WHERE email='$email' and password='$password' and confirm='1' and blocked='0' and deactive='1'"));
$query3=mysql_fetch_array(mysql_query("SELECT id FROM user WHERE email='$email' and password='$password' and confirm='1' and blocked='1' and deactive='1'"));
$query4=mysql_fetch_array(mysql_query("SELECT id FROM user WHERE email='$email' and password='$password' and confirm='1' and blocked='0' and deactive='0'"));
$query5=mysql_fetch_array(mysql_query("SELECT id FROM user WHERE email='$email' and password='$password' and confirm='0' "));
if($query1['id'])
header("location:login.php?msg=blocked");
if($query2['id'])
header("location:login.php?msg=deactive&deactivate=1");
if($query3['id'])
header("location:login.php?msg=deactiveblock");
if($query5['id']){
header("location:login.php?msg=confirm");}
if($query4['id'])
{
$_SESSION[id]=$query4['id'];
$gm=$_SESSION[id];
list($lastlogin)=mysql_fetch_array(mysql_query("select lastlogin from user where id='$gm'"));
$qry="update user set second_lastlogin='$lastlogin',lastlogin=now() where id='$gm'";
$res=mysql_query($qry);
if(!empty($_GET['code']))
{
$id=$_SESSION['id'];
$q="insert into friends(id,user_id,fr_id,fr_type,status) values('','$id','$i_id',1)";
mysql_query($q) or die(mysql_error());
}
//code to insert data in mypoint table or to show Login points
$mypoint_res=mysql_query("select * from mypoint where uid='$gm'");
$mypoint_row=mysql_fetch_object($mypoint_res);
$login_cnt=$mypoint_row->loginpoint;
$cc=mysql_num_rows($mypoint_res);
if($cc)
{
$clv=loginpoint100();
$lc=$login_cnt+$clv;
$qry="update mypoint set loginpoint='$lc' where uid='$gm'";
mysql_query($qry);
}
else
{
$lc=loginpoint100();
mysql_query("insert into mypoint values('','$gm','$lc','','','')");
}
//end of code to insert data in mypoint table or to show Login points
header("location:user_detail.php");
}
Logout :-
<?
session_start();ob_start();
session_destroy();
header("Location: index.php");
?>
User detail :-
<?php
session_start();ob_start();
include("include/db.inc.php");
if($_SESSION['lang']=='')
{
$_SESSION['lang'] = "en";
}
include 'languages/lang.'.$_SESSION['lang'].'.php';
include_once("include/bit_functions.inc.php");
$db1=new db;
$db1->open();
checked_login();
$uid=$_SESSION[id];
$query= "select * fROM user where id = '$uid'";
$sql=mysql_query($query);
$res=mysql_fetch_array($sql);
$query1= "select * fROM profile where uid = '$uid'";
$sql1=mysql_query($query1);
$res1=mysql_fetch_array($sql1);
?>
<table width="100%" cellpadding="3" cellspacing="3" style="font:Verdana, Arial, Helvetica, sans-serif ; font-size:16px; color:#9900CC; background-color:#99FFFF;">
<tr>
<td width="22%">User Name</td>
<td width="25%"><?php echo $res['uname'];?></td>
<td width="19%">Email Id</td>
<td width="34%"><?php echo $res['email'];?></td>
</tr>
<tr>
<td>Gender</td>
<td><?php if($res1['sex'] == m) { Echo "Male";}?><?php if($res1['sex'] == f) { Echo "Female";}?></td>
<td>Last LogIn </td>
<td><?php echo $res['lastlogin'];?></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
db.inc.php
var $host = 'localhost';
var $user ='root';
var $password ="";
var $database ='eaglex';
var $persistent = false;
var $adminid='admin';
var $adminipwd='admin';
define('_BASEURL_','http://localhost/signup-signin'); //protocol required (http://)
define('_DOMAINURL_','http://localhost/signup-signin');
define('_BASEPATH_','http://localhost/signup-signin');
Database :- user
CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uname` varchar(50) COLLATE latin1_general_ci NOT NULL,
`fname` varchar(40) COLLATE latin1_general_ci NOT NULL,
`lname` varchar(30) COLLATE latin1_general_ci NOT NULL,
`email` varchar(50) COLLATE latin1_general_ci NOT NULL,
`password` varchar(50) COLLATE latin1_general_ci NOT NULL,
`bday` date NOT NULL,
`state` varchar(50) COLLATE latin1_general_ci NOT NULL,
`city` int(11) NOT NULL,
`college` int(11) NOT NULL,
`collstatus` int(11) NOT NULL,
`collyear` int(11) NOT NULL,
`time_zone` varchar(50) COLLATE latin1_general_ci NOT NULL,
`question` varchar(100) COLLATE latin1_general_ci NOT NULL,
`answar` varchar(50) COLLATE latin1_general_ci NOT NULL,
`blocked` enum('0','1') COLLATE latin1_general_ci NOT NULL,
`deactive` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
`couse` text COLLATE latin1_general_ci NOT NULL,
`confirm` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '0',
`ccode` varchar(100) COLLATE latin1_general_ci NOT NULL,
`second_lastlogin` datetime NOT NULL,
`lastlogin` datetime NOT NULL,
`p_view` int(11) NOT NULL,
`online` enum('0','1') COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=134 ;
State :-
CREATE TABLE IF NOT EXISTS `state` ( `id` int(11) NOT NULL AUTO_INCREMENT, `state` varchar(30) COLLATE latin1_general_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=11 ;City :-
-- Table structure for table `city`
--
CREATE TABLE IF NOT EXISTS `city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`stateid` int(11) NOT NULL,
`city` varchar(200) COLLATE latin1_general_ci NOT NULL,
`status` enum('0','1') COLLATE latin1_general_ci NOT NULL DEFAULT '1',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=33 ;
No comments:
Post a Comment