[php] file upload and add record to db

programming
1

hello
i’m building a backend for my site, so far all the text fields are done now i want to do the images…
how can i upload one file and add it to a database in mysql at the same time?
so far the only thing i can do is, upload the image with ftp and then if i use the addrecord page and write the filename it display the image. but i want to have a filefield form and then choose the file and it goes to the database and to the server and display where it should…
i’m using dreamweaver only so if you could explain how to do that with dreamweaver (i’m using that server behaviours and etc…) would be great (i noticed that theres a extension called pure php upload but it’s not free).
If i really need to handcode that’s ok… but let me know how to do that.
thanks in advance.

2

http://kirupaforum.com/forums/showthread.php?t=67132&highlight=file+upload

3

be sure that your server supports uploads via PHP, some charge extra!

4

please help me before i’m going crazy with this thing.
i can upload and i can add data to a database.
i just can’t do both things at once.
please help me cause i’m at almost 3 days trying to do this and no luck yet. and yet i allreayd searched google and kirupa forum :confused:

so far the code that i have and let me upload without any problems is this:

<?php
define("DESTINATION_FOLDER", "./");
define("no_error", "br.php");
/* modify */
if(!empty($HTTP_POST_FILES['ficheiro'])){
if(is_uploaded_file($HTTP_POST_FILES['ficheiro']['tmp_name']) && $HTTP_POST_FILES['ficheiro']['error'] == 0){
$_file_ = $HTTP_POST_FILES['ficheiro'];
$_name_ = $_file_['name'];
$_type_ = $_file_['type'];
$_tmp_name_ = $_file_['tmp_name'];
$_ext_ = explode(".", $_name_);
$_ext_ = strtolower($_ext_[count($_ext_)-1]);
if(@copy($_tmp_name_,DESTINATION_FOLDER . "/" . $_name_)){
header("Location: " . no_error);
}
}
}
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" enctype="multipart/form-data" method="post" action="">
<input name="ficheiro" type="file" id="ficheiro">
<input type="submit" name="Submit" value="Submit">
</form>
</body>
</html>

now i just want to be able to add to one mysql database the file name… i’m sure this is pretty simple but i can’t understand how to do that :frowning:

5

i did it!!!
**** it was simple…