Monday, 15 August 2011

PHP re-adds value to database after refresh? -



PHP re-adds value to database after refresh? -

this may sound noobish, have code submits file database (and reads file) whenever nail submit, , works perfectly, except after refresh page re-adds lastly value selected. here code problem lies :

<?php mysql_connect("localhost","root",""); mysql_select_db("a1296556_data1"); if(isset($_post['submit'])){ $name=$_files['file']['name']; $temp=$_files['file']['tmp_name']; move_uploaded_file($temp,"uploaded/".$name); $url="http://www.bluejayke.com/edit/uploaded/$name"; } ?> <form action="index.php" method="post" enctype="multipart/form-data"> <input type="file" name="file"> <input type="submit" name="submit" value="upload"> </form> <iframe src='video.php' width=250 height=600></iframe> <?php if(isset($_post['submit'])){ mysql_query("insert uploadedvideos(id,name,url) values('','$name','$url')"); echo "</br>" . $name . " uploaded"; } ?>

any input?

when form submits, browser issues post request. when refresh, browser issues lastly request, submitting form again. however, browsers inquire before refreshing after submitting form. in order avoid this, you should redirect after post.

php database file refresh add

No comments:

Post a Comment