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

learn more… | top users | synonyms

0
votes
1answer
39 views

Can form entries from a WordPress form go to a database

I am using Wordpress 4.3.1. I have built a stand alone form (form 1) using PHP where one can enter volunteering tasks doable in a city, has fields like volunteering activity, city, state. The values ...
0
votes
0answers
16 views

MyISAM vs InnoDB [duplicate]

We have a Wordpress website with almost 100k posts (and many more drafts and images). Number of simultaneous visitors reach 6k at peak times. Which database is more suitable for us?
1
vote
2answers
41 views

What happens if I overwrite the current wp_options table with a backup from a week ago?

I have a rather silly situation. I tried this query UPDATE wp_options SET option_value = 'a:0:{}' WHERE option_name = 'active_plugins'; which disabled all my plugins. I was testing some issues on ...
0
votes
0answers
16 views

WordPress Integration with Drupal

I could use some assistance. Can I build a site using WordPress as a CMS for one function, and use Drupal for another site (more of a CRM suite app) elsewhere, and grant permissions to records within ...
0
votes
1answer
92 views

CPT or Custom Table for Repository of Serial Numbers

My app allows users to purchase products from a WooCommerce store. But I need to attach a serial number (cannot be generated on the fly) to each product, depending on type, size and design. The ...
0
votes
1answer
131 views

Automatically generate pages from SQL

I'm building a biodiversity database and am looking for the easiest way to display all the information online. I know I can do this without a CMS, but I have too tight a deadline to waste time ...
0
votes
0answers
51 views

Website goes slow down after importing long database

I am working on a site which have 2 lakhs post and 15 categories. I have home page with 3 post of each category on home page. And after that its goes down while run home page and shows page not found. ...
0
votes
0answers
19 views

How can I move a Wordpress multi-site's domain seamlessly?

I have a multisite install and I've been setting up local and staging sites fine using a plugin (All-in-one-migration) tool to import / export DBs which handles updating the domain link embedded in ...
0
votes
1answer
34 views

AJAX Not Working With Wordpress Database properly

I have created a simple like system where user can click on like button and the like count will increase by one . And if he has already liked the button and he like the button again then it will ...
0
votes
1answer
29 views

Directly editing WP database issues

I've been struggling with this for a long time and would appreciate some help. I would like to change a value inside WP database using phpmyadmin. Sadly, this change seems to corrupt the database (...
0
votes
1answer
103 views

Store the wordpress “featured image” under »wp_posts« Database table

How to store the WordPress featured image under the wp_posts table. Can any one help me? The reason why I am asking same table details (wp_posts), is because I am using a JSON response to add in my ...
0
votes
1answer
65 views

How do you render posts from outside wordpress?

I'm trying to display posts outside of the wordpress system (another system is pulling from the mysql database). However, the posts stored in the database seem to be void of <p> tags and ...
0
votes
2answers
305 views

Website keeps going down, is it a plugin, database, memory problem, or something else?

So I've been having a problem with one of the websites I manage. Essentially, we keep seeing the cloudflare 'site is offline' message for at least half the day, constantly and consistently. Whenever ...
0
votes
0answers
22 views

Syncronize post from different databases

I have an "engine" site that import rss post from all over the world, all day, like an aggregator. That importing activity is really slowin down things. So in a different neat and clean wordpress ...
3
votes
1answer
616 views

Can a post ID be 0?

I couldn't find explicit confirmation of this, can it be 0?
0
votes
1answer
84 views

wp_usermeta - Read from database, but save function broken

I added a custom field to the profile-page of WordPress users called "uidnumber" and it reads values from the database just fine, however it just doesn't save anything. I'd rather save it in ...
0
votes
0answers
297 views

Need to save data to database from AJAX phone submit form

I have an input that accepts a country code (a select/dropdown form) and a phone number (number input) and submits them via AJAX to a pin verification service. The verification works great, but I need ...
1
vote
1answer
34 views

Moving minor updates between local and live sites - just database?

So after I have created my site on my localhost, and moved it over (files + database + config to new url etc...) I continue to work off the localhost version. The sites are identical. I then add ...
0
votes
0answers
37 views

What would Repair and Optimize Wordpress Database do?

Recently I am getting an error establishing a database connection in a clients Wordpress site. I googled for a solution and an article suggested to enable Wordpress Repairs by adding this to the wp-...
0
votes
0answers
32 views

$wpdb global causing issues with plugin class

I am currently building a plugin. I have a main init.php file which loads all the necessary plugin classes. Within one of the classes, I have several methods that call the $wpdb global. One of the ...
0
votes
2answers
23 views

Error establishing a database connection for some files

Host: Blue Host I have just moved a friends wordpress site to another host, something I have done a few time now without fault. This time there is an issue with random files. The website loads fine ...
0
votes
1answer
37 views

Hash user emails in database?

I have a wordpress based website, a very important thing is that no one should get to know the email addresses of the people who will admin. I will make the whole website private but I am still ...
1
vote
1answer
32 views

Unable to set a default serialized array using dbdelta()

I am trying to set up a table with dbDelta() and one of the columns will have as default a serialized array with predefined values. The issue here is that dbDelta() explodes the query using ...
0
votes
0answers
58 views

how to sync user database with excel sheet

guys! I'm currently building a website for a ONG and I've been asked to create a private page where the user's could see the points they have gathered with our organization and that can latter be ...
0
votes
0answers
79 views

siteurl value getting populated with junk in wp_options table

My website was getting this error on every page : Catchable fatal error: Object of class WP_Error could not be converted to string in /home/juhisheth/public_html/wp-includes/default-constants.php on ...
0
votes
1answer
154 views

Media Library doesn't allow uploads? Upload Directory

