php - Can raw SQL be parsed into a Zend\Db\Sql\Select object? -


is there way parse sql statement string zend\db\sql\select object?

something along lines of:

$sql = 'select * table col1 = "x"'; $select = new select(); $select->parsesql($sql); 

i have many uses this, maintaining use of select object when executing raw sql statement, example pass zend\paginator\adapter\dbselect without having write custom zend\paginator\adapter\dbselect class.

got 1 answer through twitter response, specific paginator use case:

$resultset = iterator_to_array($adapter->query($sql_statement)->execute()); $iteratoradapter = new arrayadapter($resultset); $paginator = new paginator($iteratoradapter); 

Comments

Popular posts from this blog

css - I want to align grid in center -

Contact Form PHP Email Script -

python - SWIG function not printing output -