I have a site based on WooCommerce Memberships with the Teams for WooCommerce Memberships extension. 95% of the time it copes very well despite a large user base (>70,000 users). We get about 10k daily visits with response times under…
I have two tables Users and Get_cal like below : Users id_user(pk) com 1004 700 1005 700 1006 700 1010 701 1011 701 1012 701 1013 701 1014 800 1015 800 1016 800 1017 800 Get_cal id_user(fk) status 1004 ABAN…
I am trying to connect my Web API build in asp.net 6 with MySql and I am having a lot of trouble My Service looks like this builder.Services.AddDbContext<TicketApiContext>(options => options.UseMySQL("CONNECTION_STRING")); and my Database Context like this. using Microsoft.EntityFrameworkCore; namespace VelocityNetAPI.Data…
i have problem when executed this code in CodeIgniter it deletes all records not only the max value record although it works fine if i execute Sql query in phpmyadmin what wrong in PHP code my code: controller: $this->data->del_data_query('DELETE FROM…
We have a high traffic server running mysql. This database has run fine for years with no significant spikes in traffic or changes to the database but recently Mysql CPU consumption has spiked to a consistent 600%. We don't see…
I have the following table called employees: num_employee name 001 George 002 Mary And the table called records: num_employee date 001 2021-12-01 002 2021-12-01 001 2021-12-02 002 2021-12-01 001 2021-12-03 002 2021-12-06 In the example above, both employees attended on…
I have table name wp_posts and in post_content column there is a description of my posts (in HTML). I would like to have a query that searches in post_content column and selects the tag starting with <div class or no…
I have a form that updates columns in a database table on submit of a form via ajax. Everything works great, the database table columns get the information however once the browser is refreshed the information is removed from the…
Using AWS Linux 2, on my wp site this error "Error establishing a database connection", I believe I was hacked via the wp blog page and the entire site is disabled. Using MySQL: $ sudo systemctl start mysqld Job for…
I don't know if I'm so stupid or my laravel is broken, BUT, here it is. That's my api.php: Route::get('/airport', [AppHttpControllersAirportsController::class, 'index']); Route::post('/airports', [AppHttpControllersAirportsController::class, 'create']); Route::get('/registrator', [AppHttpControllersRegistrationController::class, 'index']); The airport and airports work great. It's add all data in db…