wpdb Archives - Page 4 of 21

WordPress

IT Nursery

I am not understandinhg $wpdb->prepare correctly

I have a query that runs fine in raw PHP but I cannot run using $wpdb. I seem to be missing something in ...

May 28, 2022
0 Comments

WordPress

IT Nursery

How to add/change a value of $wpdb property/var?

There is a problem: I want to add a table ‘linkmeta’ to work like ‘postmeta’ or ‘commentmeta’.. and use functions like add_metadata / ...

May 27, 2022
0 Comments

WordPress

IT Nursery

get posts and postmetas in assoc array

how do I get all posts and postmetas in an associative array? $allposts = $wpdb->get_results(" SELECT $wpdb->posts.post_title, $wpdb->postmeta.meta_key FROM $wpdb->posts JOIN $wpdb->postmeta ON ...

May 27, 2022
0 Comments

WordPress

IT Nursery

Query WP data with the WPDB API from outside WordPress

I’m working on a project with WP, a bit like a plugin, but not quite one. I’m encountering an issue, when trying to ...

May 27, 2022
0 Comments

WordPress

IT Nursery

How wordpress accesses its own database

Hi I’m just curious as to how WordPress accesses it’s own database, meaning that when I look into an admin page like link-manager.php ...

May 27, 2022
0 Comments

WordPress

IT Nursery

Get multiple custom field values in a $wpdb query [duplicate]

This question already has answers here: Closed 9 years ago. Possible Duplicate: How to query posts based on lat-lng coordinate as post meta? ...

May 27, 2022
0 Comments

WordPress

IT Nursery

How to check for empty and not a failure

I’m querying the postmeta table to see if a url has already been entered, using this statement (where $thisLink is the url I’m ...

May 27, 2022
0 Comments

WordPress

IT Nursery

$wpdb insert array

I need to insert multiple array. I get error: mysql_real_escape_string() expects parameter 1 to be string, array given My example code: $array_info is ...

May 26, 2022
0 Comments

WordPress

IT Nursery

wpdb prepare: passing varible number of fields as second argument

As i want to manage the NULL fields in my db and wordpress functions doesn’t allow to do so, i will need to ...

May 26, 2022
0 Comments

WordPress

IT Nursery

Using $wpdb Class to Pull Recent Comments Across a Network

Been looking for a clean and simple way to produce comments from across a network using the $wpdb database class. I did find ...

May 26, 2022
0 Comments