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 […]
This class shows you how to create a picture gallery app that stores its data in a MySQL database. This allows you to do things such as adding Tags, Description, and even User Ownership so […]
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 […]
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: […]
Using the GLOB function in PHP you can put all of the file names on a folder, and then print them out with additional HTML to create a Dynamic Photo Stream. In this project the […]
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 […]
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
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
You can overlay text over images using CSS. To do this you essentially create a DIV as a canvas, add an image, and then code where the Text should start to be printed within the […]
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
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
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
You can assign CSS attributes to HTML features using ID’s like you would with Classes. idStyle.css id.html
Classes allow you to format text in different tags similarly. Classes can be reused numerous times on a page, and they can be combined together. class.html classStyle.css
CSS can be added to an HTML document 3 different ways. You can use an External Style Sheet, dd CSS to the Head of the HTML document, and within the HTML tags themselves. inlineCSS.html onPageCSS.html […]
The basic syntax of CSS is to Assign Values to Properties for Selectors. In CSS “selectors” are synonymous with tags. So the h1 Selector refers to the h1 HTML Tag. CSSsyntax.html
CSS, or Cascading Style Sheets, are the way you can format your HTML to look pretty. CSS and HTML used to be considered separate technologies, but with HTML5 they are now combined as one skill […]
The QNAP QGD-1600P combines a 16port PoE Switch, with a NAS, and Linux Desktop. Beyond this you can run Virtual Servers within the NAS.
HTML forms give you the ability to ask for information from your viewers and then be able to do something with the values. HTML forms are a single component of what is required to build […]
The Title Tag allows you to name your HTML document, and is very important for SEO purposes. title.html
The Picture Tag allows you to change the size of an image displayed in an HTML document based on the width of the browser window. picture.html picture700.jpg picture400.jpg picture200.jpg
iFrames allow you to embed other web pages into your HTML document. This can be to show off other people’s websites, or simply as a way to reuse code such as for menu bars, or […]
Tables in HTML allow you to display data in your HTML page in a spreadsheet format. table.html
Lists are created in HTML by using a tag for the whole list, and then each item in the list is enclosed in tags. You can create a Tiered List by placing lists within a […]
Hyperlinks allow users to be able to click on a link to move to a different web page. Anything within the A HREF tag will be turned into a link. target=”_blank” – has the link […]
The DeckLink Quad acted quirky on a Mac Pro with Wirecast. I ended up sending it back and switching to a Magewell Quad PCIe card.
Images are added to HTML documents by pointing to them using the IMG SRC tag. You can point to images within the same directory as the HTML document, or even from an entirely different website. […]
You use Tags in HTML for basic font formatting in HTML. More sophisticated formatting can be done with CSS. <h1></h1> Heading Tag (Headings go from h1 to h6) <p></p> Standard Paragraph tag <strong></strong> for Bold […]
HTML is a simple language that uses TAGs to tell browsers how text should be formatted. Capitalization does not matter in HTML White space does not matter in HTML Doctype Declaration used to be more […]
HTML allows for formatting a multimedia document that can be read by different vendors browsers. Before HTML documents were locked into the format of the word-processor they were created in. Different browsers display HTML differently. […]
IDE’s are software packages that allow you to develop coding projects more quickly. They have everything from an equivalent of spell check, to simulators, to collaboration tools. IDE Considerations What Languages do they support What […]
Service Oriented Architecture means that many times your servers and software will be communicating with cloud based API’s instead of other physical servers. API’s give you services that a server would be too expensive to […]
SDK’s or Software Development Kits are prepackaged digital assets that make it easier for developers to create apps for new computing devices such as Rokus, iOS devices and Occulus VR.
Frameworks are prepackaged libraries of code and routines that you can use to more quickly and easily write your projects. Most coding languages have a number of different Frameworks available, and each Framework is designed […]
Pseudocode is the process of writing out you plan for your code in a human readable fashion. You can use this for your own projects however you see fit, but on projects with larger teams […]
Wireframing is simply sketching out the design for your application before you start building it. You can use a pen and paper, Google Docs, or specialized Wireframing Software. By using Wireframing you can make edits […]
There are more employers than FANG – Facebook, Apple, Netflix, Google 2.8% Unemployment Rate of Coders in Baltimore area Prepare to have conversations rather than “interviews”. Conversations seek to find if you are a good […]
People want to know the “best” programming language, but every language has a purpose and it’s own place. To find YOUR best programming language determine what your own problems in technology are, and talk to […]
Everyone should self study to see if you like it. DO NOT sign up for a bootcamp before you have done some coding!!! You are not married to a language. You can learn one, and […]
What is Programming? Programming and Coding generally mean the same thing Programming is simply telling computers to perform actions Programs can range from a calculator app to a full fledged operating system Why is Programming […]
You can validate that variable values look how they are supposed to by using filter_var in PHP. Filter_var determines if an email address, IP address, Int, Float, etc are formatted how they are supposed to […]
Sanitizing Variables prevents users from being able to submit data to a database such as HTML formatting or JavaScript code. filter_var works based off of specific filters that you designate that can be found at: […]
Prepared statements help prevent SQL Injection attacks. Essentially they send a template for your SQL Statement, and then inserts the variables separately. This prevents hackers from escaping out of the original SQL statement and being […]
Using the GET method you can pull variable values from HTML hyperlinks and process them in a PHP script to Insert records into a MySQL Table. vote.html phpLink.php votes Table
You can use PHP to Dynamically create an HTML form from a MySQL record and then be able to edit the record. Warning: Your Web Browser may cache form values. Opening a new tab may […]
You can create an HTML form that allows you to search records in your MySQL Tables and print the results in a web browser. In these project we use LIKE and wildcards for the query […]
You can easily create an HTML form with PHP to insert records within your MySQL database. Warning – It’s important to create a troubleshooting routine, and verify you have written your code properly. form.html phpTEST.php […]
Using PHP you can update records in your MySQL tables. phpUpdate.php
You can use PHP to INSERT data into MySQL Tables. This data can come from HTML forms, or things such as scripts that parse text documents. phpInsert.php
You can use PHP to access records in a MySQL database and then print them out in HTML. phpSelect.php phpSelectTable.php
You can use the built in MySQLi Extension with PHP to connect your PHP scripts to a MySQL Database. Environment – LAMP stack on Ubuntu 18.04 Desktop using tasksel gEdit – Preferences -> Display Line […]
Backing up tables and databases is very useful when you are learning to update records so that you can recover quickly when you do something wrong. create table if not exists newTable like oldTable; – […]
Stored functions allow you to manipulate data stored in tables. Unless specifically coded the data created is “impermanent” which means it only exist while using the function. If you need the results to be used […]
Stored Procedures allow you to write and call full SQL Statements just like scripts in an operating system. Create Procedure: delimiter $$ or delimiter ; – sets delimiter call procedureName; – calls procedure show procedure […]
Joining Tables allows you to interact with two tables as if they are one. This means you can simply reference a record from one table in another such as having a PART record reference a […]
MySQL has its own user accounts and security policies. Remember that most times “hackers” are only able to compromise a database using the privileges assigned to the compromised account. CREATE USER ‘user’@’localhost’ IDENTIFIED BY ‘password’; […]
Updating and Deleting records in a table is very easy. Remember that MySQL does not ask for verification of a command, and so a poorly written statement can be devastating to a database. update users […]
Insert into table(column1, column2) values(‘value1’,’value2’); – Inserts records into Table. TEXT type values need single quotation marks ‘ ‘. Select * from table; – Selects ALL records from table and displays ALL columns Select * […]
Tables are the building blocks of Databases. They store the records for the Database are are easy to create, alter and delete. Use database; – Enter Database Select database(); – Shows what Database you are currently […]
Creating and Deleting databases on a MySQL server is very easy. Sometimes it can be too easy. show databases; – Shows databases create database databasename; – Creates a database drop database databsename; – Deletes a […]
This class will show you how to build a lab for the further MySQL classes. You will use the tasksel app to install the LAMP Stack (Linux, Apache MySQL, PHP) on Ubuntu Desktop 18.04. Note: […]
In MySQL, and other databases, you can set what type of data a value in a table can be. Whether it’s text, a number, or even a file. This is used to prevent bad data […]
The structure of a MySQL Backend can be designed however the administrator thinks is logical. There are few hard rules for how the structure has to be designed. Front End/ Back End With modern applications […]
MySQL is a useful and widely used open source database Basics A Database Software stores data so that it is easily accessible Relational Databases store Like Data in Tables and those Tables are then How […]
Databases contain the records that are required for most advanced applications to run. Databases themselves only store data, and you need to create a front end and intelligence for users to be able to interact […]
Serverless Architecture allows you to abstract out Compute from your infrastructure and call compute service from Cloud Functions. This means you get the results of a server like encoding video, or computer vision without needing […]
SOA, Service Oriented Architecture, is the concept of designing infrastructure based on the services that are needed instead of focusing on the servers themselves. Designing with SOA in mind makes it easier to not only […]
Client/ Server Architecture is an Infrastructure style where Client Computers receive Services from Servers. Servers are composed of the Physical Machine, the Server Operating System, Services Software and Configurations. Clients are composed of the Physical […]
In the old days the Operating System was deeply connected to the hardware it ran on and moving the OS to a new machine could be next to impossible. With Virtualization an Operating System becomes […]
Colocation Datacenters allow you to rent space for your servers to run. You can rent from 1U of space to a dozen 42U racks for your equipment. Colocation facilities allow you to run your equipment […]
MaaS, or Metal As A Service, is the ability to rent bare metal servers from cloud providers. You can have root access to the operating system and run the server anyway you see fit. This […]
IaaS, Infrastructure as a Service, refers to cloud based services that are not full end user functional products of themselves. Google Drive is an SaaS, AWS Glacier is IaaS. IaaS offers core components of your […]
PaaS or Platform as a Service is essentially “web hosting” for your code. Even run a “serverless” enviornment you still need somewhere to run your code from. PaaS gives you a place to run code, […]
Interacting with SaaS Direct Interaction – By going to the SaaS website or using their native app you can use their service Client Applications – Third party Native applications that can communicate with the SaaS […]
Designing Cloud Infrastructure is fundamentally different that standard Client/ Server infrastructure. You think of Services as separate from the Servers, and design hardware so that entire Servers can be destroyed without effecting the Services offered. […]
Reasons for Load Balancing Fault Tolerance – Load Balancing offers fault tolerance incase a server fails. Server Upgrades – It’s easier to upgrade hardware if you can take entire machines offline without effecting user experience. […]
Clustering ties multiple servers into a single logical server for users to access. Think of it like RAID, but for the whole server. Uses for Clustering Failover – If a physical server fails services will […]
Abstraction is the concept of dividing specific functions of a server into their own individual systems. Much like subcontracting janitorial, or security services out for a building owner. Virtualization Compute – Provided by hardware with […]
Cloud Computing in one form or another is the major architecture for enterprise class infrastructure. Cloud Computing should be looked as a world view more than as a specific technology or product. What is the […]
Configuring Networking at the command line in Linux can be confusing. It’s important to know that you use many different application to manage networking and these applications may be different based on your distribution or […]
UFW is a simple firewall application that is included with Ubuntu nd can be installed on other distributions of Linux. Note: For the demonstrations to work you may need to change settings or hardware configurations […]
FTP allows you to upload, download files and perform basic file and directory tasks. FTP is a technology not a single product so there are numerous pieces of server and client software that can be […]
SSH allows you to remotely administer Linux Servers SSH is a Client/ Server System. SSH requires Port 22 to be accessible Change Network setting in VirtualBox to “Bridged Adapter” Install OpenSSH Server on your Linux […]
Cron Jobs are automated tasks that you can create in Linux to do such things as delete cache files or run antivirus scans. You simply set when you want the task to run and then […]
Tarballs are Compressed Archive Files of Folders that are useful when moving folders and making sure all contents stay intact. In the name tarball “tar” stands for the archiving, and “ball” stands for the compression. […]
The commands chown and chmod allow you to change permissions and ownership of files and folders, but you also need to know the membership of groups to make sure permissions and ownership is appropriate. View […]
Linux Permissions are much more simple than what is provided in Windows Active Directory. You have 3 permission types that you can apply to 3 groups. The permissions are Read, Write and Execute which can […]
Top is the built in Task Manager for the Linux CLI. It can be a powerful and complex tool, but most people only need it for simple tasks. top – starts top sudo top – […]
There are 3 ways to manage services on Ubuntu Linux. Systemd is considered the “right” way as of now, but using the service command and init.d scripts still work. When. you make changes to configuration […]
Managing folders is much like managing files in Linux. Just remember to use the -r option (recursive) for copying and deleting. Make Directory mkdir newfolder – Creates a folder called folder Rename Directory mv newfolder […]
Renaming, moving, copying, and deleting files in Linux command line is easy. Renaming files uses the same command as move. As an administrator if you do not own the files you are interacting with you […]