$sql = "select * from imooc where pid = ?";
$stmt = $GLOBALS['db2']->prepare($sql);
$stmt->execute(array($pid));
$row = $stmt->fetchAll(PDO::FETCH_ASSOC);
for ($i = 0; $i < count($row); $i ++) {
$data[] = $row[$i];
getList($row[$i]['id'],$data);
}
return $data;
$stmt = $GLOBALS['db2']->prepare($sql);
$stmt->execute(array($pid));
$row = $stmt->fetchAll(PDO::FETCH_ASSOC);
for ($i = 0; $i < count($row); $i ++) {
$data[] = $row[$i];
getList($row[$i]['id'],$data);
}
return $data;
2017-11-24
CREATE TABLE fullPath(
id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
cateName VARCHAR(30),
path VARCHAR(100) NOT NULL,
cateOrder SMALLINT,
createTime SMALLINT
);
id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
cateName VARCHAR(30),
path VARCHAR(100) NOT NULL,
cateOrder SMALLINT,
createTime SMALLINT
);
2017-07-24
CREATE TABLE deepClassify(
id int(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
pid int(10) UNSIGNED,
classifyName varchar(30),
classifyOrder int(10) UNSIGNED,
createTime int(10) UNSIGNED
);
id int(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
pid int(10) UNSIGNED,
classifyName varchar(30),
classifyOrder int(10) UNSIGNED,
createTime int(10) UNSIGNED
);
2017-07-24