MySQL Count Weekday occurrences

Each SQL dialect is different in some way, shape, form, or fashion from the next flavor. Some dialects have this function, while others have that function. In this post, I cover porting over Oracle SQL to MySQL in order to count the number of occurrences of a specific weekday found in the current given month (at the time of writing) purely as a learning exercise focused on MySQL DATE functions and the WITH clause…

[Keep reading for more MySQL database and Python/PHP-centric content >>>]

MySQL Aggregate Query using CodeIgniter’s Query Builder

CodeIgniter’s Query Builder ORM has class methods for nearly any kind of database access/operation you can think of. In this post, I’ll cover some of the available methods for retrieving aggregate-level query results. The examples in this post map out Query Builder method chaining to produce results you would get from a raw MySQL query. Continue reading to see more…

(more…)

WordPress Contact Form 7: Blog post compilation

Anyone with a website surely needs a reliable contact form to allow visitors and guests to reach out to them. If you are using WordPress, there are more options for contact form plugins than I could fill up in words here in this post. However, one of the more popular and easy-to-configure plugins is Contact Form 7. I recently wrote a couple of blog posts over on Medium detailing how to create a simple contact form using the Contact Form 7 plugin and want to share those posts here on my blog for readers who may be interested…

(more…)

CodeIgniter Form Helper library – at a glance

Working with forms is common for anyone in the web development field. Forms are used to capture information for one purpose or another. Be it user login credentials, or customer order details, forms are at the heart of interaction in websites and applications across the Internet. The CodeIgniter PHP framework comes with several built-in helper libraries, that assist in rapid web development. One of them is the form helper. In this post, I’ll cover some of the common methods available from the form helper library…

[Keep reading for more SQL database and PHP/Python-centric content >>>]

7 Tips to Choose a Technology Stack For a Web Application

Imagine you came up with the idea for a web application. The question is what tech stack to use to get a powerful web app. 

The technology stack for your product does not only bring it to life but affects its further maintainability, scalability, and many other factors.

Let’s consider the major tips you should take into consideration before getting the web tech stack and other web development services.

(more…)