Blog on WordPress, Yii, jQuery, JavaScript and CSS

Useful programs for web programmer under Ubuntu

Let’s take a short break from the WordPress topic and talk about something more everyday — work. More precisely, the software I use daily. This is an introductory post on the topic, and in the future, I plan to review the software I use in more detail.

Recently, I’ve become more critical of using pirated software, music, scanned books, etc. Why? — because it’s all theft 🙂 in one form or another.
Today, let’s talk about the first item — software. Fortunately, I use lUbuntu Linux, and under it, almost all software is free!

2016-04-24 Pavel Linux CommentsNo Comments

Plugin Interaction with WordPress Database. Part 2

Continuing our series of articles on working with the database in WordPress. Today, we’ll talk about creating, updating, deleting, and retrieving data from the database.
Please note that we are not working with WordPress system tables, but with a custom one.
The table dump is shown below:

CREATE TABLE IF NOT EXISTS `wp_plance_text_shortcodes` (
  `sh_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sh_title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sh_code` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sh_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `sh_is_lock` tinyint(1) unsigned NOT NULL,
  `sh_date_create` int(10) unsigned NOT NULL,
  PRIMARY KEY (`sh_id`)
) ENGINE=InnoDB;

This is the current structure of the table used in my plugin “My Text Shortcodes”.

2016-04-12 Pavel WordPress CommentsNo Comments

Plugin interaction with WordPress database. Part 1.

Hello, dear blog readers!
Let’s expand our WordPress programming knowledge a bit and look into how plugins interact with the database.

Out of the box, WP has pretty decent capabilities. I’m referring to things like creating custom taxonomies, terms, and linking them with additional data using metadata. It’s very convenient — once you write a dozen functions, you no longer need to worry about creating interfaces or even some of the internal app logic.

But for me, as someone still "new" to WordPress, it feels more natural to work with clearly structured database tables.
So in this article, I propose to explore that approach — based on one of my plugins called “my-simple-form,” slightly simplified for the purpose of the example.

2016-03-14 Pavel WordPress CommentsNo Comments

How to programmatically send an email in WordPress

While developing another plugin for WP, I remembered a small issue I once ran into — programmatically sending email messages. There's really nothing complicated about it, but still, it might be useful to someone.

Usually, across the web, I’ve seen the following code:

wp_mail(
	'to_email@example.com',
	'Email Subject',
	'Email Body'
);

2016-03-06 Pavel WordPress CommentsNo Comments

If an error occurs in the MMEX home accounting program

There’s a super cool program for personal finance management called **“MMEX”**. It’s simple, intuitive, cross-platform, and convenient. In fact, in my opinion, it’s one of the best tools for managing household finances.
But I won’t go into all of its advantages right now. Instead, I’ll share an interesting story that happened just a few minutes ago. When I launched the “Money Manager Ex” program, the following error occurred:

2016-02-29 Pavel Linux CommentsNo Comments