| Gast | Also als action ist der Verweis zum "roombase.php" definiert mit der zugehörigen method post...?! Code: <form action="roombase.php" enctype="multipart/form-data" method="post">
<label for="roomno">Room:</label>
<input type="text" size="10" name="roomno">
<label for="roompic">Picture:</label>
<input name="roompic" type="file" size="30" maxlength="100000" accept="image/*">
<fieldset style="padding: 10px;">
<legend>Furniture</legend>
<label for="lamp">How many lamps does your room have?</label>
<select name="lamp">
<option value="select" selected>select...</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="more">more</option>
<option value="dunno">don't know</option>
</select>
<label for="wardrobe">How many wardrobes does your room have?</label>
<select name="wardrobe">
<option value="select" selected>select...</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="more">more</option>
<option value="dunno">don't know</option>
</select>
<label for="bookcase">How many bookcases does your room have?</label>
<select name="bookcase">
<option value="select" selected>select...</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="more">more</option>
<option value="dunno">don't know</option>
</select>
<label for="desk">How many desks does your room have?</label>
<select name="desk">
<option value="select" selected>select...</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="more">more</option>
<option value="dunno">don't know</option>
</select>
<label for="table">How many tables does your room have?</label>
<select name="table">
<option value="select" selected>select...</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="more">more</option>
<option value="dunno">don't know</option>
</select>
<label for="chair">How many chairs does your room have?</label>
<select name="chair">
<option value="select" selected>select...</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="more">more</option>
<option value="dunno">don't know</option>
</select>
</fieldset>
<fieldset style="padding: 10px;">
<legend>Facilities</legend>
Does your room have a sink?
<input type="radio" name="sink" value="no">No
<input type="radio" name="sink" value="yes">In Room
<input type="text" name="sink_shared" size="30" value="And/or shared between how many?">
Does your room have a toilet?
<input type="radio" name="toilet" value="no">No
<input type="radio" name="toilet" value="yes">In Room
<input type="text" name="toilet_shared" size="30" value="And/or shared between how many?">
Does your room have a shower?
<input type="radio" name="shower" value="no">No
<input type="radio" name="shower" value="yes">In Room
<input type="text" name="shower_shared" size="30" value="And/or shared between how many?">
Does your room have a bath?
<input type="radio" name="bath" value="no">No
<input type="radio" name="bath" value="yes">In Room
<input type="text" name="bath_shared" size="30" value="And/or shared between how many?">
Does your room have a hob?
<input type="radio" name="hob" value="no">No
<input type="radio" name="hob" value="yes">In Room
<input type="text" name="hob_shared" size="30" value="And/or shared between how many?">
Does your room have a microwave?
<input type="radio" name="microwave" value="no">No
<input type="radio" name="microwave" value="yes">In Room
<input type="text" name="microwave_shared" size="30" value="And/or shared between how many?">
Does your room have a fridge?
<input type="radio" name="fridge" value="no">No
<input type="radio" name="fridge" value="yes">In Room
<input type="text" name="fridge_shared" size="30" value="And/or shared between how many?">
Does your room have a freezer?
<input type="radio" name="freezer" value="no">No
<input type="radio" name="freezer" value="yes">In Room
<input type="text" name="freezer_shared" size="30" value="And/or shared between how many?">
Does your room have a oven?
<input type="radio" name="oven" value="no">No
<input type="radio" name="oven" value="yes">In Room
<input type="text" name="oven_shared" size="30" value="And/or shared between how many?">
</fieldset>
<label for="description">Brief description of the room (anything that stands out as particularly good or bad):</label>
<textarea cols="60" rows="10" name="description" value="Noisy road nearby? Showers far away? Close to the bar?"></textarea>
<center><input type="submit" value="Contribute"></center>
</form>
Ich glaub ich habs jetzt... fast zumindest... ich hab die entsprechenden Datenbankfelder als "not null" definiert und das Skript dummerweise getestet, indem ich eben nur ein paar Felder ausgefüllt habe...
Und dann hab ich mal den Bereich, wo es um das hochladen eines Fotos geht auskommentiert, weil ich denke, dass man da doch sowieso noch ne spezielle Funktion nutzen muss, um ein Foto hochzuladen und in der DB zu speichern, oder?
Auf alle Fälle klappt es jetzt - die DB wird ausgefüllt, aber ich krieg eben immer noch diese "Notiz" Zitat:
Notice: Use of undefined constant localhost - assumed 'localhost' in /srv/www/htdocs/web63/html/roombase.php on line 39
INSERT INTO `room` (`roomno`, `lamp`, `wardrobe`, `bookcase`, `desk`, `table`, `chair`, `sink`, `sink_shared`, `toilet`, `toilet_shared`, `shower`, `shower_shared`, `bath`, `bath_shared`, `hob`, `hob_shared`, `microwave`, `microwave_shared`, `fridge`, `fridge_shared`, `freezer`, `freezer_shared`, `oven`, `oven_shared`, `description`) VALUES ('OH121', '1', '1', '1', '1', '1', '1', 'no', 'sink comment', 'no', 'toilet comment', 'no', 'shower comment', 'no', 'bath comment', 'no', 'hob comment', 'no', 'microwave comment', 'no', 'fridge comment', 'no', 'freezer comment', 'no', 'oven comment', 'Room description')Your contribution was successful. Thank you!
| Wie krieg ich die denn weg? Woran liegt das? Und kann mich jemand bzgl. des File-Uploads in die richtige Richtung weisen? Danke...  |