WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).

learn more… | top users | synonyms

0
votes
0answers
30 views

How do I authenticate/turn off a plugin remotely for plugin SaaS like functionality?

I have a client whom we created a custom plugin for. We are charging monthly for access to this plugin but the only way we have to disable it is manually in the Wordpress admin. How would I go about ...
0
votes
0answers
43 views

Broken Images After DB Name Change

I have a problem I have been unsuccessful in troubleshooting or finding other questions and answers for. My site was displaying fine. I changed the name of my database from "mydomain_beta" to ...
0
votes
1answer
63 views

Getting data from a table using a query

I’m starting with WordPress and I have a lot of problems and doubts. I’m trying to display on a page data stored in a table of my database. I have a table named Customers (id, name, surname, phone). ...
0
votes
0answers
36 views

Customize wordpress search query

Would this method parse_query of the WP_Query class allow a custom search query to a custom table? WP_Query I ask because the Codex says " To customize the query append additional arguments to ...
1
vote
0answers
225 views

How to populate custom field dropdown box based on prior selection?

I have two dropdown boxes for a search that uses custom fields and I need the second dropbown box to be populated depending on the results of the first box. So far I have: <form role="search" ...
0
votes
1answer
30 views

Should I use custom taxonomies or not?

I'm building a plugin which features an custom post type Events. Now I would like to add functionality to support venues. I think a custom taxonomy could do, but I'm not so sure, because I would like ...
0
votes
1answer
64 views

Given two custom post types: Automatically add meta fields from one custom post type to another

Custom post type "Company" has: Restaurant name field Restaurant description field ..and other more fields Custom post type "Restaurant" has: Restaurant name field Restaurant description field ...
0
votes
1answer
310 views

Posts and Pages not showing on admin, but showing in theme

I've just transferred a WordPress install over from and old IIS server set up by our client, to our new Lunix based VPS. Whether that is relevant or not, i'm not sure. I've changed all the usual ...
0
votes
0answers
220 views

help in applying pagination retrieve the data from database

I'm following the tutorial here http://wpengineer.com/2426/ on how to apply pagination in wordpress. Now he said "As pointed out in the comment the array_slice is only necessary because we use sample ...
0
votes
1answer
18 views

custom post type for custom talbe

Where would I start if I want to have a custom post created each time data was submitted from a form on the front page for non-logged in users? I have the script set up to send the data to a custom ...
0
votes
0answers
254 views

insert data from form to custom table

I have a custom form set up on a custom page template. I need the submitted data to be saved in custom table. What am I missing since this isn't send the data? The code I'm using: ...
0
votes
2answers
69 views

How do I use update_option to give me a new option name each time a form is submitted? [duplicate]

How do I use update_option to give me a new option name each time a form is submitted? The code I'm using now overwrites the database value. Instead I need to have a new address saved each time. The ...
0
votes
1answer
215 views

save new data to wp_options non-post form

I have a form on my front-page. It sends the entered address to Google API and returns the JSON to wp_options. That works fine. I am using update_option to do that, so it rewrites the meta_key each ...
1
vote
1answer
45 views

Wordpress not reflecting changed of the database

my problems started when I moved my website to another folder (from /dev/ to /). I have gone through the whole database in order to change all the hardcoded /dev/ into / but I still notice that ...
0
votes
1answer
98 views

access JSON results from wordpress database with wpdb

I have JSON results from Google API added to to wp_options table. At this point I just need to echo the specific elements. Namely, the coordinates. The option_name I have is py_menu_item. One of the ...
0
votes
1answer
809 views

How to delete all records from or empty a custom database table?

I can't seem to find a simple reliable way to do this - perhaps?: // delete row ## global $wpdb; $delete = $wpdb->query( $wpdb->prepare( "DELETE * FROM `wp_table_name`" ) ); ...
0
votes
1answer
180 views

How to fetch records from database WordPress

