PHP Classes

File: view/add-table.tpl

Recommend this page to a friend!
  Classes of Zacchaeus Bolaji   WordPress PHPMyAdmin   view/add-table.tpl   Download  
File: view/add-table.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: 2,624 bytes


Class file image Download
<link type='text/css' href='<?php echo ZACWP_PMA_FILE_CSS ?>' rel='stylesheet' />
<div class='wrap'>
    <h2>ZacWP PhpMyAdmin - Add Table</h2>

    <div class='subsubsub'>
        <a class='page-title-action' href="<?php echo $this->url['list_table'] ?>">&lt;&lt; Return to list</a>

if(isset($status) && isset($message)) {
"<div class='$status'><p>$message</p></div>";
<form method='post' action='<?php echo $this->url['edit_table'];?>'>
<input name="zacwp_table_add_nonce" value="<?php echo $add_nonce; ?>" type="hidden">

    <table class='wp-list-table widefat fixed' id='zacwp-add-table'>
"<tr><th class='simple-table-manager'>Table Name</th><td><input class='form-control' type='text' required name='new_table_name'></td></tr>";
"<tr><th class='simple-table-manager'></th><td><button type='button' onclick='addField()' class='btn btn-success'>Add Column</button></td></tr>";
    <div class="tablenav bottom">
        <input type='submit' name='add-table' value='Add' class='button' required>

    function makeid(length) {
        var result = '';
        var characters = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';
        var charactersLength = characters.length;
        for ( var i = 0; i < length; i++ ) {
            result += characters.charAt(Math.floor(Math.random() * charactersLength));
        return result;
    function addField() {
        var id = makeid(6);
        var string = "<tr id='"+id+"'>" +
            "<th class='simple-table-manager'><input class='form-control' type='text' name='tab-col[name][]' placeholder='column name' required></th>" +
            "<td><select class='form-control' name='tab-col[type][]' required>" +
            "<option value='INT'>Number</option>" +
            "<option value='VARCHAR'>Short text (max 255)</option>" +
            "<option value='TEXT'>Long Text</option>" +
            "<option value='DATE'>Date</option>" +
            " </select></td>" +
                "<td><button type='button' onclick='removeField(\""+id+"\")'>Remove</button></td>"+

        var element = document.getElementById("zacwp-add-table");
        element.insertAdjacentHTML('beforeend', string);

    function removeField(elementId) {
        var element = document.getElementById(elementId);
        console.log(JSON.stringify(element, null, 4))