3 replies to this topic

[monmohnish]

Hi all,i have uploaded images in database using php but unable to retrieve it.Plz help me.Am attaching the code for uploading and retrieving images ..plzz check and correct my mistakes.......
you can even mail me to mohnish34@gmail.com

Thanks in advance.

Attached Files

•  html page.txt   566bytes   114 downloads
•  uploading.txt   1.18KB   119 downloads
•  uploading.txt   1.18KB   100 downloads

[Orjan]

what's your error/problem?

[Orjan]

I would do this:
This handles both POST and GET, and the case of non-existing ID

if (isset($_POST['id']) || $_POST['id'] != "") {
  $id = mysql_real_string_escape($_POST['id']);
} else if (isset($_GET['id']) || $_GET['id'] != "") {
  $id = mysql_real_string_escape($_GET['id']);
} else {
  die("ID is missing");
}
  $query = mysql_query("SELECT * FROM tbl_images WHERE id='".$id."'");
  if (mysql_num_rows($query) > 0) {
  $row = mysql_fetch_array($query);
  $content = $row['image'];
  header('Content-type: image/jpg');
  echo $content;
} else {
  die ("Cannot find ID");
}

[Orjan]

mysql_real_string_escape should of course be mysql_real_escape_string