You don’t need PDO to write safe DB queries. PHP developers were able to do so before PDO was created 😉 There is nothing unsafe in using WPDB class, as long as you do it correctly (just use prepare and correct ways of escaping). There is one major flaw in your question: using PDO, of … Read more
Multiple things could be going wrong here,if you give some more infomation I can give you better answers here are some things to try. Check the wp-config.php to make sure the correct database settings are being used If you had permalinks you may want to check for or recheck the .htaccess file can you login … Read more
Had to update info in the wp-config.php file to match the new DB_NAME, DB_USER, DB_PASSWORD, DB_HOST
Here you go Javier, this should work. I included comments within the code to try and show you where things needed to change and added a few things you were missing. I’ll explain more below. <?php /* Should really come up with something more unique and related to your plugin */ function yourplugin_dbcreation() { global … Read more
You can’t use LIKE to compare arrays. LIKE is used to check if a string matches, or partially matches, a value in the database. IN is used to check if a value in the database is in a given set of values. They are not interchangeable. The correct comparison to use in your case depends … Read more
But surprisingly, not many threads show where these files exactly are in the server. WordPress doesn’t have files it manages, it instead relies on MySQL/MariaDB for database storage and execution. So you will not find the database stored as a file within a WordPress installation. If you need to handle database data in a file … Read more
I think this could be life saver for you . This is a simple function for creating multiple loops. It retrieves a list of latest posts or posts matching criteria. <?php $posts_array = get_posts( $args ); ?> <?php $args = array( ‘numberposts’ => 5, ‘offset’ => 0, ‘category’ => , ‘orderby’ => ‘post_date’, ‘order’ => … Read more
I had the same question here and it came down to this… It depends! (yep that’s it). This is what Otto said… Your question cannot be answered because you don’t give a proper scenario or framework by which to answer it. Searching by meta value only is inefficient because it is not an indexed value. … Read more
Try with this, It will delete existing wp_commentmeta table then create ‘wp_commentmeta’ table : DROP TABLE IF EXISTS `wp_commentmeta`; CREATE TABLE `wp_commentmeta` ( `meta_id` bigint(20) UNSIGNED NOT NULL, `comment_id` bigint(20) UNSIGNED NOT NULL DEFAULT ‘0’, `meta_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meta_value` longtext COLLATE utf8mb4_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
First, his filter is explained in the manual and is found in the code. If you have questions about hooks and functions, the manual and code is a good place to start looking for answers. The post_clauses hook is passed the associative array to filter, so just manipulate the where and join indices as per … Read more