php - Wordpress 使用简码将数据从前端插入自定义表

问题描述

我正在尝试通过从插件创建一个新表来将数据插入 WordPress 数据库。我使用简码来生成创建表的表单，但是当我尝试从表单插入数据时，它不会插入数据。有人可以帮我吗？

这是我的代码：-

function insert_into_employee_db() {
        global $wpdb;
        $page_link = get_permalink();

        // starts output buffering
        ob_start();
        ?>
        <style>
        form#v_form>input {
            margin: 5px;
        }
        </style>
        <form action="" method="post" id="v_form">

            <input type="text" name="total_employee" id="total_employee" placeholder="Total Employee" />
            <input type="text" name="present_employee" id="present_employee" placeholder="Present Today" />
            <input type="text" name="br_manager" id="br_manager"  placeholder="Manager Name"/>
            <input type="number" name="br_code" id="br_code"  placeholder="Branch Code"/>
            <input type="text" name="br_name" id="br_name"  placeholder="Branch Name"/>

            <input type="submit" name="submit_form" value="submit" />
        </form>
        <?php
        $html = ob_get_clean();
        // does the inserting, in case the form is filled and submitted
        if ( isset( $_POST["submit_form"] ) && $_POST["total_employee"] != "" ) {
            $tablename = $wpdb->prefix."sbl_employee";

            $time               = date("d/m/Y");
            $total_employee     = $_POST["total_employee"];
            $present_employee   = $_POST["present_employee"];
            $br_manager         = $_POST["br_manager"];
            $br_code            = $_POST["br_code"];
            $br_name            = $_POST["br_name"];
            $data = array(
                        'time'              => date('dd-mm-YY'),
                        'total_employee'    => (int)$total_employee,
                        'present_employee'  => (int)$present_employee,
                        'br_manager'        => $br_manager,
                        'br_code'           => (int)$br_code,
                        'br_name'           => $br_name,
                       );


            $format = array(
                '%s', '%s', '%s', '%s', '%s', '%s'
            );
            $success=$wpdb->insert( $tablename, $data, $format );
            if($success){
                $html = "<p>Successfully Saved. <a href=".$page_link.">Update? </a></p>";
            }else{
                $html = "failed. ". $wpdb->show_errors();
            }
        }
        // if the form is submitted but the name is empty
        if ( isset( $_POST["submit_form"] ) && $_POST["total_employee"] == "" )
            $html .= "<p>You need to fill the required fields.</p>";
        // outputs everything
        return $html;
    }
    // adds a shortcode you can use: [insert-employee]
    add_shortcode('insert_employee', 'insert_into_employee_db');

这是我的数据库创建功能

function sbl_employee_create_db() {

    global $wpdb;

    $charset_collate = $wpdb->get_charset_collate();
    $table_employee  = $wpdb->prefix . 'sbl_employee';
    $table_br_name   = $wpdb->prefix . 'sbl_br_name';

    $sql = "CREATE TABLE IF NOT EXISTS $table_employee (
        id mediumint(9) NOT NULL AUTO_INCREMENT,
        time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
        total_employee smallint(5) NOT NULL,
        present_employee smallint(5) NOT NULL,
        br_manager varchar(5) NOT NULL,
        br_code smallint(5) NOT NULL,
        br_name varchar(120) NOT NULL,
        UNIQUE KEY id (id)
    ) $charset_collate;";

    require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
    dbDelta( $sql );
}
//do action when plugin active
register_activation_hook( __FILE__, 'sbl_employee_create_db' );

标签： phpwordpress

php - Wordpress 使用简码将数据从前端插入自定义表

问题描述

解决方案

推荐阅读