php - 如何使用递归将数据保存到数据库

Question

我的 mysql 表如下所示:

page_id     parnt_id    page_name
------------------------------------
1           0           AboutUs
2           1           Contact_us
3           2           Home
4           2           Currear

我有一个如下所示的数组:

Array
(
    [0] => Array
        (
            [id] => 1
            [children] => Array
                (
                    [0] => Array
                        (
                            [id] => 2
                            [children] => Array
                                (
                                    [0] => Array
                                        (
                                            [id] => 3
                                        )

                                )
                        )
                )
        )
)

如何使用递归将上述数组添加到数据库中？

Answer 1

$all_pages = $given_array;

function save_page($page, $parent_id = 0) {

  $page_id = $page['id'];
  $sql = "INSERT INTO table_name (page_id, parent_id)
         VALUES ($page_id, $parent_id)";
  mysql_query($sql);

  if(array_key_exists('children', $page)) {
    save_page($page['children'], $page['id']);
  }
}

save_page($all_pages);