Full Stack LAMP, MEAN, DevOps Consultant
In this post i would like to list basic to advanced database queries using ZF2. I am gonna use TableGateway methods here. Simple Select Query
|
1 2 3 4 5 6 7 |
// use Zend\Db\TableGateway\TableGateway; // use Zend\Db\Sql\Select; $adapter = $this->getServiceLocator()->get('Zend\Db\Adapter\Adapter'); $projectTable = new TableGateway('users', $adapter); $rowset = $projectTable->select(); print_r($rowset->toArray()); exit; |
|
1 |
SELECT `users`.* FROM `users` |
In this post, I just want to show you how to return the response in JSON format in the correct way in ZF2.Returning JSON response is very useful and we almost use for all AJAX integrations. Let’s see the below example […]
Configuring multiple databases adapters in zf2 is pretty easy. In this post i will show you how to configure and connect to different databases in zf2 application. Adapter Abstract Service factory(Zend\Db\Adapter\AdapterAbstractServiceFactory) […]
Our step-by-step guide explains how you can create your own controller plugin in zf2.Fortunately creating controller plugin is very easy task. Create a directory called plugin in your module controller directory, then […]
In this tutorial i will cover the ZF2 installation on xampp for windows operating system. 1.First you need to download and install xampp server from apachefriends 2.Download and install GIT from Download GIT 3.Download […]
In this post I will show you how to create a custom view helper in ZF2, writing custom view helper in zf2 is very easy thank to zf2 authors. Here in this example i am goanna create StaticFileVersioning Module, you can […]
ZendMail provides generalized functionality to compose and send both text and MIME-compliant multipart email messages. Mail can be sent with ZendMail via the MailTransportSendmail, MailTransportSmtp or the MailTransportFile […]
We often need last inserted ID for different reasons(for example when you need to store foreign key), Immediately after a record has been inserted into the database, you can get the id that was auto incremented(primary […]
The Zend framework automatically does this if the user selected route doesn’t exists. Although in some situations like getting data from database where the route is valid , but response is 404 (row not exits or may be […]
In GF2 in order to use Sessions we should use this use ZendSessionContainer; class. This class Container extends of ArrayObject and instantiates with ARRAY_AS_PROPS flag that means you can easily iterate through properties […]
