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

learn more… | top users | synonyms

0
votes
0answers
10 views

How can I check the content in database wp_usermeta? [on hold]

I would like check the content in a meta_key into wp_usermeta from DB. For example check username: if ( ( the_author_meta( 'username', $current_user->ID ) ) == 'user1' ) { // do something ...
0
votes
0answers
16 views

GET user's metadata, list it in descending order and GET user's list number

I have a custom user metadata with meta_key reputation. The value is numeric. It is like a points system. The higher value the user has, the higher reputation they have. How do I GET where each user ...
2
votes
1answer
9 views

Weird issue with database migration and SSL links

I want to move my database to my another mirror server (for testing & stuff). My original one is using SSL and I am forcing it to do so. When I migrate with DB Migrate plugin, the non-ssl server ...
0
votes
0answers
15 views

List of products (only view) [on hold]

I'm searching to show a list of products in the user front-end. In my back-end I created some fields with this content: '0' and I would like show to the users if the content is '1'. Exemple ...
0
votes
0answers
6 views

Getting data from database and use it to complete a form

I have the following files: Main plugin file: <?php /* Plugin Name: FixFormData Description: If you want to autocomplete a form with existing data, this plugin is for you. ...
0
votes
1answer
13 views

Update image links in database

I recently changed the URL of a wordpress site and I can't seem to find some of the image links I was able to update most of the links in the wp_posts tables update wp_posts set guid = REPLACE(guid, ...
0
votes
1answer
26 views

Link to handle $_GET request

I have a set of items retrieved from a database custom table that work. So believe me that $ticket->ID outputs some integer. Say I want to delete some of them. While printing them I offer a link to ...
1
vote
0answers
19 views

Child parent relationship inside WP DB

i am a .net user so i am unfamiliar with not using a foreign key inside of the database. On my WP application, user's are able to create videos on the application, the videos are stored on a ...
0
votes
0answers
16 views

Reset postmeta entries every month

I have this currently running on my site, which counts how many times each 'post' has been viewed, adds one view to the count and then saves it in postmeta: function getPostViews($postID){ $count_key ...
0
votes
0answers
18 views

Show WP content on different PHP Sites

we are about to start developing a big dynamic web project (Probably on ZF2) which will have some modules&tabs to act as CMS module (displaying news, galleries, posts etc). Let's assume we have ...
0
votes
1answer
14 views

Wordpress sync with phpbb

How can i sync the wordpress database users with phpbb database users so i can log on each one with the same user at any time and if there`s no user created for the wordpress to log in with the phpbb ...
0
votes
0answers
22 views

Updating custom table rows using $wpdb [closed]

I'm not giving error, but it does nothing. It should update the 'user' value. $_POST value and $tickets query works. I've tested it dumping them. This is the dump from the last query, string(56) ...
0
votes
1answer
18 views

What's wrong with my $wpdb query?

I'm just trying to query the first user, but it outputs this error, WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for ...
0
votes
1answer
13 views

WordPress plugin DB upgrade

I am writing plugin. I have added 1 custom table in database. Suppose my plugin's current version is 1.0 After few days i am upgrading plugin and now its version 1.2. Same for after some time and now ...
0
votes
2answers
27 views

how to store arrays into a database

I'm trying the store multiple rows into a database. The number of fields will change. Below is the way that I use to store just one row. <?php if(isset($_POST['save'])){ ...
0
votes
1answer
23 views

Change Wordpress URL in sql file via Terminal

I've got a 40mb database file that I've exported from an old host and need to import it into a new host on a new domain. I normally open up the database in my code editor and find-replace, but as this ...
0
votes
1answer
23 views

Importing posts from old website to new conflicting post ID's?

I am wondering when I am importing posts from my old site into my new website, which has already some posts in it. Do the imported posts get a new ID or do they overrule the existing posts ID's?
0
votes
0answers
16 views

Best way to define a database with product codes and back-end support?

First let me explain what my wanted situation is: I have a WordPress site where I want the Admin to have access to about 10.000 "product keys". These codes will be inserted in a database of some sort ...
0
votes
2answers
24 views

Dump custom post type database

I have a custom post type filled with 7k entries by mistake. I want to empty the database for that custom post type. What is the best way to do it?
0
votes
0answers
21 views

Create user assessment and use results in sql query

I am building a plugin that displays custom post types based on a user's assessment result. For that I need the user to fill out a form (not a very complicated one). This form submission needs to save ...
0
votes
1answer
14 views

How to change the publishing date of each posts?

I need to set the publishing date of many posts with the post date (the creation date). I know that I can do it editing the single post and changing the Published on value but this procedure is ...
0
votes
0answers
10 views

How can I create a data entry form that has Master Detail ability?

I have a patron and books for a library (in this example). One person/patron, many books. I have the two tables. I believe I could use either tablepress or roll my owne output via a custom plugin ...
0
votes
0answers
10 views

How to handle this problem related to the publishing date of imported posts?

I have the following situation that I have to handle: I imported some posts from an old custom blog (not WordPress, a custom blog made using ASP). I exported in CSV format the content of the table ...
0
votes
1answer
16 views

What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?

I have the following doubt related to the posts table of the WordPress database. I see that when I create a new post in this table are automatically created 2 new rows. 32 1 2014-08-16 15:07:22 ...
0
votes
1answer
13 views

Why when I create a new post I found 2 record related to this post into the posts database table?

I am very new in WordPress development and I have a doubt about the WP database table named posts I have observe that when I create a new post (into the WP administration panel) are created 2 record ...
0
votes
1answer
18 views

Can I use $wpdb for my custom tables in the WordPress database?

I am building a custom application based on WordPress. I have my custom tables in the WP database. Can I use $wpdb to work with them, or is that class solely for the WP related tables? For example, ...
0
votes
0answers
7 views

Where is stored the Publish date value for a post?

I have to do a massive change in the database and I need to know in what field of what table is stored the publish date value of a post. Using phpMyAdmin I see that each record into the wp_posts ...
0
votes
2answers
17 views

Database Name Change

I read it was more secure to use something else besides wp_ as the database prefix, so I downloaded my .sql file replaced all instances of wp_ with tsi_ and then dropped the wp_ tables and imported my ...
0
votes
0answers
13 views

Custom subscription abandonment

I'm using a subscription service through a small third-party company. I've asked them to consider sending emails to users that drop-off from the subscription but they don't want to implement such a ...
0
votes
0answers
29 views

Exclude posts from certain meta_key

I have query to retrieve all posts, but how can I check the condition for post meta_key ="develop" and meta_value='anything' SELECT DISTINCT date(p.post_date) as post_date FROM $wpdb->posts p ...
0
votes
0answers
14 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
55 views

add_post_meta not saved

EDIT I changed it to if(isset($_POST['Make'])) update_post_meta($pid,"Make", $_POST['Make']); if(isset($_POST['Year'])) update_post_meta($pid,"Year", $_POST['Year']); ...
0
votes
0answers
15 views

How To Structure A Wordpress Database Query?

I have an array containing the IDs of the rows I want to update: $matches = array('abc123', 'def456', 'ghi789'); Rows with those IDs must be updated so that their 'confirmed' value is changed from ...
0
votes
1answer
20 views

How to pass username into form that sends data to database

I am trying to pass username to database through form: [insert_php] $current_user= wp_get_current_user(); $id= $current_user->user_login; [/insert_php] <input type="hidden" name="id" ...
0
votes
1answer
48 views

Adding data to custom wordpress database table

I have a form on a page that populates the database table: <table border="1"> <tr> <td align="center">Form Input Employees Data</td> </tr> <tr> ...
0
votes
0answers
17 views

How to connect database table to each registered wordpress user.

When registered user visit certain page, I want him to be able to add some 3 column data to a database that can be retrieved for him later. The way I see it implemented is by automatically adding an ...
0
votes
0answers
18 views

High CPU usage after running WP-Optimize for the first time

I installed WP-Optimize and ran it one time. It found and removed over 1500 post revisions and some spam comments. Before this, 4 CPUs were very idle, below 10%. After running the scan, all 4 CPUs ...
0
votes
0answers
20 views

Error with moving my webhost

I've been developping a wordpress webshop for a while now. This week my webhost almost expired, so I've been looking to move to another company because my old one wasn't that good. Today I got my new ...
0
votes
0answers
11 views

why ’ quote double quote in database wordpress

i'm trying backup and restore database using php code. but i don't know why quote double quote show in database wordpress, something like ’, and destroy my wiget_text. So how can i fix that.? help ...
0
votes
1answer
35 views

Is saving multiple options or saving multiple items in one option better?

I have added multiple fields to a custom taxonomy. I followed Pippin's tutorial. This method creates a single option per taxonomy item. The multiple fields are saved in taxonomy_id. I was not sure ...
0
votes
0answers
46 views

Pulling Content from Existing Database

I am moving an existing site to wordpress. The existing site already has thousands of rows of data (items for a shop) stored in a different database. I dont want to import this data directly into ...
0
votes
0answers
11 views

Custom Search Page to a different table in the same db

I am new to wordpress and php. I want to create a search page. The inputs are: State, GoverningOrg, ProgramType, Orderby. Then press the submit button. So basically what I did was create a new page ...
0
votes
2answers
64 views

Problems with plugin that fetches data from database with ajax

After some answers I have edited my code. This is my plugin structure stpl1 stpl1.php getuser.php In stpl1.php I have the following code: <?php /* Plugin Name: Wordpress Plugin Stijn 1 ...
0
votes
1answer
23 views

Where is the order of a menu saved in the database

I want to use a custom menu from the wordpress database but I get the elements disordered and I want them to have the same order how can i do that? There is a place in the database where the order is ...
0
votes
1answer
26 views

Wordpress custom posttype meta values doesnot save

I am developing a wp plugin which supports custom post type in that i have create a metabox everything goes well.When i enter the values in my metabox field it will not display in admin panel where as ...
0
votes
0answers
48 views

Can't Post to my Wordpress Anymore!

I'm at my rope's end with this whole thing and have tried everything I can to solve it. I have a WordPress site with a SQL database on Azure, but recently all of the users associated with the site ...
0
votes
1answer
30 views

Is it possible to share WP database over Dropbox?

I'm developing WordPress themes on multiple machines right now: Windows & XAMPP, MAC + MAMP My themes are shared on Dropbox and are prefectly synced between all these machines (don't worry, ...
0
votes
1answer
48 views

How do I debug an error that a plugin is causing?

I'm having an issue debugging why the plugin I'm creating keeps displaying the error You need to upgrade your database as soon as possible.... The work I've done so far has been on a remote dev site, ...
0
votes
1answer
47 views

Wordpress post count not showing for custom post type author

I've created a few custom post types based on Dave Rupert's boilerplate and then migrated existing posts to these newly created CPTs via Post Type Switcher plugin. I did not make any changes to the ...
0
votes
0answers
16 views

new multisite, old db

I'm trying to get my old posts from a WP install that was in a sub-directory on my site, into a new Multisite install on a new host. The new install is doing what it should. the problem is the posts ...