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

learn more… | top users | synonyms

0
votes
0answers
55 views

wpdb->update update the entire table instead of one row

I'm trying to use the update function of wpdb, like this: $wpdb->update( 'protocol_data_list', array( 'used' => 1 ), array( 'cod_protocollo' => $_POST['numero_protocollo'] ), ...
0
votes
1answer
91 views

Custom Post save causes 500 error

Been having issues with getting a 500 error. Sometimes a change is saved, usually not. I've output the $key/$values to verify it's reaching the function and foreach. The output is the first key/...
0
votes
1answer
66 views

How can I combine one field using wpdb and group by?

I have the following code in my functions.php where I'm trying to group the quantity sold from woocommerce orders into the variation selected on the product. My query is: $uvuorderposts = $wpdb->...
0
votes
1answer
27 views

Frontside menu based on custom roles logged in permission

I have two phases to my site, the first is menu, i want my site to hide (normal) menu items if the user isn't logged in e.g when someone visit my site, the menu should be Home About us Products ...
0
votes
0answers
76 views

Inserting PHP code snippet via shortcode

I'm trying to insert a PHP snippet on a WordPress page using XYZ Insert PHP Code Snippet plugin. This is the code that I'm using but it's not working and I can't figure out what's wrong. I've tried ...
0
votes
0answers
23 views

get_results no result back

I can't get a result back from this query...any suggestion? function per_match(){ global $wpdb; $myrows = $wpdb->get_results( "SELECT id FROM partite;"); foreach ($myrows as $myrow) { ...
2
votes
2answers
127 views

Proper way to work with wpdb to get user's firstname

I want to use $wpdb to get user's firstname. I know how to do it with php and mysql query, but I want to use $wpdb. The problem is that I don't know how to use it. I tried to create simple query to ...
0
votes
0answers
32 views

$wpdb global causing issues with plugin class

I am currently building a plugin. I have a main init.php file which loads all the necessary plugin classes. Within one of the classes, I have several methods that call the $wpdb global. One of the ...
0
votes
1answer
47 views

Wpdb empty result only if language is Russian

I'm having a little problem with wpdb query. I need to change content of an HTML select by changing another one ( simple and clean ), so, this is my query: $_queryString="SELECT stato_"....
1
vote
2answers
681 views

wpdb->insert not working

EDIT: Rewrote the page from scratch and have been unable to figure out the differences. The new page works as expected. Checked multiple questions here and also on Wordpress.org with no luck yet. ...
0
votes
1answer
46 views

writing inner join in wpdb

I have a problem in writing SQL Inner Join syntax in wordpress, This logic should definitely work, I tried this in phpmyadmin and it works fine SELECT booking_calendars.cal_name FROM ...
0
votes
0answers
178 views

$wpdb->query(update) not working as supposed when passing GET request in the where clause

I have made a table 'wp_mostfavourite' in wordpress database, it has got three fields, 'serialno', 'postid', 'counts'. The 'counts' is supposed to be increased by 1, whenever the following query is ...
0
votes
1answer
80 views

How to get product order by two custom taxonomy in wordpress

Yesterday i stuck in the middle of code that how could i retrieve product belong to specific custom taxonomy ordered by other taxonomy. Table wp_posts: id | post_title ---------------------- ...
0
votes
2answers
122 views

Get number of comments after modifying comment query

