How to save self-similar child objects (deep-object save) into a database?

Question

How do I save this array in my database table, preserving the parent-child relationship over an arbitrary array of such relationships?

Script: PHP Database: mysql

tbl_menu
===================
id, title, parent
==================

Array
(
    [0] => stdClass Object
        (
            [id] => 1
            [url] => http://google.cp,
            [text] => Contact Us
            [title] => undefined
            [childs] => Array
                (
                    [0] => stdClass Object
                        (
                            [id] => 2
                            [url] => http://google.com
                            [text] => Contact - 1
                            [title] => undefined
                            [childs] => Array
                                (
                                    [0] => stdClass Object
                                        (
                                            [id] => 3
                                            [url] => http://google.com
                                            [text] => Contact - 1 - 2
                                            [title] => undefined
                                        )

                                )

                        )

                )

        )

    [1] => stdClass Object
        (
            [id] => 4
            [url] => http://domain.com/
            [text] => About
            [title] => undefined
            [childs] => Array
                (
                    [0] => stdClass Object
                        (
                            [id] => 5
                            [url] => http://google.com
                            [text] => About - 1
                            [title] => undefined
                        )

                    [1] => stdClass Object
                        (
                            [id] => 6
                            [url] => http://google.com
                            [text] => About - 2
                            [title] => undefined
                        )

                )

        )

    [2] => stdClass Object
        (
            [id] => 7
            [url] => /
        )

)

This is what i have done so far
    function save_menu()
    {
        $menu = $_POST['menu'];
        foreach($menu as $key => $item) 
        {
            $sql = "INSERT INTO tbl_menu (`title`,`parent`) values ('".$item['title']."','')";  
            mysql_query($sql);
        }
    }

Show us what you have done. You are not getting help if you want us to finish it for you. Where are you stuck? — Rene Korss, May 11 '15 at 08:07
i searched it is possible through recursion but i am not able to get it. — Mohit Singh, May 11 '15 at 08:16

Deep Hakani · Answer 1 · 2015-05-11T08:38:32.463

0

function save_menu()
{
    $menu = $_POST['menu'];

        svae_data($menu)  
}

public function save_data($menu)
{

      foreach($menu as $key => $item) 
      {
           $sql = "INSERT INTO tbl_menu (`title`,`parent`) values  ('".$item['title']."','')";  
           mysql_query($sql);

           if(isset($item['childs']))
           {
                save_data($item['childs'])
           }
     }

}

edited May 11 '15 at 08:38

answered May 11 '15 at 08:33

Deep Hakani

197
1
8

answer given not working i am using object not an array, please check in my question? – Mohit Singh May 11 '15 at 10:10

score 0 · Answer 2 · edited May 23 '17 at 10:24

0

This is the code which You've wanted, but please pay attention to injections, and the mysql_ functions are deprecated since php 5.5 so use PDO or mysqli. More info in links, se below.

PHP PDO

mysql_real_escape_string

How can I prevent SQL injection in PHP?

function save_menu_recursive($menu, $parent = null) {
    if (!$parent) {
        $sql = "INSERT INTO tbl_menu(`title`) VALUES('{$menu->title}')";
    }
    else {
        $sql = "INSERT INTO tbl_menu(`title`, `parent`) VALUES('{$menu->title}', {$parent})";
    }
    mysql_query($sql);
    if (isset($menu->childs) && is_array($menu->childs)) {
        $insertedId = mysql_insert_id();
        foreach($menus->childs as $child) {
            save_menu_recursive($child, $insertedId);
        }
    }
}

edited May 23 '17 at 10:24

Community

1
1

answered May 11 '15 at 08:58

Vahe Shadunts

1,956
14
18

answer given not working i am using object not an array, please check in my question? – Mohit Singh May 11 '15 at 10:10
@MohitSingh I've rewrite your function save_menu, and you have write it for array. – Vahe Shadunts May 11 '15 at 11:54
@MohitSingh if anyone tries to help you, be honest to give him some feedback, (e.g. comment. did it help you or not), thanks. – Vahe Shadunts May 14 '15 at 10:33
well i found solution myself will add answer soon. – Mohit Singh May 14 '15 at 18:08

How to save self-similar child objects (deep-object save) into a database?

2 Answers2