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

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

Sep

7

2017

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 ...
read more →

Blog · Programming · Software

· · ·

WordPress fixing unattached images – empty media library

WordPress fixing unattached images - empty media library

Dec

3

2014

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 ...
read more →

Blog · Programming

· ·

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


Warning: Undefined variable $file_path in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 124

Deprecated: pathinfo(): Passing null to parameter #1 ($path) of type string is deprecated in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 124

Warning: Undefined array key "extension" in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 125

Warning: Undefined array key "dirname" in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 126

Warning: Undefined variable $image_src in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 131

Warning: Trying to access array offset on null in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 131

Warning: Undefined variable $image_src in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 131

Warning: Trying to access array offset on null in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 131

Warning: Undefined variable $image_src in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 196

Warning: Trying to access array offset on null in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 196

Warning: Undefined variable $image_src in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 197

Warning: Trying to access array offset on null in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 197

Warning: Undefined variable $image_src in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 198

Warning: Trying to access array offset on null in /www/wwwroot/abrandao.com/wp-content/themes/montezuma2026/includes/thumb.php on line 198
Using server-side PHP Datatables (grid) with SQLite / MySQL PDO

Mar

15

2014

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 ...
read more →

Blog · Programming · Software

· ·