android - Display image from MySql database in Php server -


i send image android application php server using mysql database, when try display image in browser doesn't work. how send picture

 string imagestring=base64.encodebytes(this.image);  namevaluepairs.add(new basicnamevaluepair("image", imagestring)); 

and how try display it

echo '<img src="data:image/jpeg;base64,'.base64_encode( $row['image'] ).'"/>'; 

i've checked , imagestring in app different base64_encode( $row['image']).

mysql part

$conn = new mysqli($server, $username, $password, $database); // check connection if ($conn->connect_error) {     die("connection failed: " . $conn->connect_error); }   // sql create table $sql = "create table posts ( id integer unsigned auto_increment primary key,  user varchar(50) not null, date varchar(12) not null, event varchar(1000), image blob )";  if ($conn->query($sql) === true) {     echo "table posts created successfully"; } else {     echo "error creating table: " . $conn->error; }  $conn->close();  $con = mysql_connect($server, $username, $password) or die ("could not connect: " . mysql_error()); mysql_select_db($database, $con); $user = $_post['user']; $date = $_post['date']; $event = $_post['event']; $image = $_post['image'];  echo "test"; $sql = "insert posts (user, date, event,image) "; $sql .= "values ('$user','$date', '$event', '$image')"; if (!mysql_query($sql, $con)) {  die('error: ' . mysql_error()); } else {  echo "insert success"; } mysql_close($con);   if ($result->num_rows > 0) {     // output data of each row      while($row = $result->fetch_assoc()) {         echo $row["user"]. $row["date"].  $row["event"].  "<br>";         echo '<img src="data:image/jpeg;base64,'.base64_encode( $row['image'] ).'"/>'; 

your java code doing base64 encode of image before sending server. not need encode second time when go display it. result base64 encoded string of base64 encoded string, isn't want do.

try instead:

echo '<img src="data:image/jpeg;base64,' . $row['image'] . '"/>'; 

Comments

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

linux - disk space limitation when creating war file -