mysql - Read For Learn

mysql query on wp_user and user_meta problem

In usermeta table WordPress stores many serialized data. So direct meta_value would not work I think. So try the below query- SELECT a.id, a.user_email, a.user_registered, a.user_login, b1.meta_value AS first_name, b2.meta_value AS last_name, b3.meta_value AS qualified, b4.meta_value AS referrer, b5.meta_value AS view_type, b6.meta_value AS ref_by, b7.meta_value AS wp_optimizemember_custom_fields FROM wp_users AS a INNER JOIN wp_usermeta AS … Read more

$wpdb->get_var not returning count

In your code it is actually counting the query you have inserted in $testargs. In your case you entered one. So it is giving you back one. If you need to get the count on WordPress users table then write the query like below- global $wpdb; $total_query = “SELECT COUNT(*) FROM {$wpdb->users} AS total_count”; $total … Read more

How to detect if a revision was made by woocommerce or wordpress?

Woocommerce uses the post_type product for products, so it should be easy enough to search for those instead of posts. Just look out for the proper post_type. You could filter the revisions using a self-joined select like this: SELECT * FROM `wp_posts` p1 LEFT JOIN `wp_posts` p2 ON (p2.post_parent = p1.ID and p1.post_type=”products”) WHERE p1.`post_type` … Read more

Possible to restore wordpress database from mysql56 and sqlite files?

How To connect to the same WordPress database with different database user

The solution for this is to call a function that will initialize the wpdb object properties. which is wp_set_wpdb_vars. After you instantiate the wpdb object call that function. $wpdb = new wpdb(DB_USER, DB_PASSWORD, DB_NAME, DB_HOST); //Set the database table prefix and the format specifiers for database wp_set_wpdb_vars();

Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?

Using WordPress’s wp_postmeta will help you a lot, instead of creating a new table. Functions like get_post_meta(), update_post_meta(), add_post_meta() etc, are readily available for use. All you need is to create a meta_key (which in this case will be wp_likes) and the meta_value (number of likes will be stored), which can be easily retrieved using … Read more

SELECT statement wrong?

look for $wpdb->last_error. It may help you to be helped yourself.

Plugin MySQL SELECT custom data and filter on user meta

Without a proper SQL query in the question is not possible to write a proper query in the response, but following your pseudo-code approach: SELECT custom-data FROM custom-table LEFT JOIN wp_users ON custom_data.user_id = wp_users.ID LEFT JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id WHERE some-condition AND wp_usermeta.meta_key = ‘flag’ AND wp_usermeta.meta_value=”flagvalue” So basically, you need to … Read more

Slow query when selecting with large meta query or post__in

Depending on whether or not your member and product tables are changed often, the MySQL Query Cache might be an interesting feature for you. It caches the result sets for queries once they are processed and delivers them from the cache for some time. You can set the refresh time to a longer span, if … Read more

mysql_escape_string PROBLEM

All the mysql_ functions were deprecated in PHP 4.3 and the only currently supported version of PHP where it’s still available is 5.6. These functions have been completely removed in PHP 7. Switch to using mysqli_ or PDO functions instead.

+ More