duplicate record insert on page refresh php -
whenever entered value first time , add record added whenever refresh browser pressing f5 shows message "the page you're looking used information entered..." , insert duplicate record. html code define below:
<?php include("connection.php"); ?> <form role="form" method="post"> <div class="col-md-6"> <div class="form-group"> <label>type name</label> <input name="emptype" class="form-control" placeholder="employee id"> </div> <div class="form-group"> <label>type description</label> <input name="typedecs" class="form-control" placeholder="first name"> </div> </div> <div class="col-md-12 text-right"> <button type="submit" name="addtype" class="btn btn-primary">add type</button> <button type="reset" class="btn btn-default">reset</button> </div> </form> below php code <?php $emptype=$_post['emptype']; $typedesc=$_post['typedecs']; if(isset($_post['addtype'])) { $query=mysql_query("insert emptype(typename,typedesc)values('$emptype','$typedesc')")or die("<script>alert('error');</script>"); echo '<script>showalert();window.settimeout(function () {hidealert();},3000);</script>'; does missing? please help.
suggestion: use mysqli_* or pdo instead of mysql_* functions, have written code in gave code in it.
just run select query check if record exists in database if exists not insert again.
$query=mysql_query("select * emptype typename = '$emptype' , typedesc='$typedesc') or die(mysql_error()); if (mysql_num_rows($query)<=0) { $query=mysql_query("insert emptype(typename,typedesc)values('$emptype','$typedesc')")or die("<script>alert('error');</script>"); }
Comments
Post a Comment