Blob field

[otello45]

I am a newbie with php and I do not understand why the following code doesn't display any image I previously stored in mysql blob fields. The image type i get is correct, and if I get rid of header function the only thing displayed is the raw image data. All image files stored are not greater than 300K in size, the upload_max_filesize php directive is set to 2M and MySql max_allowed_packet = to 1M

 

I am using Uniform Server 3.2a. Can anyone help me?

 

<?php

include ("connet_info_mysql.php");

$idfoto = (isset($_GET["idfoto"])) ? $_GET["idfoto"] : exit();

$tam = (isset($_GET["tam"])) ? $_GET["tam"] : 1;

 

switch($tam) {

case "1":

$campo = "foto";break;

case "2":

$campo = "thumb";break;

default:

$campo = "foto";break;

}

 

$sql = "SELECT $campo, mime FROM tabellaFoto WHERE idfoto = $idfoto";

$link = mysql_connect(DBHOST, DBUSER, DBPASSWORD) or die(mysql_error($link)); // Connessione al database.

mysql_select_db(DBNAME, $link) or die(mysql_error($link));

$conn = mysql_query($sql, $link) or die(mysql_error($link));

$dati = mysql_fetch_array($conn);

$immagine = $dati[0];

$mime = $dati[1];

Header("Content-type: $mime");

echo $immagine;

//echo $mime;

?>

 

Could you also tell me how to change the MySql variable max_allowed_packet value when using Uniform Server?

[olajideolaolorun]

I will have to get back to you... i also had to did what you are about to do and it took me a while cause no one knew anything about it.... so i had to write from scratch and so on....

 

Its a simple function to retrieve the image but i can't remember it... have to check at home and get back to you tomorrow... just remind me.

[otello45]

I am a newbie with php and I do not understand why the following code doesn't display any image I previously stored in mysql blob fields. The image type i get is correct, and if I get rid of header function the only thing displayed is the raw image data. All image files stored are not greater than 300K in size, the upload_max_filesize php directive is set to 2M and MySql max_allowed_packet = to 1M

 

I am using Uniform Server 3.2a. Can anyone help me?

 

<?php

include ("connet_info_mysql.php");                                             

$idfoto = (isset($_GET["idfoto"])) ? $_GET["idfoto"] : exit();

$tam = (isset($_GET["tam"])) ? $_GET["tam"] : 1;

 

switch($tam) {

case "1":

  $campo = "foto";break;

case "2":

  $campo = "thumb";break;

default:

$campo = "foto";break;

}

 

$sql = "SELECT $campo, mime FROM tabellaFoto WHERE idfoto = $idfoto";         

$link = mysql_connect(DBHOST, DBUSER, DBPASSWORD) or die(mysql_error($link));  // Connessione al database.

mysql_select_db(DBNAME, $link) or die(mysql_error($link));                     

$conn = mysql_query($sql, $link) or die(mysql_error($link));                   

$dati = mysql_fetch_array($conn);

$immagine = $dati[0];                                                         

$mime = $dati[1];                                                             

Header("Content-type: $mime");

echo $immagine;                                                               

//echo $mime;

?>

 

Could you also tell me how to change the MySql variable max_allowed_packet value when using Uniform Server?

2509[/snapback]

 

Don't worry Oleji, I figure out the problem. I Simply take the include function off and wrote manually all the connection data such as DBHOST,DBUSER,... just stupidly defined in the include function itself. I also got how to change the max_allowed_packet variable hidden in the my.cnf file. Windows didn't show the extension of the file and that confused me a bit.

Thanks anyway Oleji, I read you and find you great. Sorry for my English

[olajideolaolorun]

No problem.....

[madhouse]

you should also put limit 0,1 on you sql query to make sure it only brings out 1

[olajideolaolorun]

If its a big Query...