do-not-refresh - Stikked do-not-refresh - Stikked http://geopaste.scratchbook.ch/ en vouchers.php http://geopaste.scratchbook.ch/view/c1d5750e Fri, 18 Jan 2019 10:29:08 +0100 ali http://geopaste.scratchbook.ch/view/c1d5750e
  1. <?php
  2. include("includes/db.php");
  3. //vouchers.php
  4. if(isset($_REQUEST["submit"]))
  5. {
  6. //      $derror = "Duplicate record";
  7.         $lot=$_REQUEST["lot"];
  8.         $date=$_REQUEST["date"];
  9.         $operator=$_REQUEST["operator"];
  10.         $iname=$_REQUEST["iname"];
  11.         $ivno=$_REQUEST["ivno"];
  12.         $vvalue=$_REQUEST["vvalue"];
  13.         $vno=$_REQUEST["vno"];
  14.         $gref=$_REQUEST["gref"];
  15.         $gip=$_REQUEST["gip"];
  16.         $gport=$_REQUEST["gport"];
  17.         $comment=$_REQUEST["comment"];
  18.  
  19.         if(mysql_query("insert into vouchers(lot,date,operator,i_name,i_v_no,v_value,v_no,g_ref,g_ip,g_port,comment)values('$lot','$date','$operator','$iname','$ivno','$vvalue','$vno','$gref','$gip','$gport','$comment')"))
  20.         {
  21.                 header("Location:vouchers.php");
  22.                 exit;
  23.         }
  24.         else
  25.         {
  26.         echo "Failed to insert the records!";
  27.         }
  28. }
  29. ?>
  30.  
  31.  
  32.  
  33. <form method="post" id="frm1">
  34.  
  35. Lot # :<Input type="text" name="lot" required><br><br>
  36.  
  37. Date :<Input type="date" name="date" required><br><br>
  38.  
  39. Operator :<Input type="radio"name="operator"value="Zong" required>Zong<Input type="radio"name="operator"value="Telenor" required>Telenor<Input type="radio"name="operator"value="Jazz" required>Jazz
  40. </select><br><br>
  41.  
  42. Item Name :
  43. <?php $filename = 'includes/iname.txt';
  44. $eachlines = file($filename, FILE_IGNORE_NEW_LINES);//create an array
  45. echo '<select name="iname" id="value" required>';
  46. echo "<option value=''>Select Anyone</option>";
  47. foreach($eachlines as $lines){
  48. echo "<option value='{$lines}'>{$lines}</option>";
  49. }
  50. echo '</select>'; ?><br><br>
  51. I Voucher# :<Input type="text" name="ivno" required><br><br>
  52.  
  53. Voucher Value :<Input type="radio"name="vvalue"value="100" required>100<Input type="radio"name="vvalue"value="300" required>300<Input type="radio"name="vvalue"value="500" required>500<Input type="radio"name="vvalue"value="1000" required>1000 <br><br>
  54.  
  55. Voucher # :<Input type="text" name="vno" required><br><br>
  56.  
  57. Gateway Ref :
  58. <?php $filename = 'includes/gref.txt';
  59. $eachlines = file($filename, FILE_IGNORE_NEW_LINES);//create an array
  60. echo '<select name="gref" id="value" required>';
  61. echo "<option value=''>Select Anyone</option>";
  62. foreach($eachlines as $lines){
  63. echo "<option value='{$lines}'>{$lines}</option>";
  64. }
  65. echo '</select>'; ?><br><br>
  66.  
  67. Gateway IP:<Input type="radio"name="gip"value="192.168.101.101" required>192.168.101.101<Input type="radio"name="gip"value="192.168.101.102" required>192.168.101.102
  68. </select><br><br>
  69.  
  70. Gateway Port:
  71. <?php $filename = 'includes/ports16.txt';
  72. $eachlines = file($filename, FILE_IGNORE_NEW_LINES);//create an array
  73. echo '<select name="gport" id="value" required>';
  74. echo "<option value=''>Select Anyone</option>";
  75. foreach($eachlines as $lines){
  76. echo "<option value='{$lines}'>{$lines}</option>";
  77. }
  78. echo '</select>'; ?><br><br>
  79.  
  80. Comments:<Input type="text" name="comment" required><br><br>
  81. <Input type="submit" value="Submit" name="submit" onclick="return mess();">
  82.  
  83. <script type="text/javascript">
  84. function mess()
  85. {
  86.         alert ("Your records are inserted successfully");
  87.         return true;
  88. }
  89. </script>
  90. </form>
]]>