There is a controller method: public function addEducation(AddPatientEducationRequest $request) { dd($request->all()); $state = UserEducation::create($request->validated()); } The dd() returns me an array that I need to insert into db: array:1 [ // appHttpControllersApiPatientController.php:99 "education" => array:1 [ 0 => array:5 […
As far as I know, If I want to create a new database, normally fistly I have to create and switch on a server (in this case a local server in my computer), Secondly I connect my RDBMS (MySql) to…
I have created an entity tblPerson and from this entity I need to get the bGroup of t.adminID and the bGroup from the d.personID. I have tried the below query but it's not returning anything. ` SELECT t.adminID, p.firstName, p.lastName,…
How can I improve the following query's performance while the server is loaded? I've created a combo index and removed the index from the table because it's not picking it up, but is there another way to do it? ,…
I am working with a JDBC and am trying to figure out how to dynamically create queries - which is proving to be a rather challenging feat. What input can I put in a SQL query to have it return…
I am making an HTML form using Bootstrap 4 that contains three multiple-choice questions, allowing the reader to choose more than one answer using checkboxes. Here is an example of one question in the form. <div class="container"> <form action="/survey/insert.php" class="was-validated"…
While inserting data into Mysql I have encountered the following error: "Add [0] to fillable property to allow mass assignment on [AppModelsposts]" Here is my code: public function update(Request $request, $id){ posts::where('id', $id)->first()->update([ $this->validate($request, [ 'title' => 'required|max:25', 'description' =>…
am quite new to flutter and my code is pretty much a mess but can anyone explain why db. update doesn't work, whenever I try to update it throws this error "error when trying to update"(https://i.stack.imgur.com/4cCdt.png) "code"(https://i.stack.imgur.com/yDoIl.png) "UI" (https://i.stack.imgur.com/HkahR.png) all…
I'm trying to add the numbers from the MongoDB database. meal_data = Data.objects.filter(year= se_year, month= se_month, category = 'Meal') meal_amt = 0 for i in meal_data: id = i.id m_amount_data = Data.objects.get(id = id) meal_amt += m_amount_data.amount TypeError: unsupported operand…
Schema for Event const eventSchema = new mongoose.Schema( { title: { type: String, required: true }, schedule: { type: Date, required: true }, organizer: { type: mongoose.Schema.Types.ObjectId, ref: "user", required: true }, }, { timestamps: true } ); Schema for…