{"id":3970,"date":"2019-03-28T17:55:38","date_gmt":"2019-03-28T12:25:38","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=3970"},"modified":"2019-03-29T17:48:53","modified_gmt":"2019-03-29T12:18:53","slug":"codeigniter-simple-add-edit-delete-view","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/codeigniter-simple-add-edit-delete-view\/","title":{"rendered":"CODEIGNITER: SIMPLE ADD, EDIT, DELETE, VIEW"},"content":{"rendered":"\n

Date :28\/03\/2019<\/strong><\/h4>\n\n\n\n

What is codeigniter?<\/h4>\n\n\n\n

Codeigniter is a php framework to develop the application. Therefore, it provides the many libraries for connecting to the database.<\/p>\n\n\n\n

Codeigniter simple Add, Edit, Delete, View<\/h4>\n\n\n\n

However, we create database and table.

Firstly, database name is considered to be as ‘form’.

similarly, creating a table named ‘register’.<\/p>\n\n\n\n

Database Config Settings<\/h4>\n\n\n\n

In order to connect with the database, the below instructions must be followed.<\/p>\n\n\n\n

The file is located at application\/config\/database.php.<\/p>\n\n\n\n

$active_group = 'default';\n$query_builder = TRUE;\n\n$db['default'] = array(\n\t'dsn'\t=> '',\n\t'hostname' => 'localhost',\n\t'username' => 'root',\n\t'password' => '',\n\t'database' => 'form',\n\t'dbdriver' => 'mysqli',\n\t'dbprefix' => '',\n\t'pconnect' => FALSE,\n\t'db_debug' => (ENVIRONMENT !== 'production'),\n\t'cache_on' => FALSE,\n\t'cachedir' => '',\n\t'char_set' => 'utf8',\n\t'dbcollat' => 'utf8_general_ci',\n\t'swap_pre' => '',\n\t'encrypt' => FALSE,\n\t'compress' => FALSE,\n\t'stricton' => FALSE,\n\t'failover' => array(),\n\t'save_queries' => TRUE\n);\n<\/pre>\n\n\n\n
 
Controller (application\/controllers\/Welcome.php) <\/h4>\n\n\n\n
Controller is a process which get the input request from user, communicates with Model and then loads appropriate Views file.<\/p>\n\n\n\n
In the below Controller class, we have functions for different tasks. <\/p>\n\n\n\n
<\/p>\n\n\n\n
public function list ()\n  {\n    $this->load->database();\n    $this->load->model('Insert_model');\n    $data['table_items']=$this->Insert_model->list();\n    $this->load->view('list_client', $data);\n  }\n\t\n  public function create (){\n\t\t$this->load->view('display.php');\n\t}\n\tpublic function add()\n\t{\n\t\t$this->load->model('Insert_model');\n\t\t$postData = array(\n\t\t'id' => $this->input->post('id'),\n    'first_name' => $this->input->post('firstname'),\n    'gender' => $this->input->post('gender'),\n    'habbies' => $this->input->post('hobbies'),\n    'state' => $this->input->post('state'),\n    'descrite' => $this->input->post('discription'));    \n    $insert = $this->Insert_model->insert($postData);\n  }\n  \n  public function retrive_update_data($id)\n  {\n    $this->load->model('Insert_model');\n    $da= $this->Insert_model->retrive_update_data($id);\n    $data['value1'] = $da->row();       \n    $this->load->view('update_view', $data);\n  }\n \n  public function update_data($id)\n  {\n    $this->load->model('Insert_model');\n    $postData = array(\n\t\t'first_name' => $this->input->post('firstname'),\n    'gender' => $this->input->post('gender'),\n    'habbies' => $this->input->post('habbies'),\n    'state' => $this->input->post('state'),\n    'descrite' => $this->input->post('describe'));    \n     $da= $this->Insert_model->update_data_model($id, $postData);\n  }\n\n   public function delete($id)\n  {\n    $this->load->model('Insert_model');\n    $delete = $this->Insert_model<\/pre>\n\n\n\n
Model (application\/models\/Insert_model.php) <\/h4>\n\n\n\n
 This class is responsible for interacting with database for data select, insert, update and delete purposes.<\/p>\n\n\n\n
 -> To  list() function fetches\/selects register items by $slug name.
 ->In addition to  insert() function insert new item to register  
-> In order to update_data_model() function either update register item. 
 -> Most importantly,  retrive_update_data()  function fetches register item  by it\u2019s ID
  ->Finally, delete() function delets any particular register item.<\/p>\n\n\n\n
  public function list($data = array())\n  {\n    $insert = $this->db->get('register')->result();\n    return $insert;\n  }\n\n  public function insert($data = array())\n\t{\n    $insert=$this->db->insert('register',$data);\n  }\n\t\n  public function retrive_update_data($id)\n  {\n   \t\t$this->db->select('*');\n       return $query = $this->db->get_where('register',array('id'=>$id));\n  }\n\n  public function update_data_model($id, $postData)\n  {\n      $this->db->where('id', $id);\n      $this->db->update('register', $postData);\n      echo \"data updated successfully\";\n  }\n\n  public function delete($id)\n  {\n    $this->db->where('id', $id);\n    $this->db->delete('register');\n    echo \"value deleted successfully\";\n  }\n\n}\n<\/pre>\n\n\n\n

Index View  (application\/views\/list_client.php) <\/h4>\n\n\n\n
This view file is called by list() function of our Controller class because it  will lists out all the register items.<\/p>\n\n\n\n
<body>\n  <center>\n<table border=\"1\">\n<thead>\n      <tr>\n          <th>ID<\/th>\n          <th>first-name<\/th>\n          <th>gender<\/th>\n          <th>hobbies<\/th>\n          <th>state<\/th>\n          <th>discription<\/th>\n          <th>Delete<\/th>\n      <\/tr>\n    <\/thead>\n    <tbody>\n       <?php foreach($table_items as $row){ ?>\n         <tr>\n            <td><?php echo $row->id; ?><\/td>\n                <td><?php echo $row->first_name; ?><\/td>\n                <td><?php echo $row->gender; ?><\/td>\n                <td><?php echo $row->habbies; ?><\/td>\n                <td><?php echo $row->state; ?><\/td>\n                <td><?php echo $row->descrite; ?><\/td>\n<td><a href=\"<?php echo site_url('Welcome\/delete\/'.$row->id);?>\">Delete<\/a><\/td>\n<td><a href=\"<?php echo site_url('Welcome\/retrive_update_data\/'.$row->id);?>\">Edit<\/a><\/td><\/tr>\n  <?php } ?>\n<\/tbody>\n<\/pre>\n\n\n\n
Add View(application\/views\/add_new.php)<\/h4>\n\n\n\n
This view file is called by create() function of our Controller class and then most certainly, it will show the new form to add item in register.<\/p>\n\n\n\n
<body>\n\n<form role=\"form\" method=\"post\" action=\"<?php echo site_url('Welcome\/add');?>\">\n First name:<br> <input type=\"text\" name=\"firstname\">\n <br>\n gender<input type=\"radio\" name=\"gender\" value=\"male\" checked> Male<br>\n <input type=\"radio\" name=\"gender\" value=\"female\"> Female<br>\n <input type=\"radio\" name=\"gender\" value=\"other\"> Other\n <br>\n Hobbies<br><input type=\"checkbox\" name=\"hobbies\" value=\"dancing\">dancing<br>\n<input type=\"checkbox\" name=\"hobbies\" value=\"dancing\">playing<br>\n <br>\nState<br> <input type=\"text\" name=\"state\" value=\"\">\n <br>\n  Discription<br><input type=\"text area\" name=\"discription\">\n<\/textarea>\n <br>\n\n <input type=\"submit\">\n<\/form>\n\n<\/body>\n<\/pre>\n\n\n\n
Update View 
 (application\/views\/update_view.php) 

<\/h4>\n\n\n\n
This view file is called by retrive_update_data() function of our Controller class. It show the form with user data.<\/p>\n\n\n\n
<body>\n\t<form role=\"form\" method=\"post\" action=\"<?php echo site_url('Welcome\/update_data\/' .$value1->id);?>\">\n\n<label> First name:<\/label><br> <input type=\"text\" name=\"firstname\" value=\"<?php echo $value1->first_name;?>;\">  <br>\n <label> Gender:<\/label><br> <input type=\"text\" name=\"gender\" value=\"<?php echo $value1->gender;?>;\">  <br>\n\n\n<label> Hobbies:<\/label><br> <input type=\"text\" name=\"hobies\" value=\"<?php echo $value1->habbies;?>;\">  <br>\n\nstate<br> <input type=\"text\" name=\"state\" value=\"<?php echo $value1->state;?>;\">  <br>\n  Discription<br><input type=\"text area\" name=\"discription\" value=\"<?php echo $value1->descrite;?>;\">  <br>\n<button> Submit<\/button>\n<\/form><\/pre>\n\n\n\n
 Thanks for using pheonix solutions. <\/p>\n\n\n\n
You find this tutorial helpful? Share with your friends to keep it alive.<\/p>\n","protected":false},"excerpt":{"rendered":"
Date :28\/03\/2019 What is codeigniter? Codeigniter is a php framework to develop the application. Therefore, it provides the many libraries […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1022],"tags":[506,601,600,507],"class_list":["post-3970","post","type-post","status-publish","format-standard","hentry","category-web-architecture","tag-delete","tag-insert","tag-list","tag-update","psol-cat-web-architecture"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/phn2x7-122","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/3970","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=3970"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/3970\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=3970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=3970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=3970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}