MySQL Connector/ODBC C# test script

Whenever you need to test your ASP.NET connection to your MySQL database, using ODBC, you can use the following C# test script. Currently it uses MySQL ODBC 8.0 Unicode Driver, but you can easily change the version used. As a bonus it prints some connection information and it requires an SSL connection to your MySQL…

Continue reading MySQL Connector/ODBC C# test script

Fatal error: Uncaught Error: [] operator not supported for strings – PHP 7.1

With PHP 7.1, some PHP web applications fail because of deprecated code usage. This may result in an error message like [] operator not supported for strings for various Joomla, WordPress and Drupal components. Here’s how to fix this code for PHP 7.1+. Jan ReilinkMy name is Jan. I am not a hacker, coder, developer or…

Continue reading Fatal error: Uncaught Error: [] operator not supported for strings – PHP 7.1

Convert PHP ext/mysql to MySQLi

This post will show you how to convert PHP mysql extension functions to PHP MySQLi extension. Migrating away from ext/mysql to MySQLi (or PHP Data Object (PDO)) is important, because the ext/mysql functions are deprecated as of PHP 5.5.0. If you do not update your PHP code, your website will fail soon! Jan ReilinkMy name…

Continue reading Convert PHP ext/mysql to MySQLi

How to set a good PHP realpath_cache_size

The PHP directive realpath_cache_size sets the size of the realpath cache to be used by PHP. Increasing realpath_cache_size might greatly improve PHP performance, as PHP states: “this value should be increased on systems where PHP opens many files.” Setting a correct value for PHP realpath_cache_size can greatly improve PHP performance and optimize WordPress – and…

Continue reading How to set a good PHP realpath_cache_size

Magento maintenance script for IIS

Important Magento maintenance, now for IIS too: optimize the speed and performance of your Magento ecommerce webshop by carrying out important maintenance. Remove old MySQL database log files and Magento cache data on a regular basis. Jan ReilinkMy name is Jan. I am not a hacker, coder, developer or guru. I am merely a systems…

Continue reading Magento maintenance script for IIS

Joomla ACL decision flow-chart

8 Tips to improve Joomla performance

How to speed-up Joomla performance on Windows Server IIS: 8 important, but simple, tips to improve & speed up Joomla Add caching, gzip compression, set your sessions & optimize MySQL database functions… Provide your visitors with a blazing fast Joomla website! Jan ReilinkMy name is Jan. I am not a hacker, coder, developer or guru.…

Continue reading 8 Tips to improve Joomla performance

Set or remove the read-only attribute assigned to files with PHP chmod

Chmod.php, change file attributes with PHP, to make files read only or normally accessible on Windows IIS servers. Sometimes you need chmod to make files read only on your website, or make them normally accessible in case they already are read only. For instance Drupal’s settings.php configuration file, or WordPress Contact Form 7 temporary captcha…

Continue reading Set or remove the read-only attribute assigned to files with PHP chmod