unlink photo

[eluser]Narkboy[/eluser]
Ok - I haclked a little because I never get results as objects. Always seems to work faster with arrays unless you need the oop.

So:

Code:

function remove_photo($photo_id) {
    $this->db->where('id_pictures',$photo_id);
    $query = $this->db->get('pictures_table_name');

    if ( $query->num_rows() != 1) {
        // No record with this id:
        return FALSE;
    }

    $result = $query->result_array();
    $result = $result[0]; // Remove the extra level; we don't need it.

    // Now unlink as required:
    unlink( base_url() . $result['thumb'] );
    unlink( base_url() . $result['imagem'] );

    // Now delete from the db:
    $this->db->delete('table_name',array('id_pictures' => $photo_id);

    // Now you're done, either confirm or just trust:
    return TRUE;
}

Is how I'd do it.