I am super pleased to share that I have completed and uploaded my first (that I can share at least) personal portfolio piece written in PHP to a subdomain on my personal hosting server located at walk.openlamp.tech. Over the better part of the last year, I have developed a custom reporting dashboard written in PHP for my (current) employer, but do not share any of that work as it is proprietary and not owned by me. However, for a personal project, I can share far and wide. In this post, I provide a brief overview of my simple (in theory at least) application/site, built on the LAMP stack using the MVC (Model-View-Controller) design pattern in core PHP along with Bootstrap 4, jQuery, and MySQL.
[Keep reading for more SQL database and PHP/Python-centric content >>>]CRUD
SQL CRUD Basics Part 4 – Delete.
In this final part of the SQL CRUD Basics series, we visit the all-mighty and powerful DELETE
command. Does that word frighten you? It should, as DELETE
will completely remove rows of that oh-so-important data from your database table. Without warning or question, it will be gone. Perhaps your goal is to remove all rows. Great, no problem. However, removing a specific row or set of rows – instead of them all – requires filtering with a WHERE
clause predicate, just the same as you would in SELECT
and UPDATE
statements. Continue reading to see DELETE
command examples for better understanding…
SQL CRUD Basics Part 3 – Update.
Some data may never change. Yet, other data will change. In SQL, you modify existing rows of data with the UPDATE
command. UPDATE
is a powerful command as it can potentially change multiple rows of data in a single execution – for better or worse. UPDATE
is categorized as a DML command which means: Data Manipulation Language. Let’s learn how to use this integral command with examples…
SQL CRUD Basics Part 2 – Read
In SQL CRUD Basics Part 1 – Create, we learned how to create new rows of data in a database table with the INSERT
statement. In this post, we are going to visit the busiest statement in SQL – SELECT
. If you want to view or read the stored data in a table, you use SELECT
.
SQL CRUD Basics: Part 1 – Create
In Introduction to SQL CRUD Basics, I listed out the 4 elements of CRUD. Create is the first and the subject of this post. Create relates to the SQL INSERT
statement, which is used to introduce new rows of data into a database table. Continue reading to learn basic usage of this first CRUD element.