Zend Framework

Core Components

Adding a CORS implementation to Zend Expressive

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 poli…

Read more →
Best Practice

Using LIKE wildcards with Zend_Db

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.

Read more →
PHP Development

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

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 dat…

Read more →
PHP Development

Protection against SQL Injection using PDO and Zend Framework

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 statem…

Read more →
Best Practice

INSERT, UPDATE, DELETE statements with Zend_Db

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.

Read more →
Best Practice

Subqueries with Zend_Db

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 fro…

Read more →
Best Practice

What are returning the FETCH functions from Zend_Db

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, , ) array fetchAssoc (string|Zend_Db_Selec…

Read more →
Best Practice

SQL queries using Zend_Db - SELECT

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', $dbConnec…

Read more →