PHP A_Sql_Prepare Beispiele

Beispiel #1

Datei: PrepareTest.php Projekt: TheProjecter/skeleton

 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");
 }

Beispiel #2

Datei: example_prepare.php Projekt: TheProjecter/skeleton

<?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);