With this project we create an IoT Environmental control device that uses a MariaDB (MySQL) database as the datastore. This allows you to use database functionality to create log files and be able to corrrelate […]
In this project we parse an nmap XML output file and then add the values to a MySQL Database Table. We then create a basic report that pulls the values out of the database and […]
You can turn your Raspberry Pi with Raspberry PI OS into a full LAMP web server. We use MariaDB because MySQL is not provided in the main repository and it is a drop in replacement […]
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
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 […]
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 […]
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 […]
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 access records in a MySQL database and then print them out in HTML. phpSelect.php phpSelectTable.php
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 […]
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 […]