The wpdb class, accessed via the $wpdb global variable, is used to interact with the WordPress database

learn more… | top users | synonyms

3
votes
1answer
427 views

Change post status based on meta value

I have this cron set up to trash posts x days after it is posted. This works. Edit: Added my answer to my question. add_action( 'wp', 'do_trash_ads' ); function do_trash_ads() { if ( ! ...
0
votes
0answers
40 views

Wordpress - wpdb query does not list same result as sql query

I have a very weird issue with wpdb which is freaking me out. My database has the following data: INSERT INTO `wp_clb_likes` (`id`, `post_id`, `user_ip`, `time`) VALUES (5,11511,'::1','2015-01-25 ...
0
votes
0answers
107 views

why nl2br() is adding an extra <br>?

I store the text with wpdb->insert. While retrieving it with wpdb->get_results I echo it with nl2br() function to preserve the new lines (or it will be echoed without line breks). Problem is ...
0
votes
0answers
33 views

How to query for the first 5 elements published?

<div class="content left"> <div class="wrapper"> <div class="gallery-single-content left"> <div class="gallery-filter left" style="display: none;"> ...
0
votes
0answers
64 views

What is the best practice to initialise $wpdb by loading wp-load.php?

Why do users with high reputations suggest loading wp-load.php with a full path? My question is simple and was originally intended as an answer to this question. However I do not have a high enough ...
0
votes
0answers
15 views

Problem by dispaly inserted form

I've build a form and insert it's data into custom db by $wpdb. When I click on the submit button, page reloads and one row added to db but noting displays on website. You can see it at: my site ...
0
votes
0answers
38 views

why not changing site body after insert row by $wpdb?

I've create custom table and insert, update and delete it's values by $wpdb My problem: when i click on submit or send button, despite changing value in database (add a row, update value and ...), ...
0
votes
0answers
18 views

WP DB Location for “Next Post to Create” Index Value

I have a malformed DB (no mystery here, I deleted some data directly rather than through the WP admin interface). I've deleted all posts and meta for 400+ but when I create a new post, the sequencing ...
0
votes
0answers
100 views

Fetching array of postmeta with $wpdb and in_array conditional

I'm trying to fetch an array of all entries to a specific meta key and then check to see if the user input value exists in that array. I've checked the data base for the query and I see the meta ...
0
votes
0answers
47 views

Custom table in my plugin print UTF-8 (מוברש) charsets and not hebrew

i have created custom table in wordpress db to use my plugins needs. i have campaigns with hebrew names, this saved to column (varchar(100) utf8_unicode_ci ) in the DB i dont see hebrew but this: ...
0
votes
0answers
103 views

Unable to create custom table , register_activation_hook from class

Cannot create the table , what am i missing class em_db { public function em_events_custom_table() { global $wpdb; $table_name = $wpdb->prefix . "em_events_db"; ...
0
votes
0answers
66 views

run search / query from multiple databases

First of I would like to warn everyone, that my skills set in mysql and php is novice. My current wordpress website is based on a network setup (mutli-site), with the help of shardb, I was able to ...
0
votes
0answers
94 views

Storing PHP structure data in the wp_options table?

I searched too much about that but can't find resonable answer of that question I am creating a WordPress plugin that has so many options that I need to store so to store data using option API which ...
0
votes
0answers
66 views

Insert data to DB

I create plugin and that plugin, when is activate, create new table in DB.. Now i need to insert some data like (firstname, lastname..) in that table.. Here is my form : <form name="cool_form" ...
0
votes
0answers
265 views

$wpdb error : call to a member function insert() on a non-object

I'd like to add data to my custom wordpress table of my plugin, here is my code: <?php global $wpdb; $data = $_POST['name']; $wpdb->insert('ct_data' , array( 'name' => $data ), array( "%s" ...
0
votes
0answers
295 views

Get results from wordpress data custom table

Firstly i created a custom table into the wpdb : global $wpdb; $table_name = $wpdb->prefix . 'countdown_table'; $sql = ' `id` int(11) NOT NULL AUTO_INCREMENT, `styleName` varchar(255) ...
0
votes
0answers
114 views

Custom post type search shows “Not unique table/alias” error

If I search for a value on the page that shows the custom post type list ( edit.php?post_type=my_post_type ) then it returns normal results. But because I wanted to include the post meta fields in ...
0
votes
0answers
39 views

wordpress plugin admin area save settings

I am brand new in wp plugin development and i need your help cause throw web the answers that i find confused me. So i would like to make a countdown timer wp plugin for my website that will display ...
0
votes
0answers
102 views

$wpdb->get_results in not an array

Using get_result I receive an "Invalid argument supplied for foreach()" because is not an array. I tried with get_col but I don't know how to extract the data and I don't know the difference between ...
0
votes
0answers
140 views

Why are Wordpress e-mails full of “mysql_real_escape_string” errors? (wp-db.php)

Since recently all Wordpress e-mails, which include Woocommerce order confirmation emails, are full of errors like these: Warning: mysql_real_escape_string(): 19 is not a valid MySQL-Link resource in ...
0
votes
0answers
22 views

adding a log row log table, when the draft post publish

i wrote some codes, about wpdb update query. but update_post meta works fine but, wpdb update query doesn't. where am i wrong ? here is the code ; add_action('publish_post', ...
0
votes
0answers
21 views

Output terms based on custom fields

This question is rather specific. In my custom posttype "sak", I have a taxonomy called "vvpl". This taxonomy has a custom field called "revision" because a term have copies based on how many ...
0
votes
0answers
19 views

Separate Register Login

I plan to create a bespoke login and register feature on my WordPress Frontend. These users won't have access to the backend of WP. Just to a frontend area. Should i store the information submitted ...
0
votes
0answers
898 views

$wpdb->get_results(…) returns empty array despite correct query

As title implies, I cannot seem to get $wpdb->get_results to give results. Running the "raw" query is successful, but this seems to be failing for some strange unknown reason. global $wpdb; ...
0
votes
0answers
36 views

Issue On WordPress multisite its create new table for each user

I am using WordPress for multisite all configuration are right, but it's create new table for each user like (wp_1_options, wp_2_options, wp_3_options etc for each table) it's a very big issue for me. ...
0
votes
0answers
43 views

How to make iteration on wpdb->update or query statement?

I want to change post_names with iteration; I have similar post names and want to change them by foreach iteration. Initial post name is "one-book" and there are 30 similar names. I want to change ...
0
votes
0answers
105 views

Error establishing database connection on app engine

Error establishing database connection on app engine after deploying wordpress. I got an error Notice: Undefined property: batcache::$query in ...
0
votes
0answers
119 views

Fire query on ajax post url page

Here i am sending the ajax response to load_post.php page from my ajax call.I am getting response on load_post.php on load_post.php i have to fire word press query. I was try this but getting bellow ...
0
votes
0answers
85 views

WPDB update is not working for tables with large number of columns

I am using a form to update a cutom WP datatable. The update function is working fine for all the table except one which have 14columns. I can delete the rows but can't edit any entries. For edit I am ...
0
votes
0answers
494 views

How to add more custom fields in user meta table simultaneously

I am working on a task in which i have to submit some records to user_meta table at form submitting. Actually it is related to employee data and i just want to add records in user meta table. I am ...
0
votes
0answers
113 views

Query Distinct Taxonomies of Custom Post Type

I have a custom post type called "coupons". These coupons can then be drilled down by "city". City is a custom field that is defined for each individual "coupon". I am then trying to modify a sidebar ...
0
votes
0answers
103 views

There is way to improve this query? wordpress get post data and some meta data

Suppose we have 2 blog with different database A and B. I want to get some post from Blog B to show them on Blog A. The problem comes when the posts have much metadata (custom field for example) that ...
0
votes
0answers
121 views

Best way to execute custom page-specific mysql queries

I would like to query a secondary mysql database (not the Wordpress mysql database) with page-specific queries. I've seen many answers / tutorials on setting up a secondary mysql database, like: ...
0
votes
0answers
62 views

Proper way to trigger a MySQL query via link in a plugin

I am trying to develop a module in my WordPress plugin that will delete an entry from the database. The only issue is related to the trigger action. I've tried to send my users directly to the page ...
0
votes
0answers
369 views

Using the same shortcode to show any table from the database

I have a little question for you. I want to create a shortcode that makes a table with data that I have stored in a database. But i want to send the shortcode an attribute, to specify which table ...
0
votes
0answers
47 views

$wpdb: how to use a query as a base for another query?

I've got this query: select p.ID, p.post_title, p.post_content, t.term_id, tt.taxonomy, t.name, t.slug, tt.count from bdu_posts p inner join bdu_term_relationships rel on p.ID = rel.object_id inner ...
0
votes
0answers
75 views

Update tags to 10,000+ posts with wpdb?

I have over 10,000 posts on a site which all need to have a tag added to them. WP_Query is either running out of memory or timing out on my server and in the past running large queries with this ...
0
votes
0answers
4k views

AJAX with Selectbox Plugins (Select2, Chosen, Selectize)

I have been searching all over the internet for tutorials on implementing AJAX actions from jQuery selectbox plugins such as Select2 , Selectize and Chosen. (these plugins look better than the inbuilt ...
0
votes
0answers
51 views

How Can I Put Meta_Compare in the Database-Query?

Yes, I know that this can easily be done with built in wp_query but I need this in Wpdb query. I have a custom field and I need to display posts where this field does not exist. By the way can I get ...
0
votes
0answers
112 views

$wpdb->prepare - supporting multiple search terms

I am trying to write an escaped SQL statement, for example: $sql = 'SELECT * from TABLE where column LIKE %searchterm% AND column LIKE %searchterm2%'; Except I don't know how to handle it, as I do ...
0
votes
0answers
86 views

Wpdb generates too many queries

I googled for hours, then found some codes on stackexchange (http://wordpress.stackexchange.com/a/108279/108270) and created the codes below. I'm trying to get alphabetical A-Z posts lists (e.g. A B C ...
0
votes
0answers
133 views

why is $wpdb->update() causing a DB error from within wp_set_password()

I have a page-template for my custom theme that enables the user to reset their password from the front-end. I'm calling wp_set_password() and everything runs but the password is not changed in the ...
0
votes
0answers
125 views

Wordpress plugin tables become corrupt

I have written a plugin that creates and uses 3 database tables. On rare occasion, all 3 database tables become corrupt but no other tables in the database exhibit similar conditions. It is pretty ...
0
votes
0answers
184 views

esc_sql inserting weird chars to DB

I am using esc_sql function for making safer SQL operations but i am mysteriously getting ? and &nbsp; in the DB table how can i avoid them. Edit : Here is my array after esc_sql() Array ( ...
0
votes
0answers
144 views

Displaying posts from last 24 hours in current category with pagination

I am trying to find a solution for this problem but unfortunately without any success. I've checked WordPress Codex (WP_Query & wpdb) and few other solutions from Internet and still I wasn't even ...
0
votes
0answers
126 views

Error inserting row into table

I am trying to insert a row into a table. Given below are the various functions to create table. insert data into the table- but its not working. Also given below is the sample output showing all ...
0
votes
0answers
127 views

Retrieve post data via WPDB class

I'm trying to figure out doing a custom query using the $wpdb Object. I have custom type posts, event_posts, that have meta data, images, as well as event dates which are input in the post with the ...
0
votes
0answers
119 views

get_query_var('paged') giving same result

I have a custom page, in that page i am using a custom select query for my search functionality. The problem is pagination not working. I used $on_page= get_query_var('paged'); for pagination. When ...
0
votes
0answers
160 views

Custom query on Wordpress custom table

I am working with a custom table where some values will be inserted or updated if they already exists, I have checked and rechecked the syntax and it seems to be working fine, if I run the same query ...
0
votes
0answers
165 views

Filter content by custom field and category

I'm trying to filter a Wordpress request with 2 parameters. By a custom field (REGION): There are 6 regions By category: There are n-categories with 1 value per post. As a result I would like to ...