function testSql_PrepareMixedArgs() { $Sql_Prepare = new A_Sql_Prepare(); $this->assertEqual($Sql_Prepare->statement('? :foo ? :bar ? :baz')->bind('foo', array(':baz' => 3), 'bar', array(':foo' => 1, ':bar' => 2), 'baz')->render(), "foo 1 bar 2 baz 3"); }
<?php include 'config.php'; $prepare = new A_Sql_Prepare("INSERT mytable SET one=?, two='?', three=:three, three=?"); $prepare->bind("foo's", array(':three' => 'faz'), 'bar', 1); echo "Default is escaping, but no quoting<br/>A_Db_Prepare::render=" . $prepare->render() . '<br/>'; $prepare = new A_Sql_Prepare("INSERT mytable SET one=?, two=?, three=:three, three=?"); $prepare->quoteValues()->bind("foo's", array(':three' => 'faz'), 'bar', 1); echo "With quoting on by calling quoteValues()<br/>A_Db_Prepare::render=" . $prepare->render() . '<br/>'; #dump($prepare);