Acces a multidimensional array from database and save it

Question

I have a 2D array that I get from a database. It looks like that:

arrayDB = [url1,name1,url2,name2,url3,name3, ...]

Now I want to save this array within my code. I tried:

function symbolsArray(syms){
    var tableArray = [];
    var tableArray2 = [];

    for (var i = 0; i < syms.length; i++) {
        tableArray[i] = syms[i][0]; //url
        tableArray2[i] = syms[i][1]; //Name
    }
}

However, this approach is not really suitable because I would need two return values. Is there maybe a better approach or a way to solve the content in a 2D array?

Syms is the data from the database.

Your arrayDB looks like a 1D array to me. Unless your array is made up of sub-arrays who have actual values then it's a 1D array. Also, is syms the data from the database? Why do you need to copy it into different arrays? — Mike Cluck
– Mike Cluck, Commented Jan 31, 2017 at 15:36
your code doesnt work or your arrayDB is wrong ( may [[url1,name1],[url2,name2]] ?) — Jonas Wilms
– Jonas Wilms, Commented Jan 31, 2017 at 15:37

Community · Accepted Answer · 2017-05-23 12:33:29Z

1

Do take a look at How can I create a two dimensional array in JavaScript?

that answers similar question about 2d arrays in javascript. Try something like-

function symbolsArray(syms){
    var tableArray = [];

    for (var i = 0; i < syms.length; i++) {
        tableArray[i] = [syms[i][0] , syms[i][1]];
    }
}

edited May 23, 2017 at 12:33

CommunityBot

11 silver badge

answered Jan 31, 2017 at 15:41

Pallavi

5847 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hannah H. Over a year ago

Thanks, I have seen it but wasn't able to adapt it to my code. Your approach seems to work for me.

Hikmat Sijapati · Accepted Answer · 2017-01-31 15:41:45Z

1

Your array is not two dimensional.You can seperate urls and names like this...

arrayDB = ['url1','name1','url2','name2','url3','name3'];//assumed array
urls = [];//array for urls
names = [];//array for names
for(i=0;i<arrayDB.length;i++){
 (i%2==0)?urls.push(arrayDB[i]):names.push(arrayDB[i]);
}
console.log(names);
console.log(urls);

answered Jan 31, 2017 at 15:41

Hikmat Sijapati

6,9691 gold badge12 silver badges19 bronze badges

Comments

Jonas Wilms · Accepted Answer · 2017-01-31 15:44:33Z

0

If ive got you right, your problem is that your code needs to return two things, but return does just one, right?

May Return an Object:

return {names: tableArray2,urls:tableArray};

You could use it like this:

var mydata=symbolsArray(arrayDB);
console.log(mydata.names,mydata.urls);

If you just want to deep clone, do:

var cloned=JSON.parse(JSON.stringify(arrayDB));

Or more elegantly:

var cloned=arrayDB.map(el=>el.map(e=>e));

answered Jan 31, 2017 at 15:44

Jonas Wilms

139k20 gold badges164 silver badges164 bronze badges

Collectives™ on Stack Overflow

Acces a multidimensional array from database and save it

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related