yii2 Db column return Incorrect JSON
One of my columns in my db( levels table ) has JSON type.
When I write some query like this
1) $levels = Levels::find()
->select("level_permissions")
->column();
2) $levels = Levels::find()
->select("level_permissions")
->all();
In second(2) version I will get my json string in " quotes"
For example
"{"name":"level_name","active":"1","level_administering_level_id":"1"},"LevelAccessPermission":{"31":"1"}"
But in first(1) I have bug
it returns
""{"name":"level_name","active":"1","level_administering_level_id":"1"},"LevelAccessPermission":{"31":"1"} ""
and when I decode it I get
array(1) { [0]=> string(584) "{"lev_name":"ssssssssss","lev_active":"1","lev_administering_level_id":"1"},"LevelAccessPermission":{"31":"1"}}"
The problem is in quotes. in second version the string is in quotes, but when I use -> column(), I have some "" empty double quotes, then my json, then empty double quotes.
Why in column case ? I get double quotes before and after json. I have it only when I use yii2 -> column().
Any advice... Do you have some bug like this? Any idea?
json postgresql yii2 yii2-model
edited Nov 22 '18 at 23:00
rob006
9,49531032
asked Nov 22 '18 at 18:33
Lola_PadilyaLola_Padilya
336
add a comment |
One of my columns in my db( levels table ) has JSON type.
When I write some query like this
1) $levels = Levels::find()
->select("level_permissions")
->column();
2) $levels = Levels::find()
->select("level_permissions")
->all();
In second(2) version I will get my json string in " quotes"
For example
"{"name":"level_name","active":"1","level_administering_level_id":"1"},"LevelAccessPermission":{"31":"1"}"
But in first(1) I have bug
it returns
""{"name":"level_name","active":"1","level_administering_level_id":"1"},"LevelAccessPermission":{"31":"1"} ""
and when I decode it I get
array(1) { [0]=> string(584) "{"lev_name":"ssssssssss","lev_active":"1","lev_administering_level_id":"1"},"LevelAccessPermission":{"31":"1"}}"
The problem is in quotes. in second version the string is in quotes, but when I use -> column(), I have some "" empty double quotes, then my json, then empty double quotes.
Why in column case ? I get double quotes before and after json. I have it only when I use yii2 -> column().
Any advice... Do you have some bug like this? Any idea?
json postgresql yii2 yii2-model
edited Nov 22 '18 at 23:00
rob006
9,49531032
asked Nov 22 '18 at 18:33
Lola_PadilyaLola_Padilya
336
its hard to guess with this example data what could be the problem try adding the actual code and column in the code rather than generic example as the mistake could be anywhere may be you are overlooking and someone else can find it .
– Muhammad Omer Aslam
Nov 22 '18 at 21:42
I change it ... it's real example , part of my code...
– Lola_Padilya
Nov 22 '18 at 22:01
Which version of Yii you're using?
– rob006
Nov 22 '18 at 23:00
i use yii2 advanced
– Lola_Padilya
Nov 24 '18 at 14:25
add a comment |
One of my columns in my db( levels table ) has JSON type.
When I write some query like this
1) $levels = Levels::find()
->select("level_permissions")
->column();
2) $levels = Levels::find()
->select("level_permissions")
->all();
In second(2) version I will get my json string in " quotes"
For example
"{"name":"level_name","active":"1","level_administering_level_id":"1"},"LevelAccessPermission":{"31":"1"}"
But in first(1) I have bug
it returns
""{"name":"level_name","active":"1","level_administering_level_id":"1"},"LevelAccessPermission":{"31":"1"} ""
and when I decode it I get
array(1) { [0]=> string(584) "{"lev_name":"ssssssssss","lev_active":"1","lev_administering_level_id":"1"},"LevelAccessPermission":{"31":"1"}}"
The problem is in quotes. in second version the string is in quotes, but when I use -> column(), I have some "" empty double quotes, then my json, then empty double quotes.
Why in column case ? I get double quotes before and after json. I have it only when I use yii2 -> column().
Any advice... Do you have some bug like this? Any idea?
json postgresql yii2 yii2-model
edited Nov 22 '18 at 23:00
rob006
9,49531032
asked Nov 22 '18 at 18:33
Lola_PadilyaLola_Padilya
336
One of my columns in my db( levels table ) has JSON type.
When I write some query like this
1) $levels = Levels::find()
->select("level_permissions")
->column();
2) $levels = Levels::find()
->select("level_permissions")
->all();
In second(2) version I will get my json string in " quotes"
For example
"{"name":"level_name","active":"1","level_administering_level_id":"1"},"LevelAccessPermission":{"31":"1"}"
But in first(1) I have bug
it returns
""{"name":"level_name","active":"1","level_administering_level_id":"1"},"LevelAccessPermission":{"31":"1"} ""
and when I decode it I get
array(1) { [0]=> string(584) "{"lev_name":"ssssssssss","lev_active":"1","lev_administering_level_id":"1"},"LevelAccessPermission":{"31":"1"}}"
The problem is in quotes. in second version the string is in quotes, but when I use -> column(), I have some "" empty double quotes, then my json, then empty double quotes.
Why in column case ? I get double quotes before and after json. I have it only when I use yii2 -> column().
Any advice... Do you have some bug like this? Any idea?
json postgresql yii2 yii2-model
json postgresql yii2 yii2-model
edited Nov 22 '18 at 23:00
rob006
9,49531032
asked Nov 22 '18 at 18:33
Lola_PadilyaLola_Padilya
336
edited Nov 22 '18 at 23:00
rob006
9,49531032
asked Nov 22 '18 at 18:33
Lola_PadilyaLola_Padilya
336
edited Nov 22 '18 at 23:00
rob006
9,49531032
edited Nov 22 '18 at 23:00
rob006
9,49531032
edited Nov 22 '18 at 23:00
rob006
9,49531032
9,49531032
asked Nov 22 '18 at 18:33
Lola_PadilyaLola_Padilya
336
asked Nov 22 '18 at 18:33
Lola_PadilyaLola_Padilya
336
asked Nov 22 '18 at 18:33
Lola_PadilyaLola_Padilya
336
336
its hard to guess with this example data what could be the problem try adding the actual code and column in the code rather than generic example as the mistake could be anywhere may be you are overlooking and someone else can find it .
– Muhammad Omer Aslam
Nov 22 '18 at 21:42
I change it ... it's real example , part of my code...
– Lola_Padilya
Nov 22 '18 at 22:01
Which version of Yii you're using?
– rob006
Nov 22 '18 at 23:00
i use yii2 advanced
– Lola_Padilya
Nov 24 '18 at 14:25
add a comment |
its hard to guess with this example data what could be the problem try adding the actual code and column in the code rather than generic example as the mistake could be anywhere may be you are overlooking and someone else can find it .
– Muhammad Omer Aslam
Nov 22 '18 at 21:42
I change it ... it's real example , part of my code...
– Lola_Padilya
Nov 22 '18 at 22:01
Which version of Yii you're using?
– rob006
Nov 22 '18 at 23:00
i use yii2 advanced
– Lola_Padilya
Nov 24 '18 at 14:25
its hard to guess with this example data what could be the problem try adding the actual code and column in the code rather than generic example as the mistake could be anywhere may be you are overlooking and someone else can find it .
– Muhammad Omer Aslam
Nov 22 '18 at 21:42
its hard to guess with this example data what could be the problem try adding the actual code and column in the code rather than generic example as the mistake could be anywhere may be you are overlooking and someone else can find it .
– Muhammad Omer Aslam
Nov 22 '18 at 21:42
I change it ... it's real example , part of my code...
– Lola_Padilya
Nov 22 '18 at 22:01
I change it ... it's real example , part of my code...
– Lola_Padilya
Nov 22 '18 at 22:01
Which version of Yii you're using?
– rob006
Nov 22 '18 at 23:00
Which version of Yii you're using?
– rob006
Nov 22 '18 at 23:00
i use yii2 advanced
– Lola_Padilya
Nov 24 '18 at 14:25
i use yii2 advanced
– Lola_Padilya
Nov 24 '18 at 14:25
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%2f53436518%2fyii2-db-column-return-incorrect-json%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%2f53436518%2fyii2-db-column-return-incorrect-json%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
its hard to guess with this example data what could be the problem try adding the actual code and column in the code rather than generic example as the mistake could be anywhere may be you are overlooking and someone else can find it .
– Muhammad Omer Aslam
Nov 22 '18 at 21:42
I change it ... it's real example , part of my code...
– Lola_Padilya
Nov 22 '18 at 22:01
Which version of Yii you're using?
– rob006
Nov 22 '18 at 23:00
i use yii2 advanced
– Lola_Padilya
Nov 24 '18 at 14:25