mysql - PHP - BLOB image rotation when uploading from phone -


disclaimer: understand storing images in directory vs. database better way go, please humour me sake of learning. thank in advance help.

i'm having issue rotating image when uploading database blob , displaying when user logs in.

i have tested multiple methods of upload , found following:

the image rotated when:
1) choosing file, clicking "take photo" mobile device.

rotated image

the image not rotated when:
1) choosing file, clicking "from gallery" mobile device.
2) screenshot of image taken , uploaded using desktop computer.
3) image imported using application such iphoto , uploaded.

not rotated image

upload.php - upload image database.

<?php  require_once "../config/config.php"; session_start();  if(empty($_session['id'])) {   header("location: ../login/login.html"); } else {   $id = $_session['id']; }  include "fetchavatar.php";  if(!empty($_files['avatar']['name']) && (isset($_post['upload']))) {   $name = $_files['avatar']['name'];   $temp = $_files['avatar']['tmp_name'];   $size = $_files['avatar']['size'];   $type = $_files['avatar']['type'];    $fp = fopen($temp, 'r');   $img = fread($fp, filesize($temp));   fclose($fp);    if($fetchedrows) {     $stmt = $con->prepare("update avatars set name = ?, type = ?, size = ?, data = ? user_id = ?;");   } else {     $stmt = $con->prepare("insert avatars (name, type, size, data, user_id) values(?, ?, ?, ?, ?);");   }      $stmt->bindparam(1, $name);     $stmt->bindparam(2, $type);     $stmt->bindparam(3, $size);     $stmt->bindparam(4, $img);     $stmt->bindparam(5, $id);     $stmt->execute();  }  header("location: profile.php");  ?>

fetchavatar.php - select image database, store html + image $avatar.

<?php  require_once "../config/config.php"; session_start();  $id = $_session['id'];  $stmt = $con->prepare("select * avatars user_id = ?"); $stmt->bindparam(1, $id); $stmt->execute(); $result = $stmt->fetch(pdo::fetch_assoc);  $fetchedrows = $stmt->rowcount();  $_session['avatar'] = base64_encode($result['data']); $avatar = "<img src='data:image/jpeg;base64,". $_session['avatar']. "' width='100' height='100'>";  ?>

profile.php - profile page.

<?php  session_start(); include "fetchavatar.php";  ?>  <html> <body>  <div id="profile_div">  <h1>profile page</h1>    <?php echo $avatar ?>    ...  </body> </html>

here example of latest attempt @ rotating image. when attempting method, blob data uploaded blank , image no longer displayed. have tried multiple solutions offered here have not been successful in either implementing code correctly or knowing if i'm on right track.

upload.php

<?php  ...  include "fetchavatar.php";  if(!empty($_files['avatar']['name']) && (isset($_post['upload']))) {   $name = $_files['avatar']['name'];   $temp = $_files['avatar']['tmp_name'];   $size = $_files['avatar']['size'];   $type = $_files['avatar']['type'];     $image = imagecreatefromstring(file_get_contents($temp));   $exif = exif_read_data($temp);   if(!empty($exif['orientation'])) {     switch($exif['orientation']) {         case 8:             $image = imagerotate($image,90,0);             break;         case 3:             $image = imagerotate($image,180,0);             break;         case 6:             $image = imagerotate($image,-90,0);             break;      }   }    $fp = fopen($image, 'r');   $img = fread($fp, filesize($image));   fclose($fp);    if($fetchedrows) {     $stmt = $con->prepare("update avatars set name = ?, type = ?, size = ?, data = ? user_id = ?;");   } else {     $stmt = $con->prepare("insert avatars (name, type, size, data, user_id) values(?, ?, ?, ?, ?);");   }      $stmt->bindparam(1, $name);     $stmt->bindparam(2, $type);     $stmt->bindparam(3, $size);     $stmt->bindparam(4, $img);     $stmt->bindparam(5, $id);     $stmt->execute();  }  header("location: profile.php");  ?>

in last upload.php example looks attempting fopen() image resource instead of image file on file system. try changing the

$fp = fopen($image, 'r'); $img = fread($fp, filesize($image)); fclose($fp);

to

ob_start(); imagejpeg($image); $img = addslashes(ob_get_clean());

this write image resource string can inserted database.

this modified output file system instead of database, should ever change application.


-

Comments

Post a Comment

Popular posts from this blog

What Are The Best Universities In The World?

Harvard and Yale are often referred to as “the best of the best”. But when it comes to the highest ranked universities, these and other Ivy League schools don't even make it into the top five. So what are the world's best universities? Well, according to an index by the Times Higher Education, Stanford ranks 3rd in the world. Most people associate Stanford with tech-capital Silicon Valley, which is where the school is located. And in fact, it's largely because of Stanford that the region is now the global capital of entrepreneurship and technology. In the 1940's and 50's the university heavily encouraged students and faculty to start their own companies, eventually leading to companies like Google and Snapchat. And still today, the school is known to produce some of the most successful entrepreneurs. A Stanford degree is in extremely high demand, and the school maintains the lowest acceptance rate in the country, admitting less than 5 percent of applicants. Much ...
Read more

Hard vs. Soft Water: What's The Difference?

Hard or Soft? HOW AM I SUPPOSED TO KNOW? THEY BOTH LOOK EXACTLY THE SAME! Hey there, Sapna here for Dnews. From the outside, all water is seemingly the same: clear, mostly flavorless, two hydrogens, one oxygen. But once you get past the basics, water is actually pretty versatile. It can be distilled, filtered, tap, bottled, and if you're real fancy, there's water marketed as kosher, organic or kabbalah. But did you know water can also be hard or soft? No, this isn't to describe how the water actually feels. It actually has to do with its mineral content. Water becomes ‘hard' when it has a higher than normal concentration of minerals, primarily calcium and magnesium. Water picks up these minerals from rocks and soil as it flows through rivers, wells or other waterways. Soft water, on the other hand, has a low mineral content, either because it has not yet flowed through rocks or wells - like rain water - or because the rocks it has come in contact with have little to no...
Read more

The Ten Most Livable Cities In The World

Every year, the Economist Intelligence Unit releases its ranking of the “most livable cities” in the world. Therein, they attempt to quantify what exactly makes living in a city better or worse. It generally breaks down into five categories: stability, healthcare, culture and environment, education, and infrastructure. So, what are the world's most livable cities? Well, in fact, the top seven cities actually comprise just three countries, with six countries total in the top ten. Although it is not true everywhere, countries with effective policies tend to see positive effects country-wide. However, many major cities around the world can actually be victims of their own success. Cities like New York City or London are world renown, but also have higher crime rates, overpopulation leading to infrastructure failure, and often much higher costs of living. The cities in this list are able to avoid those pitfalls. The top ranked city in the world is Melbourne Australia, a title it has...
Read more