Home / Questions / 174176
Accepted
Andrés Vélez
Asked: 2020-06-20 07:32:10 +0800 CST 2020-06-20 07:32:10 +0800 CST

Create a query function for data existence in a generic way

  • 772
public function consultar_existencia($campo) {
        if ($this->request->is('post')) {
            $this->autoRender = false;
            $this->layout = false;
            $this->loadModel('Client');
            $existe = $this->Client->find('count', array(
                'conditions' => array($campo => $this->request->data('Field')['Data'])));
        }
        echo json_encode($existe);
    }

Hi, I have this function in the controller, I'm going to use it to check if a data already exists in the database, the idea is to make some changes, but I've had some problems, I'm going to show you:

public function consultar_existencia($campo)//field is for the field that is going to be compared in the DB, and the idea would also be to send the model to the one that is going to be consulted by adding something like $modelin the parameters, and in this line it would be loaded like this: $this->loadModel($model);, and through there I think that We would go well, the problem comes in this line:

$existe = $this->Client->find('count', array(
                    'conditions' => array($campo => $this->request->data('Field')['Data'])));

since in that line a specific model is called, and my question is, is there any way to tell it to consult the currently loaded model? Something like

$this->getLoadModel()->find('count',  array(
                    'conditions' => array($campo => $this->request->data('Field')['Data'])));
mvc

1 Answers

  1. Best Answer

    You can use the famous PHP variable Variables , in the documentation we found that variable properties exist and can be used in this way:

    $a = 'propiedad';
$this->{$a};

    Which would be equivalent to doing this:

    $this->propiedad;

    Since you said you already have the variable $model, you can do the following

    $this->{$model}->find('count',  array(
                'conditions' => array($model . '.' . $campo => $this->request->data('Field')['Data'])));
    • 0