Check if record exists in database using BuildRules (CakePHP 3)

Question

I want to check if the ID passed by the user using a HTTP request exists in another table in cakephp. Right now, I tried using :

public function buildRules(RulesChecker $rules)
{
    $rules->add($rules->existsIn('id_venue', 'venues'));
    return $rules;
}

But It doesn't seems to work. This rule is in a reservation table, in this table I have a column called id_venue, I have another table called Venues which has a primary key called id_venue too.

public function initialize(array $config)
{
    parent::initialize($config);
    $this->table('reservations');
    $this->primaryKey('id_reservation');
    $this->hasOne('Venues');
}

I've associated my Reservations table with my Venues table

Thanks for helping.

score 0 · Accepted Answer · edited May 23 '17 at 12:00

0

Did't completly understand the type of call you need but if you just have to check if particular row already exist into the DB you can use exists

$table = TableRegistry::get('Venues');
$conditions = ['id' => 15];
$exists = $table->exists($conditions); //returns true or false

This kind of question was already answered: Check if record exists in CakePHP3

edited May 23 '17 at 12:00

Community

1
1

answered Feb 12 '17 at 23:54

David A.

91
4

That's good but I have to check the id the user pass in the HTTP request using curl for example, in your code the id is hardcoded. – Jonathan Bouchard Feb 13 '17 at 01:41

score 0 · Answer 2 · answered Feb 13 '17 at 03:55

0

The first parameter to existsIn is an array, and I believe the second is case sensitive. Try

$rules->add($rules->existsIn(['id_venue'], 'Venues'));

answered Feb 13 '17 at 03:55

Greg Schmidt

5,010
2
14
35

Check if record exists in database using BuildRules (CakePHP 3)

2 Answers2