Solving a dilemma involving JavaScript functionality and organizing data in a database table

Question

Solving a dilemma involving JavaScript functionality and organizing data in a database table

When retrieving data from a database table, I receive values of "yes" or "no" to indicate whether a specific item is available. Instead of simply concatenating the names with the values, I am looking for a way to create a string that lists only the available products by name.

One approach I'm considering involves using a series of if statements to assign each product name to a variable based on its availability status, and then including all the variables in the final string:


var kt; 
if (kitchenTable == yes) kt = "kitchen table"; 
else kt = ""; 

var kc;
if (kitchenCabinet == yes) kc = "kitchen cabinet";
else ka = "";

output = kt + ', ' + kc;

Since there are approximately 50 items to be considered, I'm exploring more efficient solutions to this problem. One potential option is to modify how the data is stored in the database table so that instead of "yes," the entry would include the actual item name. However, this might not be the best solution overall.

javascript mysql

Answer 1

Answer №1

It goes without saying that not all details are disclosed regarding the query method, hence this serves as a conceptual representation of a function mimicking a query operation.

var availableItems = [];

var queryResult = query("living room sofa");
queryResult === "yes" && ( availableItems.push("living room sofa") );

......

var finalOutput = availableItems.join();

Answer 2

It goes without saying that not all details are disclosed regarding the query method, hence this serves as a conceptual representation of a function mimicking a query operation.

var availableItems = [];

var queryResult = query("living room sofa");
queryResult === "yes" && ( availableItems.push("living room sofa") );

......

var finalOutput = availableItems.join();

Answer 3

Answer №2

If you're looking for a solution, JavaScript has got you covered.

One way to simplify your code and make it more readable is by using an object literal.

Converting server data into true and false values is a common practice for communicating Boolean values, which can be used in the method below:

// Sample server response
var results = {
                    kitchenCabinet: true,
                    kitchenTable: true
}

// Maintain a list of related items
var kitchenProps = { 
                  kitchenCabinet: 'kitchen cabinet',
                  kitchenTable: 'kitchen table'
 }

// Use this function for different categories (e.g., masterBathroomProps...)
function getItemDataIfExists(results, hashTable){
    'use strict';

    var output = 'Your total is: '; 

    for (var item in results) {
        if (!results.hasOwnProperty(item)) return;
        if (results[item]) output += 'A '+hashTable[item]+' ';
    }

    return output;
}


getItemDataIfExists(results, kitchenProps);

Explanation:

This logic iterates through an object with key-value pairs, where keys represent item names and values indicate existence. If a value is true, it retrieves the corresponding property from another object. The key names in both objects must match.

For a live demonstration, check out this link:

http://codepen.io/nicholasabrams/pen/JXXbYz?editors=0010

Answer 4

If you're looking for a solution, JavaScript has got you covered.

One way to simplify your code and make it more readable is by using an object literal.

Converting server data into true and false values is a common practice for communicating Boolean values, which can be used in the method below:

// Sample server response
var results = {
                    kitchenCabinet: true,
                    kitchenTable: true
}

// Maintain a list of related items
var kitchenProps = { 
                  kitchenCabinet: 'kitchen cabinet',
                  kitchenTable: 'kitchen table'
 }

// Use this function for different categories (e.g., masterBathroomProps...)
function getItemDataIfExists(results, hashTable){
    'use strict';

    var output = 'Your total is: '; 

    for (var item in results) {
        if (!results.hasOwnProperty(item)) return;
        if (results[item]) output += 'A '+hashTable[item]+' ';
    }

    return output;
}


getItemDataIfExists(results, kitchenProps);

Explanation:

This logic iterates through an object with key-value pairs, where keys represent item names and values indicate existence. If a value is true, it retrieves the corresponding property from another object. The key names in both objects must match.

For a live demonstration, check out this link:

http://codepen.io/nicholasabrams/pen/JXXbYz?editors=0010

Solving a dilemma involving JavaScript functionality and organizing data in a database table

Answer №1

Answer №2

Similar questions

Learn how to use canvas and JavaScript to draw lines that display x and y coordinates on top of the mouse pointer at the same time

Having issues with passing data to a Modal on eventClick using FullCalendar with ReactJS, receiving a "cannot read property of undefined" error. Any advice on how

Reset the AJAX object using jQuery

Using JavaScript to assess the outcome of a form utilizing an if statement

What is the best way to modify the views directory for deploying on Vercel?

When utilizing npm install buefy and npm install font-awesome, there may be an unnecessary display of [email protected] and [email protected] extraneous errors

Combining the contents of one HTML table with Bootstrap styling into another Bootstrap table

Using PHP to Insert Data into MySQL Database in a Loop

Hierarchical configuration selection

Vue JS Spinner that can be used for multiple components within a single page in the same Vue application

JavaScript code altered link to redirect to previous link

Obtain user input and extract the name using jQuery's serialization function

The functionality of array.map appears to be malfunctioning within ReactJS

Is AJAX/JSON Referencing the Way to Go?

Tips for outlining regions on Google Maps

javascript send variable as a style parameter

Struggling with the functionality of having numerous jQuery UI controls on a single page. Implementing the accordion control in multiple sections

The ultimate guide to personalizing group titles in Angular UI-Select

Tips for translating mesh without using its center point, but instead using its vertices

"Add a new record into the MySQL database by selecting the highest value and