Sunday 29 January 2017

dbabc

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

No comments:

Post a Comment