I am currently using this php form to submit into our mySQL database with a "chip\_number" and "order\_number" also with a date and time stamp. We want to use this with no keyboard or mouse, just a scanner. Currently it tabs the first field and when the second field is scanned the form is submitted, which is working as intended but it completely starts the form over, i would like it to keep the first field (order\_number) after submitting so we can scan multiple "chip\_numbers" on the same "order\_number" then have a Master submit button if you will to send it all through when the employee is done with that order number and start with a blank form. This is the script i am using. thanks to all in advance! 

```
   <!-- Insert -->
<?php
$servername = "servername";
$username = "username";
$password = "password";
$dbname = "dbname";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "INSERT INTO MICROCHIP_TBL (chip_number,order_number)
VALUES 
('$_POST[chip_number]','$_POST[order_number]')";

IF (mysqli_query($conn, $sql)) {
    echo "New record created successfully";
} else {
    echo "Error: TRY AGAIN HUMAN!";
}

mysqli_close($conn);
?>

<html>
<head>
<!-- Validate form function -->
<!--<script type="text/javascript">
//  function validateForm()
//  {
//    var x=document.forms["chip_insert"]["order_number"].value;
//    var y=document.forms["chip_insert"]["chip_number"].value;
//    if (x==null || x=="")
//    {
//      alert("Please enter an Order Number.");
//      document.forms["chip_insert"]["order_number"].focus();
//      return false;
//    }
//    if (y==null || y=="")
//    {
//      alert("Please enter a Microchip Number.");
//      document.forms["chip_insert"]["chip_number"].focus();
//      return false;
//    }
//  }

</script> 
-->

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js"></script>
<script type="text/javascript">
  function getNextElement(field) {
    var form = field.form;
    for ( var e = 0; e < form.elements.length; e++) {
        if (field == form.elements[e]) {
            break;
        }
    }
    return form.elements[++e % form.elements.length];
}

function tabOnEnter(field, evt) {
if (evt.keyCode === 13) {
        if (evt.preventDefault) {
            evt.preventDefault();
        } else if (evt.stopPropagation) {
            evt.stopPropagation();
        } else {
            evt.returnValue = false;
        }
        getNextElement(field).focus();
        return false;
    } else {
        return true;
    }
}

</script>
</head>

<body onLoad="document.chip_insert.order_number.focus();">
<center>
<h1>Jeffers HomeAgain Microchip Entry</h1>

<form name="chip_insert"  id="chip_insert" action="<?php echo $PHP_SELF;?>" onsubmit="return validateForm()" method="post">
Order Number: <input tabindex="1" maxlength="11" type="text" name="order_number"  id="order_number"  required="required"onkeydown="return tabOnEnter(this,event)" /><br /><br />
Tag Number: <input tabindex="2" maxlength="15" type="text" name="chip_number" id="chip_number" required="required" /><br /><br />
<input tabindex="7" type="submit" />
</center>
</form>

```