i think you mean updating permalinks and its in wp_options table go to your host control panel (cpanel/directadmin) and phpmyadmin from there find your database and update site url and website address from wp_options table
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
In general, things that are not content, better not be in the DB in the first place. Site header images should be in you CSS, making them part of your code which you manage with GIT. This is obviously easier said than done with the way wordpress core and many plugins geared towards storing everything … Read more
wpkf_terms do not contain field called cat_name. Try using below query. update wpkf_terms set name=CONCAT(name, ‘-subbed’) Where term_id IN (SELECT term_id from wpkf_term_taxonomy where taxonomy=’category’)
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
I can see $topselected= get_the_author_meta( ‘user_top’, $user->ID ); , here you are using “user_top” as the meta_key but while updating you are using “user_chapter” update_usermeta( $user_id, ‘user_chapters’, $_POST[‘user_chapters’] ); Whatever name you are providing in <select name=”user_top” id=”user_top”>, should be used in $_POST[”] So here you are using “user_top” as your select name, so it … Read more
Adding wordpress posts using phpmyadmin
WHERE NOT IN is what you need. $sql = “INSERT INTO trip_rate (id, trip, rating, r_name, email, title, review) SELECT ”, ‘$trip’, ‘$rating’, ‘$name’, ‘$email’, ‘$title’, ‘$review’ WHERE (trip_rate.email) NOT IN ( SELECT email FROM trip_rate WHERE email=”$email” AND trip=’$trip’)”;
Duplicate WP Migration affecting site on separate domain?
You have a typo $a = the_ID(); $data = $wpdb->get_results(“SELECT `id`,`guid` FROM `wp_posts` WHERE `post_type` = ‘local-offer’ group by `post_author`”); $result = $wpdb->get_results(“SELECT * FROM `wp_postmeta` WHERE `post_id` = “.$a.” “);