{"id":2618,"date":"2025-06-11T04:41:29","date_gmt":"2025-06-10T20:41:29","guid":{"rendered":"https:\/\/www.zhaozhao123.cn\/wpcms\/wpdt\/2618.html"},"modified":"2025-06-11T04:41:29","modified_gmt":"2025-06-10T20:41:29","slug":"%e5%a6%82%e4%bd%95%e5%b0%86%e8%81%94%e7%b3%bb%e8%a1%a8%e5%8d%95%e6%95%b0%e6%8d%ae%e4%bf%9d%e5%ad%98%e5%88%b0wordpress%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/www.zhaozhao123.cn\/wpcms\/post\/2618.html","title":{"rendered":"\u5982\u4f55\u5c06\u8054\u7cfb\u8868\u5355\u6570\u636e\u4fdd\u5b58\u5230WordPress\u6570\u636e\u5e93"},"content":{"rendered":"
\r\n
\r\n
\r\n
\r\n
\r\n
\"Bug编译狮\"<\/figure>\r\n\r\n\r\n\r\n

Bug编译狮<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n

\r\n
\r\n

要将联系表单的数据保存到WordPress的数据库中，你可以使用以下步骤：<\/p>\n

    \n
  1. \n

    创建联系表单<\/strong>：首先，在WordPress后台添加一个联系表单。这可以通过编辑functions.php<\/code>文件或使用插件来实现。<\/p>\n<\/li>\n

  2. \n

    设置表单字段<\/strong>：在表单中定义你需要收集的信息字段。例如，你可以添加姓名、电子邮件和电话号码等字段。<\/p>\n<\/li>\n

  3. \n

    编写PHP脚本<\/strong>：在你的网站根目录下创建一个PHP文件（如contact-form-handler.php<\/code>），并在其中编写代码来处理表单提交。<\/p>\n<\/li>\n

  4. \n

    插入代码<\/strong>：将下面的代码复制并粘贴到你的PHP文件中，然后上传并激活它。这个代码片段将会从表单中获取信息，并将其保存到WordPress的数据库中。<\/p>\n<\/li>\n<\/ol>\n

    <?php\n\n\/\/ 获取表单数据\n$fname = $_POST['fname'];\n$email = $_POST['email'];\n$phone = $_POST['phone'];\n\n\/\/ 创建数据库连接\n$db_host = 'localhost';\n$db_user = 'username'; \/\/ 替换为你的用户名\n$db_pass = 'password'; \/\/ 替换为你的密码\n$db_name = 'wordpress_db'; \/\/ 替换为你的数据库名\n$conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);\n\nif (!$conn) {\n    die(\"Connection failed: \" . mysqli_connect_error());\n}\n\n\/\/ 插入数据到数据库\n$sql = \"INSERT INTO contacts (name, email, phone)\n        VALUES ('$fname', '$email', '$phone')\";\n\nif (mysqli_query($conn, $sql)) {\n    echo \"New record created successfully\";\n} else {\n    echo \"Error: \" . $sql . \"<br>\" . mysqli_error($conn);\n}\n\nmysqli_close($conn);\n?><\/code><\/pre>\n
      \n
    1. \n
      确保数据库配置正确<\/strong>：在上述代码中，你需要替换$db_host<\/code>, $db_user<\/code>, $db_pass<\/code>, 和 $db_name<\/code>为你自己的数据库相关信息。此外，请确保你的WordPress安装有正确的数据库权限。<\/p>\n<\/li>\n
    2. \n
      测试功能<\/strong>：最后，测试一下你的联系表单是否能够正常工作。当用户填写并提交表单时，应能看到新的记录被成功添加到WordPress数据库中。<\/p>\n<\/li>\n<\/ol>\n
      请注意，以上代码仅为基本示例，实际应用中可能需要根据具体需求调整。例如，你可能需要处理错误情况、验证输入的有效性或其他安全措施。<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>
      \r\n
      \r\n
      \r\n
      \r\n
      \r\n
      \"黑板前的Bug语法讲师\"<\/figure>\r\n\r\n\r\n\r\n
      黑板前的Bug语法讲师<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n\r\n\r\n\r\n
      \r\n
      \r\n
      要将联系表单数据保存到WordPress数据库，你需要遵循以下步骤：<\/p>\n
      1. 创建一个WordPress插件<\/h3>\n
      首先，创建一个新的WordPress插件。你可以使用WordPress官方提供的wp-content\/plugins\/<\/code>目录来存储你的插件文件。<\/p>\n
      1.1 编辑新插件文件<\/h4>\n
      打开一个新的文本编辑器（如Notepad++或Visual Studio Code），然后新建一个文件，命名为contact_form.php<\/code>。<\/p>\n
      <?php\n\/\/ 导入WordPress核心类\nrequire_once(ABSPATH . 'wp-admin\/includes\/plugin.php');\n\n\/\/ 确保插件已激活\nif (!class_exists('WP_Widget')) {\n    require_once(ABSPATH . 'wp-admin\/includes\/class-wp-widget-base.php');\n}\n\n\/**\n * Contact Form widget class.\n *\/\nclass WP_Widget_Contact_Form extends WP_Widget {\n\n    public function __construct() {\n        parent::__construct(\n            'contact_form',\n            __( 'Contact Form', 'your_plugin' ),\n            array( 'description' => __( 'A contact form for your site.', 'your_plugin' ) )\n        );\n    }\n\n    \/**\n     * Output the widget HTML.\n     *\n     * @return void\n     *\/\n    public function widget( $args, $instance ) {\n        extract( $args );\n\n        \/\/ 输出标签\n        echo $before_label . $instance['label'] . $after_label;\n\n        \/\/ 输出输入框\n        if ( ! empty( $instance['name'] ) ) {\n            printf( '<input type=\"text\" name=\"%s\" id=\"%s\" value=\"%s\" \/>', esc_attr( $this->get_field_id( 'name' ) ), esc_attr( $this->get_field_id( 'name' ) ), esc_attr( $instance['name'] ) );\n        }\n        if ( ! empty( $instance['email'] ) ) {\n            printf( '<input type=\"email\" name=\"%s\" id=\"%s\" value=\"%s\" \/>', esc_attr( $this->get_field_id( 'email' ) ), esc_attr( $this->get_field_id( 'email' ) ), esc_attr( $instance['email'] ) );\n        }\n        if ( ! empty( $instance['message'] ) ) {\n            printf( '<textarea name=\"%s\" id=\"%s\" cols=\"30\" rows=\"10\">%s<\/textarea>', esc_attr( $this->get_field_id( 'message' ) ), esc_attr( $this->get_field_id( 'message' ) ), esc_attr( $instance['message'] ) );\n        }\n\n        \/\/ 输出提交按钮\n        printf( '<br><button type=\"submit\" name=\"%s\" id=\"%s\">Send Message<\/button>', esc_attr( $this->get_field_id( 'send_button' ) ), esc_attr( $this->get_field_id( 'send_button' ) ) );\n\n        echo $after_widget;\n    }\n\n    \/**\n     * Back-end widget form.\n     *\n     * @param $args     Widget arguments.\n     * @param $instance  Widget instance.\n     *\n     * @return void\n     *\/\n    public function form( $args, $instance ) {\n        printf( '<div id=\"%s\" class=\"form-field\"><label for=\"%s\">%s:<\/label><input type=\"text\" class=\"widefat\" name=\"%s[name]\" id=\"%s[name]\" value=\"%s\"\/>&nbsp;<\/div>',\n                $this->get_field_id( 'name' ),\n                $this->get_field_id( 'name' ),\n                __( 'Name', 'your_plugin' ),\n                $this->get_field_name(),\n                $this->get_field_name(),\n                esc_attr( $instance['name'] )\n        );\n\n        printf( '<div id=\"%s\" class=\"form-field\"><label for=\"%s\">%s:<\/label><input type=\"email\" class=\"widefat\" name=\"%s[email]\" id=\"%s[email]\" value=\"%s\"\/>&nbsp;<\/div>',\n                $this->get_field_id( 'email' ),\n                $this->get_field_id( 'email' ),\n                __( 'Email', 'your_plugin' ),\n                $this->get_field_name(),\n                $this->get_field_name(),\n                esc_attr( $instance['email'] )\n        );\n\n        printf( '<div id=\"%s\" class=\"form-field\"><label for=\"%s\">%s:<\/label><textarea name=\"%s[message]\" id=\"%s[message]\" cols=\"30\" rows=\"10\">%s<\/textarea><\/div>',\n                $this->get_field_id( 'message' ),\n                $this->get_field_id( 'message' ),\n                __( 'Message', 'your_plugin' ),\n                $this->get_field_name(),\n                $this->get_field_name(),\n                esc_attr( $instance['message'] )\n        );\n\n        printf( '<div id=\"%s\" class=\"form-field\"><label for=\"%s\">%s:<\/label><input type=\"submit\" class=\"button\" name=\"%s[send_button]\" id=\"%s[send_button]\" value=\"%s\"\/><\/div>',\n                $this->get_field_id( 'send_button' ),\n                $this->get_field_id( 'send_button' ),\n                __( 'Submit', 'your_plugin' ),\n                $this->get_field_name(),\n                $this->get_field_name(),\n                esc_attr( $instance['send_button'] )\n        );\n    }\n\n    \/**\n     * Sanitize widget form values as they are saved.\n     *\n     * @see WP_Widget::update()\n     *\n     * @param $new_instance       Exposed after saving.\n     * @param $old_instance       Saved in `$_wp_post_custom`.\n     *\n     * @return array Updated safe values to be saved.\n     *\/\n    public function update( $new_instance, $old_instance ) {\n        $instance = wp_parse_args( (array) $new_instance, (array) $old_instance );\n\n        return $instance;\n    }\n\n    \/**\n     * Back-end widget form presentation.\n     *\n     * @param $instance  Widget instance.\n     *\n     * @return void\n     *\/\n    public function markup( $instance ) {\n        $output = '';\n\n        $output .= sprintf( '<label for=\"%s\">%s:<\/label><input type=\"text\" class=\"widefat\" name=\"%s[name]\" id=\"%s[name]\" value=\"%s\" \/>',\n                            $this->get_field_id( 'name' ),\n                            __( 'Name', 'your_plugin' ),\n                            $this->get_field_name(),\n                            $this->get_field_name(),\n                            $instance['name']\n        );\n\n        $output .= sprintf( '<label for=\"%s\">%s:<\/label><input type=\"email\" class=\"widefat\" name=\"%s[email]\" id=\"%s[email]\" value=\"%s\" \/>',\n                            $this->get_field_id( 'email' ),\n                            __( 'Email', 'your_plugin' ),\n                            $this->get_field_name(),\n                            $this->get_field_name(),\n                            $instance['email']\n        );\n\n        $output .= sprintf( '<label for=\"%s\">%s:<\/label><textarea name=\"%s[message]\" id=\"%s[message]\" cols=\"30\" rows=\"10\">%s<\/textarea>',\n                            $this->get_field_id( 'message' ),\n                            __( 'Message', 'your_plugin' ),\n                            $this->get_field_name(),\n                            $this->get_field_name(),\n                            $instance['message']\n        );\n\n        $output .= sprintf( '<label for=\"%s\">%s:<\/label><input type=\"submit\" class=\"button\" name=\"%s[send_button]\" id=\"%s[send_button]\" value=\"%s\" \/><\/div>',\n                            $this->get_field_id( 'send_button' ),\n                            __( 'Submit', 'your_plugin' ),\n                            $this->get_field_name(),\n                            $this->get_field_name(),\n                            $instance['send_button']\n        );\n\n        return $output;\n    }\n}\n?>\n<\/code><\/pre>\n
      这个插件定义了一个名为contact_form<\/code>的自定义插件，用于展示一个简单的联系表单。<\/p>\n
      2. 将插件添加到WordPress<\/h3>\n
      接下来，在WordPress主题的functions.php<\/code>文件中添加以下代码以启用此插件：<\/p>\n
      function enable_contact_form_plugin() {\n    register_plugin( 'my-plugin\/contact-form.php' );\n}\n\nadd_action( 'admin_init', 'enable_contact_form_plugin' );<\/code><\/pre>\n
      现在，当你激活这个插件时，用户应该可以看到一个简单的联系表单。<\/p>\n
      3. 存储联系信息到数据库<\/h3>\n
      要在WordPress数据库中存储表单数据，请执行以下操作：<\/p>\n
        \n
      • 使用wpdb<\/code>类连接数据库。<\/li>\n
      • 获取表单ID。<\/li>\n
      • 查询并更新相关字段。<\/li>\n
      • 更新表单状态。<\/li>\n<\/ul>\n
        示例代码：<\/h4>\n
        $contact_form_id = get_option('my_contact_form_id'); \/\/ 获得表单ID\n\n\/\/ 获取表单名称\n$name = get_field('name', $contact_form_id);\n$email = get_field('email', $contact_form_id);\n\n$message = get_field('message', $contact_form_id);\n\n\/\/ 检查表单是否已被提交\nif ($message && $email) {\n    \/\/ 更新表单状态为已提交\n    update_option('my_contact_form_status', 'sent');\n\n    \/\/ 提交表单数据到数据库\n    $sql = \"INSERT INTO my_table (name, email, message)\n             VALUES ('$name', '$email', '$message')\";\n    $result = $wpdb->query($sql);\n}<\/code><\/pre>\n
        请确保替换my-contact-form-id<\/code>, my-table<\/code>和my_table<\/code>中的值为你实际需要的值。<\/p>\n
        注意事项<\/h3>\n
          \n
        • 在生产环境中部署此插件前，务必先对代码进行安全测试和调试。<\/li>\n
        • 如果需要进一步扩展功能，可以考虑引入更复杂的数据验证、错误处理等逻辑。<\/li>\n<\/ul>\n
          通过上述方法，你应该能够有效地将联系表单数据保存到WordPress数据库。如果你有任何疑问或需要进一步的帮助，请随时提问！<\/p>\r\n<\/div>\r\n<\/div>\r\n<\/div>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"
          Bug编译狮 要将联系表单的数据保存到WordPress的数据&#2..<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[59],"tuisongtax":[],"class_list":["post-2618","post","type-post","status-publish","format-standard","hentry","category-wpdt","tag-pzjc"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/posts\/2618","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/comments?post=2618"}],"version-history":[{"count":0,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/posts\/2618\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/media?parent=2618"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/categories?post=2618"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/tags?post=2618"},{"taxonomy":"tuisongtax","embeddable":true,"href":"https:\/\/www.zhaozhao123.cn\/wpcms\/wp-json\/wp\/v2\/tuisongtax?post=2618"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}