Code snippets for symfony 1.x


Refine Tags

Snippets tagged "sql propel mysqli"

Executing a MySQL stored procedure

It took me quite some time but here is how to execute a MySQL stored procedure.

$connection = Propel::getConnection();
$query = 'CALL Proc(%s, %s, %s)';    
$query = sprintf($query, $var1, $var2, $var3);
$mysqli = $connection->getResource();
    if($result = $mysqli->use_result()){
      while($row = $result->fetch_assoc()){
  } while(($mysqli->next_result()));

Note that you should be using mysqli in order for this to work properly.

by Marcel van Leeuwen on 2008-04-18, tagged model  mysqli  propel  sql 
(1 comment)