The wpdb class, accessed via the $wpdb global variable, is used to interact with the WordPress database
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
322 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
293 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
568 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
266 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
261 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
172 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
483 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
233 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
647 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
243 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
...
0
votes
2answers
207 views
wpdb function insert doesn't work
It just won't insert anything, if I echo it, it will show everything fine, but it won't insert anything in database. The table name is correct. Code -
global $wpdb;
$meta2 = ...
0
votes
1answer
939 views
How does $wpdb handle COUNT(*)
I understand how to do simple queries and display results using $wpdb. This is my process:
<?php $sql = 'select * from wp_votes;'; ?>
<?php $votes = $wpdb->get_results($sql); ?>
...
0
votes
1answer
820 views
Wordpress database error: [Query was empty] - using $wpdb->prepare()
I have edited my question, I'm now getting the error about checking my MySQL settings. I changed the $sql_dvalues variable to an array with the values instead of comma spaced values and now it is ...
0
votes
1answer
2k views
wpdb->prepare and mysql UPDATE - how is it done?
Trying to set a 'removed' date time in a plugin query but I'm not sure how to use UPDATE SET with $wpdb->prepare.
Here's my query:
$cur_date = date('Y-m-d G:i:s');
$rows_affected = ...
0
votes
1answer
81 views
Why doesn't my Table get created?
I am working on creating a table in the DB for a plugin but cannot figure out why the table is not being created.
Here's my code:
global $ds_swoons_db_version;
$ds_swoons_db_version = '1.0';
...
0
votes
1answer
262 views
Making plugin to use different table prefix cause permission problem
I have multiple wordpress websites that uses the same files and database but with different table prefixes, I use a plugin "Shortcode Exec PHP" and I would like to use the same shortcodes on all the ...
1
vote
1answer
329 views
MySQL Query To Select Post By Postmeta
I have two custom post types, type1 and type2. Type2 posts have a postmeta called postID that is the ID number of a post in type1. When showing type1 in single.php I want a mysql query that selects ...
0
votes
1answer
89 views
overcoming wpdb->insert stripping the <b> tags [closed]
I'm using the following code to insert records for my plugin into the db- i need the tag as some posts need special css
$insert_array = array(
...
4
votes
1answer
139 views
Get total number of comments from posts in a specific custom taxonomy
I’m having some difficulties trying to get total number of comments from posts within a specific custom taxonomy.
The setup is as such: I’ve created a custom taxonomy for my posts, called “features”. ...
0
votes
1answer
2k views
$wpdb->insert - inserting multiple rows
How do I use $wpdb->insert to insert multiple rows. Here is my code.
for($i=0; $i<=$urlCount; $i++) {
$stat = $wpdb->insert(
'WP_URLS',
array(
'POSTID' => ...
1
vote
1answer
110 views
MySQL Rank & $wpdb
I need a rank column in my MySQL statement, for example:
SET @rank=0;
SELECT @rank:=@rank +1 as rank, player, points
FROM my_table
Is there a way to use the above with $wpdb? WordPress doesn't ...
1
vote
2answers
530 views
Use $wpdb in wordpress theme files
I want to use $wpdb in a theme file, but it doesn't work. My code is bellow:
<?php
$action = $_POST['action'];
$updateRecordsArray = $_POST['recordsArray'];
if ($action == "updatelist") {
...
0
votes
2answers
720 views
How do I modify this wpdb query to include posts that have a post_status of publish and draft?
I'm using the following function to count the number of posts an author has made from a custom post type.
<?php
function count_user_posts_by_type($userid, $post_type) {
global $wpdb;
...
1
vote
1answer
702 views
$wpdb doesn't appear to work on page inside of a plugin
I have a plugin folder foobar.
Inside this plugin I have a page called foobar.php. Inside this page I have
global $wpdb;
$orderby = (!empty($_REQUEST['orderby'])) ? $_REQUEST['orderby'] : ...
4
votes
1answer
1k views
wpdb->insert: do I need to prepare against SQL injection?
Do I need to use wpdb prepare before wpdb->insert?
If I am inserting values into a wordpress table using wpdb->insert, do I need to "clean" my data before inserting it or does this method ...
0
votes
1answer
674 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
860 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 = ...
1
vote
1answer
496 views
wp_create_user not properly entering password
I'm trying to create a new user after someone fills out a form. I'm using wp_create_user to do so. A user is being created properly, but, for whatever reason, no password is being submitted to the ...
0
votes
1answer
210 views
query for filtering published posts?
i need to filter count based on a date and post_status = 'publish', how to write a query to filter, as far as now i have filtered based on date, what is the query need to filter based published post.
...
0
votes
2answers
150 views
How to query and update one colum in postmeta table?
I'm trying to make a popularity calculation for all posts, based on page view and date of creation. Initially, there's a default popularity value saved in postmeta. Every hour I want to recalculate ...
0
votes
1answer
540 views
Formatting a date/time returned from a custom $wpdb query
I'm definitely a rookie WordPress/PHP developer, so please forgive ignorance :-)
Q: How do I format a date/time returned from a custom query against $wpdb?
Here's the scenario: I'm trying to write a ...
0
votes
2answers
8k views
How to parse row results from $wpdb -> get_results
I have the following:
$query = 'SELECT * FROM wp_pod_tbl_add_questions WHERE id LIKE '. $id;
$row = $wpdb -> get_results($query);
How do I get the ...
0
votes
1answer
374 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
2answers
787 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() ) : ...
5
votes
2answers
207 views
Does wpdb add considerable overhead on queries with large result sets?
I am working on backup-related plugin and from some research of existing plugins - they seem to favor using PHP's mysql_* functions, rather than $wpdb.
Is $wpdb overhead considerable enough that it ...
2
votes
3answers
3k views
Pagination with custom SQL query
I have my own SQL string to select Custom Post Type posts with specific WHERE clause. I've used the offset and limit to return appropriate posts depending on a page being displayed. That's working ...
0
votes
1answer
508 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 ...
0
votes
1answer
931 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 ...
3
votes
1answer
668 views
Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
I am wondering from the syntax
$sql = $wpdb->prepare( 'query' [, value_parameter, value_parameter ... ] )
It appears (from the syntax - values within prepare) that it simple escapes values not ...
1
vote
2answers
218 views
How do I order my loop query?
I have a table in my database containing vote a tally I'm trying to order posts by.
screenshot: the table
I've tried something like this, which brings up all the voted posts and pagination okay but ...
0
votes
1answer
80 views
db query for retrieving comments without any reply
what is a query for selecting a list of comment id's that have not had a reply yet so I can use it to iterate though each comment id and echo out the post it is on and the excerpt of the comment along ...
0
votes
1answer
120 views
How to create a list of terms who's posts also have a predefined external term?
I have a pretty extensive music collection and my friends are always borrowing my stuff. I would like to keep better track of my library so I'm building a sudo-checkout system using WP.
The ...
0
votes
1answer
459 views
Out of Memory - Line 791 of WP-DB.php (mysql_real_escape_string)
Update The end result is that I did not account for Apache memory limits. There were limits placed on the Apache process which caused PHP to be limited regardless of the settings placed on it. ...
2
votes
1answer
712 views
How to filter a dd/mm/yyyy date from a custom field in a query
I'm trying to build a query in order to sort some posts by a date custom field, where the dates are formatted dd/mm/yyyy.
It works by querying the database directly with get_results like in this ...
1
vote
1answer
158 views
Most effective use of DB querys
I've got a custom database table with lots of data that I'd like to query several times from a custom template file I've built. Say the db table looks like this:
id name city zip
23 ...
1
vote
1answer
1k views
Can't use get_results() in ajax query
I'm using a jquery ajax call to get certain data from wpdb and I'm getting the following message:
<b>Fatal error</b>: Call to a member function get_results() on a non-object in ...
0
votes
1answer
998 views
Query and get meta as object(stdClass) on wp postmeta table?
I want to get a groups of data from postmeta table.
The postmeta table have 4 colums, meta_id, post_id, meta_key,meta_value.
Each post_id has a list of meta_keys.
I want to run a query and get a ...
0
votes
2answers
751 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 ...
