The information contained on this page is now archived. Please see our website and documentation for current information
Moving to PDO - Notice to server admins
We have recently taken the difficult decision of migrating the Xibo code base away from the PHP MySQL extension and over to PHP PDO. Despite this being a significant development effort the end user will not notice any changes.
This change will be rolled out over the next few releases with core functions/inserts/updates/deletes covered from 1.5 series, and all queries covered from 1.7 series.
The advantages to PDO are many – the key ones for us are:
- Potential to support different RDBMS (e.g. SQL Server, Oracle, MySQL, etc).
- Prepared SQL statements that protect against SQL injection.
- Support for Transactions.
As a server admin, all that needs to happen on upgrade will be to check that the PHP PDO extension is enabled on your web server installation. PDO ships with PHP 5.1 which is already an Xibo requirement.
For more information on PDO please refer to the PHP manual.
More
Read more from the blog

Device Repurposing: The Key to Sustainable Signage?
Learn why device repurposing is the key to maximising sustainability and how ChromeOS Flex can turn outdated devices into reliable digital signage players without compromising on performance or security.

How to Maximise Efficiency With Remote Device Management
In the third instalment of our ChromeOS Essentials series, you'll learn how all you need to know about RDM and how it can be used to simplify the deployment and management of your digital signage network.

Minimal Downtime: Why Reliability Is Key to Digital Signage Success
In the second part of ChromeOS Essentials, learn key strategies for minimising digital signage downtime, from choosing your operating system and CMS, to proactive planning and physical security.
More
Read more from the blog