My Blog
Securely Inserting Data into MySQL Database using PHP PDO
Once the table structure is ready, the next step is inserting data. We must be extremely careful regarding security, as SQL Injections are one of the ...
How to Properly Design a Database for Multi-language Websites
When creating a multi-language website, we often wonder if we need a separate table for each language. The answer is a firm NO. Why use only one ta...
How to Set a Fixed Frequency on TEA5767 FM Module
If you don't need a station scanning function and want your Arduino radio to always play the same station, the best solution is a "locked" frequency. ...
How to Properly Connect a 2.0" SPI TFT LCD to Arduino
The 2.0-inch TFT display with the ILI9341 controller uses the SPI protocol. Unlike basic displays, this one allows for full color and fast refresh rat...
How to Rotate the Screen on Raspberry Pi
When working on Raspberry Pi projects, you often need to rotate the screen by 90 or 180 degrees due to the physical mounting in the case. The process ...
How to Send a CSV File as an Email Attachment using PHP
Sometimes you don't just want to download data; you might want to automatically send it to a specific email address (e.g., a daily sales report or a l...
How to Export Data from MySQL to a CSV File using PHP
In the previous post, we looked at how to import data; now we will do the opposite. Exporting data from MySQL to CSV is extremely useful for creating ...
Loading a CSV File into a MySQL Database using PHP
Importing data from CSV files into a database is one of the most common tasks when managing web applications, blogs, or online stores. While phpMyAdmi...
Understanding and Configuring the SameSite Cookie Attribute
Browsers have recently tightened security measures. If you see a warning regarding the SameSite attribute on your site, it means you must explicitly t...
How to Convert XML to CSV using PHP
XML is great for data exchange, but for spreadsheet processing or database imports, the CSV format is much more practical. Below is a PHP script that ...
Installing XAMPP on Linux and Configuring PHPStorm
XAMPP is a popular package that combines Apache, MariaDB, and PHP in one place. While Linux has its own repositories, XAMPP is an excellent choice for...
Complete LAMP Stack Installation (Apache, PHP, and MySQL) on Linux
To set up a development environment on Linux, we need three key components: the Apache web server, a database (MySQL or MariaDB), and the PHP programm...