Greetings, webmasters.

I've recently started to work with dreamweaver and I've set up a site. I have html knowledge and so, but what I really want is a database. One that'll work like this; my visitor come to the site, he or she wants to upload a picture with information such as email and description. I want this to be stored in a database.

I'm completely nulled at this subject. No idea where to begin. I just need a simple database that I can visit as administrator and look through the pictures and email addys. How do I make my site upload images and text to a database? Is there a simple code snippet to get somewhere? My host uses mysql by the way.


Any help would be really appreciated.

Thanks!

Undrium

Well i don't know if you want to use PHP or not, but it's the best language to use with mysql, check out this article at sitepoint.com i keep suggesting it and no one comes back with any problems.

You may find that Dreamweaver will have problems with you coding PHP.

Allright, I've followed the help in there.. and I've come this far;

-----------------------------------------------------------------------------------

<form action="sendmail.php" method="post" enctype="multipart/form-data">
<p>Email:
<input name="email" type="text" />
</p>
<p>
<input type="file" name="file">
<br />
Message:<br />
<textarea name="message" rows="15" cols="40">
</textarea>
<br />
<input type="submit" />
</p>
</form>

-----------------------------------------------------------------------------------

sendmail.php looks like this:

-----------------------------------------------------------------------------------

<?
$email = $_REQUEST['email'] ;
$message = $_REQUEST['message'] ;
$file =$_REQUEST['file'] ;

if (!isset($_REQUEST['email'])) {
header( "Location: http://www.mail.com/submit.htm" );
}
elseif (empty($email) || empty($message)) {
header( "Location: http://www.mail.com/submit.htm" );
}
else {
mail( "myname@mail.com", "Feedback Form Results",
$message, $file, "From: $email" );
header( "Location: http://www.mail.com/submit.htm" );
}
?>

-----------------------------------------------------------------------------------

Allright, I'm almost done. The only thing that's left is to get the file sending working. What's wrong with my code? Why won't the files get sent in the email to me? Don't bother the locations, just changed those now because of some privacy. I just wish I could get the file uploading to work

Sending attachments along with you email is a little bit more complication. Try reading this on FAQTs.com.

I'm not too sure about this, Chroder.. looks very complicated :S First; Is it a form the user is writing in to then send the information to the receiver in a mail? What do I need to put in my code to make attachments work? Thanks for the help!