My object has the following structure:
Object {Dry Aged Ribeye(medium): "1"
, Dry Aged Ribeye(rare): "1"
, Dry Aged Ribeye(well): "1"
, favorite_tables: "{"dc76e9f0c0006e8f919e0c515c66dbba3982f785":[]}"
}
I am trying to insert this into MySQL in a single column as is. However, when I attempt to do so, it just displays [object Object]. I have attempted methods like JSON.stringify and Array.join(), but they have not worked.
Can you help me convert this object into a string?
Uncertain if your object's keys are valid, but you can try using JSON.stringify to convert an object into a string.
var newObj = {key:'value'};
console.log(JSON.stringify(newObj));
If you're having trouble creating your JSON object, pay close attention to how you're defining the keys. It's important to wrap them in quotation marks (or "stringify" them).
let myObj = {
'Dry Aged Ribeye(medium)': "1"
, 'Dry Aged Ribeye(rare)': "1"
, 'Dry Aged Ribeye(well)': "1"
, 'favorite_tables' : {"dc76e9f0c0006e8f919e0c515c66dbba3982f785":[]}
};
console.log(JSON.stringify(myObj));
When dealing with keys that have spaces in them, it is important to remember to enclose them in quotes.
var myObject ={"Dry Aged Ribeye(medium)": "1",
"Dry Aged Ribeye(rare)": "1",
"Dry Aged Ribeye(well)": "1",
"favorite_tables": "{'dc76e9f0c0006e8f919e0c515c66dbba3982f785':[]}"
}
To handle the situation where double quotes are present within favorite_tables, one option is to replace them with single quotes. Alternatively, they can be escaped using \"
After making these adjustments, JSON.stringify should function correctly
I encountered a significant problem. Here is the breakdown of my application architecture: nginx -> web app (express/nodejs) -> api (jetty/java) -> mysql The performance of the API application is optimized, with response times around 200ms/req ...
I have integrated the jQuery DataTables Select plugin into my project to enable the selection of multiple rows from a table and storing their data inside an array. Subsequently, I am attempting to make an Ajax Request to pass this array to another PHP file ...
I've encountered an issue while trying to test my component unit. The problem arises when I call the product-list.component.ts from my product.service.ts. While my product.service.spec.ts is successful, the product-list.component.spec.ts fails as the ...
I created the following function: retrieveLikedProperties(): AngularFirestoreCollection<any> { return this.afs.collection('users', ref => ref.where('uid', '==', this._auth.currentUserId) .where(&a ...
I am currently working on positioning the Google Maps searchbox variable in a way that allows it to stay fixed under markers as they are listed. I am utilizing the Angular Google Maps library for this purpose, which provides a directive known as <ui-g ...
My goal was to determine when the user is interacting with an INPUT or TEXTAREA element and set a flag variable to true during this engagement. Once the user clicks out of these elements, the flag should be set back to false. To achieve this, I utilized j ...
I am genuinely curious about this: I thought that the following code would be valid within an HTML document: <script> var test = "<script>why? </script>"; </script> However, it turns out that this leads to an "unterminated str ...
Thank you for taking the time to explore and respond, your input is valuable! In my database, I have two tables - Properties storing information about different properties, and Translations holding data like title and description in multiple languages. T ...
I am attempting to display a text when different options are selected from the dropdown list. Here is the code for the drop-down list: <div class="dropdown"> <select class="form-control" id="ltype" name="ltype"> <option value=""&g ...
I have a dropdown menu containing staff names and StaffId. These are linked to an appointment business logic. I am attempting to activate a select change event where dates stored in the database will be marked as unavailable in the connected jQuery datet ...
Is there a way to add a new certificate to the list of certificates node trusts, even after some struggle? It appears that Node only trusts certificates hardcoded in its list located here: https://github.com/nodejs/node/blob/master/src/node_root_certs.h ...
After successfully running my GradeCalc function in a MVC C# context with the grade parameter, I am facing an issue where the data is not displaying and the JavaScript alert pop up shows up blank. Can you assist me with this problem? $("#test").o ...
There is a Base generic class: abstract class BaseClass<T> { abstract itemArray: Array<T>; static getName(): string { throw new Error(`BaseClass - 'getName' was not overridden!`); } internalLogic() {} } and its inherito ...
I've come across similar inquiries, but none of them quite match my situation. When a user clicks on one of the buttons in my app, it triggers a get request to fetch data and then displays that data on the screen. However, the issue arises when I nav ...
Just starting out with coding and tackling my initial project using reactJs and bootstrap 5. My aim is to create a sticky side navbar that remains fixed on the side while my content displays next to it, even when navigating through different routes. Unfort ...
I have 3 different files that are crucial for my webpage to function properly: index.html: <html> <head> </head> <body> <h1>Webpage</h1> <p id = "text">Hello world!</p> <button oncl ...
I'm currently working on integrating a custom control into my map using OpenLayers with Vue.js. The Explore.vue component is responsible for creating the "map" (olmap) with OL, and I bind it to the child component LeftSideBar2.vue. However, when att ...
I am facing an issue with my TreePanel where I want to preselect a specific node when loading it. The nodes are fetched from a remote json file and the tree structure loads correctly. However, the selected node is not getting highlighted and Firebug is sho ...
Can someone help me figure out how to store multiple values from a selection and then create an array using jQuery? Here's the scenario: In my multiple selection, I have 5 values: <select name="animal" id="animal" multiple="multiple"> ...
Imagine having an array called 'newArray'. var newArray = []; You can add strings to it like this: var thisString = 'watch'; newArray.push(thisString); Now, if you want to have 50 instances of the 'thisString' in the newAr ...