I am looking for help with uploading images to a directory on the server but to also write to db column in a table so I can call it from the DB.
I am new to all of this, infact I really don't have a clue really to what I am doing. I started building this site using all Dreamweaver PHP functionality and that has done all of the php work for me but when it came to making a form to upload pictures (which someone told me that it can be easily done with dreamweaver out of the box) I found that I had gotten over my head.
Basically for the last couple of weeks trying to figure all of this out and imagine that I have know experience with php except on how to use an include() and echo() for simple things.
Basically I need to have my upload in a form for a full sized pic and a thumb nail. I know it is kind of a weak thing to come beg someone to show me what to do but unfortenantly I am at a loss on making this thing work and I am passed my dead line.
Here is the code for the html form:
<table align="center" class="sitewidetext">
<tr valign="baseline">
<td width="58" height="20" align="right" valign="middle" nowrap class="sitewidetext">Name:</td>
<td width="319" align="left" valign="middle"><input name="name" type="text" class="sitewidetext" value="" size="32"></td>
<td width="14"></td>
</tr>
<tr valign="baseline">
<td height="20" align="right" valign="middle" nowrap class="sitewidetext">Code:</td>
<td align="left" valign="middle"><input name="code" type="text" class="sitewidetext" value="" size="32"></td>
<td></td>
</tr>
<tr valign="baseline">
<td height="23" align="right" valign="middle" nowrap>Group:</td>
<td align="left" valign="middle">
<select name="productgroup" class="sitewidetext">
<?php
do {
?>
<option value="<?php echo $row_groups['id']?>" ><?php echo $row_groups['name']?></option>
<?php
} while ($row_groups = mysql_fetch_assoc($groups));
?>
</select>
</td>
<td></td>
<tr>
<td height="23" align="right" valign="middle" nowrap>Brand:</td>
<td align="left" valign="middle">
<select name="brand" class="sitewidetext">
<?php
do {
?>
<option value="<?php echo $row_brands['brandsid']?>" ><?php echo $row_brands['brandname']?></option>
<?php
} while ($row_brands = mysql_fetch_assoc($brands));
?>
</select> </td>
<td></td>
<tr valign="baseline">
<td height="23" align="right" valign="middle" nowrap>Vendor:</td>
<td align="left" valign="middle">
<select name="vendor" class="sitewidetext">
<?php
do {
?>
<option value="<?php echo $row_vendor['id']?>"><?php echo $row_vendor['vendorname']?></option>
<?php
} while ($row_vendor = mysql_fetch_assoc($vendor));
$rows = mysql_num_rows($vendor);
if($rows > 0) {
mysql_data_seek($vendor, 0);
$row_vendor = mysql_fetch_assoc($vendor);
}
?>
</select> </td>
<td></td>
<tr valign="baseline">
<td height="111" align="right" valign="top" nowrap>Description:</td>
<td valign="top">
<textarea name="descrip" cols="60" rows="7" class="sitewidetext"></textarea> </td>
<td></td>
<tr valign="baseline">
<td height="19"> </td>
<td> </td>
<td></td>
</tr>
<tr valign="baseline">
<td height="20" align="right" valign="middle" nowrap>Selling Price:</td>
<td colspan="2" align="left" valign="middle"><input name="saleprice" type="text" class="sitewidetext" value="" size="32"> </td>
</tr>
<tr valign="baseline">
<td height="20" align="right" valign="middle" nowrap>Cost:</td>
<td colspan="2" align="left" valign="middle"><input name="cost" type="text" class="sitewidetext" value="" size="32">
(wholesale price from Vendor)</td>
</tr>
<tr valign="baseline">
<td height="12"></td>
<td></td>
<td></td>
</tr>
<tr valign="baseline">
<td height="21" valign="top"><input name="AX_FILE_SIZE" type="hidden" id="AX_FILE_SIZE" value="30000"></td>
<td colspan="2" valign="top" class="titles">picture upload</td>
</tr>
<tr valign="baseline">
<td height="23" align="right" valign="middle" class="sitewidetext">Picture:</td>
<td colspan="2" align="left" valign="middle"><input name="userfile" type="file" class="sitewidetext" id="userfile" size="35"></td>
</tr>
<tr valign="baseline">
<td height="23" align="right" valign="middle" class="sitewidetext">Thumbnail:</td>
<td colspan="2" align="left" valign="middle"><input name="userfile2" type="file" class="sitewidetext" id="userfile2" size="35"></td>
</tr>
<tr valign="baseline">
<td height="23"></td>
<td colspan="2" valign="middle"><input type="submit" class="sitewidetext" value="Insert record"></td>
</tr>
</table>
If you can't help do know somewhere I can get a better under standing of making something like this php that is similar to what I am trying to do.
