undesirable data stored in database
i have created two aws instances in both of which i am storing data in mysql database by taking input from web server while in one of which i am taking userid and password as input while on the other its just a long string while in username and password the data gets stored as required but in the comment storing database it just stored '|-|' as output on the database when the string size was put to 5000 while when put to 10 it stores '_' replacing everything that my client(on test purpose i am only the client) has sent please help me to resolve this issue and i cant debug the whole thing as i am doing th esame thing with my other instance and its working fine so help will be appreciated
this image shows what the database of my two instances are storing
php html mysql amazon-web-services mysqli
add a comment |
i have created two aws instances in both of which i am storing data in mysql database by taking input from web server while in one of which i am taking userid and password as input while on the other its just a long string while in username and password the data gets stored as required but in the comment storing database it just stored '|-|' as output on the database when the string size was put to 5000 while when put to 10 it stores '_' replacing everything that my client(on test purpose i am only the client) has sent please help me to resolve this issue and i cant debug the whole thing as i am doing th esame thing with my other instance and its working fine so help will be appreciated
this image shows what the database of my two instances are storing
php html mysql amazon-web-services mysqli
add a comment |
i have created two aws instances in both of which i am storing data in mysql database by taking input from web server while in one of which i am taking userid and password as input while on the other its just a long string while in username and password the data gets stored as required but in the comment storing database it just stored '|-|' as output on the database when the string size was put to 5000 while when put to 10 it stores '_' replacing everything that my client(on test purpose i am only the client) has sent please help me to resolve this issue and i cant debug the whole thing as i am doing th esame thing with my other instance and its working fine so help will be appreciated
this image shows what the database of my two instances are storing
php html mysql amazon-web-services mysqli
i have created two aws instances in both of which i am storing data in mysql database by taking input from web server while in one of which i am taking userid and password as input while on the other its just a long string while in username and password the data gets stored as required but in the comment storing database it just stored '|-|' as output on the database when the string size was put to 5000 while when put to 10 it stores '_' replacing everything that my client(on test purpose i am only the client) has sent please help me to resolve this issue and i cant debug the whole thing as i am doing th esame thing with my other instance and its working fine so help will be appreciated
this image shows what the database of my two instances are storing
php html mysql amazon-web-services mysqli
php html mysql amazon-web-services mysqli
asked Nov 21 '18 at 5:54


Soumya MitraSoumya Mitra
63
63
add a comment |
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%2f53406012%2fundesirable-data-stored-in-database%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%2f53406012%2fundesirable-data-stored-in-database%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