Organizing data in a database the arrangement way

Question

Organizing data in a database the arrangement way

I'm looking to populate an array with values for "name" and "nickname" extracted from an SQLITE database and then display them in an alert box.

This task is part of a JavaScript project developed using Titanium Appcelerator.

Below is the code snippet:

var fightersRS = db.execute('SELECT * FROM fighters');

 var setFighters = [];

while (fightersRS.isValidRow())
{
  var name = fightersRS.fieldByName('name');
  var nickname = fightersRS.fieldByName('nickname');

      setFighters.push = {
             name: name,
             nickname: nickname           
             };

     fightersRS.next();
}
alert(setFighters);

The intended outcome is for the alert to display all values separated by commas, like so:

"muhammad ali, rocky balboa, ten shin han, etc ...."

My current code is not functioning as expected. Any advice on how to achieve the desired output?

javascript arrays titanium appcelerator associative-array

Answer 1

Answer №1

To update your code, make the following changes:

var fightersList = db.execute('SELECT * FROM fighters');
var setFighters = [];
while (fightersList.isValidRow())
{
  var name = fightersList.fieldByName('name');
  var nickname = fightersList.fieldByName('nickname');

      setFighters.push({"name": name, "nickname": nickname}); //Ensure the correct syntax for pushing elements to the array

     fightersList.next();
}

To display the elements, utilize a for loop like so:

for(var i=0; i < setFighters.length; i++){
    alert("Name: " + setFighters[i].name + " Nickname: " + setFighters[i].nickname);
}

If you wish to show their names separated by commas, consider the following approach:

var fightersList = db.execute('SELECT * FROM fighters');
var setFighters = [];
while (fightersList.isValidRow())
{
    var name = fightersList.fieldByName('name');

    setFighters.push(name);

    fightersList.next();
}

var fighters = setFighters.join(","); //Concatenate array elements with commas
alert(fighters); //Will display all names separated by commas

Refer to the JavaScript join method for further information.

Answer 2

To update your code, make the following changes:

var fightersList = db.execute('SELECT * FROM fighters');
var setFighters = [];
while (fightersList.isValidRow())
{
  var name = fightersList.fieldByName('name');
  var nickname = fightersList.fieldByName('nickname');

      setFighters.push({"name": name, "nickname": nickname}); //Ensure the correct syntax for pushing elements to the array

     fightersList.next();
}

To display the elements, utilize a for loop like so:

for(var i=0; i < setFighters.length; i++){
    alert("Name: " + setFighters[i].name + " Nickname: " + setFighters[i].nickname);
}

If you wish to show their names separated by commas, consider the following approach:

var fightersList = db.execute('SELECT * FROM fighters');
var setFighters = [];
while (fightersList.isValidRow())
{
    var name = fightersList.fieldByName('name');

    setFighters.push(name);

    fightersList.next();
}

var fighters = setFighters.join(","); //Concatenate array elements with commas
alert(fighters); //Will display all names separated by commas

Refer to the JavaScript join method for further information.

Answer 3

Answer №2

To concatenate all values with a comma, consider using a for loop or incorporating it inside a while loop.

Retrieving data from an array with comma separation may not be feasible. For reference, here's an example of an associative array on Stack Overflow. You can customize your loop or utilize the while loop you're constructing.

Learn more about associative arrays and fetching data here

Thank you

Answer 4

To concatenate all values with a comma, consider using a for loop or incorporating it inside a while loop.

Retrieving data from an array with comma separation may not be feasible. For reference, here's an example of an associative array on Stack Overflow. You can customize your loop or utilize the while loop you're constructing.

Learn more about associative arrays and fetching data here

Thank you

Organizing data in a database the arrangement way

Answer №1

Answer №2

Similar questions

JavaScript allows for the insertion of values into either a textbox or dropdown menu

What is the best method for transforming a base64 encoded string into a base64 formatted PDF string?

javascript - Add a function to an array, iterate through, and delete once executed

Looking to spice up your static HTML site? Dive into the world of Ruby on

What could be causing the 304 error when using $http.get?

Leave a message | Google Sheets | JavaScript using nodeJS

Ordering an Array of JavaScript Objects in a Custom Sequence (utilizing pre-existing methods)

Activating a tab using a JS call in Bootstrap with the data-toggle attribute

Encountering a 500 internal server error after deploying due to utilizing getServerSideProps in Next.js

Utilize AngularJS to retrieve and interact with the JSON data stored in a local file once it has

Facing an issue in React-Native where unable to navigate to the second screen

Adding a plane to a Three.js scene

What is the best way to determine the number of items in a class's property using the Swift programming language?

Utilize AJAX within an Angular method

Mastering the art of curating the perfect image for your Facebook timeline

What is the process of calculating the difference between two time values in PHP?

Animating a dropdown menu with jQuery

Retrieving data from JSON in JavaScript

Tips for assisting flow with managing the initialization of react component state

Unable to display the retrieved list data using v-for loop from axios get request