CODEWITHSUNDEEP
codeigniter
Ricky Guinta
Ricky Guinta

Reputation: 23

CodeIgniter delete row from database

I'm trying to delete data from my database

Here's my code:

VIEW

<table border="1" class="table">
    <tr>
        <th>No</th>
        <th>Nama Depan</th>
        <th>Nama Belakang</th>
        <th>TTL</th>
        <th>Email</th>
        <th>Keterangan</th>
    </tr>
    <?php 
    $i = 0;
    foreach ($dataMember as $result) { ?>
    <tr>
        <td><?php echo ($i+1); ?></td>
        <td><?php echo $result['namaDepan'];?></td>
        <td><?php echo $result['namaBelakang']; ?></td>
        <td><?php echo $result['TTL']; ?></td>
        <td><?php echo $result['email']; ?></td>
        <td>
        <a href="<?php echo base_url() . "BelajarBerhadiah/hapusMember/" . $result->email; ?>"><button>Delete</button></a>  
        </td>
        
    </tr>
    <?php $i++; } ?> 
</table>

MODEL

public function Hapusdata($id){
    $this->db->where('email', $id);
    $this->db->delete('daftar');
}

Controller

public function hapusMember()
    {           
        $this->load->model('Member'); 
        $this->load->helper('url');
        $id = $this->uri->segment(3);
        $this->Member->Hapusdata($id);
        redirect (site_url('Belajarberhadiah/halaman_admin'));
    }

and the problem is i get

Severity: Notice

Message: Trying to get property of non-object

Filename: views/halaman_dMember.php

Line Number: 105

What should i do?

Upvotes: 0

Views: 330

Answers (1)

Hina
Hina

Reputation: 11

Please write href for delete tag as below:

<a href ="<?php echo site_url('BelajarBerhadiah/hapusMember/1');?>">delete</a>

Also be sure that the column[email] you have used for where condition in controller is the correct one. Because column name is "email" in where condition and you are passing an integer value.

Upvotes: 1

Related Questions