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…
Tag: How to
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…
Managing tags within a string with PHP
By tags I mean hashtags or “describers” often only just a single word but sometimes more. Handling them in PHP is different to most other variables as they’re often singular…
Simple AFL ladder with PHP
Here is how to use an open API to display the AFL Ladder with PHP. The concept is simple; Call the ladder API, start a table and then in a…
PHP password hashing and verifying
Password hashing is to prevent easy password exploiting by not storing password in plaintext. Instead you store a hash and verify this against the login attempt. Imagine if a database…
Mass renaming images in PHP
Lets say you have a group of photos from a location, shoot or event. They will be named depending on the camera something like DC001984 or IMG_02891 something like that…
MySQL WHERE = OR =
How to do a MySQL WHERE query whilst filtering for multiple values from the different columns. An example being the need to SELECT data where name = value OR last_name …
Getting image exif data with PHP
Exif stands for Exchangable Image Format, it is the data and information that gets attached to digital images. From location, aperture, IOS, camera, lens, date time, image size + format…
MySQL COUNT where COUNT greater than
Using MySQL COUNT with GROUP BY gives the total occurrence of each value in the database as determined with what is Grouped by. See here or here for more information….
Updating PHP version with XAMPP
Here is how to easily and successfully upgrade PHP version in XAMPP for windows. It can be done with any XAMPP PHP version of your choice. I upgraded to PHP…