I am using SQlite3 in Visual Studio code. My goal is to create a table within a database and then import data in that table. The code works fine except for when there is a space involved in the header.…
I have a hosted web app made with django and react. now i want to implement a system like- one user request for posting a blog at a specific time specific date. and on that day the post is posted…
I have a .sqlite file in a local folder. I would like to update all URLs in this SQLITE file across all tables, indicies, and rows. What is the best way to do this? In a regular sql file I…
I have a table and I want to update it, but theres always a problem everytime i update, it says its null or request column not found 0, someone can help me? Any idea? Update controller public function update(Request $request,…
I have joined 2 databases, what i want is to get the total value/sum of these 2 multiplied column: Example on the database: Price Quantity 100 1 110 2 120 3 in my query in laravel- i got the total,…
I have a table for the invoice and it has the primary key which is id, and for invoice details the foreign key is invoice_id. What I want is during saving the primary key on the invoice, it would also…
I'm working on an api and a lot of it works great, but for some reason I cannot update the members. This is the route: Route::prefix('member')->group(function () { Route::post('login', [AppHttpControllersApiMemberAuthController::class, 'login']); Route::post('register', [AppHttpControllersApiMemberAuthController::class, 'register']); Route::middleware('auth:member_api', 'member.auth.api')->group(function () { Route::get('/', [AppHttpControllersApiMemberAuthController::class,…
My react-native seems to be very slow after I added the 2 useEffects to get data from my sqlite database. It makes the app so slow that it barely responds to user inputs. How can I resolve this issue? import…
I'm a beginner that trying to build an health app for my school project The program runs fine when I use Android 11 (API 30). The error happened when I use Android higher than 11 (API 30+). The code where…
I have created a database schema and now I need to transform it into code for a project in laravel. I installed filament panel and created a filament user for the admin login : php artisan make:filament-user now when I…