Adding a CORS implementation to Zend Expressive

Posted by on | Featured | 1 Comment

This article is a guide on how to add a CORS implementation on an existing DotKernel3 project. The issue If you’re facing this message: “Access to XMLHttpRequest at ‘url’ has been blocked by cors policy. No ‘Access-Control-Allow-Origin header is present … Read More

Tags: , , , , , , , ,

Zend Registry usage in DotKernel

Posted by on | Featured | 1 Comment

This post refers to DotKernel 1, based on Zend Framework 1. If you are looking for DotKernel 3 related posts, go here. In DotKernel, Zend_Registry will contain the following variables: startTime – the result of microtime() at the beginning of the request configuration … Read More … Read More

Tags: ,

WURFL Zend Framework Integration into DotKernel

Posted by on | Featured | 2 Comments

This post refers to DotKernel 1, based on Zend Framework 1. If you are looking for DotKernel 3 related posts, go here. WURFL is integrated into DotKernel, using the Zend_Http_UserAgent class from the latest release ZF 1.11.0rc1 ( Beta release … Read More … Read More

Tags: , ,

Using LIKE wildcards with Zend_Db

Posted by on | Featured | No Comments

Continuing the Zend_Db article series, let’s discuss the LIKE condition. The LIKE condition allows you to use wildcards in the WHERE clause of an SQL statement. This allows pattern matching. It can be used in any valid SQL statement (SELECT, … Read More … Read More

Tags: ,

Protection against SQL Injection using PDO and Zend Framework – part 2

Posted by on | Featured | No Comments

Following the preview article about SQL Injection, here is more – a strong argument why you should use Zend Framework for handling database access. Zend_Db is the primary class used for access the database, but there is more: Zend_Db_Statement, Zend_Db_Select … Read More … Read More

Tags: ,

Protection against SQL Injection using PDO and Zend Framework

Posted by on | Featured | 7 Comments

SQL injection is a technique that exploits a security vulnerability occurring in the database layer of an application. Usually, user input is not filtered by the script and is passed into a SQL statement. PDO – PHP Data Objects – … Read More … Read More

Tags: ,

INSERT, UPDATE, DELETE statements with Zend_Db

Posted by on | Featured | 3 Comments

Continuing the Zend_DB article series, we are stopping now at DML statements. DML (Data Manipulation Language) statements are statements that change data values in database tables. There are 3 primary DML statements: INSERT – Inserting new rows into database tables. … Read More … Read More

Tags: ,

Subqueries with Zend_Db

Posted by on | Featured | 1 Comment

Continuing the Zend_DB article series, we are stopping now at subqueries. As you note, the below is a complicate query, with COUNT(), LEFT JOIN(), GROUP BY – select from 3 tables, and make a count from 2 different tables: … Read More

Tags: ,

What are returning the FETCH functions from Zend_Db

Posted by on | Featured | 1 Comment

Continuing the Zend_DB article series, we are stopping now at FETCH methods that are in Zend_Db_Adapter_Abstract: array fetchAll (string|Zend_Db_Select $sql, [mixed $bind = array()], [mixed $fetchMode = null]) array fetchAssoc (string|Zend_Db_Select $sql, [mixed $bind = array()]) array fetchCol (string|Zend_Db_Select $sql, … Read More … Read More

Tags: ,

SQL queries using Zend_Db – SELECT

Posted by on | Featured | 4 Comments

Zend_Db and its related classes provide a simple SQL database interface for Zend Framework. To connect to MySql database, we are using Pdo_Mysql adapter : $db = Zend_Db::factory(‘Pdo_Mysql’, $dbConnect); … Read More

Tags: ,