Month: August 2015
Execute php on commandline with the interactive mode
This article show to use PHP’s interactive mode to execute PHP code directly on the commandline shell without the need of a script file. This can be useful to test PHP snippets, run short commands or even test a certain PHP configuration.
Get table or DB size im Megabyte
Sometimes it is really useful to know how large a certain database table has become. With the following SQL statement you get a list of all tables of the currently connected database with their rounded size in MB: SELECT table_name AS “Table”, round(((data_length + index_length) / 1024 / 1024), 2) “Size in MB” FROM information_schema.TABLES […]
Allow upload mimetypes (file type extension)
This tutorial shows how to add file extensions and mimetypes to the list of allowed files of DokuWiki to get exotic files uploaded (invalid file error).
Batch resize images with ImageMagic
Recently I had to reduce the size of many images for uploading  them to a website. Unfortunately I didn’t find any tool like IrfanView on Ubuntu, which I’ve used for such problems in my Windows days. But there is a much smarter way to batch resize images on Linux. You simply can use the convert command from […]