PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
Copy Clear
Copy Format Clear
<?php function categories_list($mysqli, $id = 0, $list = []) { $stmt = $mysqli->prepare("SELECT * FROM categories WHERE parent = ?"); $stmt->bind_param('i', $id); $stmt->execute(); foreach ($stmt->get_result() as $value) { $list[] = $value['id']; //var_export($value); array_push($list, ...categories_list($mysqli, $value['id'], $list)); } return array_unique($list); } var_export(categories_list($mysqli, 0));
Show:  
Copy Clear