Getting MySQL table column names, types and more as JSON
How to get information in JSON format about a MySQL table. INFORMATION_SCHEMA has information about the metadata of the database structure such as column types, defaults, lenghts and keys. To…
Tag: PHP
PHP backend web language
PHP versions benchmark chart
PHP versions benchmark chart done on a cPanel shared hosting environment with Litespeed. The benchmarks were run 3 times for each version and are the average time in seconds taken…
PHP version select with Directadmin
Choosing and enabling multiple PHP versions with the selector in the Directadmin panel. Directadmin allows up to 4 active PHP versions to be used and chosen from. The first listed…
Cutting video into segments with timestamp as filename FFmpeg & PHP
Cutting a video into even segments and using the start and end time of the segment as its filename with FFmpeg and PHP. For this you will need the length…
Using the NBA schedule API with PHP
How to access and filter through the NBA schedule API for season 2021-22 using PHP. This is not the only way and endpoint to get the NBA schedule however since…
PHP datetime to time ago string
A PHP function to convert a DateTime to a years, months, weeks, days, hours, minutes and seconds ago string. An option can be passed through to have a short string…
Create a video trim command from a slider concept
A concept to create a video trim FFmpeg command by using a slider to view the video at a start and end timeframe. The easy slider integration is with the…
Create video thumbnail from a slider concept
A concept to manually create a thumbnail from a video by using a slider to view the video at a certain timestamp. The easy slider integration is from the noUiSlider…
Getting old Reddit submissions with Pushshift API
Pushshift is a third party Reddit API useful to find comments and submissions (posts) from the past or that are otherwise archived. Searching submissions Searching submissions uses this endpoint: https://api.pushshift.io/reddit/search/submission/…
A Wget output formatter and parser made with PHP
A Wget output parser that turns a Wget file download into a viewable JSON output. This provides a different observation and makes documenting network speeds possible. The doWget() function attempts…