MySql SHOW query in ZEND

Question

In zend it is written like

$table = $this->getTable();
        $select = $table->select()->where('status = ?',1)
                                ->where('columnOne= ?', 1) 
                                ->order('columnTwo')
                                ->limit(1);

similar to where, order, limit conditions how can I condition for LIKE?

My query is

SHOW TABLE STATUS LIKE 'tableName'

I tried in this way

    $table = $this->getTable();
                $query= $table->select("TABLE STATUS")
                                ->like($table);
    $id = mysql_query($query);

then I found that no method for LIKE is available in ZEND. Then How can I write above query in Zend framerk?

Thanks in advance.

fish through the methods in the core class. I swear I remember using a static method to get a list of all tables in a specific schema. But I cannot find anything in the documentation. — Alan B. Dee
– Alan B. Dee, Commented Jul 29, 2011 at 5:27
@Alan B. Dee : there is no object or method for SHOW statement like SELECT statement nor for LIKE opererator like WHERE operator. — maniclorn
– maniclorn, Commented Jul 29, 2011 at 6:34
@Alan: there is a listTables() method on the db adapter which is probably what you are referring to. — Tim Fountain
– Tim Fountain, Commented Jul 29, 2011 at 8:26

ChrisA · Accepted Answer · 2011-07-29 08:53:34Z

7

This works for me, so hopefully it should give you what you want:

$stmt = $dbAdapter->query("SHOW TABLE STATUS LIKE '$tableName';");
$tableStatus = $stmt->fetchObject();

answered Jul 29, 2011 at 8:53

ChrisA

2,1011 gold badge14 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySql SHOW query in ZEND

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related