Sometimes when you are committing changes in git you’ll find that a number of files have been deleted. You could manually set these files to delete by individually issuing the command: git rm filename However, there is a shortcut. If you issue the command: git ls-files --deleted It will return…

The following command can be used to find and checkout (undo) all files with modifications: git checkout $(git ls-files -m) This is effectively an “undo” of all modifications in the given branch (but it doesn’t impact added or deleted files).

Here’s a list of things you can check if you aren’t getting anything written to the PHP error log on your server: In php.ini, do you have error_reporting set to E_ALL ? In php.ini, do you have log_errors enabled? In php.ini, do you have track_errors enabled? Have you specified a…

The group_concat() function in MySQL is really nifty. It concatenates all rows that match your group by statement into a single, comma separated string. Essentially, it transposes rows to columns. Take this example. Say you have a table that stores a set of locations by country, state and city. You…

To see what storage engine is used by the server by default you can use the following command in the MySQL/MariaDB shell: show variables like '%storage_engine'; You can view a list of supported engines using: show engines\G; To find out what storage engine your tables are using by schema use…

By default on Apache web servers, PHP code will not execute in a file that does not have a .php (or similar) extension. So even though you can embed PHP into a HTML file, it won’t execute when the file extension is .html, .htm etc. To change this, you can…

For example, on a Mac, you’ll often find .DS_Store files. To find and remove these you can run the following command to search for and remove every instance: $ find . -type f -name ".DS_Store" -exec rm {} ; This will find all files (-type f) called .DS_Store and execute…

If you work with databases, sooner or later you’ll need to write SQL to “fix” data in a database table (or tables). One key piece of advice is to make sure that the SQL script you come up with is reversible, just in case you need to change things back…

The following addition to your .bash_profile is super handy if you regularly use the command line/console on your Mac. Instead of simply deleting files forever it will instead put them into the .Trash folder in a unique sub-folder so you can recover them until you empty your bin. Very handy…