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
Tell me what is the definition of a session?
What is php data type?
How do you connet mysql database with php?
What is super keyword in c++?
Why do we use hooks?
How do you pass a variable by value in php?
How many ways to include variables in double-quoted strings in php?
Explain what are the different errors in php?
How to support multiple-page forms?
What are the ways to include file in php?
How to call javascript function in php without any event?
How to turn on the session support?
Why do we use in php?
What is the purpose of $_ session?
Tell me how to set a page as a home page in a php based site?