PHP PDO MySQL cheat sheet
PHP PDO is a MySQL handler which uses object orientation. As PDO executes queries with prepared statements it is (with correct usage) safer than MySQLi. Below is the PHP PDO…
Tag: PHP
PHP backend web language
A method to check host name network status with PHP
This is a method to check if a host name is accessible i.e it is online, by using PHP. With fsocketopen() a connection will be created, if it fails false…
PHP PDO check if row exists or found
Counting or checking if your PDO MySQL query found a row relies on one key object called rowCount. rowCount returns the number of rows affected by the last executed query….
Creating PHP cron jobs on Ubuntu
Running cron jobs on your Ubuntu server to call PHP scripts in a timely manner. The first step would be creating a PHP file that when called will leave proof…
Compress image if certain size in PHP
If you are downloading and archiving images majority of the time you can compress them heavily to be able to store more. For reasons such as: never viewing the image…
PHP OOP Setters and Getters
Setters and Getters in PHP are object methods used in OOP programming. The basis being you set a property to your value and then you can get it. Using setters…
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…
PHP jpg compression Imagick vs Vanilla
Compressing a jpg file in PHP can be done without installing a third-party library, we call this method Vanilla as it is done stock standard, no extras needed. Imagick is…
Check if user or channel is live with Twitch API using PHP
Checking if a channel is live and streaming on Twitch requires a client id, you can get your client id from here. The endpoint for getting a streams information is…
Installing PHP 7.4 Beta4 on Ubuntu 18.04
Installing the new PHP 7.4 Beta 4 on an Ubuntu 18.04 server, 7.4 Beta4 was released on the 22nd of August 2019. Start by updating package lists and information sudo…