vouchers.php

From ali, 6 Years ago, written in Plain Text.

This paste is a reply to do-not-refresh from ali - go back

URL http://geopaste.scratchbook.ch/view/c1d5750e

Embed

Viewing differences between do-not-refresh and vouchers.php

~~<?php~~

<?php
include("includes/db.php");
~~if(isset($_REQUEST["gref"]))~~
//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 "<pre>";
// print_r($_REQUEST);
// die;
$date=date('d-m-Y');
$time=date('H:i:s');
$gref=$_REQUEST["gref"];
$gip=$_REQUEST["gip"];
$gport=$_REQUEST["gport"];
$staff=$_REQUEST["staff"];
$mgw=$_REQUEST["mgw"];
$mussd=$_REQUEST["mussd"];
$prob=$_REQUEST["problem"];
$action=$_REQUEST["action"];
$comment=$_REQUEST["comment"];

echo mysql_query("insert into minutes(date,time,g_ref,g_ip,g_port,staff,m_gw,m_ussd,problem,action,comment)values('$date','$time','$gref','$gip','$gport','$staff','$mgw','$mussd','$prob','$action','$comment')");
die;
"Failed to insert the records!";
        }
}
?>

<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title>Page Title</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" type="text/css" media="screen" href="main.css" />
<script src="main.js"></script>
</head>
<body>
?>

<form method="post" ~~id="frm1">~~
id="frm1">

Lot # :<Input type="text" name="lot" required><br><br>

Date :<Input type="date" name="date" required><br><br>

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
</select><br><br>

Item Name :
<?php $filename = 'includes/iname.txt';
$eachlines = file($filename, FILE_IGNORE_NEW_LINES);//create an array
echo '<select name="iname" id="value" required>';
echo "<option value=''>Select Anyone</option>";
foreach($eachlines as $lines){
echo "<option value='{$lines}'>{$lines}</option>";
}
echo '</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:
<select name="gref">
<option>Select Any One</option>
<option value="Ish-01-Qmr">Ish-01-Qmr</option>
</select><br><br>
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>~~
</select><br><br>

Gateway Port:
~~<select~~ <?php $filename = 'includes/ports16.txt';
$eachlines = file($filename, FILE_IGNORE_NEW_LINES);//create an array
echo '<select name="gport" required>
<option value="">Select Any One</option>
<option value="Port00">Port00</option>
<option value="Port01">Port01</option>
<option value="Port02">Port02</option>
<option value="Port03">Port03</option>
<option value="Port04">Port04</option>
<option value="Port05">Port05</option>
<option value="Port06">Port06</option>
<option value="Port07">Port07</option>
<option value="Port08">Port08</option>
<option value="Port09">Port09</option>
<option value="Port10">Port10</option>
<option value="Port11">Port11</option>
<option value="Port12">Port12</option>
<option value="Port13">Port13</option>
<option value="Port14">Port14</option>
<option value="Port15">Port15</option>
</select><br><br>
Staff:<Input type="text" name="staff"><br><br>
Minutes On Gateway:<Input type="text" name="mgw"><br><br>
Minutes On USSD:<Input type="text" name="mussd"><br><br>
Problem:
<select name="problem">
<option>Select Any One</option>
<option value="Package minutes consumed.">Package minutes consumed.</option>
<option value="Not showing USSD response.">Not showing USSD response.</option>
<option value="Sim Blocked.">Sim Blocked.</option>
<option value="Port Status showing Power Off.">Port Status showing Power Off.</option>
<option value="Port Status showing No SIM Card.">Port Status showing No SIM Card.</option>
</select><br><br>
Action:
<select name="action">
<option>Select Any One</option>
<option value="Minutes in overview are set id="value" required>';
echo "<option value=''>Select Anyone</option>";
foreach($eachlines as USSD.">Minutes in overview are set as USSD.</option>
</select><br><br>
$lines){
echo "<option value='{$lines}'>{$lines}</option>";
}
echo '</select>'; ?><br><br>

Comments:<Input type="text" name="comment" required><br><br>
~~<br><br>~~
<Input type="submit" value="insert" name="submit">
</form>
</body>
value="Submit" name="submit" onclick="return mess();">

