Articles of database

WordPress database products structure

I am writing an external program on c++ which supposed to import products to WordPress database (it should directly connect to remote MySQL server and just execute some SQL queries to create a new product). I have all the products’ properties and remote database access, but I can’t completely understand how does actually WordPress serves […]

Where do plugin variables live in the db?

I’m no developer, rather a designer. But for my wife, I’ll be all things (this is for her free e-comm, erp, and crm solution) So, i’m connecting dolibarr to woo com. i need to double check the entry of the highlighted field. that sucker needs to exist in the database somewhere…but i can’t find it. […]

Entity to store contact form entries?

Lets say I develop minimal contact form plugin. The plugin save contact entries in the website. I think custom post type is not best way to store contact entries since post type is specifically created for front-facing contents. Because of this curiosity, I installed a form builder (FormCraft) and make one entry by filling the […]

How do i get user data from a custom table in the wordpress database by user ID?

I’ve got a few custom user data fields that require user data from a custom database table. I’ve tried: global $wpdb; $table_name = $wpdb->prefix . “wplusersprofiles”; $user = $wpdb->get_results( “SELECT * FROM $table_name” ); and calling the data like: <tr> <th><label for=”gender”><?php _e(“Gender”); ?></label></th> <td> <input type=”text” name=”gender” id=”gender” value=”<?php echo $user->gender ?>” class=”regular-text” /><br […]

Link image with data from the wpdb

It might be a stupid question, but I can’t get it to work.. Problem I have no idea how to link my image on the frontend with the url from the database. Situation I’ve created a Custom Post Type called ‘Banners’. On each post I’m able to add a featured image. This will be saved […]

Both VPS and domain changed but Database URL stayed the same and PHPmyadmin inaccessible to change it

As I’m new to Linux and WPCLI, I moved a site from one VPS to another but URL stayed the same and PHPmyadmin doesn’t work so as of the moment I can’t change the site URL from PHPmyadmin. When I try to navigate to the site from the browser (after setting up a database, changing […]

Store and Encrypt Contact Form 7 Submissions in Database?

I have an additional security requirement (in addition to SSL) and I’m looking for a method (either a plugin or custom solution) of how to encrypt and store submissions from Contact Form 7 in the database. For example there are plugins such as Flamingo that allow the submissions to to be stored in the DB, […]

How to create a page that contains a list of post titles from specific categories?

The idea here is the following (I’ve now uploaded a picture to make it clearer what I need): Create a new page that contains a nicely formatted CSS table. Each row would refer to a specific post from a specific category. Each column would refer to specific information about that post (linked title, post date, […]

Optimizing function that automatically creates internal links based on post title string

Problem sovled,thank you @SamuelElh for the tip ,so I relect it in the code.Transient turns out to be the right solution. I wrote a function that adds links to existing post titles that occur in a post. For example, when you add a post to a site with the title “this is a title” and […]

Unable to create new database table upon plugin activation using dbDelta

I’m trying to create a new database table when my plugin is activated using dbDelta() however, no new table seems to be creating. Since I’m new to WordPress development, please let me know where I’m going wrong. <?php /* Plugin Name: Xenon-Result Plugin URI: Description: Basic WordPress Plugin Header Comment Version: 1.0 Author: Himanshu […]