mysql - Read For Learn

dbDelta not adding additional columns in plugin database update

After trial and error, here is the code that works: function installer(){ include(‘installer.php’); } register_activation_hook( __file__, ‘installer’ ); //executes installer php when installing plugin to create new database //database update checkdate function myplugin_update_db_check() { global $xenon_result_db_version; if ( get_option( ‘xenon_result_db_version’ ) != $xenon_result_db_version ) { installer(); } } add_action( ‘plugins_loaded’, ‘myplugin_update_db_check’ ); The installer.php looks … Read more

WordPress Block developer from exporting Database via PHP

First of all, as Mark suggested in the comment: never use developers you don’t trust. Once you give a developer FTP | Git | SSH etc. access to your site, he or she can do anything you can from the admin panel & even more. There is no way to stop them that will not … Read more

WordPress create database not working

dbDelta() is very picky, below I’ve checked the requirements for dbDelta() in your code. As you can see below your code fails two of the requirements which most likely prevents dbDelta() from creating the tables. You must put each field on its own line in your SQL statement. CHECK You must have two spaces between … Read more

How to get an unique identifier for a page/post/category/tag etc.?

Everything in WP has an ID. As long as your theme is using body_class you probably already have built-in classes that will cover your scenario. For example: Pages will include a page-id-## class, where ## is the id specific to that particular page. The homepage will include a home class and if it’s your main … Read more

Database Structure on Different Servers

I don’t think WordPress can manage two databases at the same time (unless you tweak it significantly, by means of HyperDB1). So, you’d probably will like the job of abstracting two databases and making them look like one to WordPress to be done by the database functionality. WordPress can work mostly with MySQL (see WordPress … Read more

creating new field on mysql

You can find any additional information in the usermeta table as meta_key meta_value pairs. Wordpress doesn’t create additional database columns for custom fields. That’s one of the great concepts that make WordPress so smart and flexible.

Changing between Local Host DB to Production DB and in reverse

The short answer is — no, there is no simple way. WP is designed to work within a boundries of a single database as installed and with core exclusively manipulating that data. There are no concepts of database being manipulated partially and externally. The most common and reliable workflow is that you copy database from … Read more

Meta Query doesn’t works as espected

Mariolex, Have you tried using meta_query? I wrote something quick and untested but it may do the trick: $args = array( ‘post_type’ => ‘posts’, ‘showposts’ => ‘-1’, ‘meta_query’ => array( array( ‘key’ => ‘pickup_address’, //meta_key ‘value’ => ’43 Longview Drive, Papamoa’, //meta_value ‘compare’ => ‘LIKE’, //compare ), ), ); $query = new WP_Query( $args ); … Read more

How does WP work in conjunction with a web server?

Apache only runs the index.php of WordPress, and serves static files (images, css, js etc). WP does all the rest, including parsing the request to find out what content to show the user. Apache does not (and needs not) know that there is communication with a data base in PHP, and doesn’t interact with that … Read more

Moving wordpress site from localhost to live server using GoDaddy cPanel

The issue was the file path. I moved all of my localhost files from the subfolder into the main public_html folder. I moved a couple of existing files – home.html/404.shtml/layout.css into a sub folder and the site now works.

+ More