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

Linux backup and rotate script 6

Linux backup and rotate script
A common task to do with backups is to rotate them , so that you have multiple copies of critical files going back x days. Below is a bash script (Linux command line) that does this. Why Rotate Backups? Why not just one current backup file… The primary reason to have a rotating backup system, ...

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

Shell script code: show oldest | newest file in folder and file age

Shell script code: show oldest | newest file in folder and file age
Determining Oldest file and file age Today I had to write a short shell script to help figure out the oldest file in a particular folder, how old that file was (in secs or minutes). This is a pretty common requirement when dealing with file(s) folders  such as working directories, where you periodically need to ...

Websockets : PHP code complete tutorial client & server 39

Websockets : PHP code complete tutorial client & server
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 ...

HTTP long poll example in php ajax 4

UPDATED: A better and easier way to do this is via Server Sent Events, Check out my recent post. Simple and easy PHP example of how to integrate long-polling (“hanging GET”) to simulate server PUSH and add more dynamic content to your web pages. As a standard HTTP is terrific protocol likely the most popular ...

Palindrome algorithms: What’s fastest reverse vs. compare. 1

Palindrome algorithms: What's fastest reverse vs. compare.
Today during a meeting a simple coding question came up as to how to write a palindrome function.  A palindrome is a word, phrase, number, or other sequence of symbols or elements, whose meaning may be interpreted the same way in either forward or reverse direction.[1]  Examples: mom , level, radar, tenet … There are quite a few programmatic solutions ...

Code Sample: PHP Javascript Currency converter + exchange rates caching RSS feed 23

Code Sample: PHP Javascript Currency converter + exchange rates caching RSS feed
Problem: For a recent project I needed to get the latest exchange rates to allow the sales folks to quickly calculate costs  while doing estimates in different currencies. There are many sites online where you can do this, but we wanted to create an in-app widget that could be re-used on various internal  pages. The ...

Code Sample: PHP Backup MySQL and files to Dropbox 16

Code Sample: PHP Backup MySQL and files to Dropbox
Most web hosts have the ability via their control panel to offer an entire site backup , and this is the minimal functionality you  should consider. Generally there’s a site backup link within the control panel that create a tar ball (.zip file)  of the entire site and its contents. then you can email,or simply download ...