Flutter - split SQL Query result
This is a very basic question which I'm sure theres an easy answer to.
I have a database and a PHP server which currently pulls all data from the table (for testing purposes).
The result looks like this
["post_id":"1","createdon":"2018-11-10","content":"This is my first post","post_id":"2","createdon":"2018-11-10","content":"This is my second post"]
How would I in Flutter take the content of post_id[1], and load it into my array[0], and same with post_id[2] into my array[1]?
php

add a comment |
This is a very basic question which I'm sure theres an easy answer to.
I have a database and a PHP server which currently pulls all data from the table (for testing purposes).
The result looks like this
["post_id":"1","createdon":"2018-11-10","content":"This is my first post","post_id":"2","createdon":"2018-11-10","content":"This is my second post"]
How would I in Flutter take the content of post_id[1], and load it into my array[0], and same with post_id[2] into my array[1]?
php

so is it basically breaking apart the json string. sorry completely new to development, and just getting my head round everything
– Dali546
Nov 12 '18 at 12:58
yup found a good link. stackoverflow.com/questions/50706500/…. I just needed to import dart.convert
– Dali546
Nov 12 '18 at 13:01
Solution found at stackoverflow.com/questions/50706500/…
– Dali546
Nov 12 '18 at 13:01
yes i am aware of flutter.io. but I found my answer. I will take a look at the documentation also
– Dali546
Nov 12 '18 at 13:05
flutter.io/docs/development/data-and-backend/json
– pskink
Nov 12 '18 at 13:10
add a comment |
This is a very basic question which I'm sure theres an easy answer to.
I have a database and a PHP server which currently pulls all data from the table (for testing purposes).
The result looks like this
["post_id":"1","createdon":"2018-11-10","content":"This is my first post","post_id":"2","createdon":"2018-11-10","content":"This is my second post"]
How would I in Flutter take the content of post_id[1], and load it into my array[0], and same with post_id[2] into my array[1]?
php

This is a very basic question which I'm sure theres an easy answer to.
I have a database and a PHP server which currently pulls all data from the table (for testing purposes).
The result looks like this
["post_id":"1","createdon":"2018-11-10","content":"This is my first post","post_id":"2","createdon":"2018-11-10","content":"This is my second post"]
How would I in Flutter take the content of post_id[1], and load it into my array[0], and same with post_id[2] into my array[1]?
php

php

edited Nov 12 '18 at 12:57
Vadim Kotov
4,37953247
4,37953247
asked Nov 12 '18 at 12:49


Dali546Dali546
13
13
so is it basically breaking apart the json string. sorry completely new to development, and just getting my head round everything
– Dali546
Nov 12 '18 at 12:58
yup found a good link. stackoverflow.com/questions/50706500/…. I just needed to import dart.convert
– Dali546
Nov 12 '18 at 13:01
Solution found at stackoverflow.com/questions/50706500/…
– Dali546
Nov 12 '18 at 13:01
yes i am aware of flutter.io. but I found my answer. I will take a look at the documentation also
– Dali546
Nov 12 '18 at 13:05
flutter.io/docs/development/data-and-backend/json
– pskink
Nov 12 '18 at 13:10
add a comment |
so is it basically breaking apart the json string. sorry completely new to development, and just getting my head round everything
– Dali546
Nov 12 '18 at 12:58
yup found a good link. stackoverflow.com/questions/50706500/…. I just needed to import dart.convert
– Dali546
Nov 12 '18 at 13:01
Solution found at stackoverflow.com/questions/50706500/…
– Dali546
Nov 12 '18 at 13:01
yes i am aware of flutter.io. but I found my answer. I will take a look at the documentation also
– Dali546
Nov 12 '18 at 13:05
flutter.io/docs/development/data-and-backend/json
– pskink
Nov 12 '18 at 13:10
so is it basically breaking apart the json string. sorry completely new to development, and just getting my head round everything
– Dali546
Nov 12 '18 at 12:58
so is it basically breaking apart the json string. sorry completely new to development, and just getting my head round everything
– Dali546
Nov 12 '18 at 12:58
yup found a good link. stackoverflow.com/questions/50706500/…. I just needed to import dart.convert
– Dali546
Nov 12 '18 at 13:01
yup found a good link. stackoverflow.com/questions/50706500/…. I just needed to import dart.convert
– Dali546
Nov 12 '18 at 13:01
Solution found at stackoverflow.com/questions/50706500/…
– Dali546
Nov 12 '18 at 13:01
Solution found at stackoverflow.com/questions/50706500/…
– Dali546
Nov 12 '18 at 13:01
yes i am aware of flutter.io. but I found my answer. I will take a look at the documentation also
– Dali546
Nov 12 '18 at 13:05
yes i am aware of flutter.io. but I found my answer. I will take a look at the documentation also
– Dali546
Nov 12 '18 at 13:05
flutter.io/docs/development/data-and-backend/json
– pskink
Nov 12 '18 at 13:10
flutter.io/docs/development/data-and-backend/json
– pskink
Nov 12 '18 at 13:10
add a comment |
0
active
oldest
votes
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%2f53262541%2fflutter-split-sql-query-result%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53262541%2fflutter-split-sql-query-result%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
so is it basically breaking apart the json string. sorry completely new to development, and just getting my head round everything
– Dali546
Nov 12 '18 at 12:58
yup found a good link. stackoverflow.com/questions/50706500/…. I just needed to import dart.convert
– Dali546
Nov 12 '18 at 13:01
Solution found at stackoverflow.com/questions/50706500/…
– Dali546
Nov 12 '18 at 13:01
yes i am aware of flutter.io. but I found my answer. I will take a look at the documentation also
– Dali546
Nov 12 '18 at 13:05
flutter.io/docs/development/data-and-backend/json
– pskink
Nov 12 '18 at 13:10