Welcome Guest, Not a member yet? Register   Sign In
Delete data by a form field
#1

(This post was last modified: 11-13-2017, 06:02 PM by prezli.)

I want to delete email addresses from my database via a form field. If the email address in the field equals to the email address in the database, it (the row) gets deleted. I'm a bit confused how to do it.

View:
Code:
<form action="Controller/delete" method="post" id="form" name="form">
   <input id="email" name="email" type="email">
   <input name="submit" id="submit" type="submit" value="Unsubscribe">
</form>

<?php

if (isset($_GET['submit'])) {
 $email=$_POST['email'];

foreach($select->result() as $row){
 $email=$row->email;

 if($email==$row){
   delete($row);
 }
}
}
?>

Model:
Code:
function select() {
 $this->db->select("email");
 $this->db->from("users");
 $query=$this->db->get();
 return $query;
}

function delete($email) {
 $this->db->where("email", $email);
 $this->db->delete("users");
}

Controller:
Code:
public function index()
{
   $this->load->model('users');

   $data["select"]=$this->users->select();
   $this->load->view("view", $data);
}

public function delete(){
  $this->load->model('users');
  $this->users->delete($email);
  redirect(Controller/index);  
}
Reply


Messages In This Thread
Delete data by a form field - by prezli - 11-13-2017, 04:51 PM
RE: Delete data by a form field - by sujith - 11-14-2017, 01:15 AM



Theme © iAndrew 2016 - Forum software by © MyBB