Articles of database

importing data into wordpress db

Hi I am currently using wordpress 4.0 multisite(bitnami multisite stack) and am using WPMU directory plugin to create business reviews directory. Have some custom fields created using custompress which is included with the WPMU directory plugin. I need to import over 3 million businesses data that is on my local mysql installation. Have tried to […]

Help With a Large WordPress Based MySQL Database on Shared Hosting

I have close to 500K posts in my WordPress database. The site is not yet live, I have the data on my local computer. I was reading about the WOrdpress’ https://wordpress.org/plugins/hyperdb/ plugin that may be useful. However, I have no clue how to get started with that. I asked a friend and he suggested maybe […]

Get results from wordpress data custom table

Firstly i created a custom table into the wpdb : global $wpdb; $table_name = $wpdb->prefix . ‘countdown_table’; $sql = ‘ `id` int(11) NOT NULL AUTO_INCREMENT, `styleName` varchar(255) NOT NULL, `css` blob NOT NULL, `expiration` blob NOT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ‘; require_once( ABSPATH . ‘wp-admin/includes/upgrade.php’ ); dbDelta( $sql ); […]

How to select particular month post from table and update the post status using MySQL?

I would like to change the post status for particular month via MySQL command Using SSH…Can you anyone tell me how to do this via SSH. I have number of post more than 40,000 posts, each month i’m having arround 2000 / 3000 posts, So before going to do the bulk update i have to […]

Create Pages for database content

i added a custom table to the wordpress database with a list of names and a description. I wrote a custom function to display all the names in a table. Now i want to have an extra page for every name where you can see the persons description after clicking on the persons name. Any […]

Backing up WordPress database and files

I’ve tried a few third party plugins for backing up my site, with some working well and others not so much, so I’m trying out backing up the site manually. Is there anything I’m missing here or is this the proper way to manually back up? In the WordPress folder on FTP copy the following […]

Save and user submitted data from a form and display them in the wp backend

My question is very simple but the answer I’m not sure if will be that simple. I’m developing a website for a non-profit organization where people can fill out a form containing questions usually asked by a doctor. Once a user submits the form I would like to grab the answers and display them in […]

Database alteration: users who voted

I have a post voting system that stores and displays the vote as an integer. When someone clicks on plus the vote increases by 1, when minus – decreases by 1 (exactly the same way as on this website). The problem is that the votes are cookies-based, so when these are refreshed the user can […]

How to Generate a list of Most Commented post?

I’m trying to call a list of most commented post. But the call to the DB returns always the same post (the first one in the loop) This is my code in functions.php function lugaresincreibles_most_commented() { global $wpdb; $pop = $wpdb->get_results(“SELECT * FROM {$wpdb->prefix}posts WHERE post_type=’post’ AND post_status=’publish’ ORDER BY comment_count DESC LIMIT 3”); foreach($pop […]

Connecting to wordpress database in my application

I am creating a wordpress site that will give accounts to people that want to be contributors/authors of a cause that people can donate too. We will approve/deny causes of approved authors Our backend developer is going to create a system that will allow people to donate to these causes by creating an account. The […]