No Picture
Notes

SQLite Notes

Open Specific Database with SQLite: Note: If you don’t designate a database a temporary one will be created which will ceae to exist when you exit. Exit Console: Open database from SQLite Console: .open database_name.db […]

*NEW

Arduino – Send Commands with Serial Communication

With the Arduino IDE Serial Monitor you can send commands to your Arduino. 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 – https://amzn.to/2Xih5ei LED […]

*NEW

Arduino Displays – Multicolor LED (RGB LED)

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 […]

*NEW

MySQL – Find Minimum and Maximum Values in Column

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

*NEW

PHP – Test Transformation (strtolower, strtoupper, ucfirst, ucwords

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() […]

*NEW

HTML Intro- Auto Refresh Webpages

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

*NEW

PHP – Parse Filenames and Paths with pathinfo()

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