Retrieve a specific key from SQL records

Question

Retrieve a specific key from SQL records

I have recently started learning JavaScript and MySQL. When I run a MySQL query in my server-side JavaScript code, the returned rows are in the following format:

For example, if I use console.log(rows), it will display:

[ RowDataPacket {
    id: 7080,
    post_author: 134,
    post_title: '99 Varieties Dosa, Indira Nagar',
    post_content: 'There',
    link: '99-varieties-dosa-indira-nagar',
    seo_keywords: null,
    seo_desc: null,
    seo_title: null,
    best_for: 'Dosas',
    special_info: '',
    also_serves: 'Dosas',
    'close-timing': '',
    address: '56, 9th A Main Road',
    direction_landmarks: 'Located in Indira Nagar',
    seating: 'Unavailable',
    longitude: '77.64097630979995',
    latitude: '12.9777060556',
    phone_no: '   ',
    image_url: null,
    location: 'Indira Nagar',
    cuisine: 'South Indian Tiffin',
    categories: 'Local Food',
    Tags: 'Mysore Masala Dosa' }]

[ RowDataPacket {...}]
[ RowDataPacket {...}]
[ RowDataPacket {...}]
[ RowDataPacket {...}]

My question is, how can I access the location key of the RowDataPacket Object?

I've tried various ways such as rows[i].location, rows[i]["location"], rows.location, rows[i].RowDataPacket.location, etc.

javascript mysql json

Answer 1

Answer №1

When you use console.log(rows);, the data is returned in JSON array format which can be accessed with the following code snippet:

$.each(rows, function(index, data){
// Check index and data details as shown below and perform additional tasks
console.log('INDEX=', index);
consoel.log('DATA=', data);  // The data here will be an object
// To access specific key data like location, you can use the code snippet below
console.log('LOCATION=', data.location);
});

For more information, you can visit the following link: https://api.jquery.com/each/

Answer 2

When you use console.log(rows);, the data is returned in JSON array format which can be accessed with the following code snippet:

$.each(rows, function(index, data){
// Check index and data details as shown below and perform additional tasks
console.log('INDEX=', index);
consoel.log('DATA=', data);  // The data here will be an object
// To access specific key data like location, you can use the code snippet below
console.log('LOCATION=', data.location);
});

For more information, you can visit the following link: https://api.jquery.com/each/

Retrieve a specific key from SQL records

Answer №1

Similar questions

jquery's animation causing elements to move abruptly when containing text

How to use a MySQL query to find multiple search terms within a single column

I have a task of initiating a request from JavaScript to a PHP file using an API

Converting a JSON array of key-value pairs into a Plain Old Java Object (POJO

Perform the subtraction operation on two boolean values using Typescript

Connect the value of the input field to the dataset

What is the method for specifying the HTML file extension within Visual Studio?

MySQL 1005 Error - Troubleshooting the Query Issue

Executing two AJAX requests simultaneously with Django, AJAX, and jQuery in a single event

What is the process for loading this image?

Enhancing JSON Objects in AngularJS with Custom Properties and Calculations

Unexpected behavior from MYSQL's fetch_assoc() when used with a LEFT JOIN statement

Tips for incorporating mapbox.js as a background while keeping html content and Navbar consistently displayed on top

Preventing Canvas Image Disappearance with JavaScript's onload Event

Initiate a server application from a client application

How can I make multiple elements change color when hovering with CSS?

What is the method for including HTML special characters in d3.js?

Is there a way to identify when a Tween.js animation has completed?

Issue with Internet Explorer: Refusing to run javascript included in AJAX-loaded content

Exploring AngularJS and Jasmine: Testing a controller function that interacts with a service via $http