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…
Scenario: Web app allows users to login to telegram >> ".session" sqlite file is created in server once logged in Problem: I now have full access to N number of users' telegram account Question: Is there a way for me(developer)…
Im used to sql queries but im little confused how to get data from my database from one column. Here the example to get all items(include all columns): // Read all items (journals) static Future<List<Map<String, dynamic>>> getItems() async { final…