Hi,
I want to upload an image ito database and display image in
a table in php
how it is possible

Answer Posted / sarita

make a folder upload in ur directory and to the following
coding:::
if (($_FILES["file"]["type"] !== "image/jpeg") &&
($_FILES["file"]["type"] !== "jimage/peg") &&
($_FILES["file"]["type"] !== "image/png") &&
($_FILES["file"]["type"] !== "image/gif") &&
($_FILES["file"]["type"] !== "image/bmp"))
{
echo "<center><b><font color=#ff0000>Invalid file type,
please select an image with extension .jpg,.gif,.bmp
or.peg</font></b></center>";
}
else
{

move_uploaded_file($_FILES["file"]["tmp_name"],
"upload/" . $_FILES["file"]["name"]);

echo ""."Stored in: "."" . "upload/" .
$_FILES["file"]["name"]."<br>";

$imgname=$_FILES["file"]["name"];
$tmpname=$_FILES["file"]["tmp_name"] ;
$type=$_FILES["file"]["type"];
$size=$_FILES["file"]["size"];
$upload= "upload/" . $_FILES["file"]["name"];

$handle = fopen("$upload", "rb");
$img = fread($handle, filesize($upload));
fclose($handle);
//die($img);

$img = base64_encode($img);


$doe=$_POST['date'];
$result1=mysql_query("insert into tbl_album
values('','".$_POST['aname']."','','$type','$size','$imgname','$doe','".$_POST['shortdes']."','".$_POST['longdes']."')")
or die(mysql_error());


if($result1)
{
echo "<center><b><font color=#0099FF>Album added
Successfully</font></b></center>";
}








$ingname is saved in ur database and folder upload
successfull...u cn change the name of folder acc to u.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is PDO?

1052


Explain a resource?

798


How to create an array in php?

798


What is super keyword in c++?

769


What does $globals mean?

739


how retrive the video file in php using video tag

1556


What is the array in php?

758


What is the static variable in function useful for?

742


Are there regular expressions in php?

681


How do you find the length of a string in php?

720


Is php front end?

694


What is the use of "enctype" attribute in a html form?

739


When use javascript vs php?

768


How break and continue while loop in php?

696


What does $_cookie mean?

722