code for MySql | MariaDB to trigger / signal external script from database

code for MySql | MariaDB to trigger / signal external script from database
One feature I often wish MySQL / MariaDB (I’ll refer from now to just MariaDB referring to both) had was the ability to trigger or launch an  external script or open a socket connection to some external site; on a database event. Perhaps using a stored procedure in other words generate a signal /event to ...

WordPress fixing unattached images – empty media library

WordPress fixing unattached images - empty media library
Having recently been the victim of WordPress site hack (vandalized) I was forced to move to a new hosting company, and move over all my content, but I didn’t want to copy my database verbatim, as I was worried that there may have been some SQL (Iframe like injected) into portions of my database.  So what ...

Using server-side PHP Datatables (grid) with SQLite / MySQL PDO 37

Using server-side PHP  Datatables (grid) with SQLite / MySQL  PDO
I have been a fan of using datatables for a while and always wanted to generalize the server side example to be able to use SQLite, MySQL or any other PDO supported database. For the longest time in my projects I have used PHP AdoDB as my Database abstraction layer, mostly because it came with ...