fetching more than one row with long blob type through an exception called java.io.eofexception in andriod












0














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










share|improve this question
























  • 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
















0














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










share|improve this question
























  • 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














0












0








0







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










share|improve this question















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








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


















  • 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












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
});


}
});














draft saved

draft discarded


















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
















draft saved

draft discarded




















































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.




draft saved


draft discarded














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





















































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







Popular posts from this blog

Monofisismo

Angular Downloading a file using contenturl with Basic Authentication

Olmecas