If you’re looking for a file with world countries boundaries: here is the link https://www.gadm.org/ This great site has both level 1 and 2 administrative subdivisions of countries. Very useful is you want to show countries overlay in your map
Day: February 21, 2011
Setting up mysql proxy (windows)
Sometimes you need to view the exact query that your client sent to the server. For example, if you don’t know how PDO binds and escapes params or you’re using ORM. There is mysql proxy utility to facilitate this. So in order to install it you should: 1. Download the distribution from https://dev.mysql.com/get/Downloads/MySQ … oobly.com/ 2. You don’t need to install anything. Just launch
Elance ANSI SQL code test with answers
Hi all, recently I tried to pass elance sql code test and managed to reply to only 8 out of 10 questions. I sent expert rating a feedback after the first pass as I believe limits should be allowed (however, maybe they are not in ANSI, I don’t remember). Anyway, here are the questions and my answers: 1. Consider a table named “salary” having the…
Website Screen scraping using Zend Framework
ZF is a component-based framework, so we can only use some of its packages for a specific task. For example, if we don’t need to build a site and don’t need MVC, dispatchers, routers and so on, we can include only necessary packages for the task. Assume we need to build a screen-scrapper for a site or group of sites. We’d need Zend_Dom_Query with its…
S/MIME email encryption/signing using Zend_Mail
Recently I wrote a class for ZF that one can use as a convenient tool for signing and/or encrypting email documents. The tricky thing was that MS Outlook Express did not want to treat it as Signed and Encrypted message unless you add “\n” to the end of the message , that was hard to find and I had to only experiment as there are…