Tagged Questions
0
votes
2answers
11 views
How to set max_allowed_packet using php code? [closed]
I am trying to set max_allowed_packet using PHP but I get this error:
WordPress database error Access denied; you need the SUPER privilege for this operation for query SET GLOBAL ...
0
votes
1answer
24 views
MySQL database migration to WordPress
I have a MySQL database established for a web application I have been working on in a non WordPress database. This database has many tables with pre-populated rows for foreign keys etc. which took a ...
0
votes
1answer
11 views
Should I use Wordpress to skin a database website?
I am going to start programming a website which allows users to post adverts for aircraft for sale. (Think autotrader for planes). It will be free to use. There are a few websites that do this already ...
0
votes
1answer
27 views
php include not working in custom page
The Problem
I have a db.php file which contains mysql login details. I want it in a separate file like this so it can be linked in several different pages for easier tracing later.
This all works ...
0
votes
1answer
27 views
How do I display offsite database info on my wordpress site?
I host some online games from my personal computer which the game saves information to my Mysql database. I would like to display live data (if possible) on my hosted Wordpress site. I know the ...
0
votes
2answers
65 views
making php value numeric
I used some of this code from this page on Stack Overflow:
Using wp_query is it possible to orderby taxonomy?
It's about the function to be able to sort a query by a taxonomy value. Although it works ...
0
votes
0answers
232 views
Creating a custom Jquery modal form to upload data in wordpress 3.5.1 [closed]
i am new to jquery.I looked to various demos but can't find what i am looking for.
I want to add a upload item feature in my wordpress website.This feature is available to the end user after he/she ...
0
votes
0answers
29 views
Automatically create a user with author rights from outside of Wp-admin
Need to create a user on the fly based on the following steps...
User clicks a link in an email with a unique url such as
1234.domain.com/?auth=42344245534534535
when the user clicks through to ...
0
votes
1answer
58 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
0answers
55 views
Use $_GET with permalinks on page
I'm currently trying to use a $_GET to populate a MySQL query with in a URL on another page within a Wordpress site.
URL sample:
<a href="http://site.com/file.php?alabama">Alabama</a>
...
0
votes
1answer
49 views
How do I Split one Table into to lists for two seperate drop down boxes
I am driving myself crazy trying to find an answer, although I know it would most likely be something simple.\
I have a mysql table with the following columns:
id
first_name
family_name
...
0
votes
0answers
55 views
using wordpress page templates programmatically
hello I am having a dilemma with a wordpress plugin, its more logic than a code problem so I hope you guys can still help me. over all here is the function of the plugin, again all code works fine ...
-3
votes
2answers
189 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 ...
0
votes
2answers
77 views
Make a database query using WordPress
I am working on a Wordpress theme that has a homepage slider. I have a table in Wordpress database that stores post view counts and I would like to make my slider show the top viewed posts.
This is ...
4
votes
1answer
101 views
Custom query to get post names beginning with a digit
I'm implementing an A-Z index for a custom post type. I've got my links printing out the page and the query working for the letters. However, the numbers are tripping me up because I don't want them ...
5
votes
3answers
414 views
is it possible to run some php code within a wordpress page?
I'd like to access a DB table and render it in some data grid format using php on a dedicated wordpress page, accessible to members of a certain group. Is this at all possible with wordpress or is ...
1
vote
2answers
87 views
How to simultaneously access the same MySQL database in the main column and sidebar of Wordpress?
I've wrote some basic custom PHP code for my Wordpress site. The code basically access a MySQL database (a different database from the wordpress database) and displays the information. In addition to ...
0
votes
1answer
87 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 ...
2
votes
2answers
538 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
56 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
3answers
230 views
Delete post revisions on post publish
Is it possible to delete post/page revisions from the database when a post/page is published?
11/05/12 Answer: See the plugin below by bueltge
I want to do this on a site with 5,000 posts and ...
1
vote
2answers
226 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
vote
1answer
254 views
mysql query from wordpress page using custom table
I want to a mysql query that matches a page title. Not sure of a better way to accomplish this task, but I am stuck.
This is my basic test code.
<?php
$page_title = wp_title('');
echo ...
0
votes
0answers
106 views
Making Ajax Web Chat to unlimited users [closed]
I am getting ajax chat script here:
http://tutorialzine.com/2010/10/ajax-web-chat-css-jquery/
The script can only accommodate a maximum of 20 users.
If I want to make an unlimited, what should I do?
...
0
votes
1answer
259 views
populate select options from extra mysql table data
hi guys i am trying to populate a select element with options from the data in one of my sql tables heres what i have so far:
<?
$SQL = "SELECT * FROM pt_country ORDER BY name";
$rs = ...
-1
votes
1answer
159 views
how to search through plugin in wordpress cimy-user-extra-fields?
I have a plugin clalled - Cimy User Extra Fields.
I need to search the content through this plugin. This plugin is in WordPress, and all the content are stored in the database also, like industry, ...
0
votes
0answers
8 views
how to used Cimy_User_Extra_Fields plugin for search? [duplicate]
Possible Duplicate:
how to search through plugin in wordpress cimy-user-extra-fields?
I am using Cimy_User_Extra_Fields plugin in wordpress.In this plugin i just entry INDUSTRY, location ...
4
votes
1answer
572 views
Searching users with WP_List_Table plug-in
I am trying to devlope a plugin that will search and return my users so I can edit some other metatdata that belongs to them. I have been using the plug-in listed on the Codex as my starting point.
I ...
1
vote
1answer
323 views
Use ajax to update_post_meta
2 days ago I asked this then I tried to work on my code to be able to understand how ajax and php work and now I have a new issue that, probably would be easily solved.
These are my codes:
<?php
...
1
vote
0answers
119 views
List authors with the last post title and order by last post date
I want to list authors with last post data and order them by last post date. Now i have this codes but i don`t know how to edit them.
// Selects from tables wp_users and wp_posts, selecting published ...
3
votes
2answers
475 views
Can i use php sql functions instead of $wpdb?
New to wordpress and was wondering why in Wordpress API do they tell you to use functions such as prepare(),insert(),get_col(),get_row(), query(), etc. when technically i can use the built in PHP sql ...
0
votes
1answer
313 views
Query the links Database
Hi I'm trying to convert from a "example" wp_list_table that displays an array of data on the same page, to a "real life" table the pulls data from the database. I have the code setup to where I just ...
0
votes
1answer
149 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 ...
6
votes
1answer
202 views
dbDelta support for FOREIGN KEY
On PHP 5.3.13/MySQL 5.5.21 the following code doesn't work:
if($check_custom_fields_form!=1){
$sql = "CREATE TABLE IF NOT EXISTS ". $table_custom_fields_form ." (
`form_name` ...
0
votes
1answer
586 views
Most viewed posts in Wordpress
I am owner of a blog/website and I am using this code for tracking post views in site :
function getPostViews($postID){
$count_key = 'post_views_count';
$count = get_post_meta($postID, ...
0
votes
1answer
203 views
Force Users To Relogin
I need a solution that i can use to force a user to logout via the admin panel of word press any help on this would be appreciated.
0
votes
1answer
349 views
the_author_meta not working
I'm trying to use the_author_meta to retrieve some links which users can set in their profile.
I set up extra profile fields and they are saving to the database.
On my author.php I have the ...
3
votes
4answers
800 views
the_date() not working
I am using wordpress 3.2 and I did a query post like this:
<?php query_posts("posts_per_page=1post=type&page=post_parent=10");?>
Then I try to echo out the date of this post I queried ...
0
votes
1answer
442 views
How to create Loop code for Menu using Wordpress?
I have created a menu called "My Menu" in wordpress using Menus feature provided under Wordpress admin panel. I have added 3 pages into it named Page A, Page B, Page C.
I have applied featured image ...
2
votes
2answers
277 views
sql query to put quotes around numbers in img tag
I have quite a few old posts that contain an img tag with height and width with no double quotes around the numbers. For example:
<img height=319 alt="" ...
0
votes
2answers
755 views
Cannot Upload Custom Header Image into Wordpress Dashboard
I'm having trouble uploading a custom image into Wordpress' dashboard. It says that it needs to be a custom 1000x288 image. When I upload it, I get the error of:
Warning: ...
0
votes
1answer
105 views
Update some database fields when post is saved
I have a class that will count the Lines of Code, Source Lines of Code, and the Code disk space used. I would like to save these values into the database so that these values can be calculated only ...
0
votes
1answer
249 views
MySQL query performed 4 times inside loop
I have enabled custom php in my pages through the use of the exec-php plugin so I can run more complex pages than the standard WordPress page. I have had no problems with this plugin so far.
I have ...
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
475 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 ...
0
votes
1answer
173 views
Check against server time to display SQL entries - Radio Station DJ Rotator Plugin
I'm building a WordPress plugin that will create a radio station "On-Air Now" DJ rotator.
Working options panel I've built so far: http://i.stack.imgur.com/SiYde.png
I've based the idea on a PHP ...
1
vote
1answer
2k views
How to validate WordPress generated password in DB using PHP?
I am working with site that is done with WordPress, and I need to add some parts that are outside WP, and to check user login, Logging users outside WP.
I tried with md5 of password but it's not...
...
1
vote
0answers
263 views
WPDB is not working when trying to run a custom query [closed]
I'm developing a WordPress plugin, and have no other plugins installed.
The logging function is as simple as
function log($message){
global $wpdb;
$message = $wpdb->escape($message);
...
2
votes
1answer
111 views
theme options echoing multiple times
I tried to strip down the Twenty Eleven theme options page and add my own fields correction: I followed a tutorial somewhere, but when I try to echo the data, it comes out multiple times.
Here is my ...
0
votes
1answer
125 views
How i can obtain all the post meta for a specific post as an array?
<?php $fields = get_post_custom($ID); ?>
This will fetch the custom fields ($key => $value) for $ID in to the array $fields.
I want ALL the fields (both custom & standard WP fields) ...
