submit image path to database

kpowning

Can anyone tell me how I can get the users uploaded images path into my sql database? I have a form right now that uploads the image to a folder on my site and sends it attached to my email address. But how can I do this? The following is the form in html:

<FORM ACTION="<?=$_SERVER['PHP_SELF'];?>" METHOD="POST" ENCTYPE="multipart/form-data" name="banner" id="banner" onSubmit="YY_checkform('banner','Name','#q','0','Field \'Your Full Name\' is Required.','Email','S','2','Field \'Email Address\' is Required.');return document.MM_returnValue">
<p align="center" class="greybold">
<INPUT TYPE="HIDDEN" NAME="SendFile" VALUE="Send File">
<INPUT TYPE="HIDDEN" NAME="MAX_FILE_SIZE" VALUE="10240">
Your Full Name:
<INPUT TYPE="TEXT" NAME="Name">
<BR>
Email Address:
<input name="Email" type="text" id="Email">
<BR>
Banner Run Time:
<select name="Time" id="Time">
<option value="1 Month $40">1 Month $40</option>
<option value="2 Months $75">2 Months $75</option>
<option value="4 Months $150">4 Months $150</option>
<option value="6 Months $200">6 Months $200</option>
</select>
<BR>
Select Your Banner:
<INPUT TYPE="FILE" NAME="UPLDoc">
<BR>
<INPUT TYPE="SUBMIT" NAME="SendFile" VALUE="Submit Banner!">
</p>
</FORM>

*I have tried everything, but all I get is field "Banner Location" cannot be null....

trexx

take a look at the PHP manual:

http://www.php.net/manual/en/features.file-upload.php

almost all you need is the move_uploaded_file func. store the file location of the moved file in your database.

Selinaar

http://www.weberdev.com/get_example.php3?count=3688

I was looking for something similar and found this, it might help you.

CREATE TABLE `tblimage` ( 
  `imgid` int(3) unsigned NOT NULL auto_increment, 
  `imgtype` varchar(16) NOT NULL default '', 
  `imgdata` longblob, 
  PRIMARY KEY  (`imgid`) 
) TYPE=MyISAM;

You might want to create the 'imgdata' field in your DB as LONGBLOB though.