How can I use the PDO class in another class ?
Example I want to use PDO in
class shirt {
var $id;
var $filename;
var $template;
var $side = 'front';
var $category = 'shirt';
var $fonts = array();
var $images = array();
function shirt() {
$this->CreateID();
}
function CreateID() {
$length = 5;
if (!isset($_SESSION['id'])) { //IF SESSION NOT SET, CREATE RANDOM ID
$aZ09 = array_merge(range('A', 'Z'), range('a', 'z'),range(0, 9));
$rand ='';
for($c=0; $c < $length; $c++) {
$rand .= $aZ09[mt_rand(0,count($aZ09)-1)];
}
$this->id = strtolower($rand . time());
$this->PrepareTemplate();
}
else {
$this->id = $_SESSION['id'];
}
}
function PrepareTemplate() {
HERE IT GOES WRONG
$sql = $db->prepare('SELECT a.id, a.front, a.back, b.title FROM items a, categories b WHERE a.categoryid=b.id LIMIT 1 ASC');
$sql->execute();
$preview = $sql->fetchAll();
$db = null;
print_r($preview);
}
}
I have no idea where to create the PDO $db ?