Topic: upload to mysql
Sveiki taigi radau upload scripta, jis veikia taciau kelia paveiksliukus i sql , o reiketu jog keltu i kazkoki folderi ir isirasytu i nuoroda i sql.
stai koki as radau kuris ne nuoroda iraso o visa faila i sql:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
if($_POST)
{
if(!is_array($_FILES) || !is_array($_FILES['visitor_photo']))
{
die("no file was uploaded");
}
$tmp = $_FILES['visitor_photo']['tmp_name'];
$fp = fopen($tmp, 'rb');
$image = fread($fp, filesize($tmp));
fclose($fp);
$name = $_POST['visitor_name'];
$db = @mysql_connect("localhost", "myusername", "mypassword") or die (mysql_error());
@mysql_select_db("competence", $db) or die (mysql_error());
// gzip file
//$image = gzdeflate($image, 9);
$image = mysql_real_escape_string($image, $db);
$result = @mysql_query("INSERT INTO `tb_member` (`nom`, `photo`) VALUES ('$name' ,'$image')", $db);
if($result === false)
{
die("could not insert into database");
}
unlink($tmp);
exit("upload successful");
}
?>
<form action="" method="post" enctype="multipart/form-data" name="fjoindre" id="fjoindre">
Name:
<input type="text" name="visitor_name">
Image:
<input name="visitor_photo" type="file" id="visitor_photo">
<input type="submit" value="Send" name="Submit">
</form>
</body>
</html>