Blog about Web Programming and Electronics
The Vadnica Blog is a place where I share my experience with web programming and electronics. Here you will find articles about HTML, CSS, JavaScript, PHP and MySQL, as well as Arduino projects, Linux and news from the world of technology. I write in a simple, understandable language, so the content is accessible to both beginners and more experienced readers.
Displaying data from a MySQL database on a webpage using PHP PDO
Once we have data safely stored in the database, it's time to display it to visitors. When outputtin...
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...