Add checkbox controller
<?php
class Add_users extends Controller
{
function Add_users()
{
parent::Controller();
$this->load->database();
$this->load->model('add_users_model');
$this->load->helper('url');
}
function index()
{
$data=array();
$submit=$this->input->post('submit');
if($submit=='Add')
{
$name=$this->input->post('name');
$this->add_users_model->add_values($name);
}
$submit=$this->input->post('submit');
if($submit=='Delete'){
$name=$_POST;
foreach($name as $value){
$this->add_users_model->delete_values($value);
}
}
$res=$this->add_users_model->getusers('user');
$data['query']=$res;
$submit=$this->input->post('submit');
if($submit=='Submit')
//if(isset($_POST['submit'])=='Submit')
{
$name=$this->input->post('search');
$data['query'] = $this->add_users_model->search_values($name);
}
$this->load->view('add_users',$data);
}
}
add_model.php
<?php
class Add_model extends Model
{
function Add_model()
{
parent::Model();
}
function insert_values($name)
{
$data = array('name'=>$name );
$query=$this->db->insert('user', $data );
}
function getusers()
{
$query = $this->db->get('user');
return $query->result();
}
function delete_values($name)
{
//$row=$this->db->delete('user', array('name' => $name));
$this->db->where('name', $name);
$this->db->delete('user');
}
function search_values($name)
{
$this->db->select('*');
$this->db->from('user');
$this->db->like('name',$name);
$query = $this->db->get();
return $query->result();
}
}
?>
add_view.php
<html>
<title>Add Users</title>
<body>
<form action="<?php echo base_url()?>add_users" method="post">
USERNAME:<input type="text" name="name" /><br>
<input type="submit" name="submit" value="Add" />
</form>
<form action="<?php echo base_url()?>add_users" method="post">
<h4>Search:<input type="text" name="search">
<input type="submit" name="submit" value="Submit"></h4>
</form>
<form action="<?php echo base_url()?>add_users" method="post">
<?php $i=1;
foreach($query as $value){?>
<input type="checkbox" name="check<?php echo $i; ?>" value="<?php echo $value->name; ?>"><?php echo $value->name; ?><br>
<?php $i++; } ?>
<input type="submit" name="submit" value="Delete" />
</form>
</body>
</html>
No comments:
Post a Comment