illuz1on Posted July 31, 2007 Share Posted July 31, 2007 Hey This form just wont insert the posted $desc1 into the database, not sure why can anyone spot an error pls? Thanks upload.html <form enctype="multipart/form-data" action="uploader.php" method="POST"> <input type="hidden" name="MAX_FILE_SIZE" value="100000" /> Choose a file to upload: <input name="uploadedfile" type="file" /><br /> Description: </b><input type="text" name="desc1" size="40" maxlength="80" value="" /> <input type="submit" value="Upload File" /> </form> uploader.php <?php /* Created on: 7/27/2007 */ ?> <html> <body> <?php include "db.php"; $target_path = "uploads/"; $name = basename( $_FILES['uploadedfile']['name']); $desc1 = $_POST["desc1"]; $target_path = $target_path . basename( $_FILES['uploadedfile']['name']); if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) { echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded"; } else{ echo "There was an error uploading the file, please try again!"; } $addoffer = MYSQL_QUERY("INSERT INTO uploaddb (id,name,desc1) VALUES ('NULL', '$name', '$desc1')") or die (mysql_error ()); echo "Upload Successful:<br>"; echo "Name: $name<br>"; echo "Description: $desc1<br>"; ?> </body> </html> Link to comment https://forums.phpfreaks.com/topic/62640-solved-posted-item-not-inserting-for-some-reason/ Share on other sites More sharing options...
jitesh Posted July 31, 2007 Share Posted July 31, 2007 echo "INSERT INTO uploaddb (id,name,desc1) VALUES ('NULL', '$name', '$desc1')"; Run above and post the query with data here. Link to comment https://forums.phpfreaks.com/topic/62640-solved-posted-item-not-inserting-for-some-reason/#findComment-311774 Share on other sites More sharing options...
Guardian-Mage Posted July 31, 2007 Share Posted July 31, 2007 The problem is here: Description: </b><input type="text" name="desc1" size="40" maxlength="80" value="" /> You forgot the id attribute, it should be: Description: </b><input type="text" name="desc1" id="desc1" size="40" maxlength="80" value="" /> Link to comment https://forums.phpfreaks.com/topic/62640-solved-posted-item-not-inserting-for-some-reason/#findComment-311777 Share on other sites More sharing options...
mrjcfreak Posted July 31, 2007 Share Posted July 31, 2007 id makes no difference to form submission, only client side DOM handling... name is what is important ref: http://www.quirksmode.org/oddsandends/forms.html Link to comment https://forums.phpfreaks.com/topic/62640-solved-posted-item-not-inserting-for-some-reason/#findComment-311780 Share on other sites More sharing options...
illuz1on Posted July 31, 2007 Author Share Posted July 31, 2007 The file CTA Domains.txt has been uploadedUpload Successful: Name: CTA Domains.txt Description: INSERT INTO uploaddb (id,name,desc1) VALUES ('NULL', 'CTA Domains.txt', '') Link to comment https://forums.phpfreaks.com/topic/62640-solved-posted-item-not-inserting-for-some-reason/#findComment-311784 Share on other sites More sharing options...
mrjcfreak Posted July 31, 2007 Share Posted July 31, 2007 The problem isn't with SQL... Try a print_r($_POST); and copy what comes out. Link to comment https://forums.phpfreaks.com/topic/62640-solved-posted-item-not-inserting-for-some-reason/#findComment-311785 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.