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

Tell me what is the definition of a session?

626


What is php data type?

620


How do you connet mysql database with php?

614


What is super keyword in c++?

676


Why do we use hooks?

586






How do you pass a variable by value in php?

628


How many ways to include variables in double-quoted strings in php?

638


Explain what are the different errors in php?

623


How to support multiple-page forms?

658


What are the ways to include file in php?

607


How to call javascript function in php without any event?

589


How to turn on the session support?

680


Why do we use in php?

625


What is the purpose of $_ session?

614


Tell me how to set a page as a home page in a php based site?

607