database

WordPress plugin: efficient way to store large data

There’re few plugins to storage it on WordPress database. I recommend you save as users. I believe one of these plugins will help you: https://wordpress.org/plugins/wp-all-import/ https://wordpress.org/plugins/wp-ultimate-csv-importer/ To send emails, you might use an Email Marketing provider, like Mailchimp. In this case you can import all the users to your mailchimp account with this plugin: https://wordpress.org/plugins/mailchimp-sync/ … Read more

Connecting to wordpress database in my application [closed]

What you likely need is the function wp_insert_post(). In your backend (not the WordPress backend, just so we’re clear), you’ll need to do a minimal load of WordPress to allow wp_insert_post() to work. You can do this by define( ‘SHORTINT’, true ). Some additional reading on doing a minimal load of WordPress: Load minimum WordPress … Read more

How to Generate a list of Most Commented post?

Primary issue with your function is “get_template_part” internally use global $post variable to display the post fields. However, your $post variable is filled for this function only. I would suggest to read this handy article Displaying Posts Using a Custom Select Query Now, specifically in your case function lugaresincreibles_most_commented() { global $wpdb, $post; // make … Read more

Function to retrieve IDs of posts, cache results, and improve wp_query

What the author of the article posted, as I read it, is suggesting you do is something like this: $cats = array(1,2,3,4); $q = new WP_Query( array( ‘category__not_in’ => $cats ) ); var_dump($q->request); You should see the complex default query in that dump. $ids = array_unique(get_objects_in_term($cats,’category’)); var_dump($ids); Now you have an array of post IDs … Read more

Files on Localhost, Database on Server

Yes, the 404 is because the local and remote server URLs are different. As a solution: You should set the local domain to be the same as the remote server In wp-config.php connect to the remote DB When you will need to access the remote server you’ll need to update the file hosts and comment … Read more

+ More