в 10:37, 26 мая 2010

2010-05-26T10:37:32Z

Admin: 1 версия

2010-05-26T07:07:55Z

1 версия

Новая страница

==Advanced PEAR::DB: Prepared Statements==



<source lang="html4strict">

include_once("DB.php");
$db = DB::connect("mysql://user:password@localhost/phpdb");
if (DB::isError($db)) {
print $db->getMessage( );
exit;
} else {
$data = array(
array("Gabor", 25),
array("Elisabeth", 39),
array("Vicky", 19)
);
$prep = $db->prepare("INSERT INTO people VALUES (?, ?);");
while(list($var, $val) = each($data)) {
print "Adding element $var\n";
$db->execute($prep, $val);
}
}
$db->disconnect( );

</source>

==PEAR::DB==



<source lang="html4strict">

include_once("DB.php");
$conninfo = "mysql://username:password@localhost/phpdb";
$db = DB::connect($conninfo);
if (DB::isError($db)) {
print $db->getMessage( );
exit;
}
$result = $db->query("SELECT * FROM people;");
while ($result->fetchInto($row, DB_FETCHMODE_ASSOC)) {
extract($row);
print "$Name: $NumVisits\n";
}
$result->free( );
$db->disconnect( );

</source>

==Quick PEAR::DB Calls==



<source lang="html4strict">

include_once("DB.php");
$db = DB::connect("mysql://user:password@localhost/phpdb");
if (DB::isError($db)) {
print $db->getMessage( );
exit;
} else {
$maxage = $db->getOne("SELECT MAX(Age) FROM people;");
print "The highest age is $maxage<br />";
$allnames = $db->getCol("SELECT Name FROM people;");
print implode(", ", $allnames) . "<br />";
$onecol = $db->getRow("SELECT * FROM people WHERE Name = "Ildiko";");
var_dump($onecol);
}
$db->disconnect( );

</source>

← Предыдущая	Версия 10:37, 26 мая 2010
(нет различий)

PHP/Utility Function/PEAR - История изменений

в 10:37, 26 мая 2010

Admin: 1 версия