How to Linux Blog

Using an Arduino board and optiLoader

if Arduino ISP hacks are not working, there is still hope ! And it is called optiLoader. This project, initiated by Bill Westfield is ‘based’ on the ArduinoISP sketch. Optiloader is a sketch designed for...

Hide database from user

Hide database from user

These two queries will restrict a user to a single database, so that the user can only see, update, and delete tables from that single database: Replace USER with the MySQL username Replace USERDATABASE...

PHP Client IP address

PHP Client IP address

Many times we need the visitor’s ipaddress for validation, security, spam prevention, etc. Getting the Visitor’s ipaddress is very easy in PHP. The simplest way to get the visitor’s/client’s ipaddress is using the$_SERVER[‘REMOTE_ADDR’] or $_SERVER[‘REMOTE_HOST’] variables. 1...

Adafruit ATMega32u4 as Arduino

Adafruit ATMega32u4 as Arduino

You can use the Adafruit ATMega32u4 breakout board  as an Arduino Leonardo by flashing the bootloader in Arduino 1.0.1 to the board. To follow this process, you use another Arduino, like the Arduino Duemilanove, as a...

Simple shell script to backup MySQL databases

Simple shell script to backup MySQL databases

Simple shell script to backup MySQL databases.

Example output (with mysql password stored inside script):