- <html>
- <head>
- <title></title>
- <script type="text/javascript">
- function populate(s1,s2){
- var s1 = document.getElementById(s1);
- var s2 = document.getElementById(s2);
- s2.innerHTML = "";
- if(s1.value == "Zong"){
- var optionArray = ["Z100|Z100","Z300|Z300","Z500|Z500"];
- } else if(s1.value == "Telenor"){
- var optionArray = ["T100|T100","T300|T300","T500|T500"];
- } else if(s1.value == "Jazz"){
- var optionArray = ["J100|J100","J300|J300","J500|J500"];
- }
- for(var option in optionArray){
- var pair = optionArray[option].split("|");
- var newOption = document.createElement("option");
- newOption.value = pair[0];
- newOption.innerHTML = pair[1];
- s2.options.add(newOption);
- }
- }
- </script>
- </head>
- <body>
- <?php
- include("includes/db.php");
- //vouchers.php
- if(isset($_REQUEST["submit"]))
- {
- // $derror = "Duplicate record";
- $lot=$_REQUEST["lot"];
- $date=$_REQUEST["date"];
- $operator=$_REQUEST["operator"];
- $iname=$_REQUEST["iname"];
- $ivno=$_REQUEST["ivno"];
- $vvalue=$_REQUEST["vvalue"];
- $vno=$_REQUEST["vno"];
- $gref=$_REQUEST["gref"];
- $gip=$_REQUEST["gip"];
- $gport=$_REQUEST["gport"];
- $comment=$_REQUEST["comment"];
- 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')"))
- {
- header("Location:vouchers.php");
- exit;
- }
- else
- {
- echo "Failed to insert the records!";
- }
- }
- ?>
- <form method="post" id="frm1">
- Lot # :<Input type="text" name="lot" required><br><br>
- Date :<Input type="date" name="date" required><br><br>
- Operator :<select id="slct1" name="operator" onchange="populate(this.id,'slct2')">
- <option value=" ">--select-- </option>
- <option value="Zong">Zong</option>
- <option value="Telenor">Telenor</option>
- <option value="Jazz">Jazz</option>
- </select><br><br>
- Item Name :<select id="slct2" name="iname"></select>
- <br><br>
- I Voucher# :<Input type="text" name="ivno" required><br><br>
- 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>
- Voucher # :<Input type="text" name="vno" required><br><br>
- Gateway Ref :
- <?php $filename = 'includes/gref.txt';
- $eachlines = file($filename, FILE_IGNORE_NEW_LINES);//create an array
- echo '<select name="gref" id="value" required>';
- echo "<option value=''>Select Anyone</option>";
- foreach($eachlines as $lines){
- echo "<option value='{$lines}'>{$lines}</option>";
- }
- echo '</select>'; ?><br><br>
- 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
- </select><br><br>
- Gateway Port:
- <?php $filename = 'includes/ports16.txt';
- $eachlines = file($filename, FILE_IGNORE_NEW_LINES);//create an array
- echo '<select name="gport" id="value" required>';
- echo "<option value=''>Select Anyone</option>";
- foreach($eachlines as $lines){
- echo "<option value='{$lines}'>{$lines}</option>";
- }
- echo '</select>'; ?><br><br>
- Comments:<Input type="text" name="comment" required><br><br>
- <Input type="submit" value="Submit" name="submit" onclick="return mess();">
- <script type="text/javascript">
- function mess()
- {
- alert ("Your records are inserted successfully");
- return true;
- }
- </script>
- </form>
- </body>
- </html>