One hundred and two million unique strings
Using mixed character strings to identify objects makes more sense due to the greater amount you can assign and their complete unpredictability. Why strings? Using numerals 1 through to 234,567,890…
Tag: MYSQL
Using Chart JS with PHP and MySQL
Chart JS is a very comprehensive framework for creating and customizing many charts and graphs. The ease of use and ability to configure the charts makes Chart JS a good…
MySQL filtering SELECT results by date
It may be getting data from inbetween two dates or even a SELECT query for data from now to 1 week ago or older than 1 month, there is a…
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…
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…
The MySQL Inner join
A MySQL Join is when data is collected from two or more tables and “joined” on keys to return as one, saving you doing multiple queries. There are several types…
How to do a MySQL GROUP BY with ORDER BY on a COUNT()
MySQL Group by returns the data of the same value into a set rows. It is often use with COUNT, SUM or AVG etc. Doing this will return how often…
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…