mycontroller.php
<?php
class Mycontroller extends CI_controller
{
public function main()
{
$this->load->helper('form');
$this->load->helper('url');
$this->load->view('first_project');
if($this->input->post('sub'))
{
$this->load->model('mymodel');
$this->mymodel->data_insert();
}
}
public function list_users()
{
$this->load->helper('url');
$this->load->model('mymodel');
$data['query']=$this->mymodel->fetch_users();
$this->load->view('list_users',$data);
}
public function edit_users($edit_id)
{
$this->load->helper('form');
$this->load->helper('url');
$this->load->model('mymodel');
$query = $this->mymodel->get($edit_id);
$data['fid']['value'] = $query['user_id'];
$data['fuser']['value'] = $query['user_name'];
$data['fpass']['value'] = $query['user_pass'];
$this->load->view('edit_project',$data);
if($this->input->post('update'))
{
$this->mymodel->data_update();
}
}
}
?>
____________________________________________________
mymodel.php
<?php
class Mymodel extends CI_Model
{
function data_insert()
{
$this->load->database();
$data = array(
'user_name'=>$this->input->post('name'),
'user_pass'=>$this->input->post('pass'),
);
$this->db->insert('tbl_user',$data);
}
function fetch_users()
{
$this->load->database();
$query=$this->db->get('tbl_user');
return $query->result();
}
function get($id)
{
$this->load->database();
$query=$this->db->get_where('tbl_user',array('user_id'=>$id));
return $query->row_array();
}
}
?>
____________________________________________________________
first_project.php
<html>
<body>
<h1>MyFirst Form</h1>
<?php echo form_open('mycontroller/main'); ?>
<?php echo "Name"; ?>:
<?php echo form_input('name'); ?>
</br>
<?php echo "Password"; ?>:
<?php echo form_password('pass'); ?>
</br>
<?php echo form_submit('sub','Submit!'); ?>
<?php echo form_close(); ?>
</br>
<?php echo anchor("mycontroller/list_users","List of Users");?>
</body>
</html>
___________________________________________________________________
list_users.php
<html>
<body>
<h1>List of Users</h1>
<?php
echo "<table border='1'>";
echo "<tr>";
echo "<td>";
echo "Id";
echo "</td>";
echo "<td>";
echo "Name";
echo "</td>";
echo "<td>";
echo "Password";
echo "</td>";
echo "<td>";
echo "Edit";
echo "</td>";
echo "<td>";
echo "Delete";
echo "</td>";
echo "</tr>";
foreach ($query as $row)
{
echo "<tr>";
echo "<td>";
echo $row->user_id;
echo "</td>";
echo "<td>";
echo $row->user_name;
echo "</td>";
echo "<td>";
echo $row->user_pass;
echo "</td>";
echo "<td>";
echo anchor('mycontroller/edit_users/'.$row->user_id,'Edit');
echo "</td>";
echo "<td>";
echo "Delete";
echo "</td>";
echo "</tr>";
}
echo "</table>";
?>
<?php echo anchor("mycontroller/main","Back");?>
</body>
</html>
_______________________________________________________
edit_project.php
<html>
<body>
<h1>MyFirst Form</h1>
<?php echo form_open('mycontroller/main'); ?>
<?php echo "Id"; ?>:
<?php echo form_input('id',$fid['value']); ?>
</br>
<?php echo "Name"; ?>:
<?php echo form_input('name',$fuser['value']); ?>
</br>
<?php echo "Password"; ?>:
<?php echo form_input('pass',$fpass['value']); ?>
</br>
<?php echo form_submit('update','Update!'); ?>
<?php echo form_close(); ?>
</br>
<?php echo anchor("mycontroller/list_users","List of Users");?>
</body>
</html>
___________________________________________________
<?php
class Mycontroller extends CI_controller
{
public function main()
{
$this->load->helper('form');
$this->load->helper('url');
$this->load->view('first_project');
if($this->input->post('sub'))
{
$this->load->model('mymodel');
$this->mymodel->data_insert();
}
}
public function list_users()
{
$this->load->helper('url');
$this->load->model('mymodel');
$data['query']=$this->mymodel->fetch_users();
$this->load->view('list_users',$data);
}
public function edit_users($edit_id)
{
$this->load->helper('form');
$this->load->helper('url');
$this->load->model('mymodel');
$query = $this->mymodel->get($edit_id);
$data['fid']['value'] = $query['user_id'];
$data['fuser']['value'] = $query['user_name'];
$data['fpass']['value'] = $query['user_pass'];
$this->load->view('edit_project',$data);
if($this->input->post('update'))
{
$this->mymodel->data_update();
}
}
}
?>
____________________________________________________
mymodel.php
<?php
class Mymodel extends CI_Model
{
function data_insert()
{
$this->load->database();
$data = array(
'user_name'=>$this->input->post('name'),
'user_pass'=>$this->input->post('pass'),
);
$this->db->insert('tbl_user',$data);
}
function fetch_users()
{
$this->load->database();
$query=$this->db->get('tbl_user');
return $query->result();
}
function get($id)
{
$this->load->database();
$query=$this->db->get_where('tbl_user',array('user_id'=>$id));
return $query->row_array();
}
}
?>
____________________________________________________________
first_project.php
<html>
<body>
<h1>MyFirst Form</h1>
<?php echo form_open('mycontroller/main'); ?>
<?php echo "Name"; ?>:
<?php echo form_input('name'); ?>
</br>
<?php echo "Password"; ?>:
<?php echo form_password('pass'); ?>
</br>
<?php echo form_submit('sub','Submit!'); ?>
<?php echo form_close(); ?>
</br>
<?php echo anchor("mycontroller/list_users","List of Users");?>
</body>
</html>
___________________________________________________________________
list_users.php
<html>
<body>
<h1>List of Users</h1>
<?php
echo "<table border='1'>";
echo "<tr>";
echo "<td>";
echo "Id";
echo "</td>";
echo "<td>";
echo "Name";
echo "</td>";
echo "<td>";
echo "Password";
echo "</td>";
echo "<td>";
echo "Edit";
echo "</td>";
echo "<td>";
echo "Delete";
echo "</td>";
echo "</tr>";
foreach ($query as $row)
{
echo "<tr>";
echo "<td>";
echo $row->user_id;
echo "</td>";
echo "<td>";
echo $row->user_name;
echo "</td>";
echo "<td>";
echo $row->user_pass;
echo "</td>";
echo "<td>";
echo anchor('mycontroller/edit_users/'.$row->user_id,'Edit');
echo "</td>";
echo "<td>";
echo "Delete";
echo "</td>";
echo "</tr>";
}
echo "</table>";
?>
<?php echo anchor("mycontroller/main","Back");?>
</body>
</html>
_______________________________________________________
edit_project.php
<html>
<body>
<h1>MyFirst Form</h1>
<?php echo form_open('mycontroller/main'); ?>
<?php echo "Id"; ?>:
<?php echo form_input('id',$fid['value']); ?>
</br>
<?php echo "Name"; ?>:
<?php echo form_input('name',$fuser['value']); ?>
</br>
<?php echo "Password"; ?>:
<?php echo form_input('pass',$fpass['value']); ?>
</br>
<?php echo form_submit('update','Update!'); ?>
<?php echo form_close(); ?>
</br>
<?php echo anchor("mycontroller/list_users","List of Users");?>
</body>
</html>
___________________________________________________
