Hi, I am a newbie in php. I have to upload an Image to a BLOB field in Mysql. But when
I insert the field it save the path of the image file and not the image itself.
This is the code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Upload.php</title>
</head>
<BODY BGCOLOR=#3366FF>
<CENTER>
<FORM ENCTYPE="multipart/form-data" ACTION="Upload1.php" METHOD=POST>
<h1> Kompatscher & Cia Ltda </h1>
<hr>
<?php
$con = mysql_connect("*****************************************) or die ("Erro ao
conectar!");
mysql_select_db("**********r", $con) or die ("Erro ao selecionar a database!");
$comando="SELECT codigo,foto FROM cadgrupo";
$res = mysql_query($comando,$con);
$linha = mysql_fetch_array($res);
echo "<TABLE ALIGN=CENTER>";
echo "<tr>";
echo "<td>";
echo "Código";
echo "</td>";
echo "<td>";
$i=$linha['codigo'];
echo "<input type=text value=$i name=codigo>";
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td>";
echo "Foto";
echo "</td>";
echo "<td>";
$i=$linha['foto'];
echo "<input type=image value=$i border=0>";
echo "</td>";
echo "</tr>";
echo "</TABLE>";
?>
<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="4000000">
<p>
Arquivo com a foto da peça: <INPUT NAME="foto" TYPE="file">
<br>
<INPUT TYPE="submit" VALUE="Enviar">
</FORM>
</CENTER>
</BODY>
</html>
Upload1.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Upload1.php</title>
</head>
<BODY BGCOLOR=#3366FF>
<center>
<h1> Kompatscher & Cia Ltda </h1>
<hr>
<?php
$con = mysql_connect("****************************************") or die ("Erro ao
conectar!");
mysql_select_db("***********", $con) or die ("Erro ao selecionar a database!");
$res=0;
$comando= "UPDATE cadgrupo SET foto='$foto' WHERE codigo=$codigo";
echo $comando;
$res = mysql_query($comando,$con);
if ($res <= 0)
{
// query incorreta
echo "<h3><B>Erro na Atualização " . $res ."</B></h3>";
}
else {
echo "<h3>Cadastro de<b> " . $nome . "</b> foi atualizado com sucesso.</h3>";
}
mysql_close($con);
?>
</center>
</body>
</html>
Thank´s for any help.
Waldemar
