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>

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>

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>

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');?>

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>

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();
    }
}
?>

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');
    }
}
?>

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);
            }
   
}



?>

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');
        }
    }
   
}

?>