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
Kategorie: PHP Rezepte
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…
PAdES (PKCS11) and Zend_Pdf
Similar to my last post about Zend_Mail S/MIME class, this one allows to digitally sign and even add TSA (timestamping) support to your PDF documents generated using Zend_Pdf. There is a standalone ASN1 parser included that can be used for other projects that require ASN1 data interchange. See https://en.wikipedia.org/wiki/PAdES , https://www.ietf.org/rfc/rfc3161.txt for reference. The challenge was to add the BytesRange element with right byte bounds of the…
Performing authentication in custom validator in ZF
Although, this is not a good approach to use more than one value in Zend_Validate, but it may be useful sometimes if you want to write your custom validator and add it to let’s say password field and use it as other validators in Zend_Form. So $password->setRequired(true) ->setLabel(’Password’) ->addFilter(new Zend_Filter_StringTrim()) ->addValidator(new My_Custom_Password_Validator());