How to change link in all posts?
How to change link in all posts?
sql
Backtick (MySQL norm) added to SQL Server Query causing error
I can’t simulate this on a clean install of WordPress. So probably there is some extra filtering of XSS/Injection prevention happening on the server side. You should probably check that out first.
How to run select query of post with category and tags?
1) Blank page in WordPress means, there is a fatal PHP error in your code. Also the or die() statement could cause the white page. You should not use or die() in production code, instead use try .. catch 2) Besides this I strongly discourage you from using mysqli_* functions in WordPress. Always use $wpdb … Read more
How to retrieve user data based on role using SQL?
Add following in WHERE condition of your SQL query. WHERE t1.meta_key = “<?php echo $wpdb->prefix; ?>capabilities” AND ( t1.meta_value LIKE ‘%ROLE_YOU_WANT_TO_FILTER%’) Let me know if it works for you or not.
WPDB delivers wrong results from complex queries
WPDB delivers wrong results from complex queries
Organising and completing posts (mark as read and hide)
I’m not entirely sure this is the right place for this question, but I can’t say I know of a better place. 🙂 Your rough proposal is a valid way of building said system, but I would argue that you’re losing all of the advantages of using WordPress with the stated method. By creating a … Read more
The MySQL Connection could not be established., before it was joomla but i have change it into worpress
Check that you have assigned the user/pass to the database via your cPanel. And that those credentials match what WordPress expects. Usually, the WP install process will do this for you. (I assume that you created a new WP installation, and are not trying to re-use an existing database.) Also, you should obfuscate the URL … Read more
Analog category_and (WP) in sql query
Thanks Milo for the answer! This block of code selects posts that have two categories at the same time. ( ( SELECT COUNT(1) FROM wp_term_relationships WHERE term_taxonomy_id IN (35,33) AND object_id = wp_posts.ID ) = 2 ) Where 35,33 are categories IDs and 2 – number of categories.
Calculating efficiently on large amount of data generated by wp_query
Calculating efficiently on large amount of data generated by wp_query
blank page after update my theme
A blank page (‘white screen of death’) is usually caused by a fatal error in the PHP code. Since you said that you updated your theme (although it is not clear whether you personally updated the code, or if the theme was updated by the theme developer), then the problem is most likely in the … Read more