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