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
hello all, I need some sample placement papers in lion bridge.. can anyone help me?
How to remove the new line character from the end of a text line in php?
List some of the features of php7.
What is php date function?
What are access specifiers?
What are the 3 types of sessions?
What is static in php?
What are the advantages of using php?
Does browser understand php?
What is super keyword in php?
What is the use of "ksort" in php?
Explain Type juggling?
Is php the same as html?
What is difference between explode() or split() in PHP?
When do sessions end?