HTML form input auto complete with PHP and MySQL
How to Autofill or auto-complete an HTML input form using JQuery with PHP and MySQL. This method uses LIKE in a MySQL query for the typed in characters and returns…
Tag: PHP
PHP converting hours, minutes & seconds string to seconds
Converting hours, minutes and seconds (H:i:s) string to just seconds with PHP can be done with an adaptable function that also works for just a minutes and seconds string. The…
MySQL rollback with PHP PDO
Roll back a MySQL transaction with the PDO rollBack() function. All that is needed is beginTransaction. Start a transaction and run a query that modifies a table: $db->beginTransaction(); $update =…
Random time from timestamp string with PHP
How to generate a random time from an H:i:s formatted timestamp with PHP. For this example 02:38:55 will be used which represents 2 hours, 38 minutes and 55 seconds. The…
Convert and format Bytes PHP function
A simple PHP function to convert and format Bytes to Megabytes, Gigabytes and Terabytes: function convertBytes(int $bytes, string $convert_to = ‘KB’, bool $format = true, int $decimals = 2): float…
Leaflet map latitude and longitude marker with PHP
How to make a simple Leaflet map box with a marker at your set latitude and longitude values. Leaflet is a free, open-source javascript library for working with interactive maps….
Using PHP __DIR__
PHP __DIR__ returns the current working directory, its usage is common when including files as you don’t have to dynamically define the directory each time. Simply running echo __DIR__; Will…
Bootstrap toggle button status update with AJAX PHP and MySQL
How to make a Bootstrap toggle button with a status update by using PHP, Ajax and MySQL. The toggle button represents on/off which is 1 and 0 in the database….
Removing duplicates from an array in PHP
Removing duplicate values from an array in PHP by using array_unique(), this will return a new array, based on the input without duplicate values. The second parameter is sort type,…
Check if a process is running on Linux with PHP
Check if a process is running on a Linux system such as Ubuntu by using PHP. This is done by using pgrep and checking if its response is empty. pgrep…