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

learn more… | top users | synonyms

0
votes
0answers
16 views

Custom table in my plugin print UTF-8 (מוברש) charsets and not hebrew

i have created custom table in wordpress db to use my plugins needs. i have campaigns with hebrew names, this saved to column (varchar(100) utf8_unicode_ci ) in the DB i dont see hebrew but this: ...
0
votes
0answers
43 views

Simple email input store in database

I'm trying to build a really simple form to store email adresses in the wp database for future newsletter purposes. What I have is just a single email input: <form method="POST"> <input ...
0
votes
0answers
42 views

Creating a custom Search Form that links to a custom database?

I'm kinda new in Wordpress and I'm still learning as I go along. Currently, I'm trying to create something like this I have a custom set of database in the server in mysql with a table. The ...
0
votes
0answers
15 views

How to print out database content like declared in DB_CHARSET?

Ok i created some table with Romanian names "CREATE TABLE `wp_drzava` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Kod` varchar(2) NOT NULL, `Naziv` varchar(100) NOT NULL, `NazivSrb` varchar(100) ...
0
votes
0answers
22 views

Unable to create custom table , register_activation_hook from class

Cannot create the table , what am i missing class em_db { public function em_events_custom_table() { global $wpdb; $table_name = $wpdb->prefix . "em_events_db"; ...
0
votes
0answers
59 views

Get id from database

I need this ID to delete users from table. My plugin crate new table in DB when he is activate. All this code is in main.php, and in second.php i have only form that display my results.. and i include ...
0
votes
0answers
15 views

Comments disappeared but showing in database

This morning I published an article under which several comments were placed. I could read them and everything worked fine. Then all of the sudden, the number of comments were still showing on the ...
0
votes
0answers
10 views

No Database Backup

I'm looking for a way to recover as much as I can from a poorly backed up Wordpress website. The website owner didn't renew their hosting and lost the site. This was the first and last Wordpress ...
0
votes
0answers
29 views

Delete entry from DB

i created plugin and now i want to add delete button, that user can delete one entry from DB table.. Here is my code i form.. function showresult(){ ?> <form method="post" ...
0
votes
0answers
15 views

Force reindexing of plugins in Multisite

I have a Wordpress multisite installation and am developing it on localhost. However if I install a plugin in development, deploy the files and check multisite plugins section in Wordpress admin, it's ...
0
votes
0answers
42 views

How to clean tables after plugins are uninstalled

A number of plugins which I use earlier are not uninstalled and there tables are still there. I don't know the table names created by those plugins. Is there a way to automatically delete (via a ...
0
votes
0answers
54 views

Insert data to DB

I create plugin and that plugin, when is activate, create new table in DB.. Now i need to insert some data like (firstname, lastname..) in that table.. Here is my form : <form name="cool_form" ...
0
votes
0answers
116 views

$wpdb error : call to a member function insert() on a non-object

I'd like to add data to my custom wordpress table of my plugin, here is my code: <?php global $wpdb; $data = $_POST['name']; $wpdb->insert('ct_data' , array( 'name' => $data ), array( "%s" ...
0
votes
0answers
52 views

Get results from wordpress data custom table

Firstly i created a custom table into the wpdb : global $wpdb; $table_name = $wpdb->prefix . 'countdown_table'; $sql = ' `id` int(11) NOT NULL AUTO_INCREMENT, `styleName` varchar(255) ...
0
votes
0answers
25 views

Use existing client information database in wordpress site

Our company's website is being completely redone, this time with wordpress. We have an existing client database where clients can log in and get the information they have permission to view. This ...
0
votes
0answers
25 views

Any way to calculate distance between 2 addresses based on custom fields?

I'm working on a directory database theme, and I wonder if there is any way to calculate distance between 2 addresses or lat/long.... It can be a straight line calculation, and direction (bearing) ...
0
votes
0answers
35 views

Unable to replace text string across site

There is a text string (a little over 1000 characters with spaces) that needs to be replaced across the entire of my website. The text recurs over 300 times on my site, is identical, and was been ...
0
votes
0answers
31 views

Preventing concurrent update of data

I have to implement the update of some metadata. An algorithm try alter some global variables in order to minimize a global error function. This algorithm is triggered by users who ratings each other. ...
0
votes
0answers
41 views

Get User data from external site

I would like to pull user data into a mobile app. I would create a simple login in the app and send the username and password to my wordpress site. The site would authenticate the user and return user ...
0
votes
0answers
19 views

Using one WordPress installation for two sub domains

I'm helping a friend of mine with his website. He's an artist and he's making music & films. he wants to have 2 separate website using subdomains. like this : music.hiswebsitename.com ...
0
votes
0answers
56 views

Manipulate database of WordPress site with my own scripts

I love WordPress as it provides plenty of great themes, good SEO and overall content management. But I'm not always happy with WordPress's original "Add post" and "Edit post" features as it required ...
0
votes
0answers
38 views

Possible to remove settings from wp_customize?

So, really basic setting here. function Ari_customize_register( $wp_customize ) { $wp_customize->add_setting('header_position', array()); $wp_customize->add_control('header_position', array( ...
0
votes
0answers
57 views

Is removing orphaned wp_postmeta records safe?

I am using woocommerce as a shopping cart on a wordpress site. Products and Product Variations are each stored as records in the wp_posts table. Each of these Variations have aprox. 15-20 associated ...
0
votes
0answers
21 views

Change Custom Menu Header Manually

I am working on a legacy site and typically don't work with Wordpress, so I'm crashing very hard into the WP world here. Basically, from what I can tell the site has these Custom Menus set up. I want ...
0
votes
0answers
74 views

Convert from .htaccess to web.config?

When I convert to web.config. It shows an error: <rewrite> <!--This directive was not converted because it is not supported by IIS: RewriteBase /.--> <rules> <rule ...
0
votes
0answers
24 views

Why is wordpress trying to re-install itself?

I ran out of space on my MySQL server so I got a bigger disk and moved the files to the new disk, restarted MySQL and things were fine. But I went to my sites and now wordpress is acting like its ...
0
votes
0answers
22 views

What's the point of wp_blog_versions?

The documentation says about wp_blog_versions: The current database version status of each site is maintained in the wp_blogs_versions table and is updated as each site is upgraded. but what's ...
0
votes
0answers
14 views

saving and retrieving data

I been following some tutorials on how to create wordpress plugin, but i did not understand how to save data into a table, from admin e.g asking some questions and then on the front end displaying it ...
0
votes
0answers
29 views

Theme options not being sent to Database

Currently working on a little project for a theme, doing this so i can learn the in's and out's of wordpress. So far i've got to the point of adding sections, and fields within those sections. ...
0
votes
0answers
35 views

Custom Post Types and Posts are mixed

I need help with a problem related with CPT and WP Database. I have a wordpress install with bbPress and a custom post type called Destinos. The problem is that when I´m looking for the forums, or ...
0
votes
0answers
66 views

Restoring .sql backup results in “Error establishing a database connection”

I'm trying to get the database dump (.sql) of a remote site to work with my local setup. Sort of like migrating from remote to local. I've already ftp-ed the site itself, but having problems ...
0
votes
0answers
59 views

Redirect Issue: Wordpress database

I have an issue with my wordpress site that seems to relate to the settings in wordpress. However, it seems to go into a redirect loop. I can confirm upon a fresh installation the issue disappears. I ...
0
votes
0answers
19 views

How does one change the posts database table of a site?

I am currently in the process of developing a mobile site to accompany a site that I have been operating for a while. I came up with the idea to use multisite to create a second site with a ...
0
votes
0answers
75 views

Error establishing database connection on app engine

Error establishing database connection on app engine after deploying wordpress. I got an error Notice: Undefined property: batcache::$query in ...
0
votes
0answers
63 views

trying to update post meta in bulk

I have been trying to arrange my site so that my URL structure is set to domain.com/collection/%collection%/%product-group% Where %collection% is a taxonomy term, collection is the index, and ...
0
votes
0answers
291 views

Unserializeing multiple column values that are stored in one database results variable

Lately i have created a custom template to search for data in a database, and also displaying it, by the use of checkboxes. So, a user can select multiple checkboxes to search data on and the query ...
0
votes
0answers
27 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 ...
0
votes
0answers
119 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
0answers
35 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
39 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
0answers
19 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
0answers
57 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
0answers
170 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
31 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
0answers
15 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
0answers
18 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
42 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
202 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
25 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
0answers
86 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 ...