syntax fejl
Er der nogen der kan sige mig hvorfor jeg får denne fejl.Jeg kan bare ikke finde den:
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't But One Kind Of Blues.mp3, '479774', '/upload/uploadify/upload_name.php', 'Gæs' at line 2
Scriptet der køre den:
if (!empty($_FILES)) {
$tempFile = $_FILES['Filedata']['tmp_name'];
$targetPath = $_SERVER['DOCUMENT_ROOT'] . $_REQUEST['folder'] . '/';
$newFileName = $_GET['name'].'_'.$_GET['lenght'].'-'.$_FILES['Filedata']['name'];
$targetFile = str_replace('//','/',$targetPath) . $newFileName;
$_SESSION['targetFile'] = $_FILES['Filedata']['name'];
$_SESSION['url'] = $_SERVER['DOCUMENT_ROOT'] . $_REQUEST['folder'] . '/';
$_SESSION['fileSize'] = $_FILES['Filedata']['size'];
$_SESSION['style'] = $_GET['name'];
$_SESSION['lenght'] = $_GET['lenght'];
// Uncomment the following line if you want to make the directory if it doesn't exist
// mkdir(str_replace('//','/',$targetPath), 0755, true);
move_uploaded_file($tempFile,$targetFile);
}
if ($newFileName)
echo $newFileName;
else // Required to trigger onComplete function on Mac OSX
echo '1';
?><br />
<?php
// hent værdier til DB
$style = $_SESSION['style'];
$lenght = $_SESSION['lenght'];
$targetFile = $_SESSION['targetFile'];
$fileSize = $_SESSION['fileSize'];
$url = $_SESSION['url'];
$user = $session->username;
$timestamp = time();
include ("config.php");
include ("opendb.php");
$query = "INSERT INTO uploads (style, lenght, targetFile, fileSize, url, user, timestamp)
VALUES ('$style', '$lenght', '$targetFile, '$fileSize', '$url', '$user', '$timestamp')";
if (!mysql_query($query))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
Og min DB:
CREATE TABLE uploads(
style VARCHAR(50),
lenght VARCHAR(30),
targetFile VARCHAR(90),
fileSize VARCHAR(90),
url VARCHAR(90),
user VARCHAR(90),
timestamp VARCHAR(80));
