The wpdb class, accessed via the $wpdb global variable, is used to interact with the WordPress database
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 ...
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
864 views
Use have_posts() with array of post results retrieved by $wpdb->get_results
I don't know if I'm retarded, crazy or just plain genius or not, but I've decided to use tags as a way to link content site-wide (a big ol' many-to-many relationship website for archiving various ...
0
votes
1answer
95 views
how to translate countries output from wp database?
i have a list of countries in french stored in my database (wp_country). i use the code above to retrieve all the countries witth this ecohing echo '"' . $country['name_country'] . '",'; it outputs ...
-2
votes
1answer
309 views
Saving data in a custom table in wp, data sent from jquery ajax [closed]
I have a custom form coded in a page template, data is being sent properly.
Part of the code is this
$.ajax({
type: "POST",
url: "<?php bloginfo("template_directory"); ...
0
votes
1answer
2k views
Retrieving custom fields with $wpdb->get_results
I'm trying to use $wpdb->get_results to retrieve an array of all posts including custom fields. I can retrieve the meta_key and meta_value columns like this:
[meta_key] => state [meta_value] ...
0
votes
2answers
244 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
221 views
Fetching review value using wpdb class
I'm generating an XML file using PHP for a website where they review tech products. In the XML file, I have to display the rating of products. For rating purposes, I'm using GD Star Rating plugin.
...
2
votes
0answers
195 views
post_content getting cut off on blank space on $wpdb->update
I am publishing the following post via xmlrpc
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<html><head><meta ...
0
votes
1answer
105 views
How to reference same column name but different table in custom db query
I use wpdb to connect to a custom db, then I use the following query:
$my_row = $wpdb_c->get_results("SELECT Employee.Name, Area.Name, Area.Region FROM Area INNER JOIN Employee ON Area.ID = ...
0
votes
2answers
150 views
Get comments after specific date
I don't think this is a parameter in get_comments( $args ); so I'm using a SQL statement. First I obtain a comment date from a separate table I created. Afterwards, I want to retrieve all comments ...
0
votes
2answers
54 views
plugin code is pulling information from database in one instance and not in other. What is wrong?
In my plugin code, I am pulling the table id from two tables. The id is being pulled from one table but not from the other and I get errors in both instances. The queries work on mysql when I use ...
0
votes
2answers
371 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 ...
1
vote
2answers
289 views
wpdb Custom Meta Data with 2 conditions
This is one of those problems that I've spent way too much time on, and there is probably a VERY simple solution that I am missing. Any help would be greatly appreciated.
I am trying to populate a ...
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 ...
0
votes
3answers
181 views
Retrieving custom field array value through db query
I'm trying to query the database for posts based on multiple custom fields. This is easy enough with the code below if values are simple:
$querydetails = "
SELECT wposts.*
FROM ...
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
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
126 views
Use Loop or direct database query?
In one of my form input, the options are a list of posts. I can use the loop to get the posts, but, getting things from database table is faster, right?
I see plugins sometimes use db directly, ...
0
votes
1answer
589 views
$wpdb->num_rows doesn't work
I'm trying to perform some checks on custom fields before they are saved on a db. So I decided to use an add_filter as it does this between browser and db. Here is my code
function ...
0
votes
1answer
61 views
Insert data through a script directly in the db
is it possible to insert data through a script or HTML site into the wpdb and this will show up as normal article in the, the same as when I use the 'create new post' page?
Which tables are affected ...
0
votes
1answer
171 views
Can't seem to get set_blog_id working, it just doesn't reset the blog ID
Trying to iterate through a list of the sites and I can't seem to get set_blog_id working. Here's the sample output:
Array ( [0] => stdClass Object ( [blog_id] => 2 ) [1] => stdClass Object ( ...
0
votes
1answer
95 views
child pages from home (or main) page [closed]
How do I create child pages which WP recognises (so I can use the $wpdb->get_results() function in them), and which I can display from my main/home page.
Would I then use normal a href="some url" ?? ...
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 ...
0
votes
1answer
55 views
Linked pages from plugin on front can't see $wpdb
I obviously need more knowledge re this one.
From my plugin.
I have a custom main page which displays my custom db data table of a list of stores.
Each store has a "link" ie using a href eg.
<a ...
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.
...
1
vote
2answers
235 views
Mysql query LIKE not working
I'm using this code.
$blog_list = $wpdb->get_results( "SELECT " . $extra . "blog_id, last_updated FROM " . $wpdb->blogs. " WHERE public = '1' AND archived = '0' AND mature = '0' AND spam = '0' ...
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:
...
0
votes
1answer
509 views
“show tables like” is reporting table does not exist when it does for some people. why? [closed]
I have some code in my plugin init function that checks for the existence of a couple of tables. Some folk with wp3.3.1 are reporting that they are getting the admin notice that the tables do not ...
1
vote
1answer
430 views
using $wpdb to insert a form into a post
I am wanting to take the following form, and use $wpdb to insert it into a post. I have tried reading the class reference page INSERT rows, but I don't really know what should be referenced. I am not ...
2
votes
2answers
438 views
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 include a file that contains some custom SQL functions in a class, in a completely ...
4
votes
1answer
189 views
Query causing load because of SQL_CALC_FOUND_ROWS post counting?
I found this query causing some load in the server, my hosting provdier asked me to look on it.
SELECT SQL_CALC_FOUND_ROWS wp_posts
I think this select no. rows found in wp_posts table.. but i ...
0
votes
1answer
215 views
Jeditable Plugin working as it should - scope issue?
I am using the Jeditable plugin to enable inline editing on a table inside the admin area, generated by a small plugin I've written. (http://www.appelsiini.net/projects/jeditable).
Basically ...
0
votes
2answers
208 views
Trouble inserting string containing quotations marks with wpdb in save_post hook
I'm having trouble with inserting a string which is containing quotation marks in wordpress via wpdb.
I've written a hook for save_post and trying to write the post_title in a table via wpdp->update.
...
1
vote
3answers
928 views
Help With MySQL to WPDB Query Conversion
I have a problem. I've got a PHP script that tracks individual file downloads, and I'm looking for a way to display that number in individual posts. I've got a half-baked solution- a plain ol' MySQL ...
0
votes
1answer
207 views
What's wrong with this wpdb query?
I want to select some tags with the same term_group, I tested it in phpadmin, the query get the correct result, but once add $wpdb flavor, it returns an empty array. Any advice?
$primary_tag_id = // ...
1
vote
1answer
411 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
2answers
249 views
Bootstrapping Wordpress MultiSite Outsite of Wordpress - No $wpdb
I'm working on a plugin for a system to use Wordpress as the authentication backend, so that I can use my existing Wordpress users in another application. The plugin works great when running in single ...
2
votes
2answers
2k views
$wpdb->insert not working in any way
I know this type of question has been asked over and over, but I couldn't find a solution for my problem, so I hope you can help me. I am using WP 3.3. and I have created a custom table. Now I want to ...
0
votes
1answer
313 views
paginate_links on custom query in admin - 'sufficient permissions' error
I have created a page in my admin with this custom query:
$rows = $wpdb->get_results("SELECT * FROM ej_feedback ORDER BY createdtime ASC");
I have made it successfully paginate as required in ...
0
votes
1answer
276 views
$wpdb->flush(); breaks the loop
I am using $wpdb->flush(); at the base of my page in an attempt to prevent the query executing multiple times due to caching however it seems that it isn't flushing the most recent query but the ...
0
votes
1answer
565 views
wpdb->get_var - count author posts, meta value
In an author.php template, i count the author post in a custom post type with $wpdb->get_var,
$post_author = $curauth->ID; //author id
$count = $wpdb->get_var( "SELECT COUNT(*) FROM ...
0
votes
1answer
257 views
$wpdb->get_var next var?
This is giving the same views value for each post how would I grab the next var for each post?
<?php if ( have_posts() ) : while ( have_posts() ) : the_post(); ?>
<a href="<?php ...
4
votes
1answer
248 views
Matching database content types to PHP types
The $wpdb query methods return all query results as strings. For example, an 'ID' column would return a string value like '42' instead of an integer 42.
Is there a way to configure the WP database ...
2
votes
1answer
164 views
Multipart/formatted MySQL query problem
I'm creating a plugin and I want to automate the creation of a MySQL Trigger on a table. The problem seems to be that $wpdb->query doesn't appear to accept either multipart statements and/or formatted ...
1
vote
1answer
476 views
Custom Query num_rows returns wrong amount
So I have a custom query that fetches all posts in a given category. I am trying to get the number of rows returned but it is giving me the wrong number.
Instead of 11, I am getting 14. Does anyone ...
0
votes
1answer
229 views
How can I change my meta_query to SQL wpdb query?
I want to extract post related to 3 meta_data fields called bed_value, bath_value, rob_value the variable data is $bedrooms, $bathrooms, &rob, I got some confused with join and like structure. The ...
0
votes
4answers
624 views
Trying to display posts by authors in with specific user meta
Ok here's the solution:
<?php
$wp_user_search1 = new WP_User_Query( array(
'meta_key' => 'state' ,
'meta_value' => 'NM',
));
$listers1 = $wp_user_search1->get_results();
$lister_ids1 = ...
1
vote
1answer
234 views
using custom taxonomies on non wp table?
I'm building a program registration system that will have a complex data structure. There are programs (custom post type, CPT), teachers (CPT), registrations (custom table and meta table), payments ...
5
votes
7answers
1k views
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 problem is I am unable to search the query for each functionality/page
I found
...
