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

learn more… | top users | synonyms

0
votes
0answers
12 views

Save data on custom table Wordpress

Here is my current code, <div class="wrap"> <div id="icon-tools" class="icon32"></div> <h2>Quote Manager</h2> <div class="aio-content"> <form method="post" ...
-1
votes
1answer
18 views

Website that sells statistics

I'm building a website that will have statistics based on user activity on the website (online votes and views etc). People will have to pay to view those stats. I am utilising wodpress features ...
0
votes
0answers
18 views

Why is converting my database to UTF-8 truncating entries?

I'm running WordPress 4.1.1. My site is hosted at NearlyFreeSpeech. I've been using my WordPress blog since the days when it encoded information in the latin1 charset. This week, I realized that ...
0
votes
1answer
11 views

Add several fields from different tables to post, fields per post are in same row of table

I like to add 4 or 5 extra fillout boxes to the adminpage of my post... For example, under the actual page box, I would like to add the following fields: Name position publications freetext Here ...
0
votes
0answers
27 views

Fatal Error in \wp-admin\includes\misc.php after failed WP update

I was recently approached by a client whose wordpress site had been hacked. The hack caused traffic from search engines to be hijacked to cuteonbags.com. I narrowed down the malware in question and ...
0
votes
1answer
21 views

Creating a search form and displaying results

Im trying to create a plugin for a site where the user can see a table of orders from customers in the Wordpress dashboard, It's a custom db but I'm using the wp-list-table, I've wrecked my brain for ...
0
votes
0answers
7 views

Widgets with *internal* links do not display after database migration

I am using Grunt to dump my local db, search and replace URLs in it (and account for serialization by using grunt-peach based on Peach), send it to my staging server, then import it into my staging ...
0
votes
1answer
30 views

Image thumbnails not available post migration, but still accessible via direct URL - DB issue

To start with, I'll just clarify that this appears to be a different issue to the numerous migration ones already covered. In short, I've migrated my site to a new domain (both in root, no directory ...
0
votes
0answers
4 views

Do you know a database or file manager for users plugin? [closed]

I save a lot of data for some clients in Excel files (currently working on exporting this as sql records). I need to have this databases (1 database per client) stored on my wordpress web so my ...
0
votes
0answers
8 views

Migrate database between 2 different wordpress version

I have been trying to import a sql dump from a production site, which is several wp version behind the development site (4.1), is there any compatibility issue? Every time I try to login after the db ...
0
votes
2answers
42 views

$wpdb->query can't insert data

I Write Code to Save data in the Wordpress database table (table name is wp_fafa) But Can't Save data in $qry = $wpdb->query( "INSERT INTO `wp_fafa` ...
0
votes
0answers
13 views

Need sort posts by data in custom DB tabel

There is possibility to vote on project (custom_post_type) in theme I created. It has separate db table, where every vote are written (post id, ip, category id, vote time). What would be best way to ...
0
votes
0answers
8 views

Featured image for a third party application

I'm building a Phonegap application that retrieves posts from an existing WordPress database. In which way featured image (i guess it's in wp_postmeta) is related to the post id and how is it ...
0
votes
1answer
22 views

Super slow queries from author archive pages killing my database

I'm wondering if you can help me figure something out with these queries from author archive pages that are killing my database server. These queries are taking 7-15 seconds to run! Here's an ...
2
votes
1answer
46 views

Ways of managing staging and production wordpress sites?

Ok I've see a lot similar questions.. but they all either outdated or do not fall in in my problem. So the problem is: We have a website and its clone stage website. On that website apart form me ...
1
vote
0answers
32 views

Separate Database Tables For Different Post Types

one big problem with wordpress is that everything on it is a post(a record in wp-posts table)! images, posts, pages, products(for example in woocommerce), portfolios, Post Revisions... Almost ...
0
votes
0answers
23 views

one database, same content, two wordpress sites, different structure? or another solution to have 2 websites with the same content?

