Your Query is wrong beacuse your are searching for the user_id inside the meta_value column instead of the user_id column. In this case i see no point in creating a custom query just for that, So here is how you can do it using the native function get_user_meta $data = get_user_meta( get_current_user_id(), ‘bookmark_posts’ ); $number … Read more
Error inserting row into table
esc_sql inserting weird chars to DB
You can simplify that by using $wpdb->get_var. $total = $wpdb->get_var( “SELECT COUNT( * ) AS total FROM tableA” ); echo “Total Records:” . $total; However, the code you’ve got should work– either version of it. I tested both. The only thing I notice is that the first version of the code should give you Array … Read more
You can use the following two inbuilt functions to do this. switch_to_blog get_option You can use both in the following way to make a function out of it which would give you the option. Put the below in the functions.php file function wpse_get_options( $blog_id = 1 ){ switch_to_blog( $blog_id ); $get_option = get_option( $option ); … Read more
Pass your information through prepare as in this example from the Codex: $metakey = “Harriet’s Adages”; $metavalue = “WordPress’ database interface is like Sunday Morning: Easy.”; $wpdb->query( $wpdb->prepare( ” INSERT INTO $wpdb->postmeta ( post_id, meta_key, meta_value ) VALUES ( %d, %s, %s ) “, array( 10, $metakey, $metavalue ) ) ); Your array should have … Read more
The best approach would be: Get an array of all of the post IDs in the database. Get an array of all of the post IDs that the user has rated (as you have done in your example) Remove the IDs in step 2 from step 1 – you’ll then have an array of all … Read more
WP has Filesystem API to write files. However it can be relatively convoluted to implement (since it handles fallback for many cases and environments and workflow for requesting FTP crednetials from users) so often simply PHP functions are used to write file. Works reliably when constrained to uploads folder, otherwise need to be sure about … Read more
I’m not sure why you are using the the_date() function, but if you must, make sure it returns the value instead of echo-ing it. So instead of this part: array( ‘value’ => the_date(‘Y-m-d’) ), try this one: array( ‘value’ => the_date( ‘Y-m-d’, $before=””, $after=””, $echo = 0 ); ), To catch the update error, check … Read more
How to add more custom fields in user meta table simultaneously