1.0接口常量,通常可以用作配置文件
2.0 Connection: 工作类/普通类
<?php
namespace _1010;
if (!interface_exists(__NAMESPACE__.'\iDbParam')) {
interface iDbParam
{
const TYPE = 'mysql';
const HOST = '127.0.0.1';
const DBNAME = 'php';
const USER_NAME = 'root';
const PASSWORD = 'root';
public static function connection ();
}
}
class Connection implements namespace\iDbParam
{
private static $type = iDbParam::TYPE;
private static $host = iDbParam::HOST;
private static $dbname = iDbParam::DBNAME;
private static $userName = iDbParam::USER_NAME;
private static $password = iDbParam::PASSWORD;
public static function connection ()
{
$dsn = self::$type . ':host=' . self::$host.';dbname='.self::$dbname;
$user = self::$userName;
$password = self::$password;
return new \PDO($dsn, $user, $password);
}
}
$link = Connection::connection();
$stmt = $link->prepare('SELECT * FROM `staff` LIMIT :limit');
$stmt->bindValue('limit', 5, \PDO::PARAM_INT);
$stmt->execute();
foreach ($stmt->fetchAll(\PDO::FETCH_ASSOC) as $staff) {
$hiredate=date('Y年m月d日', $staff['hiredate']);
echo "<li>{$staff['staff_id']}-{$staff['name']}-{$staff['position']}-{$hiredate}</li>";
}