now to make it easier, i will make a place where you can easily add a work.
now 1st of all, here is my html code for adding a photoshop work:
Code: Select all
Add Photoshop Work
<form method="post" name="addphotoshopwork" encType="multipart/form-data" src="">
Name:
<input size="35" maxlength="50" type="text" name="title1" value="" class="textbox">
Category:
<select name="catagory1">
<option value="1">Creations
<option value="2">Posters
<option value="3">Banners
</select>
Main Pic Upload:
<input type="file" name="render" value="" size="20" class="textbox">
Other Notes:
<textarea name="text" rows="10" cols="85"></textarea>
<input type="submit" name="sub_add" value="Add" class="button">
</form>1) get the name in the name box, and put it in the name field in the mysql database
2) get the catagory ID, put that in
3) upload the picture, save the URL that the pic is at in the mysql database
4) save the "other notes" in the mysql database
now so far i am guessing i can use this kind of code:
Code: Select all
$name = $_POST['title1'];
$notes = $_POST['notes'];
$query = "INSERT INTO web1 (title, notes) VALUES ('$name', '$notes')";Code: Select all
$_POST['catagory1(option)'];and for later viewing purposes i am going to have to store the uploaded image URL into another table in the database, how would i get that URL?