browscap and get_browser in PHP

If you want to know the capabilities of the current users browser in PHP you can use the get_browser() function.

mixed get_browser ([ string $user_agent [, bool $return_array = false ]] )

Fix “OSX10.9.xctoolchain/usr/bin/cc: No such file or directory”

You may get this error while compiling something on the command line with Mac OS X:

/Applications/Xcode.app/Contents/Developer/Toolchains/OSX10.9.xctoolchain/usr/bin/cc: No such file or directory

Show executed queries in WordPress with SAVEQUERIES

Once I needed to know which queries were being executed by WordPress. At that moment I configured MySQL to log all the queries and then checked that log until I found the problem and solved it. But it was not as easy as the solution I found…

Change WordPress table prefix to avoid SQL injection attacks

WordPress uses a table prefix for each installation in case you want/need to have more than one WordPress in the same database. It uses “wp_" by default but is encouraged to use other string to add another security layer…

Delete WordPress old revisions

WordPress stores revisions of the posts, pages, etc. while you write them. Without even knowing you may have about 5 or more revisions of each entry. And each revisions represents one entry in your posts database table with post_type column as revision.

Connect to MySQL over SSH with MySQL Workbench

If you don’t have phpMyAdmin installed on your server or you don’t feel comfortable using it there’s the option to connect over SSH to MySQL with MySQL Workbench. I didn’t know this could be done until changing this site from a shared hosting to a…