日期:2014-05-17 浏览次数:20487 次
<?php
$config = array();
$config['DB_HOST']='localhost';
$config['DB_USER']='root';
$config['DB_PASS']='';
$config['DB_NAME']='hfdb';
foreach($config as $name =>$val)
{
define($name,$val);
}
$dsn = "mysql:host=".DB_HOST.";dbname=".DB_NAME;
$dbo = new PDO($dsn,DB_USER,DB_PASS);
/*
$sql="select * from task";
$stmt =$dbo->prepare($sql);
$stmt ->execute();
$results = $stmt -> fetchALL(PDO::FETCH_ASSOC);
print_r($results);
$stmt ->closeCursor();
*/
class DB_Connect{
public $db;
protected function __construct($dbo=NULL)
{
$dsn = "mysql:host=".DB_HOST.";dbname=".DB_NAME;
try
{
$this->db =new PDO($dsn,DB_USER,DB_PASS);
}
catch(Exception $e)
{
die($e->getMessage());
}
}
}
class Task extends DB_Connect
{
public function __construct($dbo=NULL,$useData=NULL)
{
parent::__construct($dbo);
}
private function _LoadEventTask ($id=NULL)
{
$sql="SELECT * FROM `task`";
try
{
$stmt = $this->db->prepare($sql);
$stmt ->execute();
$results = $stmt -> fetchALL(PDO::FETCH_ASSOC);
$stmt ->closeCursor();
return $results;
}
catch( Exception $e)
{
die($e->getMessage() );
}
}
}
$ssss= new Task($dbo);
var_dump ($ssss);