Articles of database

How do I reset a self-hosted WordPress URL?

i was using a wordpress install on an ubuntu server virtual machine. At first the adapter was host-only at an address of The host had this on a vboxnet0 subnet. i changed to bridged adapter to try port forwarding from the router, and now i cant access the page with the new address. the […]

Looking for a subscriber list management system

Is there any plugin that enables the creation of forms and has a smart tool for subscribers (not site visitors who registered) database management? I’m looking for a plugin that does that for a long time for different type of needs. For example, event subscription, workshops, courses etc. I don’t need an event/calendar tool, just […]

How to Query Database for posts with certain Taxonomy Term

I want to write a select query to return data on only posts which have are associated with the taxonomy term food-and-beverage SELECT wp_postmeta . * , wp_posts.post_name FROM wp_posts, wp_postmeta, wp_terms, wp_term_relationships WHERE wp_posts.post_type = ‘projects’ AND wp_posts.post_status = ‘publish’ AND wp_posts.ID = wp_postmeta.post_id AND wp_term_relationships.object_id = wp_posts.ID AND wp_term_relationships.term_taxonomy_id = wp_terms.term_id AND wp_terms.slug […]

Modify site URL via functions.php of a theme

My site URL in the database shows Is it possible to change this via functions.php into, however still maintaining in the database? My current scenario is that I have three developers who work locally and we want to use one database. We all connect to a remote database, however, the URLs from […]

Is it possible to store visitors IPs in wp_postmeta table?

Or in any of the other 11 WordPress tables. I also need to store: submission date, name, contact number in the same table. What approach would be best? A custom table or using a standard table?

How to retrieve the value stored in a multi-dimensional array and SUM the entries?

I’m trying to retrieve multidimensional values stored in user_meta where the meta key is my_posts and the meta_value is : a:3:{i:0;s:2:”23″;i:1;s:2:”20″;i:2;s:1:”9″;} Somewhere in the admin page i want to show the sum of the selected posts which are stored in the value above….

Hello dolly type plugin that allows people to add their own

I am making a plugin that shows a random joke on a custom 404 page via shortcode and it is basically near enough the same as the default hello dolly plugin, where the jokes are hardcoded into the script. I want to be able to allow users to add their own jokes, maybe pulled from […]

Use one WordPress database with multiple instances of one site

Is there a way to use the same database, tables and all, with two different domains? For example, two employees each have thier own subdomain to develop / test with, so there may be two instances of a site: however, since the base url is stored in the database, it seems that it […]

How do I add indexes to WordPress Database?

I got a message from Hostgator about my account being suspended because of the load it put on their servers. This is about the fifth time this has happened. I am on a shared server. And they said it could be resolved by simply adding new indexes to the database or optimizing the database using […]

Retrieve and display data from custom db table in admin area?

So, i’m having a bit of an issue with a plugin i’m developing, I wonder if anyone can shed any light on the situation, as many, MANY searches have come back with zero help. :-/ Basically, my plugin creates several custom entities in the wordpress database, which all work fine, I have added a shortcode […]