How to remove excess whitespaces from a string?

I was looking for a small and quick way to remove excess whitespaces from a string. Sometimes you get SQL statement (or any other string) with whitespaces and need to clean it before your function starts to work with it.For example: $sql = "SELECT id, field1, field2 .... FROM table WHERE status = 1";And after trying some ways we found, that using preg_replace() function is

New version 6.0.8 of PHP DataGrid released

The new version 6.0.8 of PHP DataGrid is available now for downloading. There are many improvements and new features, like caching, drawing horizontal "barchart" fields, file extension icons etc. This version requires full re-installation, if you work with one of previous. Read carefully Getting Started.Here the main additions and improvements:* Feature: [added] possibility to show count of

ApPHP Shopping Cart - New Product Release

We are happy to announce that new product ApPHP Shopping Cart Advanced was released and available now for downloading from the site.A Short List of Features: * Virtual multiple product shopping cart * Multi-Language * Multi-Currency * Orders management and history * Integrated PayPal module * Admins/Customers management * News module * Gallery module * Contact Us module