wpdb

Get error messages when $wpdb->insert() returns false?

Question

$wpdb->insert() returns false which I've learned means that the insert failed. Now, I would like to know why it fails with the insert. According to this ticket https://core.trac.wordpress.org/ticket/32315

database, errors, wpdb Peter Westerlund 3 years 0 Answers 72 views

how to list all post that are in the custom taxonomy using $wpdb

Question

global $wpdb; $custom_post_type = 'post'; // define your custom post type slug here // A sql query to return all post titles $results = $wpdb->get_results( $wpdb->prepare( "SELECT ID, post_title FROM {$wpdb->posts} WHERE post_type = %s and post_status = 'publish' OR post_status

sql, wpdb Kenneth Gervacio 3 years 0 Answers 49 views

User avatar-ACF fields

Question

I'm running wp multisite and using ACF custom field (user edit) for my local avatar, in my functions.php i added : add_action('get_avatar', 'tsm_acf_profile_avatar', 10, 3); function tsm_acf_profile_avatar( $avatar, $id_or_email, $size, $default, $alt ) { $user = ''; // Get user

advanced-custom-fields, avatar, plugin-development, user-meta, wpdb MR.Don't know 3 years 0 Answers 61 views

Insert blob data with wpdb

Question

I have a shortcode in my WordPress page with which I access the WordPress database with wpdb. It works perfectly with wpdb-> get_results () and wpdb-> query (), but I am not able to execute an insert with a blob data. With wpdb:: insert I can't as it only accepts a string, int

database, sql, wpdb alvaroqm 3 years 0 Answers 74 views

WPDB Insert or if exists Update

Question

I'm not crazy familiar with WPDB or SQL in general but I have a custom table for my project and I'm trying to assign some metadata to it. What I'd "like" to happen is if a row exists, update it and if not insert it. I've read both Insert and Update in the WPDB Codex but neither really went into a

database, sql, wpdb Howdy_McGee 3 years 0 Answers 76 views

get_post() is not returning correct value

Question

I have a post and i need to update its post_parent. So i have used following to update the post_parent value. Old post_parent is 844 and using query i have updated the value to 370 using below: global $wpdb; $table_name = $wpdb->prefix . "posts"; $add_plan_to_team =

get-post, wp-query, wpdb Optimum Creative 3 years 0 Answers 49 views

How to filter database data based on select options using jquery

Question

I found this code on a website which works fine for filtering data from two different select box but I have totally five comboboxes. I want to extend this functionality to work for the other three select options. Please someone help. Thanks in advance. enter code here $(document).

database, filters, javascript, jquery, wpdb Ashur 3 years 0 Answers 49 views

Access to numerically indexed array in wpdb Class and undefined offset

Question

the following database call $einzel = $wpdb->get_row("SELECT t.id, DATE_FORMAT(t.datum, '%d.%m.%Y'), DATE_FORMAT(t.datum2, '%d.%m.%Y'), t.ueberschrift, t.uhrzeit, t.termintext, t.veranstaltungsort, t.ort, v.name, v.id, ku.name, ku.mail FROM verans

array, wpdb berndhs 3 years 0 Answers 57 views

Multiple wp_options tables to share content across installs

Question

My application has >10 user_roles, each able to perform completely different tasks, provided with an custom backend and no access to wp-admin. The extra functionality each user_role gets to use is handled via multiple plugins. Each user_rol

database, hacks, options, performance, wpdb Youleean 3 years 0 Answers 51 views

How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option

Question

I'm having troubles with the mysqli driver used by wordpress, where it is converting each and every integer value to a string within $wpdb->get_results("SELECT..."). I know that it is possible so use the the option MYSQLI_OPT_INT_AND_FLOAT_NATIVE with the mysqli drive

mysql, wpdb Raffaele Candeliere 3 years 0 Answers 55 views

1 2 … 13

Register Now

Login

Lost Password

Add question

Login

Register Now