The wpdb class, accessed via the $wpdb global variable, is used to interact with the WordPress database
1
vote
0answers
62 views
Changing status of Published posts which have less Content to “Draft”
function draftpost(){
global $wpdb;
$prefix = $wpdb->prefix;
$wpdb->query("UPDATE ".$prefix."posts SET post_status='draft' WHERE LENGTH( post_content ) <500");
}
...
1
vote
1answer
29 views
Get a row from a separate table by matching a posts meta_key to a tables ID column
I am trying to match a posts meta_key value to a separate tables column ID and call that row/array in the single-listing.php.
I have a meta_key value that is called dot_number. The table is called ...
1
vote
2answers
38 views
queries inside of a class
I'm building a plugin and I'm quite new to wordpress I have a class what has couple of methods what should execute database queries. The class look as it follows
class MyClass{
private ...
1
vote
0answers
173 views
$wpdb->get_results() returns good result only in first foreach iteration
I've got strange issue when I am using $wpdb->get_results() in content-single.php in Twenty Eleven theme. $wpdb->get_results() returns proper values only in first loop iteration. I've got simple ...
1
vote
0answers
29 views
Code only works every other time its run
This code below works fine as long as I leave the $wpdb query commented out.
However, I'm trying to clear the current settings before I write the new ones into the db. That's the purpose of the $wpdb ...
1
vote
1answer
419 views
Problem in creating table through plugin code
I'm using the following code to create the database table using plugin.
However, the table is neither getting created nor I'm getting any error message.
The code is as follows:
global $wpdb;
...
1
vote
0answers
106 views
Query most popular terms by taxonomy over 2 week period
I have written SQL for a query that pulls the most used taxonomy terms for selected taxonomies that are published, do not have a parent post are not in a comma separated list over the past two weeks ...
1
vote
0answers
102 views
wpdb updating record in wordpress with json adds extra array elements
This is killing me - I keep getting magical array elements added to my updated array in WP.
For example if my query is (var_dumped below):
string(70) "UPDATE wp_mytable SET already_played = '[9]' ...
1
vote
1answer
172 views
Which action does wp_update_user triggers?
I am working modifying an ecommerce plugin, and it makes uses of wp_update_user() function, and everytime the function runs another table (created by the plugin), gets updated too. The problem is that ...
1
vote
0answers
111 views
How to display users with posts published between two dates (Sorted by Post-Count) [Multisite]
i try to make a list of users who have published posts within two given dates.
My attempts using WP_User_query just work for one blog ID and takes time to load because it runs through a lot of ...
1
vote
1answer
254 views
Retrieving multisite blog IDs, somehow failing to foreach them properly
Working on a directory listing and have cobbled together the shortest query I can. It appears to return the listing ok (I think) but the foreach is somehow failing to process the array properly. Can ...
1
vote
1answer
329 views
passing variables as parameters to stored procedures via wpdb from php-script
i am having a slight problem with passing php-variables to a stroed procedure call from a php-script. Here comes the details:
This is how it works very perfect - passing the params as string:
...
1
vote
1answer
410 views
Programmatically Creating Page using $wpdb and getting 404 error
EDIT: Turns out I had a permalink issue that was causing the 404 error.
Original Posting below:
I am creating a page programmatically using $wpdb->insert() and the resulting page returns a 404 ...
1
vote
1answer
282 views
$wpdb not being defined in function: Fatal error: Call to a member function query() on a non-object
For some reason the $wpdb object is not being defined in one particular function. I have four other functions in the file that are using $wpdb and all are working fine except this one simple delete ...
0
votes
2answers
84 views
wpdb-> not adding prefix to custom table
I know it should work with custom table and I think it worked in previous development I believe. But this time I don't know whey it is not getting custom table with $wpdb->tablename
Code:
global ...
0
votes
1answer
226 views
Stackoverflow type of badge plugin giving warnings in Wordpress 3.5
I modified an abandoned Stackoverflow form of badge plugin to work with Wordpress 3.4.2 and it does indeed. The full script for it is here: http://pastebin.com/Ta91zXiL
When upgrading to Wordpress ...
0
votes
2answers
145 views
How to obtain a reference to $table_prefix in $wpdb object
I need to call the WordPress options table and pull some data. However, the table name may be different (typically wp_options) depending on whether the default table prefix was used on installation.
...
0
votes
1answer
1k views
How to close wpdb connection?
Is there any method to close connection similar to mysql_close() for wpdb in wordpress?
Is it not necessary to close connection for global wpdb?
0
votes
1answer
2k views
Fatal error: Call to a member function query() on a non-object
In the code below (from my functions.php), I'm attempting to create an array of items from the wp_postmeta table where the meta_key is "_wp_attached_file". I'm getting an error:
Fatal error: Call to ...
0
votes
1answer
28 views
Doing a loop with multiple DBs simultaneoulsy
I have a website setup made up of with more than 3-4 WordPress setups as subdirectories of main. For example:
Site
|
---------- Site/Site1
|
---------- Site/Site2
|
---------- Site/Site3
Each have ...
0
votes
1answer
143 views
$wpdb error (Call to a member function insert() on a non-object)
I have very few knowledge on oo php and databases, and I am simply trying to insert data in my wp_pagesvisites table but I am having some trouble with this error message.
This is my script:
...
0
votes
2answers
91 views
Custom Query based on custom field of a single post
I have posts which have a custom field date in the format yyyy-mm-dd.
What Im trying to do is list all the posts for a specific year on the side of a single page based on the year in the custom field ...
0
votes
1answer
141 views
Using WPDB class
I want to use the wpdb class on my external page not associated with wordpress.
I tried to include the following on the php file:
// include wordpress functions
include( $_SERVER['DOCUMENT_ROOT'] . ...
0
votes
1answer
654 views
$wpdb->get_var not returning a result
I launched mysql and confirmed this query returns a result:
mysql> SELECT * FROM wp_posts WHERE post_parent = 68 AND post_type = 'attachment' AND post_name = 'side-logo-auto2' LIMIT 1;
1 row in ...
0
votes
1answer
255 views
SQL query not working in alphabetical post title/content search
I have an ajax request using wp_ajax sending one variable named "q" what I want to do is after the script get's the request to look inside the db and fetch the title and id of the corresponding posts ...
0
votes
1answer
211 views
Wordpress db prepare
I am not trying to use $wpdb->insert, but prepare.
Insert method will have one query string and an array which includes # of data which is not defined but will be defined for each query string ...
0
votes
2answers
222 views
wordpress $wpdb works only once
I am working on a plugin that needs to run many different queries. I created a class that has many functions and all these functions runs different queries. A DAL basically.
Now when I call these ...
0
votes
1answer
369 views
$post not working working in AJAX plugin with custom post type
I am trying to create a plugin that can relate two posts to each other, and to do so I am trying to use AJAX, but I am having trouble getting the current posts ID using $post->ID.
I am trying to ...
0
votes
1answer
892 views
Join inside a wpdb query.. confused!
I need to get a return from a query that provides me with email, username or nicename as well as post title based on author id.
The query is to run once daily via cron and look for posts that have ...
0
votes
2answers
701 views
How to test the outcome of a wpdb query?
I want to get all the data with the meta key of "project_id" from post meta table. I wrote a query, it should work in thoery, but I have no way to see what I get, and inject this query to my plugin ...
0
votes
2answers
1k views
Use mysql_query instead of $wpdb query
I have a custom table inside my wordpress database called test.
What if i query this table using mysql_query() instead of using for example $wpdb->get_results()
Will this affect my performance?
Ty ...
0
votes
2answers
537 views
Have working sql query… trying to adjust it to use $wpdb
So I have this code that queries a custom plugin generated table in the wp database. It works perfectly as is. But I'm trying to adjust it to use $wpdb instead of the $con function I have set up.
...
0
votes
2answers
731 views
Wordpress(wpdb class) and mysql stored procedures
$query = "CALL ..........";
$result = $wpdb->get_results($query);
print_r($results);
Is returning an empty array and $wpdb->query does not return anything, how do you run stored procedures from ...
0
votes
1answer
24 views
Best practice to limit results in get_row()?
This is my query to check if a title exists (it's in a loop, therefore [$i]).
$wpdb->get_row("SELECT * FROM wp_posts WHERE post_title = '" . $titles_arr[$i] . "'", 'ARRAY_A');
Anyway, I would ...
0
votes
2answers
36 views
query_post and wpdb returning different results
I am trying to get the woocommerce products by category.. When I query using the wpdb it gets the product correctly which exists in the backend products list. But when I query using the query_posts it ...
0
votes
2answers
50 views
Really simple query giving error in SQL syntax
I'm sure this is a simple oversight but I cannot seem to narrow it down:
global $wpdb;
$tablename = $wpdb->prefix . "icrm_folders";
$sql = $wpdb->prepare( "SELECT * FROM %s", $tablename );
...
0
votes
1answer
26 views
Custom $wpdb returns unexpected time based results
I am using the $wpdb class to do a custom SQL query but I am getting weird results.
Basically this is what my SQL query is supposed to do
Retrieve the titles of post_types 'question' only if they ...
0
votes
1answer
41 views
Specify strict 'order by' in WordPress query
I have a custom post type called Employees where an employee's name is the post_title of each post.
I am trying to figure out how I would sort the post_title column by last name.
So for instance, if ...
0
votes
2answers
136 views
Speed optimization of $wpdb->get_results
I'm using this code to generate all my custom field values from all posts for custom field named "autor".
<?php $autor = $wpdb->get_results("SELECT meta_value AS autor FROM wp_posts, ...
0
votes
1answer
322 views
Creating an auto result search bar
I'm trying to create a search bar that will show me titles of posts when the user types into the text field.
I'm completely new to this and I really don't know how to go about doing this. What would ...
0
votes
2answers
92 views
Build index page from custom fields
Im starting to delve deeper into Wordpress custom fields and wanting to replicate this page in Wordpress:
http://www.clubsact.com.au/corporate/index.php
So my site is not tightly structured to a ...
0
votes
1answer
183 views
Problem adding 'has-children' class to wp_nav_menu
According to a number of references online, I should be able to use the following function to add the class, has-children, to menu items that have children under them:
function ...
0
votes
1answer
144 views
Why does this WPDB code throw an empty WPDB error? [closed]
I'm writing a feed reader plugin for wordpress. I'm seeing a DB error that I can't figure out.
First I create a table called user_entries.
Then I put a sample entry into that table.
When I try to ...
0
votes
2answers
243 views
include wp-blog-header not working on MAMP
To clarify my question...
My plugin is/was using AJAX to call the file pluginname/submit/pick.php My pluginname/pluginname.php contains the usual plugin header and wordpress automatically finds it.
...
0
votes
2answers
369 views
Ajax call in wordpress not working for subscriber user
All
In my application there is notification system, when user click on that icon I want to make ajax call.
The problem id it works fine for admin user (Debug : 200 ok), but not for subscriber user ...
0
votes
1answer
318 views
Best practice to import user base (subscribers) from one website to another?
I want to import users from a Wordpress installation to another.
Same domain, but complete different websites.
Website A (old, 700 users): running WP3.0 plain installation + BBPress 1.x
Website B ...
0
votes
1answer
664 views
AJAX wp-mysql running too slow
I have made a function of ajax, which returns all the posts starting with a particular alphabet, suppose a user clicks on letter A, then all the posts starting with letter A will be displayed, any how ...
0
votes
1answer
834 views
Wordpress $wpdb get posts from category and sort by custom meta
I have a custom post type of 'events' which has a meta key 'event_date'
Im using the following to retrieve those posts and arrange them by 'event_date'
global $wpdb;
$today = ...
0
votes
2answers
753 views
How to change a custom query into a standard loop?
I'm trying to modify how results are displayed in a post list that's currently controlled by the code below. However, it's not built in the WP_Query while ( $the_query->have_posts() ) : ...
0
votes
1answer
495 views
Wpdb->insert() doesn't insert new row after the last one
In JavaScript, I'm using an Ajax call and I'm sending an array of shops.
Except for the last element in the array all the shops already exist in the DB.
The last element is a new shop.
The PHP code ...
