Wednesday 5 October 2016

coreupdate.php

<?php
include_once("Config.php");



  $id=$_REQUEST['txt_id'];
$uname = $_REQUEST['txt_user'];
$Pwd = $_REQUEST['txt_pwd'];
//$cnfpwd = $_POST['txt_cnfpwd'];

$adrs = $_REQUEST['txt_add'];
$state = $_REQUEST['state'];
$city = $_REQUEST['city'];
$email= $_REQUEST['txt_email'];

$date= $_REQUEST['txt_date'];
$phone = $_REQUEST['txt_phone'];
$gender= $_REQUEST['gender'];


$Hobby=implode(",",$_REQUEST['Hobby']);



 $photo=$_FILES['f1']['name'];
move_uploaded_file($_FILES['f1']['tmp_name'],"upload/$photo");

    $update= "UPDATE registration SET userId='".$id."',userName ='".$uname."',password='".$Pwd."', Address='".$adrs."', state='".$state."', city= '".$city."',email='".$email."', date='".$date."',phoneNo='".$phone."',gender='".$gender."',Hobby='".$Hobby."',Photo='".$photo."'
WHERE userId='".$id."'" or die(mysql_error());
   $query=mysql_query($update);
header("Location:emp.php");

?>

Posted by at No comments:

coreedit.php


<?php

include('config.php');

if(isset($_REQUEST['eid']))
{
$id=$_REQUEST['eid'];

$query=mysql_query("select *from registration where userId='$id'")or
die(mysql_error());
$row=mysql_fetch_array($query);

}

?>


<!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=utf-8" />
<title>Edit form</title>
</head>

<body>
<form id="form1" name="frm1" action="update.php?eid=<?php echo $row['userId']; ?>" method="POST"  enctype="multipart/form-data">
  <div id="error_div"></div>
  <table align="center" border="2">
    <h1 align="center">Edit form</h1>
    <tr>
      <td>id:</td>
      <td><input type="text" name="txt_id" id="txt_id" value="<?php echo $row['userId']; ?>" /></td>
    </tr>
    <tr>
      <td>Username:<sup style="color:#C30">*</sup></td>
      <td><input type="text" name="txt_user" id="txt_user" value="<?php echo $row['userName']; ?>" /></td>
    </tr>
    <tr>
      <td>Password:<sup style="color:#C30">*</sup></td>
      <td><input type="text" name="txt_pwd" id="txt_pwd" value="<?php echo $row['password']; ?>" /></td>
    </tr>
    <tr>
      <td>Address:<sup style="color:#C30">*</sup></td>
      <td><input type="text" name="txt_add" id="txr_add" value="<?php echo $row['Address']; ?>" /></td>
    </tr>
   
    <tr>
      <td>State:-</td>
      <td><select name="state" id="state">
          <option value="">--Select State--</option>
         <?php
if($row['state']=='Gujarat')
{
?>
  <option value="Gujarat" selected="selected">Gujarat</option>
            <option value="Maharashtra">Maharashtra</option>
            <option value="Goa">Goa</option>
            <option value="Assam">Assam</option>
            <option value="Bihar">Bihar</option>
            <option value="Arunachal Pradesh">Arunachal Prdesh</option>
            <option value="Uttar Pradesh">Uttar Prdesh</option>
            <option value="Madhya Pradesh">Madhya Prdesh</option>
            <option value="Andhra Pradesh">Andhra Prdesh</option>
 <?php
}elseif($row['state']=='Maharashtra')
{
?>
<option value="Gujarat">Gujarat</option>
            <option value="Maharashtra" selected="selected">Maharashtra</option>
            <option value="Goa">Goa</option>
            <option value="Assam">Assam</option>
            <option value="Bihar">Bihar</option>
            <option value="Arunachal Pradesh">Arunachal Prdesh</option>
            <option value="Uttar Pradesh">Uttar Prdesh</option>
            <option value="Madhya Pradesh">Madhya Prdesh</option>
            <option value="Andhra Pradesh">Andhra Prdesh</option>
 <?php
}elseif($row['state']=='Goa')
{
?>
<option value="Gujarat">Gujarat</option>
            <option value="Maharashtra">Maharashtra</option>
            <option value="Goa" selected="selected">Goa</option>
            <option value="Assam">Assam</option>
            <option value="Bihar">Bihar</option>
            <option value="Arunachal Pradesh">Arunachal Prdesh</option>
            <option value="Uttar Pradesh">Uttar Prdesh</option>
            <option value="Madhya Pradesh">Madhya Prdesh</option>
            <option value="Andhra Pradesh">Andhra Prdesh</option>
 <?php
}elseif($row['state']=='Assam')
{
?>
<option value="Gujarat">Gujarat</option>
            <option value="Maharashtra">Maharashtra</option>
            <option value="Goa">Goa</option>
            <option value="Assam" selected="selected">Assam</option>
            <option value="Bihar">Bihar</option>
            <option value="Arunachal Pradesh">Arunachal Prdesh</option>
            <option value="Uttar Pradesh">Uttar Prdesh</option>
            <option value="Madhya Pradesh">Madhya Prdesh</option>
            <option value="Andhra Pradesh">Andhra Prdesh</option>
 <?php
}elseif($row['state']=='Bihar')
{
?>
<option value="Gujarat">Gujarat</option>
            <option value="Maharashtra">Maharashtra</option>
            <option value="Goa">Goa</option>
            <option value="Assam">Assam</option>
            <option value="Bihar" selected="selected">Bihar</option>
            <option value="Arunachal Pradesh">Arunachal Prdesh</option>
            <option value="Uttar Pradesh">Uttar Prdesh</option>
            <option value="Madhya Pradesh">Madhya Prdesh</option>
            <option value="Andhra Pradesh">Andhra Prdesh</option>
 <?php
}elseif($row['state']=='Arunachal Pradesh')
{
?>
<option value="Gujarat">Gujarat</option>
            <option value="Maharashtra">Maharashtra</option>
            <option value="Goa">Goa</option>
            <option value="Assam">Assam</option>
            <option value="Bihar">Bihar</option>
        <option value="Arunachal Pradesh" selected="selected">Arunachal Prdesh</option>
            <option value="Uttar Pradesh">Uttar Prdesh</option>
            <option value="Madhya Pradesh">Madhya Prdesh</option>
            <option value="Andhra Pradesh">Andhra Prdesh</option>
 <?php
}elseif($row['state']=='Uttar Pradesh')
{
?>
<option value="Gujarat">Gujarat</option>
            <option value="Maharashtra">Maharashtra</option>
            <option value="Goa">Goa</option>
            <option value="Assam">Assam</option>
            <option value="Bihar">Bihar</option>
            <option value="Arunachal Pradesh">Arunachal Prdesh</option>
            <option value="Uttar Pradesh" selected="selected">Uttar Prdesh</option>
            <option value="Madhya Pradesh">Madhya Prdesh</option>
            <option value="Andhra Pradesh">Andhra Prdesh</option>
 <?php
}elseif($row['state']=='Madhya Pradesh')
{
?>
<option value="Gujarat">Gujarat</option>
            <option value="Maharashtra">Maharashtra</option>
            <option value="Goa">Goa</option>
            <option value="Assam">Assam</option>
            <option value="Bihar">Bihar</option>
            <option value="Arunachal Pradesh">Arunachal Prdesh</option>
            <option value="Uttar Pradesh">Uttar Prdesh</option>
            <option value="Madhya Pradesh" selected="selected">Madhya Prdesh</option>
            <option value="Andhra Pradesh">Andhra Prdesh</option>
 <?php
}elseif($row['state']=='Andhra Pradesh')
{
?>
<option value="Gujarat">Gujarat</option>
            <option value="Maharashtra">Maharashtra</option>
            <option value="Goa">Goa</option>
            <option value="Assam">Assam</option>
            <option value="Bihar">Bihar</option>
            <option value="Arunachal Pradesh">Arunachal Prdesh</option>
            <option value="Uttar Pradesh">Uttar Prdesh</option>
            <option value="Madhya Pradesh">Madhya Prdesh</option>
            <option value="Andhra Pradesh" selected="selected">Andhra Prdesh</option>
 <?php
}
?>
        </select></td>
    </tr>
   
    <tr>
      <td>City:-</td>
      <td>
      <select name="city" id="city">
