Monday, July 20, 2009

how to enter phto in mysql using php

input type="hidden" name="MAX_FILE_SIZE" value="2000000
input name="userfile" type="file" id="userfile
input name="upload" type="submit" class="box" id="upload" value=" Upload











if(!$con)
{
die("conection failed".mysql_error());
}
$sql=mysql_select_db("photo",$con);if(!$sql){die("database failed".mysql_error());}
$uploadDir = 'C:/webroot/upload/';
if(isset($_POST['upload']))
{
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$filePath = $uploadDir . $fileName;
$result = move_uploaded_file($tmpName, $filePath);
if (!$result)
{
echo "Error uploading file";exit;}

if(!get_magic_quotes_gpc())
{$fileName = addslashes($fileName);
$filePath = addslashes($filePath);}
$query = "INSERT INTO upload2 (name, size, type, path ) "."VALUES ('$fileName', '$fileSize', '$fileType', '$filePath')";
mysql_query($query) or die('Error, query failed : ' . mysql_error());
mysql_close($con);
echo "
Files uploaded
";
}?>

No comments:

Post a Comment