Simple PHP MySQL page system
A simple PHP MySQL page system written as a function with code comments. For this example i had the following in the database Simple color names and an id, With…
Tag: PHP
PHP backend web language
Storing HTML in a MySQL database
How to store HTML in a MySQL database, this is done for purposes such as a blog or CMS where dynamic pages are generated from a database. The correct MYSQL…
Printing array keys and values with PHP
Being able to quickly or efficiently get the keys from an array which is most likely an API call is great. You can see what data exists which may not…
PHP MySQL loop with Bootstrap 4 columns
Here is how to implement the Bootstrap grid system into a PHP MySQL foreach loop. The code is set to be 4 columns on large screens, 2 on small screens…
Easy alert system with PHP
How to deal with errors, warnings, alerts or notices with PHP. You cannot hard code them into a page because at times they wont be needed yet when they are…
PHP base64_decode an exploiters main weapon
PHP’s base64_encode() and base64_decode() are functions that encode the inputted data with base64 and then decode it back to its original state before being encoded. A classic example is a…
PHP MySQL PDO select foreach loop
Doing a loop through on a MySQL query is super useful and common. It allows you to make tables, rows and output data in a controlled manner without doing many…
PHP format and style MySQL DateTime
MySQL DateTime format is Y-m-d H:i:s known as Year-month-day hour:minute:second. It is the bare bones datetime format for both MySQL and PHP…. it contains all you need to know and…
PHP Making an easy way for MySQL inserts
A MySQL insert in PHP can be easily done however they can be long and tedious. Frustrating to essentially make a table and then repeat it again with an insert…
PHP check if file or directory exists
To check if a file exists you use the PHP function file_exists. Input the path to the file and it will return TRUE if the file exists otherwise FALSE. if…