Ad
Why Laravel's Queries Return Nvarchar Instead Of Int?
i have thoses lines of code :
$idprat = Praticien::select('ID_Praticien')->where('NOM',$request->input('ID_Praticien'))->get();
$mission->ID_Praticien = $idprat;
and i have this error message :
la valeur nvarchar '[{"ID_Praticien":1}]' en type de données int
why it's return me nvarchar on a int column on my database ? i tried to make it correct like this :
$idprat = Praticien::select('ID_Praticien')->where('NOM',$request->input('ID_Praticien'))->get()->first();
and i tried with :
$mission->ID_Praticien = (int)$idprat;
but doesnt work
i just selected ID_Praticien value not an array xD
thanks for help ;)
Ad
Answer
Try this:
$idprat = Praticien::select('ID_Praticien')->where('NOM',$request->input('ID_Praticien'))->get();
$mission->ID_Praticien = $idprat[0]->ID_Praticien;
or
$idprat = Praticien::select('ID_Praticien')->where('NOM',$request->input('ID_Praticien'))->first();
$mission->ID_Praticien = $idprat->ID_Praticien;
Ad
source: stackoverflow.com
Related Questions
- → "failed to open stream" error when executing "migrate:make"
- → October CMS Plugin Routes.php not registering
- → OctoberCMS Migrate Table
- → OctoberCMS Rain User plugin not working or redirecting
- → October CMS Custom Mail Layout
- → October CMS - How to correctly route
- → October CMS - Conditionally Load a Different Page
- → Make a Laravel collection into angular array (octobercms)
- → In OctoberCMS how do you find the hint path?
- → How to register middlewares in OctoberCMS plugin?
- → Validating fileupload(image Dimensions) in Backend Octobercms
- → OctoberCMS Fileupload completely destroys my backend
- → How do I call the value from another backed page form and use it on a component in OctoberCms
Ad