<option value="">--select City--</option>
<?php
if($row['city']=='Gandhinagar')
{
?>
  <option value="Gandhinagar" selected="selected">Gandhinagar</option>
            <option value="Mumbai">Mumbai</option>
            <option value="Panji">Panji</option>
            <option value="Dispur">Dispur</option>
            <option value="Patna">Patna</option>
            <option value="Itanagar">Itanagar</option>
            <option value="Lucknow">Lucknow</option>
            <option value="Bhopal">Bhopal</option>
            <option value="Vijaywada">Vijaywada</option>
<?php
}elseif($row['city']=='Mumbai')
{
?>
  <option value="Gandhinagar">Gandhinagar</option>
            <option value="Mumbai" selected="selected">Mumbai</option>
            <option value="Panji">Panji</option>
            <option value="Dispur">Dispur</option>
            <option value="Patna">Patna</option>
            <option value="Itanagar">Itanagar</option>
            <option value="Lucknow">Lucknow</option>
            <option value="Bhopal">Bhopal</option>
            <option value="Vijaywada">Vijaywada</option>
<?php
}elseif($row['city']=='Panji')
{
?>
 <option value="Gandhinagar">Gandhinagar</option>
            <option value="Mumbai">Mumbai</option>
            <option value="Panji" selected="selected">Panji</option>
            <option value="Dispur">Dispur</option>
            <option value="Patna">Patna</option>
            <option value="Itanagar">Itanagar</option>
            <option value="Lucknow">Lucknow</option>
            <option value="Bhopal">Bhopal</option>
            <option value="Vijaywada">Vijaywada</option>
<?php
}elseif($row['city']=='Dispur')
{
?>
 <option value="Gandhinagar">Gandhinagar</option>
            <option value="Mumbai">Mumbai</option>
            <option value="Panji">Panji</option>
            <option value="Dispur" selected="selected">Dispur</option>
            <option value="Patna">Patna</option>
            <option value="Itanagar">Itanagar</option>
            <option value="Lucknow">Lucknow</option>
            <option value="Bhopal">Bhopal</option>
            <option value="Vijaywada">Vijaywada</option>
<?php
}elseif($row['city']=='Patna')
{
?>
 <option value="Gandhinagar">Gandhinagar</option>
            <option value="Mumbai">Mumbai</option>
            <option value="Panji">Panji</option>
            <option value="Dispur">Dispur</option>
            <option value="Patna" selected="selected">Patna</option>
            <option value="Itanagar">Itanagar</option>
            <option value="Lucknow">Lucknow</option>
            <option value="Bhopal">Bhopal</option>
            <option value="Vijaywada">Vijaywada</option>
<?php
}elseif($row['city']=='Itanagar')
{
?>
 <option value="Gandhinagar">Gandhinagar</option>
            <option value="Mumbai">Mumbai</option>
            <option value="Panji">Panji</option>
            <option value="Dispur">Dispur</option>
            <option value="Patna">Patna</option>
            <option value="Itanagar" selected="selected">Itanagar</option>
            <option value="Lucknow">Lucknow</option>
            <option value="Bhopal">Bhopal</option>
            <option value="Vijaywada">Vijaywada</option>
<?php
}elseif($row['city']=='Lucknow')
{
?>
 <option value="Gandhinagar">Gandhinagar</option>
            <option value="Mumbai">Mumbai</option>
            <option value="Panji">Panji</option>
            <option value="Dispur">Dispur</option>
            <option value="Patna">Patna</option>
            <option value="Itanagar">Itanagar</option>
            <option value="Lucknow" selected="selected">Lucknow</option>
            <option value="Bhopal">Bhopal</option>
            <option value="Vijaywada">Vijaywada</option>
<?php
}elseif($row['city']=='Bhopal')
{
?>
 <option value="Gandhinagar">Gandhinagar</option>
            <option value="Mumbai">Mumbai</option>
            <option value="Panji">Panji</option>
            <option value="Dispur">Dispur</option>
            <option value="Patna">Patna</option>
            <option value="Itanagar">Itanagar</option>
            <option value="Lucknow">Lucknow</option>
            <option value="Bhopal" selected="selected">Bhopal</option>
            <option value="Vijaywada">Vijaywada</option>
<?php
}elseif($row['city']=='Vijaywada')
{
?>
 <option value="Gandhinagar">Gandhinagar</option>
            <option value="Mumbai">Mumbai</option>
            <option value="Panji">Panji</option>
            <option value="Dispur">Dispur</option>
            <option value="Patna">Patna</option>
            <option value="Itanagar">Itanagar</option>
            <option value="Lucknow">Lucknow</option>
            <option value="Bhopal">Bhopal</option>
            <option value="Vijaywada" selected="selected">Vijaywada</option>
<?php
}
?>
</select>
     
      </td>
    </tr>
    <tr>
      <td>Email:-</td>
      <td><input name="txt_email" id="txt_email" type="text" value="<?php echo $row['email']; ?>" placeholder="Enter Your Email" size="30" /></td>
    </tr>
    <tr>
      <td>DateOfBirth</br>
        (yyyy-mm-dd):-</td>
      <td><input type="date" name="txt_date" id="txt_date" value="<?php echo $row['date']; ?>" placeholder="Enter Your DateOfBirth"></td>
    </tr>
    <tr>
      <td>PhoneNo:-</td>
      <td><input name="txt_phone" id="txt_phone" type="text" value="<?php echo $row['phoneNo']; ?>" placeholder="Enter Your PhoneNo" size="30" /></td>
    </tr>
      <tr>
   
    <td>Gender:-</td>
      <td>
   
      <label>
   
    <?php if($row['gender']=='Male')
{
?>
    <input type="radio" name="gender" value="Male" checked="checked" />
    Male
    <input type="radio" name="gender" value="Female"/>
    Female
    <?php
}
else
{
?>
    <input type="radio" name="gender" value="Male"
/>
    Male
    <input type="radio" name="gender" value="Female" checked="checked" />
    Female
    <?php
}
?>
    <br />
      </td>
   
      </tr>
   
    <tr>
      <td> Hobby:-</td>
      <td><?php

