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

learn more… | top users | synonyms

0
votes
0answers
114 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
2answers
41 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
31 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
82 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
25 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
98 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
113 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
1answer
40 views

User Tracking for Custom Post Type “Lesson”. Database Queries and Performance

So I wrote this little code snippet to add a post id along with the current users id to the user meta table. I'll use this to show the "lesson" posts that a user has viewed back to them. My only ...
0
votes
0answers
26 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
32 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 ...
0
votes
1answer
28 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
42 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
218 views

Is there a function to get post info for any publish_status by post ID?

I'm trying to, essentially, check whether a post exists and if it does (in published, draft or auto-draft states) return the post info. I'm finding get_post() doesn't seem to work with drafts, and ...
0
votes
1answer
53 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
25 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
17 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
22 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
2answers
112 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 ...
0
votes
1answer
98 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
3answers
610 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
40 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 ...
1
vote
1answer
138 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
3answers
345 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
1answer
80 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
64 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
125 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
62 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
46 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
531 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
1answer
51 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
2answers
66 views

Is it possible to have more than 1 sql databases in my wordpress blog?

I m watching video on installing wordpress manually. on first launch wordpress prompts you to input your sql database name, sql password etc. then i can start working from dashboard. is it ...
0
votes
1answer
27 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 ...
2
votes
1answer
382 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 ...
0
votes
1answer
99 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
207 views

After moving my site from a dev subdomain, to root, all my custom meta data is gone

I just movde my site from a dev subdomain, to the root. I have extensive amounts of data saved in custom meta fields which I created with the WpAlchemy class. All of this data is not appearing in ...
6
votes
4answers
7k views

Can posts have parents?

Are posts supposed to have parents? If so, what would that mean for a post to have a parent? Also, if there are some constraints to posts having parents, then where is that enforced? Not in the DB as ...
1
vote
1answer
79 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 ...
4
votes
3answers
902 views

How might I retrieve a featured post image from an external WP site and display it as a link back?

I have two WP sites. I want to reach from one of them, into the other, and retrieve specific featured images for posts, and display them with a link to that post. I am using this line (with the ...
0
votes
0answers
141 views

MySQL 1005 ErrNo 1 - “can't create table” when importing DB backup into phpmyadmin?

I have been developing a WordPress site locally using the following mysql version: LOCAL DATABASE SERVER: Server: Localhost via UNIX socket Server type: MySQL Server version: 5.5.40-0ubuntu0.14.04.1 ...
2
votes
1answer
41 views

Should I be able to run two different “close” code versions of wordpress with the same DB

A concrete example - I am upgrading to 4.1 from 4.0, the upgrade was successful but I discovered that a plugin broke. Can I just revert the code. The real live issue I am facing is having two ...
0
votes
0answers
479 views

two wordpress sites, two themes, one database, same content

I am doing research about wordpress and there are many interesting stuff to learn, i browse the wordpress forum and i found a post about duplicating site.. or multisite.. I am not sure exactly how it ...
1
vote
1answer
53 views

WordPress Local And Live Site

I have a local WordPress install that I am using to test a new theme out. When I initial set up the local site I was able to import my database and media content. However that was a few months ago. ...
1
vote
0answers
49 views

delete duplicate comments

I found a solution for this a long time ago. Here is the code: <?php require_once('wp-config.php'); global $wpdb, $comment_content, $comments,$comment_ID; # First select all comments $query = ...
0
votes
1answer
99 views

MySql Database In WordPress Multisite

I have a multi-site installation. It's a fresh installation, and currently all the sites use the same database. What would you recommend among these and why? Pros and Cons of using the same? Option 1 ...
0
votes
0answers
34 views

Serialized Data Being Cut Off?

I have two separate installations of WP on two servers. They're both the exact same website. In my CPT's meta, I have a field that's a very long piece of serialized data. On one server the full data ...
0
votes
1answer
888 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 ...
1
vote
0answers
20 views

localize elements in database

I want to localize my website with .mo files. Now, while it's pretty easy to scan existing php files and add the relative translation, it's not clear to me how to localize the elements in the db. I ...
0
votes
1answer
126 views

How do i get value from wp_postmeta?

I am trying to get a specific value from wp_postmeta, I'm aware about meta_key and meta_value. Problem is Meta value stores lots of values and i want specific value. Here's the value in the ...
0
votes
0answers
57 views

Handling Massive Amounts of Data in a Wordpress Plugin

I've been working on my own version of a Youtube Post Importer plugin for Wordpress and I've run into a bit of a wall. I'm using the 3rd version of the Youtube Data API seen here ...
0
votes
0answers
41 views

wp_update_post set value to null

Is it possible to set a field to NULL using wp_update_post? I'm trying the following: wp_update_post( array( 'ID' => $future_orphan_id, 'post_parent' ...