从自定义表单将数据插入Wordpress数据库表 [英] Insert data into Wordpress database table from a custom form
本文介绍了从自定义表单将数据插入Wordpress数据库表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试通过创建表将数据插入Wordpress数据库.我已经创建了表格,但是当我尝试从表单中插入数据时,它不会插入数据.我已经检查了数据库连接是否正常,但是不会发生插入.有人可以帮我吗?这是我的代码:-
I am trying to insert data into Wordpress database by creating a table. I have created the table but when I try to insert the data from form, it does not insert the data. I have checked that database connection works, but the insertion does not happen. Can someone help me on this? Here is my code:-
<?php
require_once('/wp-config.php');
global $wpdb;
if(isset($_POST['submit'])){
$wpdb->insert( 'wp_post_job', array( 'organizationname' =>
$_POST['organizationname'], 'post' => $_POST['post'], 'publishfrom' =>
$_POST['publishfrom'], 'publishupto' => $_POST['publishupto'],
'qualification1' => $_POST['qualification1'], 'qualification2' =>
$_POST['qualification2'], 'qualification3' => $_POST['qualification3'],
'qualification4' => $_POST['qualification4'], 'experience1' =>
$_POST['experience1'], 'experience2' => $_POST['experience2'],
'experience3' => $_POST['experience3'], 'training1' => $_POST['training1'], 'training2' => $_POST['training2'], 'training3' => $_POST['training3'],
'training4' => $_POST['training4'], 'training5' => $_POST['training5'] ),
array( '$s', '$s', '$s', '$s', '$s', '$s', '$s', '$s', '$s', '$s', '$s', '$s', '$s', '$s', '$s', '$s' ) );
}
?>
<?php
/*
Template Name: Form
*/
?>
<?php global $pc_theme_object; /* Reference theme framework class */ ?>
<?php get_header(); ?>
<form action="" id="postjob" method="post">
<table>
<tr>
<td><label for="organizationname">Organization Name:</label></td>
<td><input type="text" name="organizationname" id="organizationname" value="/></td>
</tr>
<tr>
<td><label for="post">Post:</label></td>
<td><input type="text" name="post" id="post" value="" /></td>
</tr>
<tr>
<td><label for="publishfrom">Publish From:</label></td>
<td><input type="text" name="publishfrom" id="publishfrom" /></td>
</tr>
<tr>
<td><label for="publishupto">Publish Upto:</label></td>
<td><input type="text" name="publishupto" id="publishupto" /></td>
</tr>
<tr>
<td><label for="qualification">Qualification:</label></td>
<td><input type="text" name="qualification1" id="qualification1" /></td>
<td><input type="text" name="qualification2" id="qualification2" /></td>
<td><input type="text" name="qualification3" id="qualification3" /></td>
<td><input type="text" name="qualification4" id="qualification4" /></td>
</tr>
<tr>
<td><label for="experience">Experience:</label></td>
<td><input type="text" name="experience1" id="experience1"/></td>
<td><input type="text" name="experience2" id="experience2"/></td>
<td><input type="text" name="experience3" id="experience3"/></td>
</tr>
<tr>
<td><label for="training">Training:</label></td>
<td><input type="text" name="training1" id="training1" />></td>
<td><input type="text" name="training2" id="training2" /></td>
<td><input type="text" name="training3" id="training3" /></td>
<td><input type="text" name="training4" id="training4" /></td>
<td><input type="text" name="training5" id="training5" /></td>
</tr>
<tr>
<td><button type="submit" name="submit">Submit</button></td>
</tr>
</table>
</form>
<?php get_footer(); ?>
推荐答案
将'$ s'替换为'%s'
使用此代码
if ( isset( $_POST['submit'] ) ){
global $wpdb;
$tablename = $wpdb->prefix.'post_job';
$wpdb->insert( $tablename, array(
'organizationname' => $_POST['organizationname'],
'post' => $_POST['post'],
'publishfrom' => $_POST['publishfrom'],
'publishupto' => $_POST['publishupto'],
'qualification1' => $_POST['qualification1'],
'qualification2' => $_POST['qualification2'],
'qualification3' => $_POST['qualification3'],
'qualification4' => $_POST['qualification4'],
'experience1' => $_POST['experience1'],
'experience2' => $_POST['experience2'],
'experience3' => $_POST['experience3'],
'training1' => $_POST['training1'],
'training2' => $_POST['training2'],
'training3' => $_POST['training3'],
'training4' => $_POST['training4'],
'training5' => $_POST['training5'] ),
array( '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s' )
);
}
这篇关于从自定义表单将数据插入Wordpress数据库表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文