Deleting database rows using cakephp

Question

I'm currently making a newsletter that let users subscribe and unsubscribe. Subscribing is a success but not on unsubscribing. can you help me out guys, here's my codes...

Controller

class AddsController extends AppController {
    public $helpers = array('Html','Form','Session','Flash');
    public $components=array('Session');

    public function index() {

        if($this->request->is('post')) //posting to db
        {
            $this->Add->create();
            $this->Add->save($this->request->data);
            $this->Flash->set('The user has been saved.', array('element' => 'success'));
            return $this->redirect('index'); //redirects to index.ctp
        }
    }

    /*public function delete($email = null) {
        if($this->request->is('post')) {
            $this->Add->exists($email) {
                $this->Add->delete($email);
                $this->Session->Flash('Unsubscribed');
                return $this->redirect('index');
            }
        }

    function delete(){ //delete html
        $email = $this->request->data['email'];
        if($this->Add->exists($email)){
            $this->Add->delete($email);
            $this->Session->Flash('Unsubscribed');
            //$this->Flash->set('Unsubscribed', array('element' => 'danger'));
            return $this->redirect('index');
        }
    }   */
    function delete() {
    $email = $this->request->data['email'];
    if($this->Add->exists($email)){
        $this->Add->delete($email);
        $this->Session->Flash('Unsubscribed');
        //$this->Flash->set('Unsubscribed', array('element' => 'danger'));
        return $this->redirect('index');
    }
}

}

View

<?php echo "<section>";
echo $this->Form->create('Add'); //<form > 'modelname'
echo "<label>E-mail:</label>";
echo $this->Form->input('email',array('label'=>false , 'placeholder'=>'your email')); //email input
echo $this->Form->submit('Subscribe'); //subscrib button
echo $this->Form->end();//</form>
echo "</section>";

echo "<section>";
echo $this->Form->delete('Add',array('action'=>'delete')); //<form > 
echo "<label>E-mail:</label>";
echo $this->Form->input('email',array('label'=>false , 'placeholder'=>'your email')); //email input
echo $this->Form->submit('Unsubscribe',array('action'=>'index'),array('style'=>'background:red'));
echo $this->Form->end();//</form>
echo "</section>";

My view is just "entering data into db and deleting existed data out the db Model

<?php

App::uses('AppModel' , 'Model');
class Add extends AppModel
{
    public $name = "Add";
    public $useTable = 'request';
    public $primaryket = 'id';
    public $useDbConfig = 'default';
}

db tablename: request; Just the delete row Thank you in advance!!!

without using another .ctp

Sir Mac
– Sir Mac

2017-09-20 07:01:51 +00:00
Commented Sep 20, 2017 at 7:01 — Sir Mac
– Sir Mac, Commented Sep 20, 2017 at 7:01

Ahmed Ginani · Accepted Answer · 2017-09-20 08:58:34Z

1

try to use below method (pass unique id of user) hope it will work:

$user = $this-> Add->findByEmail($email);
$this-> Add->delete($user['User']['id'], false);

answered Sep 20, 2017 at 8:58

Ahmed Ginani

6,6452 gold badges17 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Harshal Shinde · Accepted Answer · 2017-09-26 07:25:14Z

0

Alternative way

 $userId = $this->User->field('id', array('User.email' => $email));
 if($userId) {
  $this->User->id = $userId;
  $this->User->delete();
  $this->log('User of '.$email.' record deleted successfully');
  } else {
   $this->log('There is no record present of particular email = '. $email); 
  }

answered Sep 26, 2017 at 7:25

Harshal Shinde

437 bronze badges

1 Comment

Sir Mac Over a year ago

It actually work but I replaced the $this->log() into $this->set(). Still, thanks for the help Sir @Harshal Shinde

Collectives™ on Stack Overflow

Deleting database rows using cakephp

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related