Upload til Mysql database
<?if ($form_data && $form_data != "none") {
$file_code = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));
$connect = mysql_connect("**","**","**") or die(mysql_error());
mysql_select_db("**",$connect) or die(mysql_error());
$nu = $_FILES['form_data']['name'];
$size = $_FILES['form_data']['size'];
$size2=($size/1024);
$error = $_FILES['form_data']['error'];
$date = date("d/m/y - H:i:s");
$sql = "insert into files (file_code, file_size, file_type, filnavn, kommentar, ,tidspunkt, ip) values ('$file_code', '$form_data_size', '$form_data_type', '$nu', '$kommentar', '$date', '$REMOTE_ADDR'";
mysql_query($sql) or die(mysql_error());
echo $nu; echo ' is saved in the DB with the size '; echo $size2; echo ' Kb' ; echo '<BR></A>';
}
echo '<form action="'.$_SERVER[php_self].'" method="post" enctype="multipart/form-data">';
echo 'Udpeg filen: <input type="file" name="form_data"><BR>';
echo '<input type="hidden" name="MAX_FILE_SIZE" value="100000"><br>';
echo 'Hvad hedder sangen: <input type="text" name="kommentar"><br>';
echo '<input type="submit" VALUE="Upload filen">';
echo '</form>';
?>
Følgende script skal bruges til at uploade billeder til en mysql database... Men jeg får følgende fejl:
You have an error in your SQL syntax near 'tidspunkt, ip) values ('ÿØÿà\0JFIF\0\0\0d\0d\0\0ÿì\0Ducky\0\0\0\0\0U\0\0ÿî' at line 1
