FAQ PHP

$> pear channel-discover pear.phpdb.org
$> pear install phpdb/creole

<?php

require 'Creole.php';

$db = Creole::getConnection('mysql://Yogui:motdepasse@localhost/developpez');

?>

<?php

require 'creole/Creole.php';

$db = Creole::getConnection('mysql://Yogui:motdepasse@localhost/developpez');

// Statement générique
$stmt = $db->createStatement();

// Statement préparé
$insert = $db->prepareStatement('INSERT INTO user (name, password) VALUES (?, ?)');

// Requête non préparée
$stmt->executeQuery('TRUNCATE user');

// Requête préparée
$insert->setString(1, 'Yogui');
$insert->setString(2, '1234');
$insert->executeQuery();

// Requête préparée
$insert->setString(1, 'BrYs');
$insert->setString(2, '4321');
$insert->executeQuery();

// Requête non préparée
$resultSet = $stmt->executeQuery('SELECT id, name FROM user');

while($resultSet->next())
{
    echo $resultSet->get('name').'<br />';
}

?>

<?php

require 'creole/Creole.php';
require 'jargon/Query.php';

$db = Creole::getConnection('mysql://Yogui:motdepasse@localhost/developpez');

$query = new Query($db, 'SELECT id, name FROM user');
echo '<pre>';
print_r($query->getRows());
echo '</pre>';

?>