I also would vote for creating a short code. The shortcode code could pull data from a database/table, and ‘build’ the text you want with values from the table. Lots of googles on how to build shortcodes – check those out, vs me putting some sample code here. You would put the shortcode function in … Read more
Updating database with CSV file and Cron job
Apparently the right way to do this is to get the suffix returned by your custom page that normally displays the table and use it to hook into the page load before any admin content is rendered. add_action(‘admin_menu’, function() { $page_hook_suffix = add_submenu_page( # or related function … function() { # content of table page … Read more
Try to create a new page and put [elh-db-insert] as content. If you want to use [insert-into-db] as your shorcode, you should change add_shortcode(‘elh-db-insert’, ‘elh_insert_into_db’); to add_shortcode(‘insert-into-db’, ‘elh_insert_into_db’);
You most likely have invalid URLs in the database, however, it’s also entirely possible to have a hard-coded URL in somewhere in the theme or perhaps a plugin, or even .htaccess. You could always search your entire database for the URL, and make adjustments manually. However, please note that if you make any adjustments to … Read more
Note that you may need to use WPDB::prepare() to prevent against SQL injections. Although, it might be arguable in your specific case… // If the query does not work, ensure the table name is correct… $table = $wpdb->prefix . ‘SaveContactForm7_1’; $reservations = $wpdb->get_results( $wpdb->prepare( “SELECT * FROM $table WHERE user = %s”, $username ) ); … Read more
WordPress adding item to menu deletes post metadata
I solved my problem by asking for help directly at CLEARDB. I sent them my identifiers and they did the necessary. It is a connection problem.
Duplicate WP Migration affecting site on separate domain?
It is relatively rare for WP to have query performance issues on a small to moderately sized site: The queries it typically runs are reasonable (not perfect, but reasonable). A lot of things queried are aggressively cached within page load, and persistently with object cache available. While you certainly can throw enough code at it … Read more