我创建了一个PHP程序,它根据HTML联系人表单中输入的用户输入提供定制输出。HTML表单(&H);PHP输出工作正常。然而,当我试图在WP数据库中保存数据时,我无法看到任何响应。我已经在数据库中创建了“wp\\u mealplanner”表,当我试图通过PHPMYADMIN手动保存数据时,它工作正常。请让我知道我哪里做错了。我没有收到任何错误消息。
请查找以下代码:
<?php
/* Template Name: CustomPageT1 */
$region = $_POST[\'Region\'];
$name = $_POST[\'user_name\'];
$email = $_POST[\'user_email\'];
$phone = $_POST[\'user_phone\'];
$Click_here_to_start_your_download = \'https://mydailysugar.info/wp-
content/uploads/2019/09/Blood-Glucose-Chart-A4-1.pdf\';
switch ($region )
{
case \'North\':
echo "<a href=\'$Click_here_to_start_your_download\'>Click here to start your
download</a>";
die;
case \'South\':
echo "<a href=\'$Click_here_to_start_your_download\'>Click here to start your
download</a>";
die;
case \'East\':
echo "<a href=\'$Click_here_to_start_your_download\'>Click here to start your
download</a>";
die;
case \'West\':
echo "<a href=\'$Click_here_to_start_your_download\'>Click here to start your
download</a>";
die;
}
?>
<?php
if ( isset( $_POST[\'SUBMIT\'] ) )
{
global $wpdb;
$table =\'wp_mealplanner\';
$data = array(\'name\' => $_POST[\'user_name\'],\'email\' =>
$_POST[\'user_email\'],\'phone\' =>
$_POST[\'user_phone\']);
$format = array(\'%s\',\'%s\',\'%d\');
$wpdb->insert( $table, $data, $format );
}
?>
<html>
<head>
<title> Meal Planner </title>
</head>
<body>
<form method=\'POST\'>
<p>Name</p> <input type=\'text\' name=\'user_name\'>
<p>Email</p> <input type=\'text\' name=\'user_email\'>
<p>Phone</p> <input type=\'text\' name=\'user_phone\'>
<p>Dropdown Box</p>
<select name=\'Region\' size=\'1\'>
<option value=\'North\'>North
<option value=\'South\'>South
<option value=\'East\'>East
<option value=\'West\'>West
</select>
<br />
<input type=\'submit\' name =\'submit\' value=\'SUBMIT\'><input
type=\'reset\'
value=\'CLEAR\'>
</form>
</body>
</html>