I want to execute a query like the following query in zf2.
SHOW COLUMNS FROM Mytable LIKE 'Mycolumn'
What is the correct way of doing so?
By the way i am using AbstractTableGateway class.
Add a comment
|
3 Answers
I do it like this:
- Create an adapter
Pass it to the chosen class and run something like this:
$sql = "SHOW COLUMNS FROM Mytable LIKE 'Mycolumn'"; $statement = $this->adapter->query($sql); return $statement->execute();
Comments
I know reply on a very old thread, but maybe some one looking for SELECT with LIKE
$this->table = $data['table'];
$select = new Select();
$spec = function (Where $where) {
$where->like('company', '%1%');
};
$select->from($this->table);
$select->where($spec);
$resultSet = $this->selectWith($select);
$resultSet->buffer();
return $resultSet;
Comments
This is Some thing found From Google,Hope This helps u...
use Zend\Db\Sql\Sql;
$sql = new Sql($adapter);
$select = $sql->select(); // @return Zend\Db\Sql\Select
$insert = $sql->insert(); // @return Zend\Db\Sql\Insert
$update = $sql->update(); // @return Zend\Db\Sql\Update
$delete = $sql->delete(); // @return Zend\Db\Sql\Delete
For More Info Visit : click
1 Comment
rahim asgari
No, they just work for DML statements. but my query is different. it is a
show columns statement.