Welcome Guest, Not a member yet? Register   Sign In
Help deleting a record from my database.
#1

[eluser]snoopy[/eluser]
Hello there im new to codeigniter and MVC and im tryng to create a code to delete a record in my database for several days now here is my actual code:

model :
Code:
function delete($id)
    {
      $this->db->where('sale_id', $id);
      $this->db->delete('phppos_sales');
      
      return $this->db->affected_rows();    }

controller :
Code:
function apaga_venda($sale_id)
    {
     $sale_id = $this->input->post('sale_id');
     $this->load->model('sale');
    
     if ($this->sale->delete($sale_id))
     {
     redirect('vendas');
    
     }  else { die('Erro');  }

view :
Code:
<ul>

&lt;?php foreach($vendas as $v){

echo anchor('vendas/apaga_venda/$v->sale_id', 'Apaga').'Data da Venda: '.$v['sale_time']. " / ".'ID do Cliente: '.$v['customer_id']. " / ".' ID da Venda: '.$v['sale_id']."<br />";

}
?&gt;

</ul>

Thanks in advance for the help!
ps: im desperate =)


Messages In This Thread
Help deleting a record from my database. - by El Forum - 12-19-2010, 02:11 PM
Help deleting a record from my database. - by El Forum - 12-19-2010, 02:59 PM
Help deleting a record from my database. - by El Forum - 12-19-2010, 03:09 PM
Help deleting a record from my database. - by El Forum - 12-19-2010, 03:12 PM
Help deleting a record from my database. - by El Forum - 12-19-2010, 03:29 PM
Help deleting a record from my database. - by El Forum - 12-19-2010, 09:14 PM



Theme © iAndrew 2016 - Forum software by © MyBB