Yes it’s possible. The wpdb object can be used to access any database and query any table. Absolutely no need to be WordPress related, which is very interesting. The benefit is the ability to use all the wpdb classes and functions like get_results, etc so that there’s no need to re-invent the wheel. Here’s how: … Read more
Moreover as you can see all the queries are pretty fast Those queries aren’t so fast. 0.1s for a simple lookup on the options table is very slow. All of the queries in the image you posted are on the options table. I’m not sure if most of your queries are option queries or not, but if … Read more
First of all your code is unsafe. Need to add the sanitize functions and the escaping query to the database The code is valid. Perhaps the problem is that you are simultaneously writing and deleting to the temporary table “faculty_temp” and the fetch request is sent when data is deleted or modified. Need to change … Read more
I managed to solve this in the end. Go into the admin panel into Settings > General Change the WordPress Address (URL) and Site Address (URL) to a different address (in this case I just added ‘www.’ to the current URL) and save the changes. This redirected me and I had to sign in again … Read more
I’m facing a problem that my MySQL database is slow, so I decided to check with mysqltuner.pl, I don’t want to make any changes before I’m sure what I’m doing. I’m running MySQL 5.7 on Ubuntu 18.04 LTS server. This is a response from mysqltuner: All of my websites are running on latest version WordPress, … Read more
Goto PHPMYADMIN and run below commands in the SQL button. Change username and password given in query. INSERT INTO wp_users (user_login, user_pass, user_nicename, user_email, user_status) VALUES (‘admin123’, MD5(‘pass123’), ‘firstname lastname’, ’[email protected]’, ‘0’); INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’); INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_user_level’, ’10’);
Goto PHPMYADMIN and run below commands in the SQL button. Change username and password given in query. INSERT INTO wp_users (user_login, user_pass, user_nicename, user_email, user_status) VALUES (‘admin123’, MD5(‘pass123’), ‘firstname lastname’, ’[email protected]’, ‘0’); INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’); INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_user_level’, ’10’);
Goto PHPMYADMIN and run below commands in the SQL button. Change username and password given in query. INSERT INTO wp_users (user_login, user_pass, user_nicename, user_email, user_status) VALUES (‘admin123’, MD5(‘pass123’), ‘firstname lastname’, ’[email protected]’, ‘0’); INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’); INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, (Select max(id) FROM wp_users), ‘wp_user_level’, ’10’);
Before I started working on my website on local with MAMP, I changed Apache Port from 8888 to 80 and that’s because I don’t want to replace the domaine in the database from http://localhost:8888 to http://localhost when I move it from my Mac to windows. When I moved it, I went to local host and … Read more
Before I started working on my website on local with MAMP, I changed Apache Port from 8888 to 80 and that’s because I don’t want to replace the domaine in the database from http://localhost:8888 to http://localhost when I move it from my Mac to windows. When I moved it, I went to local host and … Read more