Jump to content


Photo

File Upload/Insert Information into Database prob


  • Please log in to reply
No replies to this topic

#1 alexville

alexville
  • Members
  • PipPipPip
  • Advanced Member
  • 71 posts

Posted 14 April 2006 - 06:12 PM

Hello,

I made this video upload script.

And the file gets uploaded alright, but when I want to insert some data about that one file into the database, it fails.

<?php
$target_path = "videouploads/";

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']);

if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
    echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded";
    // connect to database
    $dbcnx = @mysql_connect("localhost","dfsdfsfs","dsfsfdsfdsfds");
    if (!$dbcnx) {
        echo "<p>Unable to connect to the database server at this time.</p>";
        exit();
    }
    mysql_select_db("alexg_alexville",$dbcnx);
    // end connection
    // insert into database
    $by = $_POST['name'];
    $byemail = $_POST['email'];
    $videoname = $_POST['title'];
    $videodescription = $_POST['description'];
    $videopath = basename( $_FILES['uploadedfile']['name']);
    $sql_query = mysql_query("INSERT INTO video (videoname, videodescription, submitted, email, video) VALUES ('$videoname', '$videodescription', '$by', '$byemail, '$videopath')");
    if (!$sql_query) {
        exit("<p>Error performing query: " . mysql_error() . "</p>");
    }
} else{
    echo "There was an error uploading the file, please try again!";
}
?>

Thats the videouploader code. It outputs this when I try it:

The file bubble.wmv has been uploaded

Error performing query: 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 'bubble.wmv')' at line 1

Any idea whats wrong?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users