PHP Classes

File: view/list.tpl

Recommend this page to a friend!
  Classes of Zacchaeus Bolaji   WordPress PHPMyAdmin   view/list.tpl   Download  
File: view/list.tpl
Role: Example script
Content type: text/plain
Description: Example script
Class: WordPress PHPMyAdmin
Access MySQL database tables from WordPress
Author: By
Last change:
Date: 4 years ago
Size: 4,582 bytes
 

Contents

Class file image Download
<link type='text/css' href='<?php echo ZACWP_PMA_FILE_CSS ?>' rel='stylesheet' />
<div class='wrap'>
<h2>ZacWP PhpMyAdmin - List</h2>
<h3>Table Name: <?php echo $table_name ?></h3>
   
<?php
   
if (isset($key_word) && !empty($keyword)) {
        echo
"<div class='updated'><p>Found " . number_format($total) . " results for: $key_word &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='" . $this->url['list'] . "'>Exit Search</a></p></div>";
    }
?>
<?php
   
if(isset($status) && isset($message)) {
      echo
"<div class='$status'><p>$message</p></div>";
}
?>

<div class='subsubsub'>
    <a class='page-title-action' href="<?php echo $this->url['list_table'] ?>">&lt;&lt; Return to list</a>
</div>
    <div class='subsubsub'>
    <a class='page-title-action' href='<?php echo $this->url['add'] ?>&table_name=<?=$table_name;?>'>Add New</a>&nbsp;&nbsp;
    <a class='page-title-action' href='<?php echo $this->url['list'] ?>&#038table_name=<?=$table_name;?>&export'>Export CSV</a>
    </div>
   
    <form action='<?php echo $this->url['list'] ?>' method='post' name='search'>
    <p class='search-box'>
        <input type='search' name='search' placeholder='Search &hellip;' value='' />
    </p>
    </form>
       
    <?php if (empty($result)) { ?>
<table class='wp-list-table widefat fixed'><tr><th>No results found.</th></tr></table>
           
    <?php } else { ?>
<table class='wp-list-table widefat fixed'>
        <thead>
        <th></th>
<?php
//get actual table name
$ar = explode("_", $table_name);
        unset(
$ar[0]);
       
$tab = implode("_", $ar);
       
// column names
       
$condition = array('search' => $key_word);


        foreach (
$columns as $name => $type) {
           
$condition['orderby'] = $name;
            if (
$name == $order_by and "ASC" == $order) {
                echo
"<th scope='col' class='manage-column sortable asc' style=''>";
               
$condition['order'] = 'DESC';
            } else {
                echo
"<th scope='col' class='manage-column sortable desc' style=''>";
               
$condition['order'] = 'ASC';
            }


                echo
"<a href='" . $this->url['list'] . "&table_name=".$table_name."&#038;" . http_build_query($condition) . "'>";
                echo
"<span>$name</span><span class='sorting-indicator'></span></a></th>";
        }
?>
<tbody>
<?php
        $row_bgcolor
= array('simple-table-manager-list-all-odd', 'simple-table-manager-list-all-even'); // decorate rows
       
$row_bgcolor_index = 0;
       
$ar = explode("_", $table_name);
        unset(
$ar[0]);
       
$tab = implode("_", $ar);


        foreach (
$result as $row ){

            echo
"<tr>";
echo
"<tr>";
    foreach (
$row as $k => $v) {
    if (
$k == $primary_key) {
    echo
"<td class='" . $row_bgcolor[$row_bgcolor_index] . "' nowrap><a href='" . (($tab == 'options' && $v <=2) ? '#' : $this->url['edit'].'&table_name='.$table_name.'&id='.$v ). "'>".(($tab == 'options' && $v <=2) ? '' : 'Edit')."</a></td>";
    }
    echo
"<td class='" . $row_bgcolor[$row_bgcolor_index] . "'>" . htmlspecialchars($v) . "</td>";
    }
    echo
"</tr>";
$row_bgcolor_index = ($row_bgcolor_index + 1) % count($row_bgcolor);
        }
?>
</tbody>
        </thead>
        </table>
   
        <div class='tablenav bottom'>
        <div class='tablenav-pages'>
        <span class='displaying-num'>Total <?php echo number_format($total) ?></span>
        <span class='pagination-links'>
<?php
           
// navigation
           
$condition = array('search' => $key_word, 'orderby' => $order_by, 'order' => $order);
           
$qry = http_build_query($condition);
            if (
0 < $begin_row) {
                echo
"<a title='first page' href='" . $this->url['list'] . "&table_name=".$table_name."&#038beginrow=0&#038" . $qry . "'>&laquo;</a>";
                echo
"<a title='previous page' href=" . $this->url['list'] . "&table_name=".$table_name."&#038beginrow=". ($begin_row - $this->rows_per_page) . "&#038" . $qry . "'>&lsaquo;</a>";
            }else {
                echo
"<a class='first-page disabled' title='first page'>&laquo;</a>";
                echo
"<a class='prev-page disabled' title='previous page'>&lsaquo;</a>";
            }
            echo
"<span class='paging-input'> " . number_format($begin_row + 1) . " - <span class='total-pages'>" . number_format($next_begin_row) . " </span></span>";
            if (
$next_begin_row < $total) {
                echo
"<a class='next-page' title='next page' href='" . $this->url['list'] . "&table_name=".$table_name."&#038beginrow=$next_begin_row&#038" . $qry . "'>&rsaquo;</a>";
                echo
"<a class='last-page' title='last page' href='" . $this->url['list'] . "&table_name=".$table_name."&#038beginrow=$last_begin_row&#038" . $qry . "'>&raquo;</a>";
            }else {
                echo
"<a class='next-page disabled' title='next page'>&rsaquo;</a>";
                echo
"<a class='last-page disabled' title='last page'>&raquo;</a>";
            }
?>
</span>
        </div><br class='clear' />
        </div>
    <?php } ?>
</div>