When you use $wpdb->prepare the placeholder %s is replaced with something between quotes, so, your query becomes: “SELECT * FROM ‘wp_users’ WHERE ID = 1” but table names in SQL queries must not be wrapped in quotes. So, the right way is: $sql = $wpdb->prepare( “SELECT * FROM {$wpdb->users} WHERE ID = %d”, 1 ); … Read more
you can use this plugin for doing this: phpBB Bridge also you can find more useful description in this stackoverflow Question: How to integrate phpBB with WordPress
If this is in the admin, use the action parameter: <a href=”https://wordpress.stackexchange.com/questions/159391/<?php echo esc_url( admin_url(“?action=delete_ticket&ticket_id=$ticket->ID” ) ?>”>Delete item</a> …and then hook appropriately: function wpse_159391_delete_ticket() { if ( isset( $_GET[‘ticket_id’] ) ) { // delete it! } } add_action( ‘admin_action_delete_ticket’, ‘wpse_159391_delete_ticket’ ); For the front-end, you can just append your parameters to the current url and … Read more
Redirect Issue: WordPress database
Unfortunately, it seems that you have now learned the hard way that you should not: trust only your web hosting company to keep your data intact, or keep your backups on your web server. Sadly, restoring your WordPress installation — if at all possible — will most likely not be easy! You might be able … Read more
After instantinating a wpdb the instace vars holding the table names are still not present. You need to call the set_prefix() method, in order to setup all table names according to your other wordpress table prefix. (Very likely this will be wp_ in your case). $newdb = new wpdb( DB_USER , DB_PASSWORD , DB_NAME , … Read more
Restoring .sql backup results in “Error establishing a database connection”
If I got your question right, and you want posts created/modified between 3 years ago and today, try this query: SELECT p.ID, concat(‘http://www.toronto.com/restaurants/’, p.post_name) FROM wp_posts p WHERE p.post_type=”restaurant” AND p.post_status=”publish” AND p.post_modified > DATE_SUB(now(), INTERVAL 36 MONTH); Because your DATE_SUB returns something like this: NOW – 3 years, so, it’s something along the lines … Read more
Theme options not being sent to Database
Why is wordpress trying to re-install itself?