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
what is PDO?
Explain a resource?
How to create an array in php?
What is super keyword in c++?
What does $globals mean?
how retrive the video file in php using video tag
What is the array in php?
What is the static variable in function useful for?
Are there regular expressions in php?
How do you find the length of a string in php?
Is php front end?
What is the use of "enctype" attribute in a html form?
When use javascript vs php?
How break and continue while loop in php?
What does $_cookie mean?