dbDelta only creates the last table

Run dbDelta for each SQL statement seperately: function myplugin_install(){ global $wpdb; $table_name = $wpdb->prefix . “vehicles”; require_once(ABSPATH . ‘wp-admin/includes/upgrade.php’); $sql = “CREATE TABLE IF NOT EXISTS $table_name ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, description VARCHAR(25) NOT NULL, PRIMARY KEY (id) ); “; dbDelta($sql); $sql2 = “CREATE TABLE IF NOT EXISTS $table_name1 ( … )”; … Read more

How to call a plugin function from index.php

The same way you would any other: foo(); Active plugins are loaded before the theme files You may want to check that your plugin is activated and the function is available so things dont go pear-shaped if you forget to activate it, like: if(function_exists(‘foo’)){ foo(); } else { echo “oh dear you haven’t activated/installed ‘myplugin’, … Read more

WordPress 3.5 Media Manager – add a button

This block of code will add a button right next to the “Insert into post” one. When clicked, it will send selected images to WP editor, each wrapped inside your template HTML: var wpMediaFramePost = wp.media.view.MediaFrame.Post; wp.media.view.MediaFrame.Post = wpMediaFramePost.extend( { mainInsertToolbar: function( view ) { “use strict”; wpMediaFramePost.prototype.mainInsertToolbar.call(this, view); var controller = this; this.selectionStatusToolbar( view … Read more

Create a table in custom plugin on the activating it?

You have to include wpadmin/upgrade-functions.php file to create a table example function create_plugin_database_table() { global $table_prefix, $wpdb; $tblname=”pin”; $wp_track_table = $table_prefix . “$tblname “; #Check to see if the table exists already, if not, then create it if($wpdb->get_var( “show tables like ‘$wp_track_table'” ) != $wp_track_table) { $sql = “CREATE TABLE `”. $wp_track_table . “` ( … Read more

Woocommerce get cart total price in a number format [closed]

Update 2020 Answer See flytech’s answer for a solution using the native WooCommerce API. Note / Caveat If you’re going to do proper arithmetic with monetary values, always use signed integers (!) representing the smallest denomination of a given currency (Cent, Penny, Paisa, Dirham, e.g.). Only convert back to decimal fractions in the presentation layer … Read more

Get the category from an ID of a product?

Since the question is tagged woocommerce, i’m assuming that it’s a product CPT created by woocommerce wordpress plugin. This answer doesn’t apply if that’s not the case. The products categories is not normal categories, they are a custom taxonomy created specifically for products which is just labeled as “Categories”. You should go through the woocommerce … Read more

How can I create a bash install script for my WordPress sites setup (WP+plugins+theme)?

To always get latest plugin take for example my plugin: http://wordpress.org/extend/plugins/wordpress-file-monitor-plus/ the download link for the latest is: http://downloads.wordpress.org/plugin/wordpress-file-monitor-plus.1.1.zip but if you remove the version from the download link you always get the latest version: http://downloads.wordpress.org/plugin/wordpress-file-monitor-plus.zip EDIT: Have you considered keeping a folder of the latest wordpress and plugins unpacked? Then as soon as a … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)