<?php
session_start();
/*
Plugin Name: manoj_create_menu
Plugin URI: http://mcamady.blogspot.com/#
Description: created by Manoj Agarwal.
Author: Manu Agarwal
*/
add_action('admin_menu', 'manoj_create_menu');
function manoj_create_menu() {
//create new top-level menu
add_menu_page('Payment History', 'Payment History', 'administrator', __FILE__, 'baw_settings_page',plugins_url('/images/icon.png', __FILE__));
//call register settings function
add_action( 'admin_init', 'register_mysettings' );
}
function register_mysettings() {
//register our settings
register_setting( 'manoj-settings-group', 'new_option_name' );
register_setting( 'manoj-settings-group', 'some_other_option' );
register_setting( 'manoj-settings-group', 'option_etc' );
}
function username($userid)
{
$query=mysql_query("select * from register where user_id='$userid' ");
$row=mysql_fetch_array($query);
return $row['user_name'];
}
function usermail($userid)
{
$query=mysql_query("select * from register where user_id='$userid' ");
$row=mysql_fetch_array($query);
return $row['user_email'];
}
function baw_settings_page() {
?>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js">
</script>
<script src="jquery.tablePagination.0.5.js">
</script>
<script type="text/javascript">
$(document).ready(function() {
$('table').tablePagination({});
});
</script>
<style>
td {
border: 1px solid black;
}
#testTable {
width : 350px;
margin-left: auto;
margin-right: auto;
}
#tablePagination {
background-color: #DCDCDC;
font-size: 0.8em;
padding: 0px 5px;
height: 20px
}
#tablePagination_paginater {
margin-left: auto;
margin-right: auto;
}
#tablePagination img {
padding: 0px 2px;
}
#tablePagination_perPage {
float: left;
}
#tablePagination_paginater {
float: right;
}
</style>
<script>
function showUser(str)
{
if (str=="")
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","deletetag.php?q="+str,true);
xmlhttp.send();
}
</script>
<div class="wrap">
<br/><br/><br/>
<h2>Payment History</h2>
<p> </p>
<script>
function showHint(str)
{
if (str.length==0)
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","gethint.php?q="+str,true);
xmlhttp.send();
}
</script>
<p><strong>Enter the txn reference no.</strong></td><td><input type="text" name="search" onkeyup="showHint(this.value)" /></p>
<br/><br/>
<span id="txtHint">
<?php $result = mysql_query("SELECT * FROM payments ");
echo "<table width='100%' border='1' cellspacing='0' cellpadding='2' id='menuTable'>";
echo "<thead>
<tr>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Ref.</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Amount</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Date</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>User-Name</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>User-Email</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Status</th>
</tr></thead>";
// loop through results of database query, displaying them in the table
while($row=mysql_fetch_array($result))
{
// echo out the contents of each row into a table
echo "<tr>";
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' . $row['txnid'] . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">$'.$row['payment_amount']. '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">'.$row['createdtime'] . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' .username($row['payer_id']) . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' . usermail($row['payer_id']) . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' . $row['payment_status'] . '</td>';
echo "</tr>";
// close table>
}
echo "</table>";
}
?>
</span>
</div>
session_start();
/*
Plugin Name: manoj_create_menu
Plugin URI: http://mcamady.blogspot.com/#
Description: created by Manoj Agarwal.
Author: Manu Agarwal
*/
add_action('admin_menu', 'manoj_create_menu');
function manoj_create_menu() {
//create new top-level menu
add_menu_page('Payment History', 'Payment History', 'administrator', __FILE__, 'baw_settings_page',plugins_url('/images/icon.png', __FILE__));
//call register settings function
add_action( 'admin_init', 'register_mysettings' );
}
function register_mysettings() {
//register our settings
register_setting( 'manoj-settings-group', 'new_option_name' );
register_setting( 'manoj-settings-group', 'some_other_option' );
register_setting( 'manoj-settings-group', 'option_etc' );
}
function username($userid)
{
$query=mysql_query("select * from register where user_id='$userid' ");
$row=mysql_fetch_array($query);
return $row['user_name'];
}
function usermail($userid)
{
$query=mysql_query("select * from register where user_id='$userid' ");
$row=mysql_fetch_array($query);
return $row['user_email'];
}
function baw_settings_page() {
?>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js">
</script>
<script src="jquery.tablePagination.0.5.js">
</script>
<script type="text/javascript">
$(document).ready(function() {
$('table').tablePagination({});
});
</script>
<style>
td {
border: 1px solid black;
}
#testTable {
width : 350px;
margin-left: auto;
margin-right: auto;
}
#tablePagination {
background-color: #DCDCDC;
font-size: 0.8em;
padding: 0px 5px;
height: 20px
}
#tablePagination_paginater {
margin-left: auto;
margin-right: auto;
}
#tablePagination img {
padding: 0px 2px;
}
#tablePagination_perPage {
float: left;
}
#tablePagination_paginater {
float: right;
}
</style>
<script>
function showUser(str)
{
if (str=="")
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","deletetag.php?q="+str,true);
xmlhttp.send();
}
</script>
<div class="wrap">
<br/><br/><br/>
<h2>Payment History</h2>
<p> </p>
<script>
function showHint(str)
{
if (str.length==0)
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","gethint.php?q="+str,true);
xmlhttp.send();
}
</script>
<p><strong>Enter the txn reference no.</strong></td><td><input type="text" name="search" onkeyup="showHint(this.value)" /></p>
<br/><br/>
<span id="txtHint">
<?php $result = mysql_query("SELECT * FROM payments ");
echo "<table width='100%' border='1' cellspacing='0' cellpadding='2' id='menuTable'>";
echo "<thead>
<tr>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Ref.</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Amount</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Date</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>User-Name</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>User-Email</th>
<th align='center' bgcolor='#EAEAEA' class='box-txt' style='background-color:#d7d7d7;'>Order Status</th>
</tr></thead>";
// loop through results of database query, displaying them in the table
while($row=mysql_fetch_array($result))
{
// echo out the contents of each row into a table
echo "<tr>";
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' . $row['txnid'] . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">$'.$row['payment_amount']. '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">'.$row['createdtime'] . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' .username($row['payer_id']) . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' . usermail($row['payer_id']) . '</td>';
echo '<td align="center" bgcolor="#FFFFFF" class="box-txt">' . $row['payment_status'] . '</td>';
echo "</tr>";
// close table>
}
echo "</table>";
}
?>
</span>
</div>
Nice article about Wordpress theme development.
ReplyDeleteWordpress Theme Development in Pun
Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with extra information? It is extremely helpful for me. Book Cheap Hotels Rooms in Lekki Nigeria
ReplyDelete