passing id to link?

[eluser]slothdog[/eluser]
I want to delete an entry from the database by its id number. Ive got the model to do the delete working when I manually edit the function and put in the number for the id to delete.

for example:

#1 BLHABLH edit | delete

how do i get the id #1 into the link to tell the delete function what to delete?

thanks.


model:

Code:

function delete_by_pkey($idField)
{
      
      // LOAD DATABASE
      $this->load->database();
      
      // SELECT
      $this->db->where('id', $idField);

      // DO THE DELETE
      $this->db->delete('registration');

      return true;

   }

excerpt from controller:

Code:

function deletecollective()
    {
    // LOAD DATABASE MODEL
    $this->load->model('registrationmodel');
    
    // QUERY MODEL
    $data['query'] = $this->registrationmodel->delete_by_pkey(HERE IS WHERE I NEED TO GET THE ID#);
    
    // DISPLAY DATA
    $this->load->view('viewdeletecollective');
    
    }

view:

Code:

<? echo "Deleted"; ?>

[eluser]manilodisan[/eluser]

Code:

$data['query'] = $this->registrationmodel->delete_by_pkey($this->uri->segment(3));

I've put uri segment 3. You should put there whatever corresponds to the id of your item.

And the link:

Code:

<a href="&lt;?= site_url ( 'controller/method/' . $id ) ?&gt;">click</a>

[eluser]zimco[/eluser]
I can't tell how you're creating the links but i did something similar in a view like:

Code:

echo ('<a href="'. site_url('controller/function/'.$results[$i]['your_id']) .'">' . $results[$i]['your_id']) . '</a>');

Then do the $thedeleteid = $this->uri->segment(3, 0); thing in your delete function to know which one it is you want to delete like mailodisian already mentioned above; his post beat mine.

[eluser]slothdog[/eluser]
[quote author="manilodisan" date="1224711998"]

Code:

$data['query'] = $this->registrationmodel->delete_by_pkey($this->uri->segment(3));

I've put uri segment 3. You should put there whatever corresponds to the id of your item.

And the link:

Code:

<a href="&lt;?= site_url ( 'controller/method/' . $id ) ?&gt;">click</a>

[/quote]

i tired that using the anchor() and it sent it to a function in the class with the number that didnt exist so i got a 404 error. is there a difference between using <a > and using the anchor() to make a link?

[eluser]manilodisan[/eluser]
No. I tend to write html and not php to echo some html That's the only difference.

[eluser]slothdog[/eluser]
thanks that worked!

[eluser]Velo Studios[/eluser]
Should you not be using a form to delete?

Is it not best practice to use a form?

$data['query'] = $this->registrationmodel->delete_by_pkey($_POST['id']);