fetching more than one row with long blob type through an exception called java.io.eofexception in andriod
selecting more than one row from database through an exception java.io.EOFException: source exhausted prematurely in andriod
please note that my image column is longblob
I send the result to andriod code
Please note again if I fetched any column with type int or var char it works correctly, longblob through this exception.
this is my php code
<?php
require "conn.php";
$aa =$_POST["cid"];
$mysql_qry = "select * from cities where ID = '$aa'";
$result = mysqli_query($conn,$mysql_qry);
$FinalArr = array();
$UserData ="-1";
$count =0;
$mysql_qry2 = "select * from images ";
$result2 = mysqli_query($conn,$mysql_qry2);
while ( $row2 = mysqli_fetch_array($result2))
{
if($row2["cityID"] == $aa)
{
$image1 = $row2["image"];
$imagearr = array($image1);
$FinalArr[$count] = array();
$FinalArr[$count] = $imagearr;
$count++;
}
}
$UserData = json_encode($FinalArr,JSON_UNESCAPED_UNICODE);
echo $UserData;
$conn->close();
?>
I want to select specific number of rows from table with long blob type
php sql
add a comment |
selecting more than one row from database through an exception java.io.EOFException: source exhausted prematurely in andriod
please note that my image column is longblob
I send the result to andriod code
Please note again if I fetched any column with type int or var char it works correctly, longblob through this exception.
this is my php code
<?php
require "conn.php";
$aa =$_POST["cid"];
$mysql_qry = "select * from cities where ID = '$aa'";
$result = mysqli_query($conn,$mysql_qry);
$FinalArr = array();
$UserData ="-1";
$count =0;
$mysql_qry2 = "select * from images ";
$result2 = mysqli_query($conn,$mysql_qry2);
while ( $row2 = mysqli_fetch_array($result2))
{
if($row2["cityID"] == $aa)
{
$image1 = $row2["image"];
$imagearr = array($image1);
$FinalArr[$count] = array();
$FinalArr[$count] = $imagearr;
$count++;
}
}
$UserData = json_encode($FinalArr,JSON_UNESCAPED_UNICODE);
echo $UserData;
$conn->close();
?>
I want to select specific number of rows from table with long blob type
php sql
That doesn't look like java.
– The Impaler
Dec 27 '18 at 20:23
@theImpaler yes this is php and andriod, it through this exception in andriod
– Eman Fateen
Dec 27 '18 at 20:26
Are you running PHP on Android? Or visiting a PHP powered web server/service through an Android browser/app?
– GolezTrol
Dec 27 '18 at 20:27
@GolezTrol visiting a PHP powered web server/service through an Android browser/app?
– Eman Fateen
Dec 27 '18 at 20:28
Allright. The error you're getting is quite generic, but is not coming from PHP itself. It seems to be that your query ran fine, or at least it ran, some content was sent to the Android client, which tried to use it, and threw the error. Perhaps because the Json returned was malformed,or so. Hard to tell. But I would start by making the same request that the app (or browser) does, and check if the results are what they should be. If so, it's not in the PHP script at all. If the output is wrong, then break it down to figure out why, but note that this error is not (directly) an SQL error.
– GolezTrol
Dec 27 '18 at 20:32
add a comment |
selecting more than one row from database through an exception java.io.EOFException: source exhausted prematurely in andriod
please note that my image column is longblob
I send the result to andriod code
Please note again if I fetched any column with type int or var char it works correctly, longblob through this exception.
this is my php code
<?php
require "conn.php";
$aa =$_POST["cid"];
$mysql_qry = "select * from cities where ID = '$aa'";
$result = mysqli_query($conn,$mysql_qry);
$FinalArr = array();
$UserData ="-1";
$count =0;
$mysql_qry2 = "select * from images ";
$result2 = mysqli_query($conn,$mysql_qry2);
while ( $row2 = mysqli_fetch_array($result2))
{
if($row2["cityID"] == $aa)
{
$image1 = $row2["image"];
$imagearr = array($image1);
$FinalArr[$count] = array();
$FinalArr[$count] = $imagearr;
$count++;
}
}
$UserData = json_encode($FinalArr,JSON_UNESCAPED_UNICODE);
echo $UserData;
$conn->close();
?>
I want to select specific number of rows from table with long blob type
php sql
selecting more than one row from database through an exception java.io.EOFException: source exhausted prematurely in andriod
please note that my image column is longblob
I send the result to andriod code
Please note again if I fetched any column with type int or var char it works correctly, longblob through this exception.
this is my php code
<?php
require "conn.php";
$aa =$_POST["cid"];
$mysql_qry = "select * from cities where ID = '$aa'";
$result = mysqli_query($conn,$mysql_qry);
$FinalArr = array();
$UserData ="-1";
$count =0;
$mysql_qry2 = "select * from images ";
$result2 = mysqli_query($conn,$mysql_qry2);
while ( $row2 = mysqli_fetch_array($result2))
{
if($row2["cityID"] == $aa)
{
$image1 = $row2["image"];
$imagearr = array($image1);
$FinalArr[$count] = array();
$FinalArr[$count] = $imagearr;
$count++;
}
}
$UserData = json_encode($FinalArr,JSON_UNESCAPED_UNICODE);
echo $UserData;
$conn->close();
?>
I want to select specific number of rows from table with long blob type
php sql
php sql
edited Dec 27 '18 at 20:25
asked Dec 27 '18 at 20:17
Eman Fateen
12
12
That doesn't look like java.
– The Impaler
Dec 27 '18 at 20:23
@theImpaler yes this is php and andriod, it through this exception in andriod
– Eman Fateen
Dec 27 '18 at 20:26
Are you running PHP on Android? Or visiting a PHP powered web server/service through an Android browser/app?
– GolezTrol
Dec 27 '18 at 20:27
@GolezTrol visiting a PHP powered web server/service through an Android browser/app?
– Eman Fateen
Dec 27 '18 at 20:28
Allright. The error you're getting is quite generic, but is not coming from PHP itself. It seems to be that your query ran fine, or at least it ran, some content was sent to the Android client, which tried to use it, and threw the error. Perhaps because the Json returned was malformed,or so. Hard to tell. But I would start by making the same request that the app (or browser) does, and check if the results are what they should be. If so, it's not in the PHP script at all. If the output is wrong, then break it down to figure out why, but note that this error is not (directly) an SQL error.
– GolezTrol
Dec 27 '18 at 20:32
add a comment |
That doesn't look like java.
– The Impaler
Dec 27 '18 at 20:23
@theImpaler yes this is php and andriod, it through this exception in andriod
– Eman Fateen
Dec 27 '18 at 20:26
Are you running PHP on Android? Or visiting a PHP powered web server/service through an Android browser/app?
– GolezTrol
Dec 27 '18 at 20:27
@GolezTrol visiting a PHP powered web server/service through an Android browser/app?
– Eman Fateen
Dec 27 '18 at 20:28
Allright. The error you're getting is quite generic, but is not coming from PHP itself. It seems to be that your query ran fine, or at least it ran, some content was sent to the Android client, which tried to use it, and threw the error. Perhaps because the Json returned was malformed,or so. Hard to tell. But I would start by making the same request that the app (or browser) does, and check if the results are what they should be. If so, it's not in the PHP script at all. If the output is wrong, then break it down to figure out why, but note that this error is not (directly) an SQL error.
– GolezTrol
Dec 27 '18 at 20:32
That doesn't look like java.
– The Impaler
Dec 27 '18 at 20:23
That doesn't look like java.
– The Impaler
Dec 27 '18 at 20:23
@theImpaler yes this is php and andriod, it through this exception in andriod
– Eman Fateen
Dec 27 '18 at 20:26
@theImpaler yes this is php and andriod, it through this exception in andriod
– Eman Fateen
Dec 27 '18 at 20:26
Are you running PHP on Android? Or visiting a PHP powered web server/service through an Android browser/app?
– GolezTrol
Dec 27 '18 at 20:27
Are you running PHP on Android? Or visiting a PHP powered web server/service through an Android browser/app?
– GolezTrol
Dec 27 '18 at 20:27
@GolezTrol visiting a PHP powered web server/service through an Android browser/app?
– Eman Fateen
Dec 27 '18 at 20:28
@GolezTrol visiting a PHP powered web server/service through an Android browser/app?
– Eman Fateen
Dec 27 '18 at 20:28
Allright. The error you're getting is quite generic, but is not coming from PHP itself. It seems to be that your query ran fine, or at least it ran, some content was sent to the Android client, which tried to use it, and threw the error. Perhaps because the Json returned was malformed,or so. Hard to tell. But I would start by making the same request that the app (or browser) does, and check if the results are what they should be. If so, it's not in the PHP script at all. If the output is wrong, then break it down to figure out why, but note that this error is not (directly) an SQL error.
– GolezTrol
Dec 27 '18 at 20:32
Allright. The error you're getting is quite generic, but is not coming from PHP itself. It seems to be that your query ran fine, or at least it ran, some content was sent to the Android client, which tried to use it, and threw the error. Perhaps because the Json returned was malformed,or so. Hard to tell. But I would start by making the same request that the app (or browser) does, and check if the results are what they should be. If so, it's not in the PHP script at all. If the output is wrong, then break it down to figure out why, but note that this error is not (directly) an SQL error.
– GolezTrol
Dec 27 '18 at 20:32
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%2f53950407%2ffetching-more-than-one-row-with-long-blob-type-through-an-exception-called-java%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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53950407%2ffetching-more-than-one-row-with-long-blob-type-through-an-exception-called-java%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
That doesn't look like java.
– The Impaler
Dec 27 '18 at 20:23
@theImpaler yes this is php and andriod, it through this exception in andriod
– Eman Fateen
Dec 27 '18 at 20:26
Are you running PHP on Android? Or visiting a PHP powered web server/service through an Android browser/app?
– GolezTrol
Dec 27 '18 at 20:27
@GolezTrol visiting a PHP powered web server/service through an Android browser/app?
– Eman Fateen
Dec 27 '18 at 20:28
Allright. The error you're getting is quite generic, but is not coming from PHP itself. It seems to be that your query ran fine, or at least it ran, some content was sent to the Android client, which tried to use it, and threw the error. Perhaps because the Json returned was malformed,or so. Hard to tell. But I would start by making the same request that the app (or browser) does, and check if the results are what they should be. If so, it's not in the PHP script at all. If the output is wrong, then break it down to figure out why, but note that this error is not (directly) an SQL error.
– GolezTrol
Dec 27 '18 at 20:32