index.php: <?php $new=$wpdb->query("select * from wp_posts where post_title='Auto Draft'"); $new1=mysql_fetch_row($new); echo $new1[0]; ?> How to fetch record from database? How ...
0
votes
0answers
148 views

Pull Data from DB for Admin Page Display as Relates to Admin Page Class by BA Internet

Why do developers make it so darn hard to use the tools they develop? Don't answer, I already know :) Have had some success using this: https://github.com/bainternet/Admin-Page-Class ...to develop a ...
2
votes
1answer
778 views

wp_users user_status field

I have found an answer to my question here but it's 7 years old. I simply want to know if I can use this column for my own purposes. I'm planning to use the user_activation_key column to store a ...
0
votes
1answer
102 views

Weird characters in title if it contain “ ”

If my post title contain “ ” all the title stored in the database title column in weird characters like this ...
0
votes
0answers
16 views

Any harm in pointing my dev Wordpress installation to my production database?

I have a dev instance of a public website that I maintain, and while they are very similar, there are differences between the site structure of the development instance and the production website. ...
0
votes
1answer
135 views

Get content from other database table based on an ID and rewrite URL

I am currently using WordPress with SEO friendly permalinks. One page of my website is a special one though, let's call it http://example.org/locales. It is using a custom page template that loads ...
1
vote
4answers
2k views

Converting WordPress into Android or iPhone app

I've had a request from my client to convert their WordPress website into an App for Android and iPhone. I've looked around at a number of options and it seems doable especially for just the blog ...
0
votes
0answers
115 views

Why are my WordPress post queries so slow?

I'm working on a larger WordPress site and trying to troubleshoot why my site is so slow. I've installed W3 Total Cache and have run multiple page speed and plugin tests with no luck. What's strange ...
0
votes
1answer
63 views

Sub-domain or 2nd, temporary different domain?

I'm developing a Wordpress site for a website that already exists (that's not currently using Wordpress). The current website cannot be taken down until the new Wordpress site is ready to replace it. ...
1
vote
0answers
89 views

MS Access to manage WordPress Database

Now I don't believe this is practical or possible without a large amount of development. My client's old site used MS Access to manage the user's profiles on his old website. His new site uses ...
0
votes
2answers
1k views

Synchronizing Two WordPress Sites Content

I've googled a lot, and I do have found answers at WordPress SE and at stackoverflow.com. However, the answers are somewhat incomplete or doesn't work at all. Here I'll explain my problem in detail, ...
1
vote
1answer
702 views

Can I use MariaDB instead of MySQL in wordpress?

Is it possible to use MariaDB instead of MySQL in Wordpress installation? If possible: how do I do that? Is there any drawback or complexities?
0
votes
1answer
63 views

/var/run/mysqld/mysqld.sock

I'm using Wordpress v.3.4.2 and today I've tried to update to the v.3.7.1 using all possible ways but in all of them I got the following error "Can't estabilish database connection", and since I was ...
0
votes
1answer
226 views

How WordPress attaches its Featured Images with posts?

I'm working on a WP_Query(), where I'm trying to fetch all the images using 'post_type' => attachment and 'post_parent_in' => array( 1688 )(I want to pass some more post_ids) along with other ...
2
votes
1answer
571 views

Ajax with jQuery UI dialog not working

