wpdb Archives - Page 20 of 21

WordPress

IT Nursery

what is the way to see the currently executing query in wordpress?

I am working on wordpress which is new to me Now I have been provided with site completely designed in wp But the ...

April 13, 2022
0 Comments

WordPress

IT Nursery

Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?

In order of figuring out the following issue, see https://wordpress.stackexchange.com/questions/178995/sanitize-a-working-query-string-by-using-wpdb-prepare-fails-with-mysql-db-er i ran into an rather odd behaviour. Even that my used query was ...

April 13, 2022
0 Comments

WordPress

IT Nursery

How to parse row results from $wpdb -> get_results

I have the following: $query = 'SELECT * FROM wp_pod_tbl_add_questions WHERE id LIKE '. $id; $row = $wpdb -> get_results($query); How do I ...

April 13, 2022
0 Comments

WordPress

IT Nursery

$wpdb won’t insert NULL into table column

When i try something like this $status = NULL; $wpdb->update( 'table', array( 'status' => $status, ), array( 'id' => 1 ) ); In ...

April 13, 2022
0 Comments

WordPress

IT Nursery

How to programatically change username (user_login)?

As in the title, how to programatically change user’s login? I wanted to use wp_insert_user function, but it appears that when updating current ...

April 10, 2022
0 Comments

WordPress

IT Nursery

get_results using wpdb

I’m trying to retrieve information on my database. I wanted to display all pages using this statement, but I’m getting a blank ARRAY ...

April 10, 2022
0 Comments

WordPress

IT Nursery

wpdb->insert: do I need to prepare against SQL injection?

Do I need to use wpdb prepare before wpdb->insert? If I am inserting values into a wordpress table using wpdb->insert, do I need ...

April 10, 2022
0 Comments

WordPress

IT Nursery

Is it mandatory to use $wpdb->prefix in custom tables

Sorry if this question is trivial. I’m just beginning to develop plugins in WordPress. In all the tutorials I found this: while creating ...

April 10, 2022
0 Comments

WordPress

IT Nursery

How to return number of found rows from SELECT query

I wrote a function which is supposed to return the number of rows found in a SELECT query but it always either seems ...

April 9, 2022
0 Comments

WordPress

IT Nursery

Showing errors with $wpdb update

I am using $wpdb->update to update a custom table I have in my database. When I var_dump the result it returns: int(0) So ...

April 9, 2022
0 Comments