Simple Pins and Serial Number Order Form

you will need to create a pins and serial number order form that that can fetch pin and serial numbers from database and display the order for buyer to view and copy when buy now button is click meanwhile, the pin and serial numbers will be listed in a database, one entry per line and when a purchase is made, the code should then extracts the first pin and serial number from the database and display instantly like, thanks for ordering pin and serial number from us please see your order details: pin 0980900989 serial number: wrs9098989 sends also to the purchaser email and then removes that pin and serial number from the database list. The email sent to the purchaser contains the pin and serial number. The sales history listing also identifies which pin number has been sold to the purchaser. if a client type 10 pin in the quantity box then 10 pins will be retrieve from the database and the 10 pin will also be remove instantly from the database. if pins is empty in the database there must be a way to load pin, if pin is not loaded and clients try to order then pin is not available message will be display. apply only if you understand the above task and how it works SEE A SAMPLE FORM I CREATED IT IS ALREADY WORKING BUT IT NEW TO RETRIEVE PIN FROM DATABASE Code: <form action="[login to view URL]" method="post" autocomplete="true"> <div class="col-sm-8 col-sm-offset-1"> <div class="form-group"> <label class="col-sm-3 control-label right"> <strong>PHONE NO</strong></label> <div class="col-sm-9"> <input type="text" name="num" placeholder="EX: 01XXXXXXXXX" class="form-control" /> </div> </div> <div class="form-group"> <label class="col-sm-3 control-label right"> <strong>PIN QUANTITIES</strong></label> <div class="col-sm-9"> <input type="text" name="num" placeholder="EG:5" class="form-control" /> </div> </div> <div class="form-group"> <label class="col-sm-3 control-label right"> <strong>PIN TYPE</strong></label> <div class="col-sm-9"> <select name="amount" class="form-control"> <option value="7">700 FOR pin 1</option> <option value="6">600 FOR pin 2 </option> <option value="2">2500 pin 3</option> <option value="8"> 800</option> </select> <br /> </div> </div> <div class="form-group"> <label class="col-sm-3 control-label right"> <strong>YOUR SECURITY </strong></label> <div class="col-sm-9"> <input type="password" name="pin" class="form-control" /> </div> </div> <div class="col-sm-9 col-sm-offset-3"> <button type="submit" class="btn btn-primary btn-block">GET CARD PIN NOW</button> </div> </form><br/><br/>