Scribd Logo
Upload

Welcome to Scribd!

  • 36 views

    CI Update Delete

    Uploaded by

    angkatan pertama
    This document outlines how to update and delete data from a category table (tblcategory) in CodeIgniter. It involves: 1. Creating a model (CateModel) to interact with the database 2. Adding a form to a view (cate_added) to list categories from the table 3. Adding functions to a controller (Category) to save, edit, update, and delete categories 4. Creating an edit view (cate_edit) to populate the edit form with existing category data

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    CI Update Delete

    Uploaded by

    angkatan pertama
    36 views5 pages
    This document outlines how to update and delete data from a category table (tblcategory) in CodeIgniter. It involves: 1. Creating a model (CateModel) to interact with the database 2. Adding a form to a view (cate_added) to list categories from the table 3. Adding functions to a controller (Category) to save, edit, update, and delete categories 4. Creating an edit view (cate_edit) to populate the edit form with existing category data

    Original Title

    CI-update-delete

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document outlines how to update and delete data from a category table (tblcategory) in CodeIgniter. It involves: 1. Creating a model (CateModel) to interact with the database 2. Adding a form to a view (cate_added) to list categories from the table 3. Adding functions to a controller (Category) to save, edit, update, and delete categories 4. Creating an edit view (cate_edit) to populate the edit form with existing category data

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    36 views5 pages

    CI Update Delete

    Uploaded by

    angkatan pertama
    This document outlines how to update and delete data from a category table (tblcategory) in CodeIgniter. It involves: 1. Creating a model (CateModel) to interact with the database 2. Adding a form to a view (cate_added) to list categories from the table 3. Adding functions to a controller (Category) to save, edit, update, and delete categories 4. Creating an edit view (cate_edit) to populate the edit form with existing category data

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5

    How to Update and Delete Data from tblcategory

    1. Create Model : cateModel.php


    <?php
    defined('BASEPATH') OR exit('No direct script access allowed');

    class CateModel extends CI_Model {


    public function __Construct()
    {
    parent::__construct();
    }
    public function gettable(){
    $query=$this->db->get('tblcategory');
    return $query->result();
    }
    function getonerow($id){
    $this->db->where('cate_id',$id);
    $query=$this->db->get('tblcategory');
    return $query->row();
    }
    }
    2. Edit code in view to add list of category(table of category) : cate_added.php

    <html>
    <head><title>form add Category</title>
    </head>
    <body>

    <form method="post" action="<?php echo site_url('Category/savedata');?>"


    enctype="multipart/form-data">
    <table border=0>
    <tr><td>Brand</td>
    <td><input type="text" name="txtname"></td></tr>
    <tr><td>Icon </td>
    <td><input type="file" name="img1"></td></tr>
    <tr><td>Detail</td>
    <td><input type="text" name="txtdec"></td></tr>
    <tr><td colospan=2>
    <input type="submit" name="submit" value="Add"></td></tr>
    </table>
    </form>
    <table border=1>
    <?php
    foreach($this->m->gettable() as $row){
    echo"<tr>
    <td>$row->cate_id</td>
    <td>$row->cate_name</td>
    ";
    ?>
    <td><img src="../../uploads/<?php echo $row->img ; ?>" width=50>
    <td><?php echo $row->dec ; ?></td>

    <?php
    echo"
    <td><a href='".site_url('Category/edit/'.$row->cate_id)."'>Edit</a> |
    <a href='".site_url('Category/delete/'.$row-
    >cate_id)."'>Delete</a>
    </td>
    ";
    }
    echo"</tr>";
    ?>
    </table>

    </body>
    </html>
    3. Add function in controller : category.php
    <?php
    defined('BASEPATH') OR exit('No direct script access allowed');

    class Category extends CI_Controller {


    public function __Construct()
    {
    parent::__construct();
    $this->load->helper(array('form', 'url'));
    $this->load->model('CateModel', 'm');
    }

    public function index()


    {
    $this->load->view('cate_added', array('error' => ' ' ));
    }
    public function savedata()
    {
    $config['upload_path'] = './uploads/';
    $config['allowed_types'] = 'gif|jpg|png';
    $config['max_size'] = 100;
    $config['max_width'] = 1024;
    $config['max_height'] = 768;
    $config['file_name'] = $_FILES['img1']['name'];

    $this->load->library('upload',$config);
    $this->upload->initialize($config);

    $uploadData = $this->upload->data();
    $picture = $uploadData['file_name'];
    if (!$this->upload->do_upload('img1'))
    {
    $error = array('error' => $this->upload->display_errors());

    $this->load->view('cate_added', $error);
    }
    else
    {
    $data=array(
    'cate_name'=>$this->input->post('txtname'),
    'img'=>$picture,
    'dec'=>$this->input->post('txtdec')
    );
    $this->db->insert('tblcategory',$data);
    redirect('Category/index');
    }
    }

    function edit($id){
    $row=$this->m->getonerow($id);
    $data['r']=$row;
    $this->load->view("cate_edit",$data);

    function update(){
    $id=$this->input->post('id');
    $name=$this->input->post('txtname');
    $dec=$this->input->post('txtdec');

    $config['file_name'] = $_FILES['img1']['name'];

    $this->load->library('upload',$config);
    $this->upload->initialize($config);

    $uploadData = $this->upload->data();
    $picture = $uploadData['file_name'];
    $data = array(
    'cate_name'=>$name,
    'img'=>$picture,
    'dec'=>$dec
    );
    $this->db->where('cate_id',$id);
    $this->db->update('tblcategory',$data);
    redirect("Category/index");
    }

    function delete($id){
    $id=$this->db->where('cate_id',$id);
    $this->db->delete('tblcategory');
    redirect("Category/index");

    }
    4. Go to view folder create file’s name cate_edit.php
    <html>
    <head><title>form add Category</title>
    </head>
    <body>

    <form method="post" action="<?php echo site_url('Category/update');?>"


    enctype="multipart/form-data">
    <table border=0>
    <tr><td>id</td>
    <td><input type="text" name="id" value="<?php echo $r-
    >cate_id; ?>"></td></tr>
    <tr><td>Brand</td>
    <td><input type="text" name="txtname" value="<?php echo $r-
    >cate_name; ?>"></td></tr>
    <tr><td>Icon </td>
    <td><input type="file" name="img1"></td></tr>
    <tr><td>Detail</td>
    <td><input type="text" name="txtdec" value="<?php echo $r-
    >dec; ?>"></td></tr>
    <tr><td colospan=2>
    <input type="submit" name="submit" value="update"></td></tr>
    </table>
    </form>
    <table border=1>
    <?php
    foreach($this->m->gettable() as $row){
    echo"<tr>
    <td>$row->cate_id</td>
    <td>$row->cate_name</td>
    ";
    ?>
    <td><img src="../../uploads/<?php echo $row->img ; ?>" width=50>
    <td><?php echo $row->dec ; ?></td>

    <?php
    echo"
    <td><a href='".site_url('Category/edit/'.$row->cate_id)."'>Edit</a> |
    <a href='".site_url('Category/delete/'.$row-
    >cate_id)."'>Delete</a>
    </td>
    ";
    }
    echo"</tr>";
    ?>
    </table>

    </body>
    </html>

    You might also like