database - Read For Learn

How to modify post content?

You might check out the content_edit_pre filter. Your example would then look like this: function wpse89725_pre_edit_content( $content, $post_id ) { $content = “nothing”; return $content; } add_filter( ‘content_edit_pre’, ‘wpse89725_pre_edit_content’, 10, 2 ); You can read more about this filter in the Codex: https://codex.wordpress.org/Plugin_API/Filter_Reference/content_edit_pre Edit: You can also try the edit_post_content filter: add_filter( ‘edit_post_content’, ‘my_pre_edit_content’, 10, … Read more

Merging two wp_posts tables while avoiding duplicates

Import the new table as wp_posts_2, then join them and delete all duplicates based on post_content; then merge the two tables. The following SQL query (untested!) should give the posts from the new table to be deleted: SELECT wp2.* FROM wp_posts_2 as wp2 LEFT JOIN wp_posts as wp ON wp2.post_content = wp.post_content WHERE wp2.post_content = … Read more

Error establishing database connection – high traffic?

I have encountered the same kind of issue before, as you have already noted down the problem boiled down to mysql not accepting too many connections, The solution we implemented was to apply proper caching (check how often the cache is invalidated and other caching settings) and upgrade the mysql server. As a quick fix, … Read more

Is it possible to create Custom Post plug-in?

It is possible to use custom post types and only some features WordPress adds to that API. In fact, this is the default: When you call register_post_type(), the default value for public is FALSE. No UI, no query var, no rewrite rules, list tables or public visibility. You can leave public => FALSE, turn on … Read more

Extracting post categories

WordPress has a table called *wp_term_relationships* to keep track of several types of relationships, including post – category. Let’s go table by table: wp_posts – holds all posts,pages, and other content. You want to poll all rows that have -> post_type = post . You might want to poll only published posts -> post_status = … Read more

Use mulitple usernames?

WordPress does not allow this “configuration”. And I seriously doubt you would have any luck writing a plugin that would take care of this in a complete way. The WPDB class is heavily utilized throughout the site, and sifting through read-only vs write-enabled uses would be daunting.

Installed domain-based Multisite but can’t access wp-admin (redirect loop)

Chances are something doesn’t line up in the database. The values in wp_options->site_url should the an exact match for the wp_blogs->domain + path values. I made a post here on the tables needed to change to transfer a multisite. Double-check these values. For subdomain multisites, your domains should be site1.domain.com and path should be /, … Read more

How to create database table, add data, update and delete using wpdb via plugins?

Yes, it is possible to add, update and delete data in custom tables with a plugin. When you run your insert_data_into_table() function, what errors do you get?

Displaying BLOB PDF File

That looks like it is a template file. If so, the function add_header_info is hooked into send_headers long after send_headers had fired. You will need to move that code so that it executes earlier. It should work from a mu-plugin file, a plugin file or from your theme’s functions.php. However, $FileType and those other variables … Read more

How to access data in wordpress database externally using php

Unless you want to use PHP to run queries directly on your database, you’ll have to use a REST API and Javascript to gather the data. One point worth noting is these REST API’s also use direct database queries in order to gather info to return to you when you make a request. This means … Read more

+ More