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 ...

PHP 7 is here! 1

PHP 7 is here!
It looks like the latest edition of PHP has been released, PHP 7 , and it  brings a lot of new enhancements. Its biggest new capabilities are vast speed improvements, rumor has it that its on par with Facebook’s proprietary HHVM project (PHP JIT compiler). There’s a nice write up here over at Kinsta.com of PHP ...

genetic algorithms in PHP code example of (evolutionary programming ) 13

genetic algorithms  in PHP code example of (evolutionary programming )
This posting and php code sample is about fascinating topic of  Genetic Algorithms (GA) which simulate evolution using computer code to help find  near-optimal solutions when dealing with problems that  involve multiple disparate requirements. I recently began playing with Genetic algorithms (Genetic algorithms  GA, for short) which  are  part of a class of evolutionary algorithms (EA) that make up ...

Bootstrap Bootgrid with PHP json server side script 37

Bootstrap Bootgrid with PHP json server side script
I recently came across Jquery Bootgrid, which is Twitter Bootstrap (aka bootstrap)  friendly table grid, that is very similar in function to Datatables.While not as feature rich as datatables (yet), it provides a very tiny 4Kb (minified and gzipped) footprint and allows you to leverage all the typography and layout control elements that are present in bootstrap. ...

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 ...

PHP backup monitoring and alert script: prevent backup rot… 3

PHP backup monitoring and alert script: prevent backup rot...
One of the key components with any IT software system is putting together an automated , reliable backup solution. Gone are the days of manually backing up files to a removable media, with our interconnected world we can simply setup some form of cloud back up and go. In a previous post I discussed how ...

Websockets : Using HTML5 client and PHP server for real-time server push 28

Websockets : Using HTML5 client and PHP server for real-time server push
Step-by-step to build a simple HTML5 using a PHP server for true server-push websocket communications I’m going to demo how you can create a simple and easy echo server, and communicate bidirectionally with various web clients.  The ability for the server to send (or “push“) communications to the client (browser) at any moment provides a ...