A Typical Data Field and Value for a Node about stefano-tree

[bartko-s]

Which database are you using postgres or mariadb?
For primary key are you using autoincrement or sequence or uuid?
Do you want to insert into table more then one independent tree structure?

[philecom]

@bartko-s I'm using MySQL(MariaDB)
I'm using autoincrement as a primary key
I'm currently inserting into one tree; but would be happy to know how to insert into multiple independent tree structure

[bartko-s]

Then:

• remove 'sequenceName' from your settings. This is necessary only for postgres(sequence)
• remove 'scopeColumnName' from your settings. This is used only when you want to have more then one tree in one DB table. see #6
• When you create new node then remove 'id' from params. "id" primary key will be generated by database(autoincrement)

$options = array(
    'tableName' => 'vz0q4_users',
    'idColumnName' => 'id', 
    'leftColumnName' => 'lft',
    'rightColumnName' => 'rght',
    'levelColumnName' => 'level',
    'parentIdColumnName' => 'parent_id'
);

$tree = new NestedSet($options, $dbAdapter);

[philecom]

@bartko-s
I got that part. what my issue is the content of "values" in the $data array

`$data = array(
// values
// id_column_name => uuid
);

$rootNodeId = $tree->createRootNode($data);
`

[philecom]

@bartko-s I dont know why you close this issue when the problem has not been solved

[bartko-s]

This is not issue. This is only question. The content of $data is values which you want to insert into database row exlude primary_key(is generated by database autoincrement), left, right, level, scope, parent_id. See example