I am trying to update my custom database table when changes are made in a dialog box. The script for the dialog box and ajax call is as follows - jQuery(document).ready(function($){ $("td > ...
0
votes
1answer
160 views

How long is “as long as possible” in wp_cache_set()?

The documentation for wp_cache_set() says that if you pass in 0 for $expire (which is also the default), then it is cached for "as long as possible". How long is this? What determines it? Are we ...
0
votes
2answers
61 views

Do WordPress Permalinks Refer to a Lookup Table in the Database?

I'm trying to figure out how to rewrite URLs while dropping the original parameter (whether it's a number or text); basically exactly what WP does with it's clean permalinks Does a database lookup ...
1
vote
1answer
381 views

How to recover Wordpress on GoDaddy hosting after reseting database password? [closed]

I did reset my database password, so I could enter the phpMyAdmin, but now my Wordpress installation can't connect to the database. I tried to access the "wp-config.php" (should be at ...
0
votes
0answers
19 views

Plugins folder broken-No website functionality

After some plugin updates caused me to receive a database error, I was unable to access my dashboard. I changed the name of the plugins folder in FTP and it came back online. I then deleted my ...
0
votes
0answers
32 views

Get posts, terms and custom fields in array

I have a multisite and want all posts from post type products I want to query through the database to get all posts belonging to post type "products" i have accomplished this with the following code ...
0
votes
1answer
32 views

Wordpress ERD mistake?

I just had a look at the ERD of the Wordpress CMS system and I think I found a mistake... Check the relation between the wp_term_taxonomy and the wp_terms table: ...
0
votes
2answers
47 views

Let users register weight each day and save it in DB

I need a way that lets my users register they're weight (kg) and maybe % of bodyfat and save that information on each user in the DB. Then i need a way to output that number again on the logged in ...
0
votes
0answers
26 views

I have a problem with my WordPress DB after I tried to install multi-site

I tried to install WordPress Multi-Site. But I ran into some problems with the DB. wp_1_posts: Table 'studioc_editionspanda.wp_1_posts' doesn't exist wp_1_comments: Table ...
0
votes
1answer
1k views

How to add checkbox with multiple values in table?

Right now i changed from options table to my own table so things are getting difficult i have a checkbox its name is selection in table, so here is what i tried <input type="checkbox" ...
-2
votes
1answer
161 views

get_option returning a different value from what's saved

add_action( 'admin_init', 'register_mysettings' ); function register_mysettings() { //register our settings register_setting( 'plugin_options', 'plugin_options', 'plugin_options_validate' ); ...
0
votes
0answers
22 views

How to joint develop a WP locally on two far away machines?

I was hoping someone can confirm to me, someone new to WP, how I can view a WP site created locally on 1 computer on another computer in a far away land. Basically my friend started developing a site ...
1
vote
2answers
216 views

Efficiency on displaying random authors based on large database

I'm trying to display a list of 5 authors randomly. Here are some solutions I had found: http://stackoverflow.com/questions/5502609/get-authors-randomly ...
0
votes
1answer
26 views

WordPress site seems convinced that it's still at its old URL

I had a demo environment set up in /subdirectory/ and then moved it to my root directory to make the site live. Used the wp migrate db plugin to export my database with the new paths, then replaced ...
0
votes
1answer
83 views

import (migration) user database to wp-users

I am having hard time for importing to user-meta and post-meta from my non-wp-tables. I am trying to do db migration from user table and post table to WordPress tables. So it might be user table ...
0
votes
0answers
136 views

Getting Poster Image (Thumb) of Video Embedded through JW Player in Feed

I am trying to add the poster image of YouTube video I embedded through JW Player in the post in the RSS Feed. Till now I found these: 1. This Code is working when used separately, it is getting the ...
2
votes
2answers
162 views

js Conflict in admin panel - I guess it's from the core WP installation

A client's site: causing serious js conflict or js loading disabilities, is under custody. Activating DEBUG, Deactivating all Plugins, and Activating Default theme "T13" found that, still the problem ...
1
vote
1answer
66 views

Posts are deleted everyday at night

So I have a weird issue with WP and that is that all Posts on the site are getting deleted sometime in the night. Before I turn of all plugins and change theme to default.. I would like to know if ...
1
vote
1answer
35 views

How can I get a list of comments by target

I've been looking at the classes WP_Comment_Query and WP_Meta_Query but to be honest, I can't figure out how to use them together. I want to query the database for comments where wp_posts::post_author ...
0
votes
2answers
1k views

Connect to remote database using Localhost install

I will be designing and developing a website for a client but want to allow the client to add content while I am working on the design and development of the site so that it is pretty mich done by the ...