Page 6 of 8

USPS Web Tools guide

Besides its primary role – delivering mail, USPS allows several other functions by means of https://www.usps.com/webtools/. In order to use them you’ll need to make xml in conformance with USPS Web Tools documentation and send it as for example cURL request. Below given is a class that will handle all these cURL requests. It’s the class serving all the requests in this article. We’ll need…

Zend_Gdata_Youtube and disallowing commenting/embedding of video

Even in the latest ZF stable release 1.11.4 there is still no support of new Youtube API accessControl element. The framework is still using yt:noembed option and has no support for disallowing commenting at all. As I tried yt:noembed – it wasn’t working, so we need to add support to ZF of this feature. First we need to understand how Youtube feed needs to be…

World boundaries kmz, shp

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

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…

Page 6 of 8