Hi,

I've been trying to find a script to upload a file to a folder on the server and insert the name into a MySQL Database. I am very new to PHP and so I'm using Dreamweaver CS4 for 99% of my work. I got an upload script from this forum, Cheers Bokeh, which is working fine, and I went through the post I got it from and there were others trying to do the same thing as I am. I have tried a all of their methods and some others I have found around the net but for some reason I can't get it to add the name to the database.

Ok, so here is my code (very slightly edited from the original) without anything to add the name to the database:
PHP Code:
<?php require_once('../Connections/conn.php'); ?>
<?php
// filename: upload.php 

// first let's set some variables 

// make a note of the current working directory, relative to root. 
$directory_self str_replace(basename($_SERVER['PHP_SELF']), ''$_SERVER['PHP_SELF']); 

// make a note of the directory that will recieve the uploaded file 
$uploadsDirectory $_SERVER['DOCUMENT_ROOT'] . $directory_self '../images/'

// make a note of the location of the upload form in case we need it 
$uploadForm 'http://' $_SERVER['HTTP_HOST'] . $directory_self 'index.php'

// make a note of the location of the success page 
$uploadSuccess 'http://' $_SERVER['HTTP_HOST'] . $directory_self 'success.php'

// fieldname used within the file <input> of the HTML form 
$fieldname 'file'

// Now let's deal with the upload 

// possible PHP upload errors 
$errors = array(=> 'php.ini max file size exceeded'
                
=> 'html form max file size exceeded'
                
=> 'file upload was only partial'
                
=> 'no file was attached'); 



// check the upload form was actually submitted else print the form 
isset($_POST['submit']) 
    or 
error('the upload form is neaded'$uploadForm); 

// check for PHP's built-in uploading errors 
($_FILES[$fieldname]['error'] == 0
    or 
error($errors[$_FILES[$fieldname]['error']], $uploadForm); 
     
// check that the file we are working on really was the subject of an HTTP upload 
@is_uploaded_file($_FILES[$fieldname]['tmp_name']) 
    or 
error('not an HTTP upload'$uploadForm); 
     
// validation... since this is an image upload script we should run a check   
// to make sure the uploaded file is in fact an image. Here is a simple check: 
// getimagesize() returns false if the file tested is not an image. 
@getimagesize($_FILES[$fieldname]['tmp_name']) 
    or 
error('only image uploads are allowed'$uploadForm); 
     
// make a unique filename for the uploaded file and check it is not already 
// taken... if it is already taken keep trying until we find a vacant one 
// sample filename: 1140732936-filename.jpg 
$uploadFilename $uploadsDirectory.$_FILES[$fieldname]['name'];


// now let's move the file to its final location and allocate the new filename to it 
@move_uploaded_file($_FILES[$fieldname]['tmp_name'], $uploadFilename
    or 
error('receiving directory insuffiecient permission'$uploadForm); 
    
header('Location: ' $uploadSuccess);
// The following function is an error handler which is used 
// to output an HTML error page if the file upload fails 
function error($error$location$seconds 5

    echo 
'<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"'."\n"
    
'"http://www.w3.org/TR/html4/strict.dtd">'."\n\n"
    
'<html lang="en">'."\n"
    
'    <head>'."\n"
    
'        <meta http-equiv="content-type" content="text/html; charset=iso-8859-1">'."\n\n"
    
'        <link rel="stylesheet" type="text/css" href="stylesheet.css">'."\n\n"
    
'    <title>Upload error</title>'."\n\n"
    
'    </head>'."\n\n"
    
'    <body>'."\n\n"
    
'    <div id="Upload">'."\n\n"
    
'        <h1>Upload failure</h1>'."\n\n"
    
'        <p>An error has occured: '."\n\n"
    
'        <span class="red">' $error '...</span>'."\n\n"
    
'         The upload form is reloading</p>'."\n\n"
    
'     </div>'."\n\n"
    
'</html>'
    exit; 
// end error handler 

mysql_free_result($devuploadRS);
?>
Now, all I want to do is add $uploadFilename to my my database table 'home'. Anyone out there help me out?

Thanks for any help!