Securely inserting data into a MySQL database using PHP PDO
Once we have the table structure ready, the next step is inserting data. At this stage, we must be e...
How to properly design a database for multi-language websites
When starting to build a website in multiple languages, we often wonder if we need to create a separ...
How to set a fixed frequency on TEA5767 for BBC Radio 1
If you don\'t need to scan for stations and want your Arduino radio to always play the same station ...
How to rotate the screen on Raspberry Pi
In Raspberry Pi projects, it frequently happens that you need to rotate an official or external disp...
How to Send a CSV File as an Email Attachment with PHP
Sometimes we don't just want data transferred to the computer, but we want to automatically send it ...
How to Export Data from MySQL Database to CSV File with PHP
In the previous post, we looked at how to import data; now we'll do the reverse. Exporting data from...
How to Import a CSV File into a MySQL Database with PHP
Importing data from CSV files into a database is one of the most common tasks when managing web appl...
How to Convert an XML File to CSV with PHP
XML is excellent for data exchange, but when we want to process it in Excel or import it into a data...
Understanding and Setting the SameSite Attribute for Cookies
Browsers have recently tightened security. If you see a warning about the SameSite attribute on...
Installing XAMPP Server on Linux and Connecting to PHPStorm
XAMPP is a popular package that combines Apache, MariaDB, and PHP in one place. Although Linux uses ...
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...
How to Force the Footer to the Bottom of the Page Using the calc() Function
On websites with little content, it often happens that the footer doesn\'t stay at the bottom of the...