convert rowdatapacket into array , How to convert mysql node.js api rowdatapacket to array , string to array
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
please help me to convert my rowdatapacket into array of array or nested array
enter code here
router.get('/getPosts/:user_id', (req, res, next) => {
connection.query('SELECT * FROM files WHERE user_id = ?', [req.params.user_id], (err, rows, fields) => {
if (!err) {
resultArray = JSON.parse(JSON.stringify(rows));
console.log(resultArray);
return res.status(200).send(resultArray);
} else {
console.log(err);
return res.status(404).send('Sorry user_id does not exits');
}
})
});
OUTPUT
javascript mysql arrays node.js string
asked Jan 4 at 14:21
Sivasankar chimataSivasankar chimata
13
add a comment |
please help me to convert my rowdatapacket into array of array or nested array
enter code here
router.get('/getPosts/:user_id', (req, res, next) => {
connection.query('SELECT * FROM files WHERE user_id = ?', [req.params.user_id], (err, rows, fields) => {
if (!err) {
resultArray = JSON.parse(JSON.stringify(rows));
console.log(resultArray);
return res.status(200).send(resultArray);
} else {
console.log(err);
return res.status(404).send('Sorry user_id does not exits');
}
})
});
OUTPUT
javascript mysql arrays node.js string
asked Jan 4 at 14:21
Sivasankar chimataSivasankar chimata
13
1
Possible duplicate of How to access a RowDataPacket object
– HMR
Jan 4 at 14:31
add a comment |
please help me to convert my rowdatapacket into array of array or nested array
enter code here
router.get('/getPosts/:user_id', (req, res, next) => {
connection.query('SELECT * FROM files WHERE user_id = ?', [req.params.user_id], (err, rows, fields) => {
if (!err) {
resultArray = JSON.parse(JSON.stringify(rows));
console.log(resultArray);
return res.status(200).send(resultArray);
} else {
console.log(err);
return res.status(404).send('Sorry user_id does not exits');
}
})
});
OUTPUT
javascript mysql arrays node.js string
asked Jan 4 at 14:21
Sivasankar chimataSivasankar chimata
13
please help me to convert my rowdatapacket into array of array or nested array
enter code here
router.get('/getPosts/:user_id', (req, res, next) => {
connection.query('SELECT * FROM files WHERE user_id = ?', [req.params.user_id], (err, rows, fields) => {
if (!err) {
resultArray = JSON.parse(JSON.stringify(rows));
console.log(resultArray);
return res.status(200).send(resultArray);
} else {
console.log(err);
return res.status(404).send('Sorry user_id does not exits');
}
})
});
OUTPUT
javascript mysql arrays node.js string
javascript mysql arrays node.js string
asked Jan 4 at 14:21
Sivasankar chimataSivasankar chimata
13
asked Jan 4 at 14:21
Sivasankar chimataSivasankar chimata
13
edited Jan 4 at 14:27
Sivasankar chimata
asked Jan 4 at 14:21
Sivasankar chimataSivasankar chimata
13
asked Jan 4 at 14:21
Sivasankar chimataSivasankar chimata
13
asked Jan 4 at 14:21
Sivasankar chimataSivasankar chimata
13
13
1
Possible duplicate of How to access a RowDataPacket object
– HMR
Jan 4 at 14:31
add a comment |
1
Possible duplicate of How to access a RowDataPacket object
– HMR
Jan 4 at 14:31
1
1
Possible duplicate of How to access a RowDataPacket object
– HMR
Jan 4 at 14:31
Possible duplicate of How to access a RowDataPacket object
– HMR
Jan 4 at 14:31
add a comment |
1 Answer
1
active
oldest
votes
OutPut:
{ post_id: 17,
user_id: 1,
description: ' Hi How are you ',
file_name: 'iron_man_5k_2.jpg,iron_man_captain.jpg',
mimetype: 'image/jpeg,image/jpeg',
size: '5696459,180',
saved_name:
'1546438737564_iron_man_5k_2.jpg,1546438737672_iron_man_captain.jpg',
file_path:
'uploads1546438737564_iron_man_5k_2.jpg,uploads1546438737672_iron_man_captain.jpg',
created: '2019-01-02T14:18:57.000Z' }
answered Jan 4 at 14:58
Sivasankar chimataSivasankar chimata
13
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54040754%2fconvert-rowdatapacket-into-array-how-to-convert-mysql-node-js-api-rowdatapacke%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
OutPut:
{ post_id: 17,
user_id: 1,
description: ' Hi How are you ',
file_name: 'iron_man_5k_2.jpg,iron_man_captain.jpg',
mimetype: 'image/jpeg,image/jpeg',
size: '5696459,180',
saved_name:
'1546438737564_iron_man_5k_2.jpg,1546438737672_iron_man_captain.jpg',
file_path:
'uploads1546438737564_iron_man_5k_2.jpg,uploads1546438737672_iron_man_captain.jpg',
created: '2019-01-02T14:18:57.000Z' }
answered Jan 4 at 14:58
Sivasankar chimataSivasankar chimata
13
add a comment |
OutPut:
{ post_id: 17,
user_id: 1,
description: ' Hi How are you ',
file_name: 'iron_man_5k_2.jpg,iron_man_captain.jpg',
mimetype: 'image/jpeg,image/jpeg',
size: '5696459,180',
saved_name:
'1546438737564_iron_man_5k_2.jpg,1546438737672_iron_man_captain.jpg',
file_path:
'uploads1546438737564_iron_man_5k_2.jpg,uploads1546438737672_iron_man_captain.jpg',
created: '2019-01-02T14:18:57.000Z' }
answered Jan 4 at 14:58
Sivasankar chimataSivasankar chimata
13
add a comment |
OutPut:
{ post_id: 17,
user_id: 1,
description: ' Hi How are you ',
file_name: 'iron_man_5k_2.jpg,iron_man_captain.jpg',
mimetype: 'image/jpeg,image/jpeg',
size: '5696459,180',
saved_name:
'1546438737564_iron_man_5k_2.jpg,1546438737672_iron_man_captain.jpg',
file_path:
'uploads1546438737564_iron_man_5k_2.jpg,uploads1546438737672_iron_man_captain.jpg',
created: '2019-01-02T14:18:57.000Z' }
answered Jan 4 at 14:58
Sivasankar chimataSivasankar chimata
13
OutPut:
{ post_id: 17,
user_id: 1,
description: ' Hi How are you ',
file_name: 'iron_man_5k_2.jpg,iron_man_captain.jpg',
mimetype: 'image/jpeg,image/jpeg',
size: '5696459,180',
saved_name:
'1546438737564_iron_man_5k_2.jpg,1546438737672_iron_man_captain.jpg',
file_path:
'uploads1546438737564_iron_man_5k_2.jpg,uploads1546438737672_iron_man_captain.jpg',
created: '2019-01-02T14:18:57.000Z' }
answered Jan 4 at 14:58
Sivasankar chimataSivasankar chimata
13
answered Jan 4 at 14:58
Sivasankar chimataSivasankar chimata
13
answered Jan 4 at 14:58
Sivasankar chimataSivasankar chimata
13
answered Jan 4 at 14:58
Sivasankar chimataSivasankar chimata
13
13
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54040754%2fconvert-rowdatapacket-into-array-how-to-convert-mysql-node-js-api-rowdatapacke%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Possible duplicate of How to access a RowDataPacket object
– HMR
Jan 4 at 14:31