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

learn more… | top users | synonyms

0
votes
0answers
4 views

Selectively restoring original posts from a compromised site to a freshly installed WordPress database

My site has recently been compromised. If I restore the full database, google says there is hacked content on my site. The hacker has created many new garbage posts in my site - which already got ...
0
votes
2answers
26 views

How to fetch Data in WordPress using MySQLi or $wpdb

I have custom table like this: useraw 1. id (Primary*) 2. user_ip 3. post_id 4. time I am inserting data in the table using $wpdb->insert($table_name , array('user_ip' => $user_ip, '...
1
vote
0answers
19 views

Transferring WordPress Database - Serialised data

I'm attempting to migrate data that is using a plugin (WordPress Job Board) to a new instance of a plugin (WordPress Job Manager). The plugins are storing data differently in certain parts of the data....
0
votes
1answer
18 views

Can I customised default WP table

I have a XML file that consist of product information. Format of XML file : <product> <name>Product-1</name> <description>this is product 1 description</...
0
votes
1answer
15 views

execute custom function on database connection error

is it possible to execute a function on wordpress db connection error? I mean is there any hook or something in the (error stablishing database connection) thing...? I want to do something when I get ...
-2
votes
1answer
22 views

CSV generated through admin-ajax.php retuns empty [on hold]

I'm trying to generate a csv file based on data passed through an Ajax post. The posted data are user id's, these are then used to retrieve the user's email which will be put into a csv file. No ...
-4
votes
0answers
14 views

write a generic script which allows any database in the box and output as below [on hold]

Write a generic script which allows any database in the box and output as below. Database is running in host < > since <> Following are the details: # DB Name : TEST Version ...
0
votes
0answers
30 views

I want 3 WordPress websites, with the same users able to login to each

I want to install 3 WordPress websites, and I want users to be able to sign up to any of the sites and then access all the other sites with the same login credentials - like Google where you can sign ...
0
votes
1answer
32 views

WP Query - filtering terms with regex

is there a possibility of filtering posts by terms using regexp? My code doesn't quite seem to work. $tax[] = [ 'taxonomy' => 'tax_name', 'field' => 'name', 'terms' => $...
0
votes
1answer
18 views

How to create a custom page for unrelated database?

I'm writing a plugin to display products (my first plugin). I have a 10.000 product database with ids, names, images, description. I can display all of them from a page template/dummy page. How can I ...
-1
votes
0answers
11 views

About wordpress data

student will send application via school website. I want to edit custom database table data through wordpress option page/wordpress dashboard & print this via option/dashboard. How do I do this?
0
votes
3answers
52 views

How to properly insert data into custom table via plugin

I have a plugin that reads data from an uploaded file and runs queries on the wp database. These inserts are into a table created by my plugin, so they aren't the post type. This is how I got it ...
0
votes
1answer
9 views

Does Wordpress Support Using Named Pipes on the Windows Operating System?

Okay, suppose I wish to disable networking completely on a development machine running MariaDB 10.1.14, and instead use Windows' Named Pipes/Sockets. I'm using a local copy of Apache (2.4.23 x64 VC14),...
1
vote
1answer
10 views

cache specific data?

I want to display some information from database in each post, for example date of registration of user and user role etc. It is quite static data that doesn't change. Now if I make a query to the ...
-3
votes
0answers
32 views

Create like button from scratch

Would someone kindly give me a pointer on direction to take to create a simple test data unique to each user that can be updated by other user from front end and saved in database. I know it sounds ...
-1
votes
0answers
43 views

Removing duplicate user emails from the database

I converted a database to WordPress. There are many users with the same email addresses. I imported all users, but now I'd like to delete the multiple users with the same e-mail and attribute all ...
0
votes
0answers
10 views

Plugin option page store draggable list in WP database

I have create a plugin. On the plugin option page I use a sortable list. I will save the order in a db table (example xxxtest). What's wrong. I see that ajax transmit (success alert) but nothing ...
0
votes
0answers
8 views

Bulk update post slugs (find and replace all)

Is there a way to bulk update permalinks through the database? I have several 100 posts and all I want to do is replace all "-" to "_" to the permalink. I could just manually update but that's too ...
0
votes
1answer
28 views

Error establishing a database connection problem in xampp saver

Im beginner for the word press development, Im try to install my local host to word press but i had following problem, can you please help me to fix this My WP-CONFIG // ** MySQL settings - You can ...
-1
votes
0answers
11 views

Create dynamic webpages of images based on image tags [closed]

I have a database of pictures associated with different tags. I want my website to dynamically create a webpage based on a specified tag. For example, if one clicks on "Puppies" I want all the photos ...
0
votes
0answers
15 views

Use Shortcode to pull specific custom post type into any page

I'm looking for a way to code a shortcode like [shortcode slug="slug-name"] that will pull data from the slugs specific custom post type and fill the variables of my template that I'm attaching or ...
0
votes
0answers
15 views

Multiple file upload frontend and capture their paths

<input name="image_url" type="file" /> <input name="Submit" type="Value" value="Přidat" /> I have this in html form and this in php : if ( $_FILES['image_url']['name'] != "" ) { ...
0
votes
0answers
11 views

WP_Query - Find the State and Match Zip Code

I a trying to develop a search box in which people can type in the State and enter a zip code and in return the results will show specific people. I have added Advanced Custom Fields and each person ...
1
vote
0answers
30 views

Localhost to Staging to Development Dynamic WP-CONFIG

I am trying to setup 3 environments: Localhost, Staging and Development. The issue is that each environment has its own db. We want to have ONE config file which will dynamically change the Db ...
1
vote
1answer
24 views

Wordpress Multisite blogs not working after domain swap

After I swapped over my domains and updated every instance of the old domain in the database and everything else in this guide: https://wpengine.com/support/how-to-change-a-multi-site-primary-domain/ ...
0
votes
2answers
36 views

Export only pages and posts with mysql dump

How to export only pages and posts using mysql database to database approach? More precisely: what tables should one select for dump (I suppose wp-posts and wp-post-meta ) is it safe to export only ...
0
votes
1answer
11 views

SELECT SQL_CALC_FOUND_ROWS with wordpress search

When I make a search on my site no posts are retrieved and through wordpress debug I get this error message: WordPress database error: [Table 'theme_se.wp_comments' doesn't exist] SELECT ...
0
votes
0answers
24 views

Connect Local Install to Remote Database

I would like to connect a local installation of WordPress to a remote database. How would I go about accomplishing this?
0
votes
1answer
26 views

Child theme functions.php file change database entries

I'm sure my title is not the correct terminology. I will do my best to explain what I'm trying to accomplish. Years ago I spent countless hours customizing a theme. I was finally forced to update ...
1
vote
2answers
34 views

Setup 3 Sites To Connect To 1 Database and Share Data

How do I setup 3 different Wordpress installations on 3 different servers, all of which connect to a single database and also share the same data? I'd like to set up 3 different servers. One for ...
0
votes
0answers
37 views

How can i change posts dates random?

I have totaly 5k content. I need change all of them dates. How can i set randomly dates? SQL? Example from 01.01.2010 to 20.06.2016 everyday can be dates.
0
votes
1answer
51 views

Ajax not working to insert, query and result data

On my site, through a form I send/register same information in database, do a SELECT/query and return it! Return the last table saved in database, just that user just entered on the form (along with ...
0
votes
0answers
24 views

Database with mixed collation (utf8mb4 & utf8_general_ci)

Each time I was uploading my WP install from offline to online, I was noticing strange characters in text and digging a bit I have discovered that wp-config.php on the online server was set to define('...
2
votes
1answer
30 views

Get all tags not just first 10 with wp api 2.0

if I do /wp-json/wp/v2/tags I only can get first 10, and seems the adding per_page=0 no longer work on it for getting actually all tags. Anyone knows how to actually get all the tags with wp-api 2.0?
0
votes
0answers
18 views

Override $table_prefix only for the options table

The only documentation i found was too obsolete. (https://wordpress.org/support/topic/two-sites-two-themes-one-database-same-content) and this one (Change options table prefix only) doesn't help me. ...
0
votes
1answer
30 views

Wordpress plugin boilerplate table create

Hi I have a terrible problem. I generated the code plug on the page: http://wppb.me/ And now, in no way do I add a table to the SQL database installation. I tried to do it this way: includes/class-my-...
0
votes
0answers
19 views

Call to a member function insert()

I did a POST form and try to sign in to the Wordpress database is showing this error. Fatal error: Call to a member function insert() on a non-object in C:\wamp\www\teste\wp-content\themes\...
1
vote
1answer
37 views

Wordpress Integration with Google Groups

I'm having some trouble trying to make an area on my WordPress site, that must be accessible only to members of my Google Group. I tried to make it with some plugin, but most of them would take me to ...
0
votes
0answers
38 views

How to generate notifications when MySQL data base changes

I am developing a WordPress multisite and I am wondering how I can generate notifications when MySQL database changes? For example the user in site #1 can sell his society. When he selected it, it ...
3
votes
1answer
36 views

stdObject stored in database. How does one convert it to usable format?

So I logged on phpmyadmin, went to check out how data is stored in a table and saw it''s 'data' columns contents (pasted below): a:8:{i:2;O:8:"stdClass":2:{s:5:"label";s:6:"Vardas";s:5:"value";s:1:"A"...
-2
votes
1answer
51 views

Fetch all categories from database

My Android project needs to fetch the database every day. I have a category structure like: console tablet camera phone laptop other The structure of the WordPress database is very confusing. I ...
0
votes
0answers
27 views

How to display the results of inner join to user?

I have three tables of contents. And I put them together and display the result to the user, how can I do this? MY CODE THAT INSERT DATA IN TABLES: function cadastra_experiencia($nome, $email, $...
0
votes
0answers
26 views

Sharing tables between 2 different websites based on the same database

I have 2 different websites installed on the same database. The 2 websites are sharing the users tables, but I want them to share the posts tables too. I tried to do it by editing wp-db.php. After ...
0
votes
1answer
48 views

How to connect and insert data in database of wordpress?

On my website, there is a section called "My Ideal plank." It is a form where the user will enter their data and there will be a return message with the type of ideal board for the person. First ...
0
votes
0answers
23 views

Wordpress Authentication without Wordpress functionality

The requirement is to authenticate against the WordPress users tables to get past the paywall but not offer any WordPress functionality. The problem to resolve is that since the user is ...
1
vote
1answer
69 views

Store and Work with huge array in WP [closed]

I need to get all terms that have post with dates in custom field. So I need a list for all dates from the term. I need to know exactly what is tha dates within each term in my site. It's not in term, ...
0
votes
0answers
21 views

Trim data before insert?

Recently I use this syntax to input data like below: $STRING_DATA = StrToLower(Trim($input_data)); $wpdb->query ( $wpdb->prepare ( 'SQL SYNTAX WITH PARAMETER STRING', $STRING_DATA ) ); Do I ...
3
votes
1answer
57 views

Right way of storing large number of custom post fields

On one of the sites of my multi-site network; I'm creating a custom post type 'Events'. Each of the 'Events' post will have about 30-50 custom post fields - because we require event creators to enter ...
0
votes
1answer
14 views

Regenerate user_nicename column

I'm struggling with a database issue. I took control over a solution created by someone else. When inserting / updating users in the database, the earlier developers wrote a custom database script to ...
1
vote
1answer
41 views

Trying to establish connection to External Database

I'm trying to get a connection to a separate external database from the database the wordpress site depends on. I have a PHP file inside the same location of my theme, it is basically a blank PHP it ...