<script src="//ajax.googleapis.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script> 
<script>
$(document).ready(function(){
$('form').submit(function(event) {
event.preventDefault();

// get the form data
// there type="text/javascript">
function mess()
{
        alert ("Your records are many ways to get this data using jQuery (you can use the class or id also)
var formData = $(this).serializeArray()

// process the form
$.ajax({
type : 'POST', // define the type of HTTP verb we want to use (POST for our form)
// url : '', // the url where we want to POST
data : formData, // our data object
dataType : 'json', // what type of data do we expect back from the server
encode : true
})
// using the done promise callback
.done(function(data) {
document.getElementById('frm1').reset();

// log data to the console so we can see
alert('done');

// here we will handle errors and validation messages
});

// stop the form from submitting the normal way and refreshing the page
});

})
inserted successfully");
        return true;
}
</script>
~~</html>~~</form>

Author

Title

Language

Your paste - Paste your paste here

&lt;?php
include(&quot;includes/db.php&quot;);
//vouchers.php
if(isset($_REQUEST[&quot;submit&quot;]))
{
//      $derror = &quot;Duplicate record&quot;;
        $lot=$_REQUEST[&quot;lot&quot;];
        $date=$_REQUEST[&quot;date&quot;];
        $operator=$_REQUEST[&quot;operator&quot;];
        $iname=$_REQUEST[&quot;iname&quot;];
        $ivno=$_REQUEST[&quot;ivno&quot;];
        $vvalue=$_REQUEST[&quot;vvalue&quot;];
        $vno=$_REQUEST[&quot;vno&quot;];
        $gref=$_REQUEST[&quot;gref&quot;];
        $gip=$_REQUEST[&quot;gip&quot;];
        $gport=$_REQUEST[&quot;gport&quot;];
        $comment=$_REQUEST[&quot;comment&quot;];

if(mysql_query(&quot;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')&quot;))
        {
                header(&quot;Location:vouchers.php&quot;);
                exit;
        }
        else
        {
        echo &quot;Failed to insert the records!&quot;;
        }
}
?&gt;

&lt;form method=&quot;post&quot; id=&quot;frm1&quot;&gt;

Lot # :&lt;Input type=&quot;text&quot; name=&quot;lot&quot; required&gt;&lt;br&gt;&lt;br&gt;

Date :&lt;Input type=&quot;date&quot; name=&quot;date&quot; required&gt;&lt;br&gt;&lt;br&gt;

Operator :&lt;Input type=&quot;radio&quot;name=&quot;operator&quot;value=&quot;Zong&quot; required&gt;Zong&lt;Input type=&quot;radio&quot;name=&quot;operator&quot;value=&quot;Telenor&quot; required&gt;Telenor&lt;Input type=&quot;radio&quot;name=&quot;operator&quot;value=&quot;Jazz&quot; required&gt;Jazz
&lt;/select&gt;&lt;br&gt;&lt;br&gt;

Item Name :
&lt;?php $filename = 'includes/iname.txt';
$eachlines = file($filename, FILE_IGNORE_NEW_LINES);//create an array
echo '&lt;select name=&quot;iname&quot; id=&quot;value&quot; required&gt;';
echo &quot;&lt;option value=''&gt;Select Anyone&lt;/option&gt;&quot;;
foreach($eachlines as $lines){
echo &quot;&lt;option value='{$lines}'&gt;{$lines}&lt;/option&gt;&quot;;
}
echo '&lt;/select&gt;'; ?&gt;&lt;br&gt;&lt;br&gt;
I Voucher# :&lt;Input type=&quot;text&quot; name=&quot;ivno&quot; required&gt;&lt;br&gt;&lt;br&gt;

Voucher Value :&lt;Input type=&quot;radio&quot;name=&quot;vvalue&quot;value=&quot;100&quot; required&gt;100&lt;Input type=&quot;radio&quot;name=&quot;vvalue&quot;value=&quot;300&quot; required&gt;300&lt;Input type=&quot;radio&quot;name=&quot;vvalue&quot;value=&quot;500&quot; required&gt;500&lt;Input type=&quot;radio&quot;name=&quot;vvalue&quot;value=&quot;1000&quot; required&gt;1000 &lt;br&gt;&lt;br&gt;

Voucher # :&lt;Input type=&quot;text&quot; name=&quot;vno&quot; required&gt;&lt;br&gt;&lt;br&gt;

Gateway Ref :
&lt;?php $filename = 'includes/gref.txt';
$eachlines = file($filename, FILE_IGNORE_NEW_LINES);//create an array
echo '&lt;select name=&quot;gref&quot; id=&quot;value&quot; required&gt;';
echo &quot;&lt;option value=''&gt;Select Anyone&lt;/option&gt;&quot;;
foreach($eachlines as $lines){
echo &quot;&lt;option value='{$lines}'&gt;{$lines}&lt;/option&gt;&quot;;
}
echo '&lt;/select&gt;'; ?&gt;&lt;br&gt;&lt;br&gt;

Gateway IP:&lt;Input type=&quot;radio&quot;name=&quot;gip&quot;value=&quot;192.168.101.101&quot; required&gt;192.168.101.101&lt;Input type=&quot;radio&quot;name=&quot;gip&quot;value=&quot;192.168.101.102&quot; required&gt;192.168.101.102
&lt;/select&gt;&lt;br&gt;&lt;br&gt;

Gateway Port:
&lt;?php $filename = 'includes/ports16.txt';
$eachlines = file($filename, FILE_IGNORE_NEW_LINES);//create an array
echo '&lt;select name=&quot;gport&quot; id=&quot;value&quot; required&gt;';
echo &quot;&lt;option value=''&gt;Select Anyone&lt;/option&gt;&quot;;
foreach($eachlines as $lines){
echo &quot;&lt;option value='{$lines}'&gt;{$lines}&lt;/option&gt;&quot;;
}
echo '&lt;/select&gt;'; ?&gt;&lt;br&gt;&lt;br&gt;

Comments:&lt;Input type=&quot;text&quot; name=&quot;comment&quot; required&gt;&lt;br&gt;&lt;br&gt;
&lt;Input type=&quot;submit&quot; value=&quot;Submit&quot; name=&quot;submit&quot; onclick=&quot;return mess();&quot;&gt;

&lt;script type=&quot;text/javascript&quot;&gt;
function mess()
{
        alert (&quot;Your records are inserted successfully&quot;);
        return true;
}
&lt;/script&gt;
&lt;/form&gt;

Create Shorturl - Create a shorter url that redirects to your paste?

Private - Private paste aren't shown in recent listings.

Delete After - When should we delete your paste?

Reply to "vouchers.php"