I have a WordPress site that shows posts that it gets from rss using a plugin. I want to split the "jobs" in 2 different websites because in this configuration is not working properly (high amount of ...
0
votes
0answers
20 views

Sharing woocommerce product data

I am needing two installs of WordPress and both are being used as an online shop. The problem i am having is that, I am having to update two sites with the same products and wanting to find a way to ...
0
votes
2answers
32 views

Shared Custom post type between WP network sites

I'm developing four websites which are separate, besides the Events (custom post type). Three of the websites are WP, and I've got them in a Network. I would like Events to show up in all three Admin ...
0
votes
2answers
21 views

Connecting to wordpress database in my application [closed]

I am creating a wordpress site that will give accounts to people that want to be contributors/authors of a cause that people can donate too. We will approve/deny causes of approved authors Our ...
0
votes
0answers
11 views

Display all records in a table

I am new for word press i am displaying the all records in a table.Which file to write the coding in word press files.And also display the users page my like this ...
0
votes
1answer
31 views

Wordpress plugin: efficient way to store large data

I have excel file with 1000+ records. Basically it has zipcode and corresponding email addresses. I need to create a custom wordpress plugin which queries this data and sends the mail. It would be ...
0
votes
0answers
7 views

Creating a meta table for term or term taxonomy

I found this tutorial which works great for what I need. However, I am doubting wether it should be associated with the wp_term's term_id or the wp_term_taxonomy's term_taxonomy_id. They seem to be 1 ...
0
votes
1answer
28 views

not saving post in wp_post wordpress database table

I write following code to save post in wordoress wp_post database table. but don't save in database function writeMsg(){ global $wpdb; $result = $wpdb->get_results ( "SELECT * FROM ...
0
votes
0answers
29 views

save content in to wordpress wp_post table of database

i write code to get content from other site. now I want save content in to wp_post of wordpress database.. date .. content.. titile ,.. wp_insert function wp_publish function thise my php ...
0
votes
0answers
16 views

Moving Site: Is Re-downloading Files After Changing URLs necessary?

On the Wordpress Codex: Moving Site page under Changing Your Domain Name and URLs, it states that you should re-download your site files (Step 5) after changing your site URLs (Step 4). Is Step 5 ...
0
votes
1answer
16 views

more than 1 database user with in wordpress using wp-config

i want to use more than 1 database user to overcome the 7500 query database limit how i can do that using wp config my server is rxrxus.ipagemysql.com I want the users have the same password thanks ...
-1
votes
0answers
34 views

How to change page ID to preserve links?

I'm developing a site, and the current site uses the page ID in the permalinks (eg site.com/content/?page_id=8). I am recreating the pages, and would like to make sure I don't break any existing links ...
0
votes
1answer
27 views

Database alteration: users who voted

I have a post voting system that stores and displays the vote as an integer. When someone clicks on plus the vote increases by 1, when minus - decreases by 1 (exactly the same way as on this website). ...
0
votes
1answer
23 views

How can I work on a database along side a client?

I was wondering what the best way would be to work on a database locally while a client is placing content into the database externally. My initial thought was to connect remotely to the database but ...
0
votes
1answer
25 views

Wordpress as a frontend website for iOS app [closed]

I am developing a product for a local gym. The product comes in 2 parts : - a smartphone app used by the client - a website used by the coach The coach uses the website to prepare the workout. So ...
0
votes
0answers
20 views

wordpress database error

I write code to extract peice from website with curl. this should be refresh page to get price. I want store data in the wordpress database with foreach. when I refreshing page but give this ...
0
votes
0answers
6 views

Partial text search custom taxonomy

I am trying to do an autocomplete field that interrogates the database finding a custom taxonomy but can't seems to figure out how to achieve this. Would i need a custom query?
0
votes
1answer
11 views

Website displays old version of page

So I'm working on a website for a company and everytime I edit a page/post I have to manually go in to the database and remove the old versions (which isn't something that I'd like to do since it's ...
0
votes
1answer
30 views

Populate a select box with data stored in the database?

I know generally how to add custom fields to the user profile page. However, I need to add a custom select box to the profile page that is populated with all the schools in the state. (Our users will ...
0
votes
1answer
18 views

Write mysql credentials in plugin

I've to create a custom plugin to print data from a database different from the wordpress one. I'm using wpdb. Is it fine, from a security point, to write database credantials in the plugin files in ...
0
votes
2answers
95 views

Why are no posts showing despite my apparently correct DB restoration?

I restored a backup to MySQL using the phpMyAdmin Import feature. When I browse the DB in phpMyAdmin, I see that my posts are there. But in Wordpress, I only see the default out-of-the-box welcome ...
1
vote
1answer
64 views

$wpdb->get_results leaking memory

I have developed a wordpress plugin that reads large custom xml files and imports the information as custom post types and a lot of post meta information. So I am calling a lot of database ...
0
votes
1answer
26 views

Doubt using $wpbd->get_col for a single column

$table = $wpdb->prefix . 'posts'; foreach ( $wpdb->get_col( "DESC " . $table, 0 ) as $column ){//get all columns from wp_posts echo "<div><p>". ...
0
votes
1answer
21 views

Import live site to local setup without access to live site

I am working with a client to update a current wordpress site. I do not have access to the actual Wordpress install because they are behind a VPN that I'm not able to get behind for various reasons. ...
0
votes
0answers
50 views

Insert Custom Registration fields in Database

I am newbie to WP and working on login and registration forms. Recently I have integrated custom registration form following this tutorial. I managed to add validations and user can register but some ...
0
votes
1answer
33 views

fastest replacement DB

What's the best database setup for WordPress for speed and lots of posts (hundred thousands of rows in posts and post_meta tables)? While I can cache as much as I can and optimize my queries/PHP as ...
0
votes
2answers
28 views

Looking for suggestions on creating simple database (Help!!)

I'm working on creating a basic database for a theatre and really need some suggestions as the best way to approach this. Each production from this theatre will have its own page. The page should ...
0
votes
2answers
136 views

Woocommerce - Check product stock availability from external database

I have an external database (not a Wordpress one) where my client's stock is managed and I need to check the product availability considering this database, not the wordpress' one. My inicial idea is ...
0
votes
3answers
91 views

Execute a function every hour in the background

I'm in kind of a weird situation (for me) My client has a website that runs on a custom CMS He wants an online site that loads some data from the existing database. This is an external MSSQL database ...
0
votes
1answer
21 views

using same mysql user with many databases

As we know that in order to connect WP with database we should to define mysql username and password in wp-config.php, so at that point i have a question regarding security or ( some sort of ...
0
votes
1answer
20 views

Backing up Wordpress database and files

I've tried a few third party plugins for backing up my site, with some working well and others not so much, so I'm trying out backing up the site manually. Is there anything I'm missing here or is ...
0
votes
1answer
183 views

Retrieve and display data from custom db table in admin area?

So, i'm having a bit of an issue with a plugin i'm developing, I wonder if anyone can shed any light on the situation, as many, MANY searches have come back with zero help. :-/ Basically, my plugin ...
1
vote
1answer
103 views

Retrieve featured image (thumbnail) url from multiple posts with one query

I have a list of post ids and need to get all the standard data plus the thumbnail of the posts. As there will be several hundred posts i need an efficient way to retrieve the data, just looping over ...
1
vote
1answer
35 views

Add action on delete comments?

I add some input fields to the comment form, and than this new data is stored on commentmeta table. When a comment is deleted, the data on commentmeta is still there. How can I delete these data ...