Top "Zend-db" questions

Database access component for the Zend Framework.

zend adapter beginTransaction() and commit() fails

I am facing a strange issue The Zend_DB_Adapter's beginTrasaction() and commit() methods don't seem to be working as …

mysql zend-framework transactions zend-db referential-integrity
SQL: Insert only new rows/records into a table?

I'm parsing a json feed routinely and need to insert only the newest users from the feed and ignore existing …

php mysql sql zend-framework zend-db
Insert into .. select from .. using zend db

I have the following raw query which moves items from a shopping cart to an order table: insert into webshop_…

php zend-db
Is there a way to get the number of records from a query with Zend-framework?

Given my generic select below, is there a way to get the number of records returned from a query with …

php zend-framework zend-db
Zend Enable SQL Query logging

I am using this to retrieve the database connection atm. $db = Zend_Db_Table::getDefaultAdapter(); I do set this up …

zend-framework zend-db zend-db-table
Zend db adapter mysqli or PDO_MYSQL

I've seen several code samples that do this in application.ini resources.db.adapter = mysqli or resources.db.adapter = PDO_…

php mysql database zend-framework zend-db
Best way to set charset for Zend_Db (or at least better than what I'm currently doing)

I'm using Zend_DB and trying to change the charset to utf8, here is the code: config.ini : [development] db.…

php mysql zend-framework character-encoding zend-db
Best way to do an Inner Join using the Zend Framework?

It seems like there's a few different ways to join two tables using the Zend Framework, but I've never done …

zend-framework inner-join zend-db zend-db-table zend-db-select
Zend Framework 2 Paginator + TableGateway

How to use the database mapper with the paginator? I'm having a bit trouble understanding how I implement the DbSelect …

zend-framework2 zend-db zend-paginator tablegateway
zend not using columns, and selecting everything

I have the following code $result = $handle->select()->from('store_details') ->where('store_details.store_…

php zend-framework zend-db