# \#zend-db

**URL:** https://discourse.laminas.dev/tag/zend-db/2.md

[Latest](https://discourse.laminas.dev/latest.md) · [Categories](https://discourse.laminas.dev/categories.md) · [Tags](https://discourse.laminas.dev/tags.md)

---

## [Enterprise Application Framework based on Laminas - Questions regarding opensource](https://discourse.laminas.dev/t/enterprise-application-framework-based-on-laminas-questions-regarding-opensource/1315)

<div class="topic-metadata">

**Author:** [@Praesidiarius](https://discourse.laminas.dev/u/Praesidiarius)\
**Replies:** 16\
**Last updated:** [October 12, 2020, 3:03pm UTC](https://discourse.laminas.dev/t/enterprise-application-framework-based-on-laminas-questions-regarding-opensource/1315 "2020-10-12T15:03:04Z")

</div>

Hi. I am a developer of a Software Framework called “onePlace” - since 2009 its based on Zend Framework, started with Version 1. My 10th Version (PLC X) has now reached end of beta (0.9.8) based on latest Zend Framework…

---

## [Db/transaction?](https://discourse.laminas.dev/t/db-transaction/1656)

<div class="topic-metadata">

**Author:** [@Claudio\_Eterno](https://discourse.laminas.dev/u/Claudio_Eterno)\
**Replies:** 1\
**Last updated:** [June 1, 2020, 7:11pm UTC](https://discourse.laminas.dev/t/db-transaction/1656 "2020-06-01T19:11:47Z")

</div>

Does anyone know where to find a good example about the implementation of transactions over db? In the old(zend) documentation something was written but on laminas docs I haven’t found it. On stackoverflow there is a p…

---

## [Where to file a bug report? Or how to submit a fix to the project?](https://discourse.laminas.dev/t/where-to-file-a-bug-report-or-how-to-submit-a-fix-to-the-project/1550)

<div class="topic-metadata">

**Author:** [@JeffD](https://discourse.laminas.dev/u/JeffD)\
**Replies:** 2\
**Last updated:** [April 21, 2020, 6:52pm UTC](https://discourse.laminas.dev/t/where-to-file-a-bug-report-or-how-to-submit-a-fix-to-the-project/1550 "2020-04-21T18:52:26Z")

</div>

I’ve been working to update a ZF3 application from php 7.1 to go to php 7.4 and switched over to the Laminas project. I ran across some errors in our unit tests that pointed me to this piece of code in ResultSet::Initia…

---

## [Create data-driven WebApps in record speeds with onePlace - a Laminas based PHP Application Framework](https://discourse.laminas.dev/t/create-data-driven-webapps-in-record-speeds-with-oneplace-a-laminas-based-php-application-framework/1332)

<div class="topic-metadata">

**Author:** [@Praesidiarius](https://discourse.laminas.dev/u/Praesidiarius)\
**Replies:** 0\
**Last updated:** [January 24, 2020, 5:37pm UTC](https://discourse.laminas.dev/t/create-data-driven-webapps-in-record-speeds-with-oneplace-a-laminas-based-php-application-framework/1332 "2020-01-24T17:37:20Z")

</div>

Greetings folks, since 2008 i am developing a software framework called “onePlace”. It started on Zend Framework V1 and the beta version of my 10th release PLC X based on the latest Zend Framework 2/3 Modules following …

---

## [Using TableGateway on table where \< is in string of results and is messing up object](https://discourse.laminas.dev/t/using-tablegateway-on-table-where-is-in-string-of-results-and-is-messing-up-object/1209)

<div class="topic-metadata">

**Author:** [@kingharrison](https://discourse.laminas.dev/u/kingharrison)\
**Replies:** 0\
**Last updated:** [September 30, 2019, 10:55am UTC](https://discourse.laminas.dev/t/using-tablegateway-on-table-where-is-in-string-of-results-and-is-messing-up-object/1209 "2019-09-30T10:55:43Z")

</div>

I have this text within a field: Protect Rounding? \<\<\<Flag1=1 I can query down to the row as expected, but when I output the results anything past the field with the \<\<\< the results get messed up when working with it a…

---

## [RFC: proposals for zend-db 3.0.0](https://discourse.laminas.dev/t/rfc-proposals-for-zend-db-3-0-0/857)

<div class="topic-metadata">

**Author:** [@enrico](https://discourse.laminas.dev/u/enrico)\
**Replies:** 21\
**Last updated:** [March 18, 2019, 5:57am UTC](https://discourse.laminas.dev/t/rfc-proposals-for-zend-db-3-0-0/857 "2019-03-18T05:57:06Z")

</div>

zend-db is one the oldest and largest libraries in the Zend Framework family. It’s designed as an abstraction for SQL databases, supporting MySQL, PgSQL, PDO, IBM DB2, Oracle, Microsoft SQL Server, and more. However, Th…

---

## [Zend-DB for multivalued attributed entity](https://discourse.laminas.dev/t/zend-db-for-multivalued-attributed-entity/1033)

<div class="topic-metadata">

**Author:** [@mmuhasan](https://discourse.laminas.dev/u/mmuhasan)\
**Replies:** 0\
**Last updated:** [April 15, 2019, 12:06pm UTC](https://discourse.laminas.dev/t/zend-db-for-multivalued-attributed-entity/1033 "2019-04-15T12:06:43Z")

</div>

I have an entity (model) that has a multivalued attribute. For obvious reason, it needs to save into multiple tables in the database where they will be connected via the primary key. What is the best way to implement suc…

---

## [About zf3 validator of RecordExists](https://discourse.laminas.dev/t/about-zf3-validator-of-recordexists/949)

<div class="topic-metadata">

**Author:** [@jobsfan](https://discourse.laminas.dev/u/jobsfan)\
**Replies:** 34\
**Last updated:** [March 12, 2019, 3:09pm UTC](https://discourse.laminas.dev/t/about-zf3-validator-of-recordexists/949 "2019-03-12T15:09:38Z")

</div>

In my global.php file: return \[ 'db' =\> \[ 'driver' =\> 'Pdo', 'dsn' =\> 'mysql:dbname=admin;host=localhost;charset=utf8', \], 'main' =\> \[ // this is the database I wanna to use for some Recor…

---

## [I wanna to use mssql in zf3, how to config in global.php if I wanna to use the tablegateway as tutorial](https://discourse.laminas.dev/t/i-wanna-to-use-mssql-in-zf3-how-to-config-in-global-php-if-i-wanna-to-use-the-tablegateway-as-tutorial/898)

<div class="topic-metadata">

**Author:** [@jobsfan](https://discourse.laminas.dev/u/jobsfan)\
**Replies:** 2\
**Last updated:** [February 26, 2019, 3:56am UTC](https://discourse.laminas.dev/t/i-wanna-to-use-mssql-in-zf3-how-to-config-in-global-php-if-i-wanna-to-use-the-tablegateway-as-tutorial/898 "2019-02-26T03:56:06Z")

</div>

Generally, I use mysql as database, and config as follow in the global.php: return \[ 'db' =\> \[ 'driver' =\> 'Pdo', 'dsn' =\> 'mysql:dbname=dbname;host=localhost;charset=utf8', \], \]; and use the…

---

## [Zend Framwork 3 and Doctrine](https://discourse.laminas.dev/t/zend-framwork-3-and-doctrine/894)

<div class="topic-metadata">

**Author:** [@benmoussa90](https://discourse.laminas.dev/u/benmoussa90)\
**Replies:** 1\
**Last updated:** [January 7, 2019, 12:09pm UTC](https://discourse.laminas.dev/t/zend-framwork-3-and-doctrine/894 "2019-01-07T12:09:22Z")

</div>

database : i need add doctrine to zend framwork 3

---

## [Zend-mail use Pop3 and Imap but can not storage](https://discourse.laminas.dev/t/zend-mail-use-pop3-and-imap-but-can-not-storage/853)

<div class="topic-metadata">

**Author:** [@amy0812](https://discourse.laminas.dev/u/amy0812)\
**Replies:** 1\
**Last updated:** [December 13, 2018, 8:37am UTC](https://discourse.laminas.dev/t/zend-mail-use-pop3-and-imap-but-can-not-storage/853 "2018-12-13T08:37:34Z")

</div>

Hello everybody, i have a issue, when i using zend-mail to send an email and i want to storage into “sent” folder of email. I try to use Pop3 and Imap but can not storage, Please help me!

---

## [TableGateWay problem](https://discourse.laminas.dev/t/tablegateway-problem/507)

<div class="topic-metadata">

**Author:** [@Dileep](https://discourse.laminas.dev/u/Dileep)\
**Replies:** 3\
**Last updated:** [November 28, 2018, 5:36pm UTC](https://discourse.laminas.dev/t/tablegateway-problem/507 "2018-11-28T17:36:47Z")

</div>

Hi Team, i m new in Zend framework 3 i m developing album module using TableGateWay concept what ever the tutorial was given by Zend Documentation.But i m following this url https://docs.zendframework.com/tutorials/ge…

---

## [In Zend framework getting 500: Internal Server Error](https://discourse.laminas.dev/t/in-zend-framework-getting-500-internal-server-error/828)

<div class="topic-metadata">

**Author:** [@nirajsavaliya](https://discourse.laminas.dev/u/nirajsavaliya)\
**Replies:** 1\
**Last updated:** [November 26, 2018, 2:45pm UTC](https://discourse.laminas.dev/t/in-zend-framework-getting-500-internal-server-error/828 "2018-11-26T14:45:51Z")

</div>

I have one issue in zend framework got stuck due to this error I developed Rest API but POST urls not working 500: Internal Server Error but all get urls are working When i debug all code its showing me error in Abst…

---

## [How to set a profiler class to Zend-DB](https://discourse.laminas.dev/t/how-to-set-a-profiler-class-to-zend-db/769)

<div class="topic-metadata">

**Author:** [@eguvenc](https://discourse.laminas.dev/u/eguvenc)\
**Replies:** 1\
**Last updated:** [October 8, 2018, 6:03am UTC](https://discourse.laminas.dev/t/how-to-set-a-profiler-class-to-zend-db/769 "2018-10-08T06:03:58Z")

</div>

How can it set a profiler class for https://docs.zendframework.com/zend-db/ component ? Thanks.

---

## [How to compare two timestamps for a duration longer than a certain time period zend-db](https://discourse.laminas.dev/t/how-to-compare-two-timestamps-for-a-duration-longer-than-a-certain-time-period-zend-db/641)

<div class="topic-metadata">

**Author:** [@kingharrison](https://discourse.laminas.dev/u/kingharrison)\
**Replies:** 1\
**Last updated:** [July 15, 2018, 4:12pm UTC](https://discourse.laminas.dev/t/how-to-compare-two-timestamps-for-a-duration-longer-than-a-certain-time-period-zend-db/641 "2018-07-15T16:12:06Z")

</div>

I want to compare two timestamps (which are in the format of:YYYY-MM-DD HH:MM:SS.SSSSSS example: 2018-07-11 06:38:32.916000) to return all the entries where the tim difference between the two is more than a second. Here…

---

## [Zend-Db-Adapter-Exception-RuntimeException](https://discourse.laminas.dev/t/zend-db-adapter-exception-runtimeexception/643)

<div class="topic-metadata">

**Author:** [@tthhorritto](https://discourse.laminas.dev/u/tthhorritto)\
**Replies:** 1\
**Last updated:** [July 14, 2018, 10:19pm UTC](https://discourse.laminas.dev/t/zend-db-adapter-exception-runtimeexception/643 "2018-07-14T22:19:25Z")

</div>

Hi. Following the https://docs.zendframework.com/tutorials/getting-started/database-and-models/ I got the following error accessing this page http://192.168.1.1:8080/album Zend\\Db\\Adapter\\Exception\\RuntimeException .…

---

## [How To Make Dynamic Programmatically Generated Nested Statement Using the ZF3 SQL Builder](https://discourse.laminas.dev/t/how-to-make-dynamic-programmatically-generated-nested-statement-using-the-zf3-sql-builder/639)

<div class="topic-metadata">

**Author:** [@kingharrison](https://discourse.laminas.dev/u/kingharrison)\
**Replies:** 7\
**Last updated:** [July 12, 2018, 6:19pm UTC](https://discourse.laminas.dev/t/how-to-make-dynamic-programmatically-generated-nested-statement-using-the-zf3-sql-builder/639 "2018-07-12T18:19:13Z")

</div>

Is there an example anywhere of a a dynamic programmatically generated nested statement using the ZF3 SQL builder? here is what I tried: if ($true) { $where = new Where(); $firstone = false; …

---

## [ErrorHeroModule: a php errors & exceptions handler which now support for ZF2, ZF3, and Expressive (version 1, 2, 3)](https://discourse.laminas.dev/t/errorheromodule-a-php-errors-exceptions-handler-which-now-support-for-zf2-zf3-and-expressive-version-1-2-3/601)

<div class="topic-metadata">

**Author:** [@samsonasik](https://discourse.laminas.dev/u/samsonasik)\
**Replies:** 1\
**Last updated:** [July 1, 2018, 2:28am UTC](https://discourse.laminas.dev/t/errorheromodule-a-php-errors-exceptions-handler-which-now-support-for-zf2-zf3-and-expressive-version-1-2-3/601 "2018-07-01T02:28:23Z")

</div>

Hi All, I built ErrorHeroModule, a php errors & exceptions handler which now support for ZF2, ZF3, and Expressive (version 1, 2, 3), It support zend-servicemanager, symfony, aura, auryn, and pimple container with zend-v…

---

## [Zend\_DB ResultSet Returns Empty](https://discourse.laminas.dev/t/zend-db-resultset-returns-empty/612)

<div class="topic-metadata">

**Author:** [@ganapathi](https://discourse.laminas.dev/u/ganapathi)\
**Replies:** 7\
**Last updated:** [June 19, 2018, 12:45am UTC](https://discourse.laminas.dev/t/zend-db-resultset-returns-empty/612 "2018-06-19T00:45:29Z")

</div>

Hi As i am trying to retrieve the records from postgresql database using ZF3 with Pdo adaptor. But always am getting empty result but field count is shows right one and querystring also proper one,where am able to run …

---

## [ZF3 master-master database replication using doctrine](https://discourse.laminas.dev/t/zf3-master-master-database-replication-using-doctrine/607)

<div class="topic-metadata">

**Author:** [@AksVivek](https://discourse.laminas.dev/u/AksVivek)\
**Replies:** 0\
**Last updated:** [June 8, 2018, 11:52am UTC](https://discourse.laminas.dev/t/zf3-master-master-database-replication-using-doctrine/607 "2018-06-08T11:52:19Z")

</div>

Hello Guys, I want to configure master-master database replication in zf3 using doctrine.Currently I am using single database; following is my database configuration 'doctrine' =\> \[ 'connection' =\> \[ 'orm\_d…

---

## [Zend-db call RowGateway::save can not update only modified fields](https://discourse.laminas.dev/t/zend-db-call-rowgateway-save-can-not-update-only-modified-fields/552)

<div class="topic-metadata">

**Author:** [@Moln](https://discourse.laminas.dev/u/Moln)\
**Replies:** 1\
**Last updated:** [April 4, 2018, 5:44am UTC](https://discourse.laminas.dev/t/zend-db-call-rowgateway-save-can-not-update-only-modified-fields/552 "2018-04-04T05:44:58Z")

</div>

Why RowGateway removed update only modified fields feature in zend-db. And what’s a good solution in zend-db, when I just want to update the modified fields. Code to reproduce the issue $row; //Get exists row; $row-\>a…

---

## [ResultSet always returns string (Pgsql adapter)](https://discourse.laminas.dev/t/resultset-always-returns-string-pgsql-adapter/530)

<div class="topic-metadata">

**Author:** [@jbelien](https://discourse.laminas.dev/u/jbelien)\
**Replies:** 2\
**Last updated:** [March 15, 2018, 11:40am UTC](https://discourse.laminas.dev/t/resultset-always-returns-string-pgsql-adapter/530 "2018-03-15T11:40:23Z")

</div>

Hello everyone, I started to use zend-db to query a PostgreSQL database ; it obviously works fine but I’m a bit confused with the ResultSet interface. No matter what datatype my columns are in the database, it always r…

---

## [Dynamic Menu items](https://discourse.laminas.dev/t/dynamic-menu-items/488)

<div class="topic-metadata">

**Author:** [@erfan](https://discourse.laminas.dev/u/erfan)\
**Replies:** 1\
**Last updated:** [February 20, 2018, 4:15pm UTC](https://discourse.laminas.dev/t/dynamic-menu-items/488 "2018-02-20T16:15:07Z")

</div>

Hi everyone, I am seeking to find out how it is possible to retrieve my menu items from menu table from my database and pass them to the Application\\view\\layout\\layout.phtml file to show them. the point is in the / route…

---

## [Zend Db Sql Comments](https://discourse.laminas.dev/t/zend-db-sql-comments/460)

<div class="topic-metadata">

**Author:** [@Brandon](https://discourse.laminas.dev/u/Brandon)\
**Replies:** 0\
**Last updated:** [February 2, 2018, 3:24pm UTC](https://discourse.laminas.dev/t/zend-db-sql-comments/460 "2018-02-02T15:24:41Z")

</div>

Hello All, I have a need to add comments to SQL queries to help with debugging. I found this conversation http://zend-framework-community.634137.n4.nabble.com/SQL-comments-with-Zend-Db-td674220.html from the ZF1 days. I…

---

## [ZF3 + Doctrine - how to retreive MySQL error?](https://discourse.laminas.dev/t/zf3-doctrine-how-to-retreive-mysql-error/403)

<div class="topic-metadata">

**Author:** [@djmentos](https://discourse.laminas.dev/u/djmentos)\
**Replies:** 1\
**Last updated:** [December 20, 2017, 10:49am UTC](https://discourse.laminas.dev/t/zf3-doctrine-how-to-retreive-mysql-error/403 "2017-12-20T10:49:20Z")

</div>

Hello, I have an EntityManager (PilotManager class) and function: /\*\* \* Entity manager \* @var Doctrine\\ORM\\EntityManager; \*/ private $entityManager; /\*\* \* Constructor \*/ public function \_\_construct($entityManager…

---

## [Is there a bug fix for #6383 for zend framework 3?](https://discourse.laminas.dev/t/is-there-a-bug-fix-for-6383-for-zend-framework-3/388)

<div class="topic-metadata">

**Author:** [@zwanzig20](https://discourse.laminas.dev/u/zwanzig20)\
**Replies:** 5\
**Last updated:** [December 5, 2017, 9:00am UTC](https://discourse.laminas.dev/t/is-there-a-bug-fix-for-6383-for-zend-framework-3/388 "2017-12-05T09:00:16Z")

</div>

I’ve got the bug #6383 in zend framework 3 described in https://github.com/zendframework/zendframework/issues/6383. This bug is set to closed but its not fixed for “zendframework/zend-db” : “^2.8”. Is this bug really fi…

---

## [Zend-db sql query distinct](https://discourse.laminas.dev/t/zend-db-sql-query-distinct/359)

<div class="topic-metadata">

**Author:** [@erfan](https://discourse.laminas.dev/u/erfan)\
**Replies:** 2\
**Last updated:** [November 6, 2017, 3:13pm UTC](https://discourse.laminas.dev/t/zend-db-sql-query-distinct/359 "2017-11-06T15:13:30Z")

</div>

does anyone know how to use DISTINCT in our query usin zend-db sql??? the example here is shown: $sql = new Sql($this-\>db); $select = $sql-\>select('keywords\_relation') -\>join(\['k'=\>'keywords'\],'k.id = keywords\_rela…

---

## [Joining three tables](https://discourse.laminas.dev/t/joining-three-tables/354)

<div class="topic-metadata">

**Author:** [@erfan](https://discourse.laminas.dev/u/erfan)\
**Replies:** 1\
**Last updated:** [November 5, 2017, 4:54pm UTC](https://discourse.laminas.dev/t/joining-three-tables/354 "2017-11-05T16:54:49Z")

</div>

hi there! I have a model by the name of ‘Keywords.php’ with the following content: namespace Blog\\Model; \<?php class Keywords { private $id; private $keyword; private $counter; public function \_\_construct ($id,$keywo…

---

## [Zend-db join problem in view script](https://discourse.laminas.dev/t/zend-db-join-problem-in-view-script/332)

<div class="topic-metadata">

**Author:** [@erfan](https://discourse.laminas.dev/u/erfan)\
**Replies:** 4\
**Last updated:** [October 27, 2017, 8:33am UTC](https://discourse.laminas.dev/t/zend-db-join-problem-in-view-script/332 "2017-10-27T08:33:30Z")

</div>

hi there im a newbie somehow to zend framework and i want to know more about its functionality. to do so i would like to know how is it possible to join two tables and get the values returned in the view script. beside…

---

## [Zend-db how to create a query in zf3 for several tables](https://discourse.laminas.dev/t/zend-db-how-to-create-a-query-in-zf3-for-several-tables/264)

<div class="topic-metadata">

**Author:** [@karango](https://discourse.laminas.dev/u/karango)\
**Replies:** 2\
**Last updated:** [August 30, 2017, 8:12pm UTC](https://discourse.laminas.dev/t/zend-db-how-to-create-a-query-in-zf3-for-several-tables/264 "2017-08-30T20:12:41Z")

</div>

hi, i’m new user in zend framework, i’m using Zend Framework version 3.0.3-dev, for postgresql. i have problem with request, so i would like to have your help if it’s possible. sorry for bad English, i have not great exp…

[Next page](https://discourse.laminas.dev/tag/zend-db/2.md?match_all_tags=true&page=1&tags%5B%5D=zend-db)