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.
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"
ORDER BY (data_length + index_length) DESC;
This query selects all tables from all connected databases. If you want to select a certain […]
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).
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 […]