zend dynamic creating and using tables

Question

I need to automatically create tables with same structure each month and use a newest one but old tables should be readable. I think to make a table witch will contain names of this tables but how can I use in Zend_Db_Table_Abstract protected $_name of table that I need? I think to make something like

<?php 
class Application_Model_DbTable_ads extends Zend_Db_Table_Abstract

{

    /** Table name */

    protected $_name    = 'ads';


    public function __construct($name){

        parent::__construct();
        $this->_name = $name;

    }
}

Does Zend has something to manage this?

Why you need to create tables with same structure each month. — Fouad Fodail, Sep 11 '13 at 07:16
I have few applications that use this database and only this one uses Zend — user1927652, Sep 11 '13 at 08:11

Bogdan Solomykin · Answer 1 · 2013-09-12T16:00:03.270

0

You can create table with prefix of year+month and concatenate table name with current year+month dynamically in code:

protected $_name = "table_name_" . date("Y-m");

edited Sep 12 '13 at 16:00

answered Sep 12 '13 at 15:53

Bogdan Solomykin

176
5

You want to read from all tables oldest and newest? In this case you can create a merge table and read from there http://dev.mysql.com/doc/refman/5.0/en/merge-storage-engine.html – Bogdan Solomykin Sep 13 '13 at 08:16

zend dynamic creating and using tables

1 Answers1