What I'm doing is checking every Input tag if its empty or not, if not empty call the function, Im just wondering if there is a better way to do this $firstname = $this->request->getPost('firstname'); $lastname = $this->request->getPost('lastname'); $middlename = $this->request->getPost('middlename');…
I'm trying to come up with a good database design for this use case I have a table called expenses as follows id category_id item_id Problem item_id column wouldn't make sense if the expenses category is i.e. "Rent" It would…
I can't execute sql query, that has to rename the table to the same name as type, that already exists. I have not found any rules or comments about the same name for different things in postgres. CREATE TYPE ratings.processed_sport_bet…
Why is it not secure to connect a mobile app to a MongoDB database directly? I've been looking into creating an application with dotnet MAUI and using MongoDB as the database. I've seen in several threads online that it's a…
Since i've thousands of articles the bulk edit is impossible. It will require too much time and with 999 articles a time WordPress will already crash. So i thought about using a simple db query but i'm not sure how…
I have a custom wordpress theme for movie website. I want to add metadata tag for keywords but when i add this in WP theme Header its work for all my posts mean show these keywords for all posts that's…
so i want to create an event, which inserts values into Daily_Profit based on values from transaction. so I have used this syntax to get a unique value and hope there will be no duplication ALTER TABLE Daily_Profit ADD UNIQUE…
Undefined property: IlluminateDatabaseQueryBuilder::$title public function show(string $id) { $books = DB::table("book_tbls") ->where("author_tbls.id", "=", $id) ->where("author_tbls.id", "=", "book_tbls . author_id") ->where("categories.id", "=", $id) ->where("categories.id", "=", "book_tbls . category_id"); // $books = book_tbl::find($id); return view('books.show', compact('books')); } I am learning laravel for…
Hi hope you are having a good day ! ,I have a Laravel application where I'm using a custom primary key for my Ticket model. In the store method of my TicketController, I generate a random string for the ticketID…
I am currently using Redis as a vector database and was able to get a similarity search going with 3 dimensions (the dimensions being latitude, longitude, and timestamp). The similarity search is working but I would like to weigh certain…