Monday, 23 September 2013

Wordpress Admin Plugin Creation, Wordpress admin value listing pluign

<?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>&nbsp;</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>

2 comments:

  1. 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