1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
|
<?php
define("SERVER","localhost");
define('USER',"login");
define('PASSWD',"pwd");
define('DB_NAME', "base");
define('PDO_DSN',"mysql:host=" . SERVER . ";dbname=" . DB_NAME);
class sdb
{
static private $PDOInstance;
private function __construct($dsn, $username, $password)
{
if(!self::$PDOInstance) {
try {
self::$PDOInstance = new PDO($dsn, $username, $password);
// self::$PDOInstance->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
die("PDO ERREUR: " . $e->getMessage() . "<br/>");
}
}
return self::$PDOInstance;
}
public static function getInstance($dsn, $username=false, $password=false)
{
if (is_null (self::$PDOInstance)) {
self::$PDOInstance = new self($dsn, $username, $password);
}
return self::$PDOInstance;
}
}
$db = sdb::getInstance(PDO_DSN,USER,PASSWD);
foreach ($db->query("SELECT id,name FROM liste") as $row)
{
echo '<p>'.$row['name'].'</p>';
}
?> |
Partager