I personally find it easier to use built-in WP functions rather than running straight MySQL queries, so here’s one option: <?php global $wpdb; // replace ‘yoursearchword’ with whatever you’re looking for. // the two % symbols are to find the word no matter what comes before or after. $query = “SELECT * FROM wp_posts WHERE … Read more
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
Points 1 and 2: Use the wpdb class to read the table. Then use wp_insert_post() to create your page. Point 3: WordPress has a Template Hierarchy that allows you to define which theme file to use. Point 4: Read the article on Writing a Plugin and add your code in it. Point 5: Choose a … 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
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
The plugin you are using hasn’t been updated for two years. It is better not to rely on plugins so old. You should consider writing an sql script, that would create a database, as per the MySQL documentation. And simply run the SQL command through php. You can check how that can be done in … 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
Why don’t you use something like: Bla bla bla [shortcode postID=”100″ content=”Special bla bla”] Bla bla and then retrieve your content in your shortcode function. extract( shortcode_atts( array( ‘content’ => ”, ), $attr ) ); echo ‘special content is: ‘.$content;