I just put up a WP 4.31 site. Most of the content was copied from a different WP site via FTP. All the stuff in wp-content: uploads, plugins,themes, etc. It all seemed to work as usual, and I've ...
0
votes
0answers
83 views

How to get data from Wordpress form into php or C#

I have a wordpress website and I created a form where the users can put in some information. I want to get that submitted information using preferably C# or any other popular programming language like ...
0
votes
0answers
52 views

why require a refresh page for see the changes from database $wpdb

I used a functions for create a new user, new site, switch to new blog and give new theme. wpmu_create_blog add_user_to_blog switch_to_blog switch_theme(); restore_current_blog(); when form ...
0
votes
0answers
35 views

mySLQ database into wordpress

Ok. I'm not even sure how to ask this but I'm trying to make a leaderboard on my site, where users enter points daily for five different options - on the honor system. I want the users to enter the ...
1
vote
0answers
88 views

Refresh page after update_post_meta

I have created a input field on a front-page where the value of the database is on the same page as the input-field. If a value is passed to the database I have to reload the page for it to show on ...
7
votes
1answer
96 views

Automate Wordpress Database Upgrade

I've set up auto-updates on my Wordpresses by adding /* Updates */ define('WP_AUTO_UPDATE_CORE', true); in the wp-config.php file. Once Wordpress releases a new version, when I try to reach the ...
0
votes
1answer
983 views

How to create a searchable database with a single-field search box at the front end?

I have seen many websites having developed a (hidden) database of their certified clients (actually details of the clients and the given certificates) and they have devoted a web page where clients ...
0
votes
1answer
22 views

Get multisite count without php?

I'm writing a program in Python that outputs information about Wordpress installations and I'm adding some features to detect Multisite installations and their details. I would like it to print how ...
0
votes
1answer
84 views

How to get product order by two custom taxonomy in wordpress

Yesterday i stuck in the middle of code that how could i retrieve product belong to specific custom taxonomy ordered by other taxonomy. Table wp_posts: id | post_title ---------------------- ...
0
votes
1answer
38 views

How to add an external php page with wordpress?

i want to add a page with html data to show form and get input from user,store it to database and after successful query show next page with massage that the data is inserted successfully.
0
votes
1answer
27 views

Installation question

I am a brand new developer to wordpress and about to begin work on a client's website that is already up and running. The site is very simple, it is more-or-less just a brochure with very little use ...
0
votes
1answer
237 views

Remove empty rows from the database

I'm writing a script to alter the post content column in the database and I just notice it has a lot of empty rows, these seem to be deleted posts that now have no content or anything, I don't like ...
0
votes
2answers
527 views

What's The Proper Way To SAnitize Checkbox Value Sent To The Database

I have tried using sanitize_text_field() and esc_attr() to filter checkbox data when saving their values to the database, but it is causing the data not being saved. What is causing it and what's the ...
0
votes
1answer
78 views

Show a table from data submitted by a form from a user

I would like to show a table on my wordpress site, which is filled by registered users. How can I realize this? So my thoughts are: Registered users should be able to submit 2 variables through a ...
0
votes
1answer
47 views

special characters not supporting in wordpress

First I dont know from which thing I am facing problem. I have created a wordpress website and it was working fine. I have moved it later to justhost.com and then I have got this problem. Special ...
1
vote
0answers
168 views

Create a table with wordpress plugin boilerplate

I am a new wordpress developer and i would like to create my first wordpress plugin based to wp plugin boilerplate template plugin. My plugin will have to do with my clients data so for this reason i ...
1
vote
0answers
295 views

Slow SQL_CALC_FOUND_ROWS Query

We are experiencing very slow performance with queries that use SQL_CALC_FOUND_ROWS within the admin section of WordPress. We currently have about 125,000 posts on our site and use Varnish to cache ...
1
vote
1answer
38 views

Storing Array from returned database query and using the array in a new query

I'm currently storing results in a variable from a db table like this : $followed = $wpdb->get_results("SELECT user_id1 FROM wp_um_followers WHERE user_id2 = 1", ARRAY_A); This returns an array ...
0
votes
1answer
225 views

What might be the reason of Couldn't fetch mysqli_result on another domain?

I'm developing a plugin and it works fine on my Wordpress website, but I've tested it on other domains with different Wordpress instances. When trying to activate the plugin on some other sites and ...
2
votes
1answer
35 views

What are conventions about the schema of the $table_prefix

I wonder if there are any conventions or best practices about the table prefix of any WordPress set up. The official documentation on wordpress.org does not make any statements to that topic. ...
0
votes
1answer
58 views

Changing order of db results when encoding to JSON

There is probably a very simple solution to this but I just can't work it out. I am getting some info from the wp database, bypassing WP's built in classes, then echoing the results as encoded JSON ...
0
votes
1answer
82 views

WP_Query always returning the last custom post

I have code that works fine on our live system, and I'm porting it to a new theme. In the new theme, the WP_Query always seems to return the last custom post. My function is: function ...
0
votes
1answer
31 views

Send data to database after redirect (and popping out of iframe)

I am using $wpdb->insert to place form data into a custom database. There a multiple things happening, though. The page that sends the data to the database is caught in an iframe. I know how to get it ...
-3
votes
2answers
60 views

Problem with form database connectivity

Many people has asked the same question, I have read those things and mine is different, I am trying to insert some values inside the database from the form but it's not getting inserted I have a ...
0
votes
0answers
37 views

Querying same column twice with wpdb (for postmeta values, specifically latitude and longitude)

I've seen similar questions around, but I just can't apply them to my case, I'm quite new at this, apologies. I'm trying to create a google map of my posts, using a latitude and longitude that are ...