Tagged Questions
0
votes
0answers
10 views
How to export/import theme customizer settings?
I am wondering if it is possible to export theme customizer settings(theme_mods) to be imported into another install of the same theme. I know that the settings are saved into the database so I am ...
0
votes
0answers
37 views
Host does not allow remote connection, so how do I transfer data to my WordPress site?
I spent the last week trying to get my PHP code on my website to connect to my remote "personal" computer to display some data on a webpage. I just found out today from my web host (ipage)
"our ...
0
votes
0answers
41 views
Trying to post information from a remote database to wordpress page
I'm fairly new to Wordpress and looking for some help.
Goal: I would like to stream data from my personal computer's Mysql database and display it on a webpage in my offsite Wordpress hosted site. ...
0
votes
0answers
21 views
MySQL Engine vs. Charset
I am attempting to have my plugin create a new table. I am fairly new to SQL. I have found two different method for creating tables:
Method I
$table_name = $wpdb->prefix . 'cool_table';
$sql = ...
0
votes
1answer
47 views
Creating Database Table vs. Adding MetaData to Post & User
I am creating some event functionality for my wordpress site.
Each event will have a set of tickets associated with it.
A user who is purchased at least one ticket will additionally have a set of ...
0
votes
1answer
77 views
Query specific posts per user selections from dropdown menus
This may be a little different than most people do. I'm trying to show certain posts that are determined by 4 different "categories." I have a large database table full of "products" (I'm using the WP ...
-3
votes
2answers
168 views
Preventing duplicate entries in mySQL database with PHP
I have a contact form (Contact Form 7) that submits all fields into a mySQL database (via the Contact Form 7 to Database Plugin), everything is working fine with that. I want it to however, throw the ...
3
votes
1answer
245 views
Wordpress admin never finishes saving page on site with large page count
I have a Wordpress install with a very large amount of pages (a few hundred thousand), and over time it has gotten to the point where editing a page takes an extremely long amount of time. It would ...
0
votes
0answers
45 views
downloading BLOB from database [closed]
I have a small problem with the php content-disposition, I kind of understand where the problem lies but I have no idea how to solve it (new to using databases). Calling this php page will result in ...
-1
votes
4answers
105 views
Insert into db with foreach problem
I have no idea why this foreach it`s not running. When i post the article, only inserts once. Should make it at much as needed. Do you see any problem?
$array_produse = array();
for($i=1; $i<=8; ...
0
votes
1answer
45 views
Is this plugin safe to run?
This is an extract of code from a wordpress plugin. Is it safe to run despite the variables not being filtered? Also does the wpdb class filter to prevent any injection?
list($email_id, $user_id, ...
6
votes
2answers
128 views
How to check if image is already stored in a site's post database? (network)
I currently have configured Wordpress so that a post can be copied to other sites within a Wordpress network. However, a post may be broadcast more than once, and I want to check if the image is ...
0
votes
1answer
85 views
Using custom tables for old posts
I have a site with about 24,000 posts and 200 posts daily and the database will get huge soon. So I plan to transfer the old posts to custom tables to reduce the database load. There's no need to show ...
0
votes
1answer
54 views
Make Database query only when option is updated
Below is a DB query I am using to retrieve values and place them in a WP_List_Table. Values are currently being added by add_option, then those values are converted into a custom database table ...
0
votes
1answer
65 views
Filtering a Database Query
In a WP_List_Table example I'm using, I am seeing how to make a general query to the wp_options table in the Wordpress database.
For example, $query = "SELECT * FROM $wpdb->options";
I also see ...
1
vote
2answers
277 views
Prevent Data Resubmission On Page refresh
UPDATED FOR CLARIFICATION
I've got this rating plugin that keeps submitting & duplicating the rating data on page refresh. When a user wants to add a rating, they have to click a button that ...
2
votes
2answers
474 views
Check if post of title already exists
I'm writing a plugin that takes an xml feed and posts it into WordPress using wp-cron
Everything is working dandy, except it keeps adding the same posts over again.
So, I'm working on a system to ...
0
votes
1answer
54 views
Does WordPress cache get_user_meta() results?
If I call get_user_meta() to retrieve a value, does WordPress cache the value? If I call get_user_meta() to retrieve the same value, does WordPress have to query the database again or is it stored in ...
1
vote
2answers
212 views
How to create and work with custom data / tables (i.e., for arbitrary data)?
Getting started on Wordpress just today. I noticed that Wordpress created tables in a mySql database (with name *.wrdp1) when I first set it up. These tables cover comments, posts, users, and some ...
-1
votes
2answers
232 views
PHP Call to External Database
I am using the Sleek child theme from Studio Press and want to do a PHP call to this external database for it to display just like this link: http://www.escort332.org/tuskegeecadets.php . The Theme ...
0
votes
2answers
191 views
Add custom php database code above <head>
I have a non plugin script that has it's own database and I want to use it with Wordpress. How can I add custom php code that connects to this separate database in my wordpress pages? It needs to go ...
2
votes
1answer
435 views
How to edit/delete single row items in a table on my own menu page
I have successfully created a wp-LINKS-list-table that displays the output of WP's core "Links" table in the WP Dashboard, and I have it displaying on a menu page I created. Step 1 accomplished!
...
0
votes
1answer
143 views
How to display results from a data table with an encrypted user id?
I'm trying to display a table of results for particular users who have submitted answers to quizzes. The problem is that the mysql database I am working with has a funky value for the user's ID.
I'm ...
3
votes
2answers
83 views
Wordpress will not operate correctly
My website is ImASpy.com. If you click on the link, Findings, this takes you to my first Wordpress page. It appears to work fine until you click on comments, or you try to go to the about page, which ...
1
vote
2answers
429 views
Import 10,000 Users into Wordpress WITH a specific ID for each user
I have a website which has about 10,000 users. I am converting this site over to Wordpress. The new site is ready to roll, but I have to bring over all the users.
There are a number of plugins ...
1
vote
1answer
121 views
Adding Custom Forms
I'm looking to create a page for a wedding site that will have a form. The idea is that it is an RSVP page where a visitor will input a unique string that was on the invitation that they received and ...
2
votes
1answer
253 views
How to create Sub Sub domain Multi User blogs?
Hi to all I would like to create a big Wordpress network with this structure:
sitename.com (Main website)
cat1.sitename.com (sub website)
cat11.cat1.sitename.com (sub-sub website)
...
0
votes
1answer
357 views
How to use multiple check-box values to work in a function and insert values in database
I am working on a custom theme where there is option to upload images . I have certain check-boxes in the form which the users select as per where the image has to go. My form code is as follows :
...
9
votes
1answer
624 views
How do I make an HTML table from a database table?
is there a built-in wordpress function to make the HTML or should I use plain-old PHP?
0
votes
1answer
351 views
Wordpress and MySQL: trying to print data using PHP from user_meta custom field data
I have some custom user_meta fields in my MySQL database. The data is stored in my DB as follows:
the meta_key is called "paypal_user" and the info is stored in the meta_value column as:
...
1
vote
1answer
188 views
WP database error for comments_popup_link()
I'm using the comments_popup_link() function to show the number of comments for each post in a loop.
<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
<?php if ( ...
1
vote
1answer
314 views
Fastest way to get the comment and ping total count for a post
I'm making my own comment template (like this) and I need to know how can I get the comment and ping count for the current post, maybe using a fast database query or something like that?
Note that I ...
0
votes
1answer
426 views
SQL error with custom query
I'm trying to create a custom post query for sorting posts that have been voted "thumbs up".
I'm joining my custom "wp_post_votes" table (which stores the number of votes each post received) with ...
0
votes
2answers
819 views
Custom query_posts() parameter
I'm adding voting features to a theme. Visitors can vote posts Up or Down. I created a table for storing number of votes for each post and that works fine. Now I'm trying to sort posts by their votes.
...
1
vote
1answer
184 views
Prevent WordPress from loading comments
I'm displaying the comments for a post my way, using $comm = get_comments() and then passing $comm to wp_list_comments() (this is the reason why).
How to disable WordPress from loading comments from ...
1
vote
1answer
299 views
if statement on database query
Part of a voting script I'm working on: I'm checking a custom table in my WP database to see if a user already voted for a post by checking the IP address and the post id.
If the user's IP already ...
0
votes
1answer
988 views
add_action for publish_post doesn't work
I'm working on a personal voting plugin, I don't intend to release it publicly because I'm still learning WP.
In general, you can vote posts "up" or "down". I have 2 tables, one collects IPs (to ...
1
vote
3answers
179 views
Recent comments from my blogs only
I'd like to create a list of recent comments, specific to each user on my network (Buddypress).
My best idea so far is pretty lame: DB Query on all user's blogs, compare dates, select top 10 by date. ...
