Laravel MySQL Check if there is a record

Question

Laravel MySQL Check if there is a record

Navigation

#1 by (1 votes)
#2 by (0 votes)
#3 by (0 votes)

0

Could someone help me to correct my laravel code so that before inserting a new record, check if that record exists? (to avoid duplicates) that is, if there is a record equal to the one to be inserted, do not allow registration, otherwise allow it to be inserted.

It is worth mentioning that what I want to validate is a foreign column and it arrives as a value in a formula of formulurio. So far I have the following:

    $ciclo=$request->idCiclo; //Guardo el valor que recibo del formulario

    $existencia = DB::table('planespago')   //realizo la sentencia para saber si existe
    ->select('idCiclo')
    ->where('idCiclo', '=', $ciclo);

   if ($existencia = $ciclo) {   //aqui valido si son iguales en el campo de la db y 
                                  lo que llego del formulario
       return json_encode('no puedes registrar otro');

    }else{

      return  json_encode('creado');

    }

But the validation does not do me good and it passes directly that it is true even though I choose a value that does not exist

mysql laravel

asked by Juan Antonio 12.06.2018 в 19:41

source

3 answers

LINQ query collects the values in keyValuePair object but then I can not save them all in the list Detect click on li, not on div

score 1 · Answer 1

Possibly due to typographical errors.

First in your query you need to use the get method to bring the data

$existencia = DB::table('planespago')
    ->select('idCiclo')
    ->where('idCiclo', '=', $ciclo)
    ->get();

And in your validation you are using only a = to make your condition, when you should use ==

if ($existencia == $ciclo)

If it is not due to that, it is possible that in your conditional you are comparing badly the variables and you should change to this:

if ($existencia->idCiclo == $ciclo)

The other way of solution is to change the condition to:

if(count($existencia) >= 1)

score 0 · Answer 2

You save the value that $ request brings in the position "idCiclo", perfect keep in mind that this is an INT therefore you must compare it with a data that is of a similar type.

$ciclo=$request->idCiclo;

We summarize this line of code a little by making the query directly to the model (with the method find () it is not necessary to say get ()), keep in mind that here an OBJECT of the PlanesPago class is returned.

$existencia = PlanesPago::find($ciclo);

This is where you have the error, you are comparing a variable of type INT with a variable of type PlanesPago

if ($existencia = $ciclo)

The correct way would be

if($exitencia->idCiclo == $ciclo)

I would even say that you can implement the "===" operator since they are the same type.

I hope this is helpful.

score 0 · Answer 3

0

It's simpler than that, we have a helper that returns a Boolean

DB::table('planespago')->where('idCiclo', $idCiclo)->exists();

answered by 14.06.2018 в 17:06