Python tutorial for beginners: learn the basics
Welcome to the wonderful world of Python programming! If you’re new to coding, buckle up because Python is one of the easiest, yet most powerful, languages out there. Whether you’re looking to automate tedious tasks, build web apps, or dive into data science, Python is your gateway to coding success....
Read more →
LibreOffice Calc for beginners: a complete guide to spreadsheets
Are you new to LibreOffice Calc and eager to master spreadsheets? Don’t worry—you’re in the right place! Whether you’re a student, professional, or someone who just wants to organize their life better, LibreOffice Calc has got your back. It’s not just an alternative to Excel; it’s a powerful, open-source tool...
Read more →
Core PHP CRUD operations: a beginner's tutorial
Creating dynamic web applications often involves interacting with a database. One of the foundational elements of web development is the ability to perform CRUD operations: Create, Read, Update, and Delete. This tutorial will guide you through core PHP CRUD operations, helping you understand how to manage data effectively in your...
Read more →
Common PHP errors: solutions to frequently encountered issues
PHP is a powerful scripting language widely used for web development, but like any language, it’s easy to run into errors that can be frustrating to debug. While some errors are simple and easy to fix, others may be a little more complex. This article covers some of the most...
Read more →
Unlocking speed: the power of indexing in database performance
In today’s data-driven world, the performance of databases is crucial for applications, businesses, and users alike. As databases grow in size and complexity, the need for efficient data retrieval becomes paramount. One of the most effective strategies for enhancing database performance is indexing. This article explores the role of indexing...
Read more →
PHP libraries for PDF handling: evaluation and use case guide
PDF generation and processing is a common requirement in many web applications, especially for generating invoices, reports, or documents dynamically. PHP provides various libraries to handle PDF creation, manipulation, and extraction. In this article, we will evaluate the most popular PHP libraries for PDF handling, breaking down their pros and...
Read more →
Seven most aesthetically pleasing fonts for your web apps
Without Google Fonts, our typography would be in limbo! Now, I’m neither a web designer nor have an eye for the pixel perfect and aesthetic design which a pro designer usually does. Instead, my usual workflow is to cobble together web components like bootstrap, jquery, codeigniter, etc. and try to...
Read more →
Introducing Comment Monk: simple comment hosting system for static blogs and websites
I wanted to implement a comment hosting system for my static blog https://prahladyeri.github.io, just basic Wordpress.org style commenting feature with user’s name, website, etc., no complicated logins or sign-ups or third-party platforms. The user reads your blog, posts a comment, and you approve from the backend (or alternatively, it gets...
Read more →
How to fix "silent error handling" of PDO errors after upgrading to PHP 8
PHP 8.x is filled with hidden land mines which can suddenly trip the unaware PHP coder, especially when porting from legacy frameworks like CodeIgniter or CakePHP to PHP 8.x systems. One such issue is PDO’s default exception handling method. Prior to PHP 8, PDO’s default exception handling mode was PDO::ERRMODE_SILENT...
Read more →
How to install composer packages locally or offline
The usual way of installing composer packages with composer require <foo> is the standard. But occasionally, we might want to install the packages from our local computer to save Internet bandwidth or some other reason. Unlike Python’s pip, PHP’s composer doesn’t offer us a straightforward path to install from an...
Read more →