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>