These are the notes for importing data from XML document into MySQL, and then to print a simple report. parse.php nmapReport.php MySQL Setup nmapTest.xml
This project shows you how to parse (read) the nmap XML output file and turn ip addresses, mac addresses, hostnames, vendors and ports into PHP variable values and then print them out. Prerequisite Classes: Linux […]
The standard Ubuntu Desktop works well on a Raspberry Pi 4 with 4GB of RAM. To get the Desktop Environment simply install the Ubuntu Server and then install the Ubuntu-Desktop on to it. Prerequisite Classes: […]
You can install Ubuntu very easily on the Raspberry Pi. Ubuntu Server and IoT Core versions come preloaded with the Raspberry Pi Imager Software. Note: Ubuntu Server will automatically start an auto update process when […]
SAMBA allows you to use SMB/CIFS to do traditional/ windows type file management over the network. You can access files and folders just like you would on a windows network without needing to install additional […]
The GPIOzero Python Package allows you to control and read from the GPIO Pins on your Raspberry Pi. GPIOzero is included in the Raspberry Pi Operating System, and can be installed on other distros. GPIOzero […]
With Thonny you can easily begin to code Python Scripts on Raspberry Pi OS. Thonny is a very simple Python IDE that is easy to learn.
Installing an Operating System on a Raspbery Pi is easy, but very different than installing an OS on a standard PC. You download the Imager software from Raspberry Pi, and then you image your Micro […]
You can find your Network Settings and assign the values to variables.
This project allows you to create a Motion Detection Spycam with a PIR Sensor, and ArduCam, and a Data Logging Shield with Real Time Clock. This project takes a pictures when motion is detected, saving […]
Time and Place…...
3 Color RGB LED’s allow you to use a single LED to show multiple colors. Functional Parts in the Project: Arduino Uno – https://store.arduino.cc/usa/arduino-uno-rev3 560 Piece Jumper Wire Kit – https://amzn.to/2MsCLjL 220 Ohm Resistors – https://amzn.to/2RiiMD9 Breadboard Kit […]
This project shows the Date, Time, Temperature, Humidity and Alerts you when the temperature breaks a threshold and gives you a timestamp of highest temperature reached. Prerequisite Classes: Arduino – I2C 20 x 4 LCD […]
The DHT11, 21 and 22 Sensors can be used to determine both temperature and humdity. Note: Make sure to comment/ uncomment the right sensor in setup Links: Adafruit DHT Library – https://github.com/adafruit/DHT-sensor-library Functional Parts in […]
Looking stupid is a great motivator to get better…...
This is an easy to use library to add RTC to an Arduino. http://www.rinkydinkelectronics.com/library.php?id=73
This project shows you how to log Variable Values to an SD Card using a Data Logging Module. Prerequisite Classes: Analog Temperature Sensor with Arduino Functional Parts in the Project: Arduino Uno – https://store.arduino.cc/usa/arduino-uno-rev3 Breadboard Kit […]
Let your peers copy your notes…...
When does the “victim” become the aggressor…???...
This project allows me to send commands directly from one Arduino Wifi to another. The SENSOR Arduino has an analog temp sensor and sends commands to the RECEIVER. The RECEIVER Parses the commands ?red or […]
The IoT Relay from Digital Loggers Inc allows to easily and safely control standard american powered appliances such as fans, dehumidifiers, pumps and such. It is important to realize how the 4 power ports work. […]
Do you hear yourself…???...
You can send commands to your Arduino Uno with WiFi thorough connection URL’s with wget on Linux. This is a simple way to add Arduino Commands to your scripts and web apps. wget https://www.gnu.org/software/wget/ http://manpages.ubuntu.com/manpages/bionic/man1/wget.1.html […]
This project uses a server with PHP to send commands to the Arduino Vehicle. The commands are sent use shell_exec and triggering wget on the command line. wget needs to be installed on your server. […]
I’m working on building a remote control car using the Arduino Uno with WiFi and the FeeTech Vehicle platform.
You can find the Minimum and Maximum values in a column using SQL. min() https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html https://www.w3schools.com/sql/func_mysql_min.asp max() https://www.w3schools.com/sql/func_mysql_max.asp https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html
You can pull the average of the numeric values in a column with SQL in MySQL. avg() https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html https://www.w3schools.com/sql/func_mysql_avg.asp
In MySQL you can list the unique values from a column in a Table. DISTINCT https://dev.mysql.com/doc/refman/8.0/en/distinct-optimization.html https://www.w3schools.com/sql/sql_distinct.asp
The time() and date() functions allow you to add time data to your applications. Time() provides the seconds since Unix Epoch (January 1, 1970) which is useful for basic timing in your application. The date() […]
UX is worth a few dollars…...
Text transformation in PHP is useful not just for esthetics, but to also make sure that data is uniform when dealing with databases and such. strtolower() https://www.php.net/manual/en/function.strtolower.php https://www.w3schools.com/php/func_string_strtolower.asp strtoupper() https://www.php.net/manual/en/function.strtoupper.php https://www.w3schools.com/php/func_string_strtoupper.asp ucfirst() https://www.php.net/manual/en/function.ucfirst.php https://www.w3schools.com/php/func_string_ucfirst.asp ucwords() […]
You can use the tool belenaEtcher to create a bootable installation flash drive for Ubuntu. https://www.balena.io/etcher/
The explode() function allows you to turn a String into an Array based on a separator you define. explode() https://www.php.net/manual/en/function.explode.php https://www.w3schools.com/php/func_string_explode.asp explode.php
The var_dump() function allows you to see what a variable’s data type is, and what it’s value is. var_dump() https://www.php.net/manual/en/function.var-dump.php https://www.w3schools.com/php/func_var_var_dump.asp varDump.php
You can have your HTML document auto refresh itself so that d=ynamic information is continuously updated. <meta http-equiv=”refresh” content=”5″> https://www.w3schools.com/tags/att_meta_http_equiv.asp autoUpdate.php
The strpos() function allows you to parse strings in PHP. strpos() https://www.php.net/manual/en/function.strpos.php https://www.w3schools.com/php/func_string_strpos.asp strpos.php
A pond and an ocean look the same when you’re an inch off the ground…...
In this example we use exec() to ping domain names and IP addresses and then parses the results so that you can test the results using an If/Else statement. exec() https://www.php.net/manual/en/function.exec.php unset() https://www.php.net/manual/en/function.unset.php https://www.w3schools.com/php/func_var_unset.asp strpos() […]
This is a simple Up/Down network monitor to show what your server is able to see on the network and internet. shell_exec() https://www.php.net/manual/en/function.shell-exec.php shellExecPingArray.php
The shell_exec() function allows you to send commands to the Command Line using PHP. You can use this for everything from pinging websites, to calling installed apps such as FFMPEG. shell_exec() also returns the results […]
The pathinfo() function allows you to turn a filepath into an Array and then interact with the keys of the Array. You can grab the Filename, Extension, Folder Name and Basename. pathinfo() https://www.php.net/manual/en/function.pathinfo.php https://www.w3schools.com/php/func_filesystem_pathinfo.asp pathinfo.php
A picture can say a thousand (misconstrued) words…...
No one can punch a virus… it’s foolish, and cruel to pretend that survivors “fought” harder to live…...
The glob() function in PHP allows you to search folders and put the results into an array based on basic filtering. glob() https://www.php.net/manual/en/function.glob.php https://www.w3schools.com/php/func_filesystem_glob.asp glob.php glob.php (with Image Embed)
You can send Variable Names and Values using hyperlinks to PHP Scripts. This is an easy way to send variable data, but is incredibly insecure. To send a variable to a PHP script add ?variable_name=variable_value […]
How do you cook a Gold Play Button…?...
The first rule of being a drug dealer is make sure your customers can buy your products once they become addicted…...
In this project we build the ability to search for images based on Tags stored in MySQL. Previous Classes in Series: PHP Project (Simple) – Dynamic Photo Gallery Stream PHP Project (Simple) – Dynamic Photo […]
With this project you will be able to edit the MySQL records that relate to your pictures in your gallery. You use the pic_id identifier to select and update specific MySQL records. Previous Classes in […]
Are you supporting companies that explicitly dislike you..?...
Previous Classes in Series: PHP Project (Simple) – Dynamic Photo Gallery Stream PHP Project (Simple) – Dynamic Photo Gallery Prerequisites: Basic LAMP, or Web Server Administration Verify pictures and folder have READ/WRITE permission for OTHER […]
“Pandemic” is not an excuse to be lazy…...
This project shows you how to create a Picture Gallery App that is dynamically based off of the pictures in a folder. Previous Classes in Series: PHP Project (Simple) – Dynamic Photo Gallery Stream Prerequisites: […]
Did you know the average comic book fan if over 35…?...
FFMPEG allows you to easily convert and resize your video files. FFMPEG: https://www.ffmpeg.org Install FFMPEG Convert Video to Another Format Change Video Size – Manually Input Width and Height Change Video Size – Keep Aspect […]
Jpegoptim allows you to compress/optimize image files from the command line in linux. WARNING: by default Jpegoptim modifies the source file JpegOptim: https://www.mankier.com/1/jpegoptim Install Jpegoptim on Ubuntu Resize Image (overwrites source) Saves Converted Image into […]
Sometimes inertia only stops when its kneecapped…...
By setting the Position Attribute to “Sticky” it will allow the element to stay at the same location as you scroll through an HTML page. stickyStyle.css sticky.html
You can create animations with CSS for everything from alerts to fun widgets on your HTML pages. animationStyle.css animation.html
You can format hyperlinks based on whether you’re hovering over them, actively clicking on them, or have visited them. This can be useful when creating dashboards and control panels. linkStyle.css link.html
We all knew “it” was coming… we just couldn’t define “it”…...
You can do some interesting things with color on your HTML pages with color options with CSS. Color Picker: https://www.w3schools.com/colors/colors_picker.asp Color Names: https://www.w3schools.com/colors/colors_names.asp color.html colorStyle.css
With CSS you can create shapes to add visual elements to your HTML documents. Shape Examples: https://www.w3schools.com/howto/howto_css_shapes.asp shapeStyle.css shape.html
Changing the opacity of text or pictures can make them easier to view by users. You can also use :hover to show when an object is being hovered over. opacityStyle.css opacity.html
Until you open your door the rest of the world is both perfectly fine, and falling apart…...
CSS can be used to create basic animations for Web Based Dashboards to attract user attention. alertStyle.css alert.html
You can dynamically modify both text and image formatting when a user hovers over elements in an HTML document. hoverStyle.css hover.html picture700jpg
CSS allows you to do a lot of interesting formatting with images on HTML documents. This class shows 3 simple examples of how to embed images using CSS. imageStyle.css image.html picture700.jpg
Creating a self fulfilling prophecy…...
You can use Tag Elements with CSS Classes to create text with similar styling. classTagStyle.css classTag.html
nth-of-type allows you to automatically format HTML texts based off of simple rules. nthStyle.css nth.html
You can format Tables using CSS to not just add borders, but also interactive features. tableStyle.css table.html
Clouds make silver miners wealthy…...
You can use DIV tags and Borders to group text together in your web page and do things such as create coupons. borderStyle.css divBorder.html