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…
Tag: How to
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…
Storing and reading a JSON file in MySQL with PHP
Storing values from a json output into a database is a common occurence, but storing the whole json call into a column not so much. Traditionally it is more efficient…
FFmpeg choosing stream to download
With most online streams, decent ones at least you can choose the quality. The stream quality is mostly bit rate and resolution based. Lowering the resolution means you can lower…
Creating a dynamic captcha image with PHP
Sick of my contact form being used as an express way for spammers i set about to make a solution to end the spam to which i was surprised still…