Search jQuery

jQuery Forum

Using jQuery

vikaspa

CHelp to create JSON

in Using jQuery • 4 years ago

Dear Sir/Madam

I came as across

https://codepen.io/prajaktasoftware/pen/yqqgrV

My difficulty is to stored the changed data

in database so that changes can be stored and retrieved

pl help how can i do it

Replies(8)

jakecigar

Re: CHelp to create JSON

4 years ago

The plugin that you "came across" is probably the one documented @ https://github.com/bigeyex/jquery.orgChart ,

There are several callbacks, and methods. You use them, especially

getData(): get all the node data of the org chart in an array.

JΛ̊KE

vikaspa

Re: CHelp to create JSON

4 years ago

Dear JΛ̊KE

thanks tons for this valued information

however i donot know how to how to do thsi

$(document).ready(function(){
$('#getdata').click(function() { alert('getdata');
var dataArray = getData();
$.each(dataArray, function(index, value){
$("#result").append(index + ": " + value + '<br>');
});});

in console i am getting folllowing error

example.html:77 Uncaught ReferenceError: getData is not defined

at HTMLDivElement.<anonymous> (example.html:77)

at HTMLDivElement.dispatch (jquery-1.11.1.min.js:3)

at HTMLDivElement.r.handle (jquery-1.11.1.min.js:3)

Depending on output we can decide the valus to be stored in database

Hopefully we can store the data in following format

{id: 1, name: 'Acme Organization', parent: 0},

{id: 2, name: 'CEO Office', parent: 1},

{id: 3, name: 'Division 1', parent: 1},

{id: 4, name: 'Division 2', parent: 1},

{id: 6, name: 'Division 3', parent: 1},

{id: 7, name: 'Division 4', parent: 1},

{id: 8, name: 'Division 5', parent: 1},

{id: 5, name: 'Sub Division', parent: 3},

jakecigar

Re: CHelp to create JSON

4 years ago

If you call

org_chart = $('#orgChart').orgChart({…})

You can call

data = org_chart.getData();

to get the data.

JΛ̊KE

jakecigar

Re: CHelp to create JSON

4 years ago

I made a demo @ http://home.jejaju.com/jquery.orgChart-master/example.html All users share the same chart, so If you make a change, everyone can see it.

JΛ̊KE

vikaspa

Re: CHelp to create JSON

4 years ago

Dear JΛ̊KE

You are really genius

really interested in knowing database part

and frankly i will like to have code of

get.php

and

save.php

thats the heart of this fantastick work of yours

Save this data in database will be most important here

jakecigar

Re: Re: CHelp to create JSON

4 years ago

I did not use a database. I just stored it in a flat JSON file.

I don’t usually write PHP for people.

get.php is

<?php

echo file_get_contents('/tmp/org.json');

and save.php is

<?php

file_put_contents('/tmp/org.json',file_get_contents("php://input"));

JΛ̊KE

watusiware

Re: CHelp to create JSON

4 years ago

Saving to the database is not a jQuery problem. jQuery can send the data to your server. Your server code has to take it from there.

You have to do it in PHP (or some other server language). If you need more help with PHP, you need to find a PHP site.

And even a PHP site may not help you with everything. You need to pick a database and learn how to use it. MySQL, PostgreSQL, and SQLite are popular choices.

vikaspa

Re: CHelp to create JSON

4 years ago

Thanks

Top Reply

Response title

Attachments

jQuery Forum

CHelp to create JSON

Replies(8)

Re: CHelp to create JSON

Re: CHelp to create JSON

Re: CHelp to create JSON

Re: CHelp to create JSON

Re: CHelp to create JSON

Re: Re: CHelp to create JSON

Re: CHelp to create JSON

Re: CHelp to create JSON

Statistics

Tags

Actions