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> Quote 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. Quote 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="" /> Quote 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 Quote 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', '') Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.