error_reporting(0);

$hb=array('Cricket','Tennis','Football','Hocky');

$ex=explode(',',$row['Hobby']);

foreach($hb as $r)
{
if($ex[0]==$r || $ex[1]==$r || $ex[2]==$r || $ex[3]==$r)
{
?>
        <input type="checkbox" name="Hobby[]" value="<?php echo $r;?>" checked="checked">
        <?php echo $r;?>
        <?php
}
else
{
?>
        <input type="checkbox" name="Hobby[]" value="<?php echo $r;?>">
        <?php echo $r;?>
        <?php
}
}

?>
</td>
    </tr>
    <tr>
      <td>Photo:-</td>
      <td>
      <input type="hidden" name="tmp_name" value="<?php echo $row['Photo'];?>"/>
      <input type="file" name="f1" value="<?php echo $row['Photo'];?>"/></td>
    </tr>
    <tr>
      <td align="center"><input name="btn_Edit" type="submit" value="Submit"/></td>
    </tr>
  </table>
</form>

</body>
</html>
Posted by at No comments:

coreemp.php

<?php
session_start();
if(!$_SESSION['user'])
{
header("Location:login.php");
}

if(isset($_SESSION['user']))
{
echo "Welcome ".$_SESSION['user'];
}

include('config.php');

if(isset($_REQUEST['btn_sub']))
{
$user=$_REQUEST['txt_user'];
$pwd=$_REQUEST['txt_pwd'];
$address=$_REQUEST['txt_address'];
$state=$_REQUEST['drp1'];
$city=$_REQUEST['drp2'];
$email=$_REQUEST['txt_email'];

$query = "SELECT 1 FROM registration WHERE email = '$email'";
    $abc = mysql_query($query);
if(mysql_num_rows($abc)>0)
    {
        die('email already exists');
    }
$date=$_REQUEST['txt_date'];
$phone=$_REQUEST['txt_phone'];
$gender=$_REQUEST['gender'];
$hobby=implode(",",$_REQUEST['hobby']);
$photo=$_FILES['f1']['name'];
move_uploaded_file($_FILES['f1']['tmp_name'],"upload/$photo");

//$photo=$_FILES['f1']['name'];
// move_uploaded_file($_FILES['f1']['tmp_name'],"upload/$photo");

$reg=mysql_query("Insert into registration
(userName,password,Address,state,city,email,date,phoneNo,gender,hobby,Photo)
values
('$user','$pwd','$address','$state','$city','$email','$date','$phone','$gender','$hobby','$photo')") or die( mysql_error());

  if($reg)
{
$found="N";
}
}

if(isset($_REQUEST['did']))
{

mysql_query("delete from registration where userId=".$_REQUEST['did']);
// unlink("upload/".$query);

}

?>
<!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=utf-8" />
<title>Employee Form</title>
<style>
.msg
{
color:#0C0;
}

</style>
<a href="logut.php">Logut</a>

<script>function submitform()
{
document.getElementById("Form1").submit();
alert("your form submitted");
}
</script>

<script language="javascript" type="application/javascript">

function validate()
{
  var user=document.getElementById("txt_user");
   if(user.value.length==0)
{
  alert("plese enter Username");
  user.focus();
  return false;
}
var pwd=document.getElementById("txt_pwd");
if(pwd.value.length==0)
{
alert("Please Enter Password..");
pwd.focus();
return false;
}
var cnfpwd=document.getElementById("txt_cnfpwd");
if(cnfpwd.value != pwd.value)
{
alert("Password And Confirm Password Must be Same..");
pwd.focus();
return false;
}
var email=document.getElementById("txt_email");
if(email.value.length==0)
{
alert("Please Enter The Email Address");
email.focus();
return false;
}
var phone=document.getElementById("txt_phone");
if(phone.value.length==0)
{
alert("Enter The Contact No");
phone.focus();
return false;
}

}

</script>
</head>

<body>

<form action="" method="post" name="Form1" enctype="multipart/form-data">
  <fieldset id="Field1">
    <legend>Registration</legend>
    <table width="200" border="0" align="center">
      <caption align="center" style="font-family:Verdana, Geneva, sans-serif">
      RegistrationForm
        </br>
      </caption>
     
      <tr>
        <td>Userid:-</td>
        <td><input name="txt_id" type="text" readonly="readonly" value="<?php

?>" size="5" /></td>
      </tr>
   
      <tr>
        <td>UserName:-</td>
        <td><input name="txt_user" id="txt_user" type="text" size="30" placeholder="Enter Your Name" /></td>
      </tr>
   
      <tr>
        <td>Password:-</td>
 <td><input name="txt_pwd" id="txt_pwd" type="password" size="30" placeholder="Enter Your Password" /></td>
      </tr>
     
      <tr>
        <td>cnfpassPassword:-</td>
        <td><input name="txt_cnfpwd" id="txt_cnfpwd" type="password" size="30" placeholder="Enter Your cnfPassword" /></td>
      </tr>
      <tr>
        <td>Address:-</td>
        <td><textarea id="txt_address" name="txt_address" placeholder="Enter Your Address" rows="4" cols="23" ></textarea></td>
      </tr>
     
      <tr>
        <td>State:-</td>
        <td><select name="drp1" id="drp1" onFocus="message('Field of choice')" >
            <option value="Select" selected="selected">--Select--</option>
            <option value="Gujarat">Gujarat</option>
            <option value="Maharashtra">Maharashtra</option>
            <option value="Goa">Goa</option>
            <option value="Assam">Assam</option>
            <option value="Bihar">Bihar</option>
            <option value="Arunachal Pradesh">Arunachal Prdesh</option>
            <option value="Uttar Pradesh">Uttar Prdesh</option>
            <option value="Madhya Pradesh">Madhya Prdesh</option>
            <option value="Andhra Pradesh">Andhra Prdesh</option>
          </select></td>
      </tr>
   
      <tr>
        <td>City:-</td>
        <td><select name="drp2" id="drp2" >
            <option value="--Select--" selected="selected" onfocus="Select" >--Select--</option>
            <option value="Gandhinagar">Gandhinagar</option>
            <option value="Mumbai">Mumbai</option>
            <option value="Panji">Panji</option>
            <option value="Dispur">Dispur</option>
            <option value="Patna">Patna</option>
            <option value="Itanagar">Itanagar</option>
            <option value="Lucknow">Lucknow</option>
            <option value="Bhopal">Bhopal</option>
            <option value="Vijaywada">Vijaywada</option>
          </select></td>
      </tr>
   
      <tr>
        <td>Email:-</td>
        <td><input name="txt_email" id="txt_email" type="text" placeholder="Enter Your Email" size="30" /></td>
      </tr>
     
      <tr>
        <td>DateOfBirth</br>
          (yyyy-mm-dd):-</td>
        <td><input type="date" id="txt_date" placeholder="Enter Your DateOfBirth" name="txt_date"></td>
      </tr>
   
      <tr>
        <td>PhoneNo:-</td>
        <td><input name="txt_phone" id="txt_phone" type="text" placeholder="Enter Your PhoneNo" size="30" /></td>
      </tr>
   
       <tr>
        <td>Gender:-</td>
        <td>
            <label>
              <input type="radio" name="gender" value="Male" checked="checked" id="RadioGroup1_0" />
              Male</label>
            <br />
            <label>
              <input type="radio" name="gender" value="Female" id="RadioGroup1_1" />
              Female</label>
            <br />
          </td>
      </tr>
   
      <tr>
        <td> Hobby:-</td>
        <td>
            <label>
              <input type="checkbox" name="hobby[]" value="Cricket" />
              Cricket</label>
            <label>
              <input type="checkbox" name="hobby[]" value="Tennis"  />
              Tennis</label>
            <label></br>
              <input type="checkbox" name="hobby[]" value="Football" />
              Football</label>
            <label>
              <input type="checkbox" name="hobby[]" value="Hocky"/>
              Hocky</label>
            <br />
          </td>
      </tr>
   
      <tr>
      <td>Photo:-</td>
<td>
      <input type="file" name="f1" id="f1" placeholder="Enter Your Photo"/></td>
      </tr>
      <tr>
        <td align="center"><input name="btn_sub" type="submit" value="SignUp" onclick="return validate()" /></td>
     
      <!--
<div onclick="submitform()" style="color:blue;">Submit the form by clicking this</div>
       -->
       
        <td align="left"><input name="btn_reset" type="reset" value="Reset"/></td>
      </tr>
       <tr>
      <td colspan="2" >
         <strong class="msg">
<?php
 if(isset($found))
 {
echo "Data Insert Succsessfully..";
 }
 ?></strong></td>
        </tr>
    </table>
  </fieldset>
 
    <fieldset><legend>DataGridview</legend>
  <table align="center" border="1">
  <caption><h3>Registration Form</h3></caption>
  <tr>
  <th>UserId</th>
  <th>UserName</th>
  <th>Password</th>
  <th>Address</th>
  <th>State</th>
  <th>City</th>
  <th>Email</th>
  <th>DateOfBirth</th>
  <th>PhoneNo.</th>
  <th>Gender</th>
  <th>Hobby</th>
  <th>Photo</th>
 
<th>Edit</th>
<th>Delete</th>
 </tr>

 <?php
 $query= mysql_query("select * from registration");
 $no=1;

 while($row=mysql_fetch_array($query))
 { ?>
  <tr>
   <td><?php echo $row['userId'] ?></td>
        <td><?php echo $row['userName'] ?></td>
        <td><?php echo $row['password'] ?></td>
        <td><?php echo $row['Address'] ?></td>
        <td><?php echo $row['state'] ?></td>
        <td><?php echo $row['city'] ?></td>
        <td><?php echo $row['email'] ?></td>
<td><?php echo $row['date'] ?></td>
        <td><?php echo $row['phoneNo'] ?></td>
        <td><?php echo $row['gender'] ?></td>
        <td><?php echo $row['Hobby'] ?></td>
<td><img src="upload/<?php echo $row['Photo'];?>" width="80" height="80" title="<?php echo $row['Photo'];?>"/> </td>
<td><a href="edit.php?eid=<?php echo $row['userId'];?>">Edit</a></td>
        <td><a href="emp.php?did=<?php echo $row['userId'];?>" onclick="return confirm('Are you Sure Delete?')">Delete</a></td>
    </tr>
 <?php
 $no++;
 }
 ?></table>
 </fieldset>
    </form>


</body>
</html>
Posted by at No comments:

corelogin.php

<?php
include('config.php');

session_start();

if(isset($_REQUEST['btn_login']))
{
$user=$_REQUEST['txt_user'];
$pwd=$_REQUEST['txt_pwd'];

$_SESSION['user']=$user;

$res=mysql_query("select * from login where username='".$user."' and password='".$pwd."'");

if(isset($_SESSION['user']))
{
if(mysql_num_rows($res)==1)
{
echo "Success ".$_SESSION['user'];
header("location:emp.php");
}
else
{
echo "Invalid ".$user;
}
}
}
?>
<!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=utf-8" />
<title>Login Form</title>
<script type="text/javascript"  src="js/jquery.min.js"></script>
<script>
        $(document).ready(function()
{
c=0;
$("#pass").click(function()
{
              if(c==0)
 {
 document.getElementById("txt_pwd").setAttribute("type","text");
 c=1;
 }
 else
 { document.getElementById("txt_pwd").setAttribute("type","password");
 c=0;
 }
            });
         
        });
</script>


</head>

<body>

<form action="" method="post" name="Form1" enctype="multipart/form-data">

<fieldset id="Field1"><legend>Login</legend>
<table width="200" border="0" align="center">
  <caption align="center" style="font-family:Verdana, Geneva, sans-serif">Login</br></br></br></caption>
  <tr>
    <td>UserName:-</td>
    <td><input name="txt_user" type="text" placeholder="Username"  style="border:inset;" /></td>
  </tr>

  <tr>
    <td>Password:-</td>
    <td><input name="txt_pwd" id="txt_pwd" type="password" placeholder="Password" style="border:inset;"  /></td>
  </tr>
  <tr>
  </tr>
  <tr><td colspan="2">
    <input type="checkbox" id="pass"/>
  Show Password
  </tr>
  <tr align="right">
    <td colspan="2"><a href="forgetpassword.php"/>ForgotPassword</a> <a href="employee.php"/>SignUp</a> </td>
  </tr>
 
  <tr>
    <td align="center"><input name="btn_login" type="submit" value="Login"/></td>
 
    <td align="left"><input name="btn_reset" type="reset" value="Reset"/></td>
  </tr>
</table>
</fieldset>
</form>
</body>
</html>
Posted by at No comments:

Monday 20 June 2016

loginForm Codeignter


<fieldset>


<div class="heading"><h1>Admin Login</h1></div>
<form method="post">
<table class="table" align="center" border="0">

<?php echo $msg;?>



<tr>
<td align="right">Username</td>
<td><input type="text" name="username" class="text"><span class="error">*</span></td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('username');?></td>
</tr>

<tr>
<td align="right">Password</td>
<td><input type="password" name="password" class="text"><span class="error">*</span></td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('password');?></td>
</tr>

<tr>
<td colspan="2" align="center"><input type="submit" value="login" class="btn">
<input type="reset" class="btn"> <br> <a href="<?php echo base_url();?>index.php/abc">Signup</a> ||
<a href="<?php echo base_url();?>index.php/login/forget">Forget Password</a>
 </td>
</tr>

</table>

</form>
</div>
</fieldset>
Posted by at No comments:

Edit Codeigneter


<form method="post" enctype="multipart/form-data">

<?php $row=$this->dbabc->getedit($aaa);?>

<table>
<tr>
<td>Username</td>
<td><input type="text" name="username" value="<?php echo $row->username;?>"></td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('username');?></td>
</tr>

<tr>
<td>Password</td>
<td><input type="text" name="password" value="<?php echo $row->password;?>"></td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('password');?></td>
</tr>


<tr>
<td>Address</td>
<td><input type="text" name="address" value="<?php echo $row->address?>"></td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('address');?></td>
</tr>


<tr>
<td>Contact</td>
<td><input type="text" name="contact" value="<?php echo $row->contact?>"></td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('contact');?></td>
</tr>


<tr>
<td>Email</td>
<td><input type="text" name="email" value="<?php echo $row->email?>"></td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('email');?></td>
</tr>

<tr>
<td>Image</td>
<td>
<input type="hidden" name="old_image" value="<?php echo $row->image;?>">
<input type="file" name="image"><?php echo $row->image;?></td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('image');?></td>
</tr>

<tr>
<td>Gender</td>
<?php
if($row->gender =='male')
{
?>
<td><input type="radio" name="gender" value="male" checked="checked">Male</br>
<input type="radio" name="gender" value="female">Female</td>
<?php
}
else
{
    ?>
    <td><input type="radio" name="gender" value="male" >Male</br>
<input type="radio" name="gender" value="female" checked="checked">Female</td>

    <?php
}
?>
</tr>

<tr>
<td></td>
<td><?php echo form_error('gender');?></td>
</tr>



<tr>
<td>City</td>
<td>
 <select name="city[]" multiple="multiple">

<?php

error_reporting(0);

$hbs=array('surat','nadiad','Baroda');

$exq=explode(',',$row->city);



foreach($hbs as $r)
{
    if($exq[0]==$r || $exq[1]==$r || $exq[2]==$r)
    {
        ?>
     
       <option value="<?php echo $r;?>" selected="selected"><?php echo $r;?>
        <?php
    }
    else
    {
        ?>
       
       <option value="<?php echo $r;?>"> <?php echo $r;?>
        <?php
    }
}

?>
 </select>
</td>

</tr>

<tr>
<td></td>
<td><?php echo form_error('city');?></td>
</tr>

<tr>
<td>Hobby</td>
<td>
<?php

error_reporting(0);

$hb=array('cricket','tennis','football');

$ex=explode(',',$row->hobby);

foreach($hb as $r)
{
    if($ex[0]==$r || $ex[1]==$r || $ex[2]==$r)
    {
        ?>
        <input type="checkbox" name="hobby[]" value="<?php echo $r;?>" checked="checked">
        <?php echo $r;?>
        <?php
    }
    else
    {
        ?>
        <input type="checkbox" name="hobby[]" value="<?php echo $r;?>">
        <?php echo $r;?>
        <?php
    }
}

?>

</td>

</tr>

<tr>
<td></td>
<td><?php echo form_error('hobby');?></td>
</tr>



<tr>
<td><input type="submit"></td>
<td><input type="reset"></td>
</tr>

</table>
</form>
Posted by at No comments:

View Codeigneter

<div align="right">
<form method="post" action="<?php echo base_url();?>index.php/abc/search">
<input type="text" name="search" required placeholder="Only Username Allowed">
<input type="submit"  value="Search">

</form>

</div>



<a href="<?php echo base_url();?>index.php/abc">Insert</a>

<div align="center">
<table  border="1" style="background-color:#">
<tr>
<td>Id</td>
<td>Username</td>
<td>Password</td>
<td>Address</td>
<td>Contact</td>
<td>Email</td>
<td>Image</td>
<td>gender</td>
<td>city</td>
<td>hobby</td>
<td>Delete</td>
<td>Update</td>
</tr>

<?php
if($result)
{
   
$no=1;
foreach($result as $row)
 {
    ?>
   
    <tr>
    <td><?php echo $no; $row->signup_id;?></td>
    <td><?php echo $row->username;?></td>
    <td><?php echo $row->password;?></td>
    <td><?php echo $row->address?></td>
    <td><?php echo $row->contact;?></td>
    <td><?php echo $row->email;?></td>
    <td><img src="<?php echo base_url();?>upload/<?php echo $row->image;?>" width="50" height="50" title="<?php echo $row->image;?>"/></td>
    <td><?php echo $row->gender;?></td>
    <td><?php echo $row->city;?></td>
    <td><?php echo $row->hobby;?></td>
    <td><a href="<?php echo base_url();?>index.php/abc/delete/<?php echo $row->signup_id;?>" onClick="return confirm('Delete')">Delete</a></td>
   
     <td><a href="<?php echo base_url();?>index.php/abc/edit/<?php echo $row->signup_id;?>">Update</a></td>
 
    </tr>
    <?php
    $no++;
}
}
else
{
    ?>
 <div align="center" style="margin-bottom:-100px;margin-top:100px; color:#F00;">
   
    <?php echo "Record Not Found !!!!!!"; ?>

    <?php
}

?>
</table>
Posted by at No comments:

form Codeigneter


<div align="" class="top">

<fieldset>

<div class="head">
<div class="heading"><span style="text-align:left;">Signp Now</span></div>
<div class="link" ><a href="<?php echo base_url();?>index.php/abc/view">View</a>

</div>
</div>

<div align="center">

<form method="post" enctype="multipart/form-data">

<table>
<tr>
<td>Username</td>
<td><input type="text" name="username" class="text"></td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('username');?></td>
</tr>

<tr>
<td>Password</td>
<td><input type="text" name="password" class="text"></td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('password');?></td>
</tr>


<tr>
<td>Address</td>
<td><input type="text" name="address" class="text"></td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('address');?></td>
</tr>


<tr>
<td>Contact</td>
<td><input type="text" name="contact" class="text"></td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('contact');?></td>
</tr>


<tr>
<td>Email</td>
<td><input type="text" name="email" class="text"></td>
</tr>


<tr>
<td></td>
<td><?php echo form_error('email');?></td>
</tr>
<tr>
<td>Image</td>
<td><input type="file" name="image"></td>
</tr>

<tr>
<td>Gender</td>
<td ><input type="radio" name="gender" value="male">Male
<input type="radio" name="gender" value="female">Female</td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('gender');?></td>
</tr>


<tr>
<td>City:</td>
<td>
<select name="city[]" multiple="multiple" class="text">
<option hidden="">Choose city</option>
<option value="surat">Surat</option>
<option value="nadiad">Nadiad</option>
<option value="Baroda">Baroda</option>

</select>
</td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('city');?></td>
</tr>

<tr>
<td>Hobby</td>
<td><input type="checkbox" name="hobby[]" value="cricket">cricket
<input type="checkbox" name="hobby[]" value="tennis">tennis
<input type="checkbox" name="hobby[]" value="football">footbol</td>
</tr>

<tr>
<td></td>
<td><?php echo form_error('hobby');?></td>
</tr>



<tr>
<td colspan="2" align="center"><input type="submit" class="but">
<input type="reset" class="but"></td>
</tr>

</table>
</form>
</div>

</fieldset>
</div>
</body>
</html>


<?php $this->load->view('footer');?>
Posted by at No comments:

Header of abc

<!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=utf-8" />
<title>Untitled Document</title>

<link rel="stylesheet" type="text/css" href="<?php echo base_url();?>/css/style.css">

</head>

<body>

<div class="header">

<table width="100%">
<tr>

<td align="right">
<span style="font-size:18px;">Welocme</span> &nbsp;-
<span style="text-transform:capitalize; font-size:16px; color:#FFF;">
<?php echo $this->session->userdata('username');?>
</span>
<br>

<span style="font-size:18px; color:#F00;">
<a href="<?php echo base_url();?>index.php/logout">Logout</a></span> ||

<a href="<?php echo base_url();?>index.php/chgpwd">Change Password</a>
</td>
</tr>
</table>
<ul class="menu">

    <li><a href="">Mobile</a>
   
    <ul>
        <li><a href="">Sony</a></li>
        <li><a href="">Samsung</a></li>
        <li><a href="">Apple</a></li>
     </ul>
   
    </li>
   
    <li><a href="">Computer</a><ul>
        <li><a href="">Sony</a></li>
        <li><a href="">Dell</a></li>
        <li><a href="">Hp</a></li>
     </ul></li>
    <li><a href="">Men</a></li>
    <li><a href="">Women</a> </li>

</ul>
</div>
<table width="200" border="1">
  <tr>
    <td><?php if($this->session->flashdata('msg')=='sucess')
    { ?>
    <div class="success"><?php echo $this->session->flashdata('type')?></div>
   
     <?php
    }
    ?>
      
    </td>
   
  </tr>
</table>

</body>
</html>
Posted by at No comments:

DbLogin

<?php
class dblogin extends CI_model
{
    function chklogin($user,$pass)
    {
        $sql=$this->db->query("select *from register where username='".$user."' and password='".$pass."' ");
        return $sql->row();
    }
   
    function chkuser($user)
    {
        $sql=$this->db->query("select *from register where username='".$user."'");
        return $sql->row();
    }
   
    function chkpass($user)
    {
        $sql=$this->db->query("select password from register where username='".$user."'");
        return $sql->row();
    }
}
?>
Posted by at No comments:

DbInsertUpdateDelete

<?php
class dbabc extends CI_Model
{
    function insertwww($abcd)
    {
        $this->db->insert('register',$abcd);
    }
   
    function getalldata()
    {
        $sql=$this->db->get('register');
        return $sql->result();
    }
    function getsearch()
    {
        $match=$this->input->post('search');
        $sql="select *from register where(username like'%".$match."%')";
        $res=$this->db->query($sql);
        return $res->result();
       
    }
    function getedit($i)
    {
        $sql=$this->db->query("select *from register where signup_id=$i");
        return $sql->row();
    }
   
        function deleteimg($i)
    {
        $sql=$this->db->query("select *from register where signup_id=$i");
        return $sql->row();
    }

   
    function update($abc,$id)
    {
        $this->db->where('signup_id',$id);
        $this->db->update('register',$abc);
    }
    function delete($id)
    {
        $this->db->where('signup_id',$id);
        $this->db->delete('register');
    }
}
?>
Posted by at No comments:

login Codeigneter

<?php
class login extends CI_controller
{
    function __construct()
    {
        parent::__construct();
        $this->load->model('dblogin');
    }
    function index()
    {
       
       
        $this->form_validation->set_rules('username','Username','required');
        $this->form_validation->set_rules('password','Password','required');
       
        $this->form_validation->set_error_delimiters("<div class ='error'>");
        if($this->form_validation->run()==false)
        {
          $data['msg']='';       
        }
        else
        {
            $result=$this->dblogin->chklogin($_POST['username'],$_POST['password']);
           
            if($result)
            {
                $this->session->set_userdata('username',$_POST['username']);
                $data['msg']='Login Sucess';
                $this->session->set_flashdata(array('msg'=>'sucess','type'=>'Login Is Sucess'));
               
                redirect('abc');

            }
            else
            {
                $data['msg']='Login Invalid';
            }
           
        }
        $this->load->view('login_form',$data);
            }
           
        function forget()
        {   
            $this->form_validation->set_rules('username','username','required');
            if($this->form_validation->run()==false)
            {
                $data['msg']='';
            }
            else
            {
                $re=$this->dblogin->chkuser($_POST['username']);
                if($re)
                {
                  $pass=$this->dblogin->chkpass($_POST['username']);
                  $getpass=$pass->password;
                   $data['msg']=("<script language='javascript'>alert('Your Password Is....$getpass')</script>");
                }
                    else
                {
                    $data['msg']='User Wrong';
                }
            }
                $this->load->view('forget',$data);
            }
   
}



?>
Posted by at No comments:

ControllerInsertUpdateDelete

<?php
class abc extends CI_controller
{
    function __construct()
    {
        parent::__construct();
        $this->load->model('dbabc');
       
        $login=$this->session->userdata('username');
        if($login=='')
        {
            redirect('login');
        }
       
    }
    function index()
    {
        $this->form_validation->set_rules('username','Name','required|alpha');
        $this->form_validation->set_rules('password','Name','required');
        $this->form_validation->set_rules('address','Name','required');   
        $this->form_validation->set_rules('contact','Name','required|is_numeric|min_length[10]|max_length[10]');
        $this->form_validation->set_rules('email','Name','required|valid_email');
        $this->form_validation->set_rules('gender','Name','required');
        $this->form_validation->set_rules('city','Name','required');
        $this->form_validation->set_rules('hobby','Name','required');       
       
        if($this->form_validation->run()==false)
        {
          $this->load->view('form');
        }
        else
        {
            $abc['upload_path']='upload'; 
            $abc['allowed_types']='png|jpg|jpeg|gif';
           
            $this->load->library('upload',$abc);
           
            if(!$this->upload->do_upload('image'))
            {   
                $file="";
            }
            else
            {
                $file=$this->upload->file_name;
            }
           
    $abc=array('username'=>$_POST['username'],
                'password'=>$_POST['password'],
                'address'=>$_POST['address'],
                'contact'=>$_POST['contact'],
                'email'=>$_POST['email'],
                'gender'=>$_POST['gender'],
                'city'=>implode(',',$_POST['city']),
                'hobby'=>implode(",",$_POST['hobby']),
                'image'=>$file);
            $this->dbabc->insertwww($abc);
            redirect('abc/view');
        }
    }
    function view()
    {
        $data['result']=$this->dbabc->getalldata();
        $this->load->view('view',$data);
    }
    function search()
    {
        $data['result']=$this->dbabc->getsearch();
          $this->load->view('view',$data);
    }
    function delete($id)
    {
        $abc=$this->dbabc->deleteimg($id);
        unlink("upload/".$abc->image);
       
        $this->dbabc->delete($id);
        redirect('abc/view');
    }
    function edit($a)
    {
        if($a=='')
        {
            redirect('abc/view');
        }
        $this->form_validation->set_rules('username','Name','required');
        $this->form_validation->set_rules('password','Name','required');
        $this->form_validation->set_rules('address','Name','required');   
        $this->form_validation->set_rules('contact','Name','required|is_numeric|min_length[10]|max_length[10]');
        $this->form_validation->set_rules('email','Name','required|valid_email');
        $this->form_validation->set_rules('gender','Name','required');
        $this->form_validation->set_rules('city','Name','required');
        $this->form_validation->set_rules('hobby','Name','required');       
       
        if($this->form_validation->run()==false)
        {
            $data['aaa']=$a;
            $this->load->view('edit',$data);
        }
        else
        {
            $abc['upload_path']='upload'; 
            $abc['allowed_types']='png|jpg|jpeg|gif';
           
            $this->load->library('upload',$abc);
            if(!$this->upload->do_upload('image'))
            {
                $file=$_POST['old_image'];
            }
            else
            {
                $file=$this->upload->file_name;
            }
    $abc=array('username'=>$_POST['username'],'password'=>$_POST['password'],'address'=>$_POST['address'],'contact'=>$_POST['contact'],'email'=>$_POST['email'],'gender'=>$_POST['gender'],'city'=>implode(',',$_POST['city']),'hobby'=>implode(",",$_POST['hobby']),'image'=>$file);
            $this->dbabc->update($abc,$a);
            redirect('abc/view');
        }
    }
   
}

?>
Posted by at No comments:

Saturday 9 January 2016

InsertUpdateDelete with Validtion

//Config.php
<?php

$cn = mysql_connect('localhost','root','') or die(mysql_error());
if(!$cn)
{
    echo "ERROR:not connected";
   
    }


$db = mysql_select_db('info') or die(mysql_error());
    if(!$db)
{
    echo "ERROR: Not Connected..";
   
    }   
?>

 //Stud.php

<body>
<form action="" method="post" enctype="multipart/form-data">
  <div align="center">
    <fieldset>
      <legend>Stud-Info</legend>
       <div>
        <label>userId:-</label>
        <label>
            <input name="txtid" id="txtid" type="text" readonly="readonly"
             />
          </label>
      </div>
      <div>
        <label>Name:-<sup style="color:red">*</sup></label>
        <label>
            <input name="txtname" id="txtname" type="text" placeholder="Enater Name" />
          </label>
      </div>
     
      <br/>
      <div><input name="txtsignup" type="submit" value="Signup" onclick="return validate() " /></div>
    </fieldset>
  </div>
 
  <fieldset><legend>Griedview</legend>
  <table align="center" border="1"><caption><h3>Griedview</h3></caption>
   <tr>
  <th>userid</th>
  <th>Username</th>
  <th>Edit</th>
  <th>Delete</th>
  </tr>
  <?php
 
  $grid=mysql_query("Select * from Registration");
 
  //echo "<table><tr><th>Id</th> <th>name</th></tr>";
  
  while($gr=mysql_fetch_row($grid))
  {
    echo "<tr>";
    echo "<td>$gr[0]</td>";   
    echo "<td>$gr[1]</td>";
      echo "<td><a href=Stud.php?did=$gr[0]>Delete</a></td>";
    echo "<td><a href=update.php?uid=$gr[0]>Edit</a></td>";
  }
 
  ?>
 
  </table>

  </fieldset>
 
</form>

</body>

 //validation on head
<script language="javascript" type="text/javascript">
function validate()

{
    var x1= document.getElementById("txtname");
        if(x1.value.length==0)
        {
            alert("please Enter UserName");
            x1.focus();
           
        return false;
           
            }
    }

</script>



 <?php
include_once("config.php");
extract($_POST);
if(isset($txtsignup))
{
    $res= mysql_query("insert into Registration (userName) Values('$txtname')") or
    die(mysql_error());
       
    }
   
        if(isset($_REQUEST['did']))
    {
        mysql_query("delete from Registration where userId=".$_REQUEST['did']);
    }
?>
//Update.php
 



<?php
     include_once("config.php");

    if(isset($_REQUEST['uid']))
   {
      $res=mysql_query("select * from registration where userId=".$_REQUEST['uid']) or die(mysql_error());
   
      $r=mysql_fetch_row($res);
   }
  
   if(isset($_POST['submit']))
   { 
 mysql_query("update registration set userName = '".$_POST['fname']."'
 where userId='".$_POST['id']."'")or die(mysql_error());
      header('location:Stud.php');
     
     
   }
?>


<br>

<form id="tform" name="frm1" action="" method="post" enctype="multipart/form-data">
<div></div>
<table align="center" border="2">
<h1 align="center">Edit form</h1>
<tr>
<td>id:</td>
<td><input type="text" name="id" id="id" value="<?php echo $r[0];?>" /></td>
</tr>
<tr>
<td>first name:<sup style="color:#C30">*</sup></td>
<td><input type="text" name="fname" id="fname" value="<?php echo $r[1];?>" /></td>
</tr>
<td>
<input type="submit" name="submit" id="submit" value="edit"/>
</td></tr>
</table>
</form>
Posted by at No comments:

Session

//Login.php
<?php
session_start();
   
   
    if(isset($_POST['s1']))
    {
    $x=$_POST['t1'];
    $_SESSION['user']=$x;
    $y=$_POST['t2'];
   

if(isset($_SESSION['user']))
            {
                header("Location:session1.php");   
            }   
    else
        {
            echo "Sorry........";
        }
    }

?>
<form id="form1" name="form1" method="post" action="">
  <table width="300" border="1">
    <tr>
      <td width="88">User</td>
      <td width="196"><input name="t1" type="text" id="t1" /></td>
    </tr>
    <tr>
      <td>Password</td>
      <td><input name="t2" type="text" id="t2" /></td>
    </tr>
    <tr>
      <td colspan="2"><div align="center">
        <input name="s1" type="submit" id="s1" value="Submit" />
      </div>  <div align="center"></div></td>
    </tr>
  </table>
</form>

//Session.php


<?php
session_start();
if(isset($_SESSION['user']))
{
    echo "Hi " .$_SESSION['user'];
}
?>
Posted by at No comments:
Subscribe to: Posts (Atom)