id = $id;
$this->name = $name;
$this->parent_id = $parent_id;
}
}
function load() {
$con = new mysqli('localhost', 'root', '', 'Test');
$stmt = $con->prepare('SELECT cat_id,cat_name,parent_cat_id FROM cat');
$stmt->execute();
$stmt->store_result();
$stmt->bind_result($id, $name, $parent_id);
while ($stmt->fetch()) {
$data[$id] = new Rec($id, $name, $parent_id);
}
$stmt->close();
$con->close();
return $data;
}
function printrec($data, $parent_id, $header, $footer, $start, $end) {
echo $header;
foreach($data as $d) {
if($d->parent_id == $parent_id) {
echo $start . $d->name . $end;
printrec($data, $d->id, $header, $footer, $start, $end);
}
}
echo $footer;
}
function printall($data, $header, $footer, $start, $end) {
printrec($data, null, $header, $footer, $start, $end);
}
$data = load();
printall($data, "\r\n", "", "\r\n");
?>