-- wimg <[EMAIL PROTECTED]> wrote
(on Thursday, 07 December 2006, 06:47 AM -0800):
> OK, the find works with $this->find(1);
> But theoretically, I should get back a row, which I should be able to get
> like this :
> $result=$this->find(1);
> print $result->pocinstance_id;
>
> but when I try that, I get :
> Fatal error: Uncaught exception 'Zend_Db_Table_Row_Exception' with message
> 'column 'pocnstance_id' not in row'
This has to do with a design decision in Zend_Db_Table that's currently
under heavy debate. Basically, all field names are accessed in
Zend_Db_Table and the Row/Rowset classes using camelCase -- the field
names are transliterated such that the underscores are removed and the
character following an underscore is converted to uppercase:
pocinstance_id => pocinstanceId
template_id => templateId
pocinstance_name => pocinstanceName
pocinstance_description => pocinstanceDescription
pocinstance_locked_user_id => pocinstanceLockedUserId
pocinstance_locked_datetime => pocinstanceLockedDatetime
pocinstance_hostname => pocinstanceHostname
So, try print $result->pocinstanceId, and you should be good to go.
> a print_r($result) gives me :
> Zend_Db_Table_Row Object
> (
> [_data:protected] => Array
> (
> [pocinstance_id] => 1
> [template_id] => 0
> [pocinstance_name] => Test instance
> [pocinstance_description] => This is a test instance
> [pocinstance_locked_user_id] => 0
> [pocinstance_locked_datetime] => 0000-00-00 00:00:00
> [pocinstance_hostname] => test
> )
>
>
>
>
>
> Matthew Weier O wrote:
> >
> > -- wimg <[EMAIL PROTECTED]> wrote
> > (on Thursday, 07 December 2006, 06:04 AM -0800):
> >>
> >> Did that. Now when I do :
> >> $db=$this->getAdapter();
> >> $result=$db->find(1);
> >>
> >> I get :
> >> Fatal error: Call to undefined method Zend_Db_Adapter_Pdo_Mysql::find()
> >
> > You're calling the method on the wrong object. find() is only available
> > via a Zend_Db_Table object, which I'm assuming $this is in your snippet
> > above. Try this:
> >
> > $result = $this->find(1);
> >
> > Within your Zend_Db_Table objects, you shouldn't need to access the
> > adapter unless you need to do specialized queries or want to return
> > result sets other than Zend_Db_Table_Rows and Zend_Db_Table_Rowsets.
> >
> > In the former case, which is how you started the thread (a question
> > about quoteInto()), you can then do things like:
> >
> > $where = $this->getAdapter()->quoteInto('value = ?', $value);
> >
> >> Lee Saferite wrote:
> >> >
> >> > If I'm not mistaken, you need to call the parent constructor inside
> >> your
> >> > POCInstance __construct function.
> >> >
> >> > Something like:
> >> >
> >> > public function __construct()
> >> > {
> >> > parent::__construct();
> >> > }
> >> >
> >> > The reason is that the Zend_Db_Table constructor calls _setup(), which
> >> > populates the per instance adapter that you are trying to get with
> >> > getAdapter(). It looks for a specific adapter being passed in the
> >> config
> >> > array and in the absense of one, it uses a reference to the default
> >> > adapter.
> >> >
> >> >
> >> > At least, that's how I read the code. =)
> >> >
> >> >
> >> >
> >> > On 12/7/06, wimg <[EMAIL PROTECTED]> wrote:
> >> >>
> >> >>
> >> >> I've attached the full code :
> >> >> - index.php - bootstrap
> >> >> - IndexController.php
> >> >> - POCInstance.php - the class POCInstance
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> Lee Saferite wrote:
> >> >> >
> >> >> > Matthew,
> >> >> >
> >> >> > In the first message from wimg, it says that
> >> >> > Zend_Db_Table::setDefaultAdapter($db)
> >> >> > is being called.
> >> >> > However, even if that were not the case, you should not be able to
> >> get
> >> >> the
> >> >> > reported error, at least as far as I can tell from the code in
> >> >> question.
> >> >> > If the default adapter was never set the it should be throwing an
> >> >> > Exception
> >> >> > since there is no default adapter and one is not being passed in the
> >> >> > constructor.
> >> >> >
> >> >> > Seems to me it would help a lot in troubleshooting if we had the
> >> real
> >> >> code
> >> >> > to look at.
> >> >> >
> >> >> > Lee
> >> >> >
> >> >> > On 12/6/06, Matthew Weier O'Phinney <[EMAIL PROTECTED]> wrote:
> >> >> >>
> >> >> >> -- wimg <[EMAIL PROTECTED]> wrote
> >> >> >> (on Wednesday, 06 December 2006, 07:29 AM -0800):
> >> >> >> > It returns NULL.
> >> >> >> >
> >> >> >> > I'm completely puzzled by this. I've used framework 0.1.5 and it
> >> >> worked
> >> >> >> > fine, but 0.2.0 just fails on this.
> >> >> >> >
> >> >> >> > When I store the $db element in the registry, then do this :
> >> >> >> > $db=Zend::registry('db');
> >> >> >> > $select=$db->select();
> >> >> >> > $select->from('Article','*')
> >> >> >> > ->where('Artcile_id',$id);
> >> >> >> > $result=$db->fetchOne($select->__toString());
> >> >> >> > print_r($result);
> >> >> >> >
> >> >> >> > The print_r returns '1', nothing more.
> >> >> >>
> >> >> >> Did you call Zend_Db_Table::setDefaultAdapter()? This has to be
> >> done
> >> >> for
> >> >> >> your various table objects to have access to the adapter:
> >> >> >>
> >> >> >> // in your bootstrap...
> >> >> >> $db = Zend::registry('db');
> >> >> >> Zend_Db_Table::setDefaultAdapter($db);
> >> >> >>
> >> >> >> Then, any Table object created will automagically have access to
> >> the
> >> >> >> database adapter.
> >> >> >>
> >> >> >> > Dinh wrote:
> >> >> >> > >
> >> >> >> > > You may be need to check if $this->getAdapter() returns an
> >> >> expected
> >> >> >> > > object. var_dump() should be useful here.
> >> >> >> > >
> >> >> >> > > Dinh
> >> >> >> > >
> >> >> >> > > On 12/6/06, wimg <[EMAIL PROTECTED]> wrote:
> >> >> >> > >>
> >> >> >> > >> I've been setting up an app using Zend Framework 0.2.0.
> >> >> >> > >> I have a simple index.php, which :
> >> >> >> > >> - includes Zend.php
> >> >> >> > >> - sets autoloading for classes
> >> >> >> > >> - connects to MySQL database using PDO_MYSQL
> >> >> >> > >> - Does "Zend_Db_Table::setDefaultAdapter($db);"
> >> >> >> > >>
> >> >> >> > >> The IndexAction on the IndexController contains :
> >> >> >> > >> $inArticle = new Article();
> >> >> >> > >> $inArticle->getArticle(1);
> >> >> >> > >>
> >> >> >> > >> The Article.php in the models contains :
> >> >> >> > >>
> >> >> >> > >> class Article extends Zend_Db_Table
> >> >> >> > >> {
> >> >> >> > >> protected Article_id;
> >> >> >> > >> protected Article_name;
> >> >> >> > >>
> >> >> >> > >> public function getArticle($id)
> >> >> >> > >> {
> >> >> >> > >> $db=$this->getAdapter();
> >> >> >> > >> $where=$db->quoteInto('Article_id=?',$id);
> >> >> >> > >> $row=$db->fetchOne($where);
> >> >> >> > >> $this->Article_name=$row->Article_name;
> >> >> >> > >> }
> >> >> >> > >> }
> >> >> >> > >>
> >> >> >> > >>
> >> >> >> > >> When I run this example, I get :
> >> >> >> > >> Fatal error: Call to a member function quoteInto() on a
> >> >> non-object
> >> >> >> in
> >> >> >> ...
> >> >> >> > >>
> >> >> >> > >> Any idea what might be wrong here ? I've also tried it with
> >> >> 'find',
> >> >> >> but
> >> >> >> > >> that
> >> >> >> > >> gives the same error.
> >> >> >> > >>
> >> >> >> > >> I am extending Zend_Db_Table, so I thought I should be able to
> >> >> >> access
> >> >> >> the
> >> >> >> > >> functions quoteInto and find ?
> >
> > --
> > Matthew Weier O'Phinney
> > PHP Developer | [EMAIL PROTECTED]
> > Zend - The PHP Company | http://www.zend.com/
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/inheritance-not-working---tf2768458s16154.html#a7740447
> Sent from the Zend Framework mailing list archive at Nabble.com.
>
--
Matthew Weier O'Phinney
PHP Developer | [EMAIL PROTECTED]
Zend - The PHP Company | http://www.zend.com/
