enter browse for file name into database

v3nt

http://www.jynk.net/Adelphoi/main/admin/project_add_b.php

i can't get the file name to go into the database? it works with a normal field, but when i change it to a browse for file field it just doesn't get entered?

can it be done? i can do it with an uploading script i have but i just want the name of the file entered.

dotbob

Use javascript:

function get_file_name()
{
var frm = document.FORMNAME; //change this to the name of your form

var str_filename = frm.FILE.value; //change this to the name of your file upload control

if(str_filename != "")
{
last_pos = str_filename.lastIndexOf("\");
var file_name = str_filename.substring((last_pos+1),str_filename.length);
}
}

This will leave you with just the filename stored in the file_name var. You can then pass this onto a php script via POST, querystring or any other method.

v3nt

form called- jonny
file field called-filename_a

i run the function from the form button-
<input name="submit" type="Submit" onClick="get_file_name()" value="ADD">

dotbob

almost,

form called- jonny
file field called-filename_a

i run the function from the form button-
<input name="submit" type="Submit" onClick="get_file_name()" value="ADD">

make your button a normal button i.e. type="button".

now make sure you have a hidden field somewhere on your form called 'thefilename' or whatever.

now in the function I gave you, add these lines to the bottom of it (outside of the if).

frm.thefilename.value = file_name;
frm.submit();

Doing this will store the filename in the hidden field and submit your form. On the page that the form submits to you will be able to access the filename from the $thefilename var (or whatever you called it).

v3nt

mmm, form wont post now... and im having trouble pasting in the form!

function get_file_name()
{
var frm = document.jonny;
var str_filename = frm.FILE.filename_a;

frm.thefilename.value = filename_a;
frm.submit();
if(str_filename != "")
{
last_pos = str_filename.lastIndexOf("\");
var file_name = str_filename.substring((last_pos+1),str_filename.length);
}
}

v3nt

browse file field is called filename_a

nothing will appear below this line?!//
button-
input name="Submit" type="button" id="button" onClick="get_file_name()" value="ADD"

dotbob

ok.

here's an example form and javascript which will work.

<html>
<head>
<script type="text/javascript">
function get_file_name()
{
var frm = document.test; //change this to the name of your form

var str_filename = frm.file.value; //change this to the name of your file upload control

if(str_filename != "")
{
last_pos = str_filename.lastIndexOf("\");
var file_name = str_filename.substring((last_pos+1),str_filename.length);
}

//store the filename in the hidden field
frm.thefilename.value = file_name;
//submit the form
frm.submit();
}
</script>
</head>
<body>
<form name="test" id="test" action="somefile.php" method="POST">
<input type="file" name="file">
<input type="hidden" name="thefilename">
<input type="button" value="Submit" onClick="get_file_name();">
</form>
</body>
</html>

v3nt

im sorry, but it just doesn't submit!
http://jynk.net/Adelphoi/main/admin/

also, which word do i modify? .value or .file.
var str_filename = frm.file.value; //change this to the name of your file upload control