Questions tagged [zend-db-table]

Object-oriented interface to database tables

The Zend_Db_Table class is an object-oriented interface to database tables. It provides methods for many common operations on tables. The base class is extensible, so you can add custom logic.

The Zend_Db_Table solution is an implementation of the Table Data Gateway pattern. The solution also includes a class that implements the Row Data Gateway pattern.

Official documentation

437 questions
1
vote
2 answers

How can i run the admin module in zend 2.3?

I have tried so much through Googling but I have not found the right solution for that. Can anyone help me out? Even I tried to change the module.config file code through routing as well as I have tried application.config file to add module name in…
1
vote
1 answer

How to add custom fields in ZFC-user module for zend 2 without doctrine?

I have tried using creating a different module and attaching the ZfcUser\Form\Register over init method. But it wasn't working. I want to add few custom fields, with changing any thing in the vendor dir, as is it not a good practice. I also tried…
Wiki
  • 43
  • 5
1
vote
1 answer

How does Zend_Db_Table_Select work?

I'm trying to figure out how to use Zend_Db_Table_Abstract correctly. I want to return just the name column from my query. Can you please explain what's wrong with the following code? class Model_DbTable_Foo extends Zend_Db_Table_Abstract { …
jwhat
  • 2,042
  • 23
  • 29
1
vote
2 answers

Why zend framework can't access to mysql database?

I'm following the user guide tutorial directly from the Zend framewrok website; I create the module ALbum and the mysql table as the guide says, but when I open the link 'localhost:8080/album' return a page error with the message below : Connect…
Davide
  • 113
  • 2
  • 11
1
vote
1 answer

Zend database query result converts column values to null

I am using the next instructions to get some registers from my Database. Create the needed models (from the params module): $obj_paramtype_model = new Params_Model_DbTable_Paramtype(); $obj_param_model = new…
1
vote
1 answer

Write PDF in Zend Controller

I require make mediantes reports query the database, so my idea is to write "text" in a PDF with the model view controller know how to perform queries and this is the code I use the controller to generate the PDF public function mensualAction() { …
1
vote
3 answers

A value for the identity was not provided prior to authentication with Zend_Auth_Adapter_DbTable

I am getting below error while running Login Authentication Code on. I am using zend framework & zend studio as IDE A value for the identity was not provided prior to authentication with Zend_Auth_Adapter_DbTable. Below is the code which i have…
Gaurav Pawar
  • 52
  • 2
  • 7
1
vote
1 answer

get values form global secondary indexes table

I am using DynamoDB and zend framework. I am able to fetch row from normal table using this. $response['Items'] = $this->dbClient->query( array( "TableName" => "user", "KeyConditions" => array( …
keen
  • 3,001
  • 4
  • 34
  • 59
1
vote
2 answers

How to create a select - option in Zend Framework +MySQL Table

How to create a select - option in Zend Framework +MySQL Table COntroller: $persons = new Application_Model_DbTable_Persons(); $data_persons = $persons->findPersons(); Controller and View? How to? o.O
Jhosman
  • 555
  • 2
  • 8
  • 20
1
vote
1 answer

Change Order By SocialEngine Pages plugin

Can someone please tell me how I can change the order_by of the pages query? The site I'm working on is using the pages plugin from Hire Experts. I can't for the life of me get it to take an order by displayname asc. I'm not too familiar with Zend…
Carl Weis
  • 79
  • 7
1
vote
1 answer

Zend_Db_Table Cascade DELETE And UPDATE

I'm trying to achieve a cascading UPDATE and DELETE effect in a MyISAM database (similar effect as you can create in InnoDB tables with foreign keys). Two example tables: albums photos (has an album_id column that is a "foreign key" to the albums…
Richard Knop
  • 81,041
  • 149
  • 392
  • 552
1
vote
2 answers

duplicated column name when using join with Zend_Db_table

I have two tables. Both of them have a column named 'title'. When I use the following code snippet to join two tables, I can't access one of the title column. $select = $this->select(Zend_Db_Table::SELECT_WITH_FROM_PART); …
Moon
  • 22,195
  • 68
  • 188
  • 269
1
vote
1 answer

Zend Select and NOT IN array

I want to select table entries by id that are not in an other table. Is used the following code: $table2 = new OfferTable(); $select = $table2->select()->from('offers', array('aId as id')) ->where('mem_id =?', $memId); $table = new…
ilse2005
  • 11,189
  • 5
  • 51
  • 75
1
vote
1 answer

Getting results from 2 tables in Zend

I have 2 database tables, 1. gallery -> id, title, description 2. gallery_images -> image_id, gallery_id, name, image_title, thumb_name, image_name I am able to select the images for specific gallery_id, using my Admin_Model_GalleryImages and my…
NishanCK
  • 57
  • 7
1
vote
1 answer

Zend TableGateway # (pound or number sign) in Column Name

I am new to Zend Framework 2 and I am trying to hook my table up to TableGateway and do a basic select that should look like: SELECT * FROM WHERE QMQT# = 1 It looks like this in my table model: $rowset =…
Sarah Kemp
  • 2,670
  • 3
  • 21
  • 29