The sql tag has no wiki summary.
1
vote
2answers
166 views
wpdb->prepare function remove single quote for %s in SQL statment
I am using the below wpdb->prepare function in a sql statement. I am passing in several variables some field names and some values. When I try to use the %s for the field name it puts single quotes ...
1
vote
2answers
35 views
How do you use prepare when asking for a list of id's
I'm looking to get a number of records back from the database given a list of numbers and was wondering how I would use $wpdb->prepare to do this (to take advantage of the sanitising vs SQL injection ...
1
vote
1answer
77 views
Get the timout value of a saved transient?
Does anyone know if there is a Wordpress function to get the timeout value of a saved transient? I am using a transient with a 5 minute timeout to cache data from a web API call locally. Between ...
1
vote
1answer
157 views
Location-Based Pages displaying results near customer
I'm creating a website where the customer will enter their postal code and the pages (with a distance selected of 5, 10, 20 miles) will display on either a Google map or Bing map. The page results ...
1
vote
1answer
285 views
Importing Geo data into wordpress database
I have a listing wordpress site and want to integrate geo data into the Wordpress MySQL Database for custom search functionality
I want to utilize different aspects to create different things...
...
1
vote
1answer
248 views
Detect session/cookie variable in wordpress to prevent access to documents
<?php
@session_start();
If (!array_key_exists(‘authed’, $_SESSION))
{
include ‘not_authed.inc’;
exit();
}
// go about your business.
?>
and i'm trying to add that to this:
...
1
vote
1answer
752 views
Modify Wordpress SQL Query to pull from within a category
I am using a wordpress plugin called "kf most read" which stores a count of how many times a post was read, and lets you output a list of most read posts.
This works well. The issue is, I am trying ...
1
vote
1answer
20 views
wpdb query problem to access previous 3 days posts
I am trying to get all published posts titles by author id 2 most recent by post date for the last days. Here is my query:
"SELECT post_title FROM $wpdb->posts WHERE post_status = 'publish' AND ...
1
vote
0answers
25 views
Meta Query And/Or
My question is very similar to Meta Query with AND & OR? . This question was answered in 2011 by @Otto.
With the exception that my logic is different.
I want to query, for example, posts with ...
1
vote
1answer
44 views
Wordpress Custom post query sorting does not work
I created a custom WP query to collect products that have 3 different taxonomy values in them and sorted them by price using the following:
$my_products = new WP_Query(
array(
...
1
vote
0answers
132 views
Retrieve/get current image from Nextgen gallery db
I thought that I can do it using the database where the idea was to get the image from the ngg_gallery_pictures table, where the browser URL is equal to URL of the image in the table.
Then I will get ...
1
vote
0answers
183 views
Why is my 'list_terms_exclusions' filter function timing out? [closed]
Why is my function timing out?
When the issue was first noticed I added wp_defer_term_counting('true') to delay that process but to no avail.
/* Filter category from get_categories and ...
0
votes
2answers
263 views
Moving an entire wordpress site from one domain to a new domain and database
I have done all the steps requiered to import the dump.sql file to new database, and copiey the entire content from the old domain over to the new one.
When i login to mydomain/wp-admin, i'm ...
0
votes
3answers
523 views
Code to remove authors with no posts connected to them
I am looking for SQL code that I can run from phpmyadmin to remove all registered users on the blog that do not have any post associated with them.
0
votes
3answers
616 views
How do I move a Wordpress site to another server?
i'm using this sql..
but it does not work
UPDATE wp_options SET option_value = replace(option_value, 'http://old.com, 'http://new.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE ...
0
votes
3answers
3k views
Authors list Pagination : result set from $wpdb->get_results()
Using this solution :
Paginate result set from $wpdb->get_results()
I did make my code for Authors list page template as follow:
<div>
<table id="mytable"><tbody>
<?php
// ...
0
votes
2answers
2k views
Scanning Database for malicious Data
After a site of a friend has been hacked I told him he should just clean up the mess and restart from scratch so he know that no file has been altered.
I could scan the site for him with tools like ...
0
votes
1answer
185 views
Total number of posts in last year
How can i echo total number of posts in last year ? I‚m writing article with stats, and want to get number of posts i published last year.
There is something here, but not for last year ...
0
votes
1answer
55 views
List recent 25 blogs across the network
I need to list recent 25 blogs in the network with their title. How to edit this code ?
$bcount = get_blog_count();
global $wpdb;
$blogs = $wpdb->get_results($wpdb->prepare("SELECT * FROM ...
0
votes
3answers
533 views
How do I add indexes to Wordpress Database?
I got a message from Hostgator about my account being suspended because of the load it put on their servers. This is about the fifth time this has happened. I am on a shared server.
And they said it ...
0
votes
2answers
1k views
SQL query to extract only the “current” wp_posts?
The wp_posts table seems to retain all revisions of the same, ok very similar but presumably different, posts/pages/whatever.
I'm somewhat conversant with SQL but not WordPress. I need to extract ...
0
votes
2answers
707 views
How to set up default values for a plugin?
What is the best way to go about setting up default values for a plugin? Should I just insert those values into the wp_options table?
AND...if that's the best way to go about it, I have another ...
0
votes
1answer
372 views
Speeding SQL queries for a large database?
I am using a WordPress plugin called feedwordpress in order to run a planet like website on wordpress (See it here).
The plugin is great except for one thing - it hogs down my (VPS) server into ...
0
votes
3answers
325 views
Problems with moving my Wordpress site to another domain/server
I'm having problems moving a wordpress site from one domain to another. I've searched the site but couldn find a useful answer for my situation.
Here's what i did:
I made a backup of the website. ...
0
votes
2answers
46 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
25 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
104 views
pull data from a remote wordpress database
I am trying to pull some data from a remote wordpress database. Here is the code I have:
$server = "my server code";
$user = "my username";
$password = "my password";
$db = "mydb";
$con = ...
0
votes
1answer
37 views
How to migrate a database from a server to another
I try the export method of phpmyadmin, but the user is exported with the data... so there is no way to re import it into another database without error message.
The old user is name : ...
0
votes
1answer
65 views
Proper approach to moving complete site from one domain to another AND preserve widgets
I consider myself fairly versed in this matter, however I've recently had a rash of issues when moving sites. I am able to successfully move the site, edit wp-config.php, move the database, etc.
...
0
votes
1answer
44 views
Removing posts by sql
Often i build a site and we have test posts. I was wondering if there's a way via sql to drop all the blog posts with a simple sql query.
Obviously, I would have backed up my previous database before ...
0
votes
1answer
598 views
Export SQL query based on post type
I'm looking to export only wp_posts where post_type = post.
Is that possible?
0
votes
2answers
385 views
How to rename a custom field?
I have 3000 posts with that custom field name 'refer' and i need to change it to 'ref' for theme needs, instead of doing it manually i need a query or technique to change them all.
Question 1
I am ...
0
votes
4answers
895 views
I need a SQL command to delete specific authors and all posts connected with them
I unfortunately have authors with a lot of unreadable/spam posts published (thousands some of them)
I have tried deleting through admin,but its a slow painful process-does anyone have a specific SQL ...
0
votes
2answers
44 views
How can I get all author written content?
I have a site that needs two different tabs:
1. all author written content (Posts, comments, CTP)
2. all author followed content (categories, taxonomies, other users content)
For the first all I ...
0
votes
1answer
22 views
How do I query for posts by custom meta and those that have been stickied?
I realize how clumsy and inefficient this query is but SQL is not my strong point. I use the following query to pull the latest 8 events from a custom post type called Event Posts. However, I also ...
0
votes
1answer
53 views
Custom SQL query ORDER BY term_order
I have custom taxonomy that list terms under "series" that contain posts that are also present in terms under "media_type" and where media_type is term_id 16.
I want to order the list by the ...
0
votes
1answer
112 views
Using color schemes with Color Picker
What I'm doing
User interface to change website colors - User can change colors individually (like menu color, footer color, content color), or use color scheme that will change all colors (values ...
0
votes
1answer
35 views
Print page content with formatting when doing custom SQL query
I guess there's a simple solution for this but couldn't find any.
I'm trying to fetch 3 pages and show them on footer. The problem is that every page is shown as text without formatting which means ...
0
votes
2answers
134 views
SQL query to get posts from multiple categories but not in a category
I need to get the last posts' ID and the post_tile within categories 1 and 2, and exclude those within category 3. It must be SQL, because if I use WP_Query it retrieves too much info and I only need ...
0
votes
1answer
114 views
Wordpress SQL JOIN query
Hi
Im trying to run 2 querys in the same query call.
// send the query
global $wpdb;
$commentQ = "SELECT * FROM $wpdb->comments " . $whereClause . $orderBy;
$comments = ...
0
votes
2answers
46 views
How to delete ALL comments from certain category in Wordpress database?
I'm trying to delete all comments from posts in a certain category in a Wordpress database.
The Wordpress database is rather complicated so this must be probably some join of wp_posts, wp_comments ...
0
votes
1answer
42 views
Return number of items in a table with post id
I am trying to return the number of reviews for a given page id, I have this so far...
<?php
global $wpdb;
$countreviews = $wpdb->get_var($wpdb->prepare("SELECT COUNT(ID) FROM ...
0
votes
1answer
134 views
Export all posts to import as product items
Up until now, my client has been using WordPress posts as his way to display his products. I now need to export all these posts into a CSV format so that I can format the CSV file and import it back ...
0
votes
1answer
157 views
SQL query add only posts with custom field to array
I have this SQL query which is building an array of wordpress posts...
$query = "select $wpdb->posts.* from $wpdb->posts,$wpdb->terms,$wpdb->term_taxonomy,$wpdb->term_relationships ...
0
votes
1answer
241 views
SQL Query members by profile fields Buddypress
i am trying to add a profile based search option into my existing plugin. my plugin already search members by distance within a certain radius and i want to add the option to filter results by profile ...
0
votes
1answer
190 views
Show array of meta_value in Edit Post Coloum
what I'm trying to do is add a new coloumn to Edit post page (done) and in that coloumn show data taken from a set of custom fields (partially done).
This is my code (I use it as a plugin so it ...
0
votes
1answer
1k 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
218 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.
...
0
votes
1answer
158 views
Remove password protection from all posts
So I messed up my blog (QBobble). I had an SQL backup, fortunately, so I reinstalled Wordpress, and imported my SQL database.
Unfortunately, it password protected all of my posts. I know that I can ...
0
votes
3answers
88 views
quotes problem in very simple sql
I just simply want to execute a SQL sentence inside of a post (i am using EXEC-PHP widget for that).
The problem are the quotes when i want to do something like
$my_name='hello'
"select * from ...