I have modified the comment query arguments in comment-template.php from $author_id = get_query_var( 'author_id', 1 ); $comment_args = array( 'order' => 'ASC', ...
0
votes
1answer
75 views

Generate a unique hash/number for tracking on $wpdb insert

I want to generate a unique hash/number that I can use for status tracking for an contest. I'm going to use this hash/number in a url created with add_query_args. The url creation will look something ...
0
votes
1answer
43 views

WPDP related functions look to work but they don't

I have a custom database table called wp_wcpl_user_packages which has the following columns: id | user_id | product_id | ..irrelevant columns... | package_limit | package_timestamp | ...
0
votes
1answer
66 views

Store plugin page content in wp_options?

I want to write a plugin for wordpress that in some cases will show some content as if it were a post or page as an end result of a form processing. My idea is to add a hook that checks for and ...
1
vote
0answers
160 views

Create a table with wordpress plugin boilerplate

I am a new wordpress developer and i would like to create my first wordpress plugin based to wp plugin boilerplate template plugin. My plugin will have to do with my clients data so for this reason i ...
0
votes
0answers
65 views

Using $wpdb_update and foreach loop

I have this function to update data in my table list but it's not working. My insert and delete are working well, but I don't know what's wrong with this: function update_data() { global $wpdb; ...
0
votes
1answer
63 views

New User ID not working in custom function with user_register hook

I'm adding data to a table whenever a new user registers on the site. add_action( 'user_register', 'auto_follow_admin', 10, 1 ); function auto_follow_admin() { global $wpdb; $wpdb->...
0
votes
0answers
207 views

How to execute a SQL-query which contains multiple queries using $wpdb->query?

I want to execute the following Query-String, which contains 2 separate queries using $wpdb->query: CREATE TABLE `foobar` ( `id` int(2) NOT NULL AUTO_INCREMENT, `foo` varchar(22) COLLATE ...
1
vote
1answer
50 views

How would I format a query that depends on post parent taxonomy

I'm trying to do a custom query which is outside the scope of a single WP_Query, I think I should be using $wpdb but my SQL is a bit ropey. Also I only need the post IDs returned not post objects. ...
0
votes
0answers
37 views

Querying same column twice with wpdb (for postmeta values, specifically latitude and longitude)

I've seen similar questions around, but I just can't apply them to my case, I'm quite new at this, apologies. I'm trying to create a google map of my posts, using a latitude and longitude that are ...
0
votes
0answers
195 views

$wpdb not working in file of WordPress plugin

I am working in WordPress plugin. I create a custom form where user add values and then click on submit button. When user click on submit button its redirect to custom process file, where i write ...
0
votes
1answer
81 views

Run an update query in a function

I need to run the below in a function, it updates my database if certain conditions are met. I can't get it to work and I can only assume its because of the "SET @newnum" at the beginning. I've echo'...
0
votes
1answer
128 views

MySQL Select within WP Page template

I have one WP page which contains a form that posts data to a table in the Wordpress database called "members", data such as first name, surname, email, role and bio. Table posts fine and data is ...
0
votes
1answer
86 views

$wpdb->get_results breaking page?

I'm trying to generate a list of years that have posts on a Wordpress page using a "php in posts" plugin that has a shortcode. but the code I'm using seems to break the page. What could be the issue ...
0
votes
1answer
187 views

Multiple wp_options tables to share content across installs

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 ...
0
votes
0answers
21 views

Does WP query update accept variables being built into it?

Trying to figure out if this is a WP specific quirk. The var_dump code shows the correct string to be inserted but the last query dump at the end shows an incomplete query with no variable being ...
0
votes
1answer
475 views

Custom select query two tables by a meta key

I'm using an event plugin which creates wp_ftcalendar_events table in database with start_datetime column. Here's image of whole table: I want to query my posts by start_datetime. I know that I can'...
0
votes
0answers
24 views

$wpdb->get_var not matching after first loop through foreach

I'm trying to match my array with a entries in a table and retrieving the ID of the entry. So I have the following array called $features. Array ( [0] => Body Side Moldings: Body-...
1
vote
2answers
137 views

Getting users who registered 360 days from current date

As per the title, what I want to do is run a custom query that (using WP-Cron) will run once a day to check for users who registered exactly 360 days before the current date (don't need time, just ...
0
votes
1answer
146 views

How to insert a single row to WP database table?

Intro: I have a function that handles a contact form variables in my website. user enters name, email and text. function.php gets variables using javascript. I get more information on the user ...
5
votes
1answer
196 views

So much data in postmeta

Last year started using custom fields and in one year I have 230,540 rows in wp_postmeta table. This year will add more data and new fields and I don't know what to do, to create new table or continue ...
0
votes
1answer
39 views

How to fix this insert? Don't work for me!

I need to fix errors of this insert because this don't work in my script. I'm a beginner in WordPress SQL. Thanks $wpdb->insert('wp_cadastrados', array ( 'ID' => NULL, ...
0
votes
1answer
38 views

Why is this $wpdb query looping 5 times?

I want to only return one value for this query, it's in my functions.php file. The idea is to return a value that I need once post_meta has been updated. It's returning the same (correct) value 5 ...
0
votes
0answers
37 views

$wpdb how can i save my postmeta table before querying it

This function is in my functions.php file. The query returns the value I'm looking for via phpmyadmin, but only AFTER the function has been run in WordPress. add_action( 'transition_post_status', '...
0
votes
1answer
248 views

wpdb query not returning results containing single quotes

I'm using a simple $wpdb query that searches the database for all other posts with the same title as the current one and then displays a link to them on the current post. So if I go to a post titled ...
0
votes
1answer
59 views

Problem in using wpdb

I used "wpdb" in my code But it was not working and the following error: Fatal error: Call to a member function insert() on a non-object Notice: Trying to get property of non-object" in ...
1
vote
1answer
125 views

Convert simple SQL Query to WordPress query

I'm trying to 'batch' update the value in my post_parent fields in my wp_posts table. I can do it from within phpmyadmin using the following SQL Query: UPDATE wp_posts SET post_parent = '8' WHERE ...
0
votes
0answers
33 views

How do I update post based on meta_key in another table?

So I have a function that is called by the wp_schedule_event (cron job) once daily. The goal of the function is to set all posts with a field wpcf-engine-days-to-go that has a value of "0" to a draft. ...
0
votes
1answer
53 views

wpdb insert working in one function, but not another

I have the following function: function addToShortlist($propref) { global $wpdb; if (isset($_SESSION['shortlist'])) { $shortlist = new Namespace\Shortlist($_SESSION['shortlist']); ...
2
votes
1answer
24 views

When and why should I use $wpdb different return types?

This one returns an object $mylink = $wpdb->get_row("SELECT * FROM $wpdb->links WHERE link_id = 10"); An associative array $mylink = $wpdb->get_row("SELECT * FROM $wpdb->links WHERE ...
0
votes
1answer
202 views

Convert a WP Query into a simpler SQL query to fetch only COUNT of posts

I have this WP Query running for each row in my admin screen for a certain post type: $entry_args = array( 'meta_key' => 'wp_comp_entry_competition-id', '...
0
votes
0answers
249 views

Export Wordpress Table to CSV from page

I want to export my members table to csv format on my default download location. So I used a shortcode in functions.php and called it on a page. I am getting an already sent header warning and csv ...
0
votes
1answer
188 views

Site going down due to slow queries

My site keeps going down and the host says it's due to some slow queries overloading the server. They've supplied a list of slow queries, any pointers as to what I should be doing to get rid of or ...
0
votes
1answer
43 views

meta_value timestamp older than now

In my wp_posts table I want to select the rows where post_type == event. I also want to a connection with wp_postmeta from the specific row. In my wp_postmeta table I want to do a where like this: ...
0
votes
1answer
290 views

form $_post action value gets truncated after it passes through two forms

There are three pages page1, page2 and page3. When I press submit on my first form on page 1 my group name field can be catched with $_POST['groupname'] in the destination page but in the page 2 I ...
0
votes
0answers
244 views

Passed variable gets undefined variable error on insert on next page

I am passing a variable with $_POST to another page and on the destination page I want to perform an insert operation and want to use that passed value . The variable "$mygroup" is coming from a forms ...
1
vote
2answers
54 views

Database query works fine outside Wordpress

This is my code <?php global $wpdb; $rows = $wpdb->get_results("SELECT `submit_time` AS 'Submitted', max( if( `field_name` = 'Salutation', `field_value` , NULL ) ) AS 'Salutation', max( if( `...