wpdb

database – Is it important to have integers inserted using %d rather than %s?

Question

Is it important to have integers inserted using %d rather than %s? I have a situation where there is a large number of fields and values. When database changes are made, it is difficult to match all the field types to th

Steve 3 days 0 Answers 0 views

php – MySQL Query Returns Array () In Shortcode

Question

This is in my theme's functions.php. I have an external MySQL database that I'm connecting to in WordPress with the following code, and I'm attempting to create a shortcode that shows the total of a column named total_downloads, with rows fi

Adam ImaginedAtom Mitchell 2 weeks 0 Answers 0 views

php – Add posts to custom table in database instead of wp_posts

Question

What the code does: Imports posts, loops through all the posts and calls wp_insert_post to create a new posts for each import. Objective: Import posts and store them in another table,

DevSem 2 months 0 Answers 0 views

php – how to get serialized post meta

Question

I have posts that have video content and these videos stored in database like this (serialized) a:1:{s:9:"video_url";s:0:"";} This serialized data have post video urls but can not get this data. I used <?php echo get_post_meta(get

Teymur Abbasov 2 months 0 Answers 0 views

php – Isn’t Returning Value While Using SELECT COUNT(*) FROM {$wpdb->prefix}

Question

I'm trying to count rows in sql table using SELECT COUNT(*) for the post view count. My code is function get_post_views($offset=0, $post_id){ global $wpdb; $get_visit_query = "SELECT COUNT(*) FROM {$wpdb->prefix}" .

Morty_Smith 3 months 0 Answers 0 views

wpdb – Counting Posts with multiple taxonomy and terms condition using MySQL and AJAX

Question

I am trying to get the number of posts with multiple taxonomy and terms using MySQL and AJAX. but I cannot get the desired result with my query. I derived my query in this wpdb query and sadly it returns 0. I am hoping anyone can give me the exact sql qu

Blitzkriegfest 5 months 0 Answers 0 views

wp query – Which is faster wpdb & get_row or wp_query & ge_post_meta?

Question

You should always use get_post_meta. Your attempt to micro-optimise using a raw SQL query will reduce not improve performance. When you fetch a post, WordPress bulk fetches its meta for performance reasons, so if you used get_post_meta it

Amenadiel 5 months 0 Answers 0 views

plugins – ob_end_flush(): failed to send buffer of zlib output compression (0) in external php

Question

I have this little php I call from jqGrid url that I use inside an admin's wordpress plugin: require_once($_SERVER['DOCUMENT_ROOT'] . '/xDl21my20/wp-load.php'); remove_action( 'shutdown', 'wp_ob_end_flush_all', 1 ); add_action( 'shutdown',

Luigino 6 months 0 Answers 0 views

wpdb – issue with save custom post meta in custom table

Question

until now, I was saving my custom post meta in post_meta table. and my code was: function add_book_meta_box() { add_meta_box( 'book_meta_box', 'book info', 'show_book_meta_box', 'book',

Saeed 6 months 0 Answers 0 views

custom post types – See if the email exists or not

Question

I have extracted a bunch of emails using PHP IMAP connection and assigned those emails to a custom post type. Here's the code how I assigned those emails to custom post type. $total = $emails->total_msg(); for ($j=1; $j <= $tot

Rohit KC 7 months 0 Answers 0 views

1 2

Register Now

Login

Lost Password

Add question

Login

Register Now