首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >提交表单后数据库为空

提交表单后数据库为空
EN

Stack Overflow用户
提问于 2019-02-21 06:16:22
回答 1查看 0关注 0票数 0
代码语言:javascript
复制
<?php require('includes/config.php'); 

//if not logged in redirect to login page
if(!$user->is_logged_in()){ header('Location: login.php'); exit(); }
$uname= htmlspecialchars($_SESSION['username'], ENT_QUOTES);
if(isset($_POST['submit'])){
if (!isset($_POST['title'])) $error[] = 'Please fill out title field';
if (!isset($_POST['content'])) $error[] = 'Please fill out content field';
if (!isset($_POST['date'])) $error[] = 'Please fill out date and time field';
$title=filter_var($_POST['title'], FILTER_SANITIZE_STRING);
$content=filter_var($_POST['content'], FILTER_SANITIZE_STRING);
$postdate=$_POST['date'];

$divid = md5(uniqid(rand(),true));
$htmlcode="<style>
.demo-card-wide.mdl-card {
  width: 512px;
}
.demo-card-wide > .mdl-card__title {
  color: #fff;
  height: 176px;
  background: url('https://www.getmdl.io/assets/demos/welcome_card.jpg') center / cover;
}
.demo-card-wide > .mdl-card__menu {
  color: #fff;
}
</style>
<div class=\"demo-card-wide mdl-card mdl-shadow--2dp\" id=\"$divid\">
  <div class=\"mdl-card__title\">
    <h2 class=\"mdl-card__title-text\">$title</h2>
  </div>
  <div class=\"mdl-card__supporting-text\">
    \"$content\"<br><i class =\"material-icons\">calender_today</i>$postdate
  </div>
  <div class=\"mdl-card__actions mdl-card--border\">
    <a class=\"mdl-button mdl-button--colored mdl-js-button mdl-js-ripple-effect\">
       Done <i class=\"material-icons\">done</i>
    </a>
  </div>
  <div class=\"mdl-card__menu\">
    <button class=\"mdl-button mdl-button--icon mdl-js-button mdl-js-ripple-effect\">
      <i class=\"material-icons\">delete</i>
    </button>
  </div>
</div>";
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "events";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "INSERT INTO events (user, html, divid)
VALUES ('$uname', '$htmlcode', '$divid')";

if (mysqli_query($conn, $sql)) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
header("Location:events.php?action=success"); exit();}
?>

此代码不会向数据库添加数据,但也不会返回任何错误

代码语言:javascript
复制
<?php
ob_start();
session_start();

//database credentials
define('DBHOST','localhost');
define('DBUSER','root');
define('DBPASS','');
define('DBNAME','registration');

//application address
define('DIR','localhost/');
define('SITEEMAIL','noreply@domain.com');

try {

    //create PDO connection
    $db = new PDO("mysql:host=".DBHOST.";charset=utf8mb4;dbname=".DBNAME, DBUSER, DBPASS);
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);//Suggested to uncomment on production websites
    //$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);//Suggested to comment on production websites
    $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);

} catch(PDOException $e) {
    //show error
    echo '<p class="bg-danger">'.$e->getMessage().'</p>';
    exit;
}

//include the user class, pass in the database connection
include('classes/user.php');
include('classes/phpmailer/mail.php');
$user = new User($db);
?>

这是config.php plz需要帮助,还有一件事如何检查表单中提交的日期是否存在。非常需要帮助,谢谢。 我首先清理数据,然后检查日期,但它在xampp服务器上测试不正常我需要这个代码用于我的项目。

EN

回答 1

Stack Overflow用户

发布于 2019-02-21 15:30:38

将此代码置于顶部,看看您是否发送了预期的参数!(复制代码保存在文件中,并通过#include'filename'将其放在代码的第一行,以方便工作)

代码语言:javascript
复制
check if $uname id passed?
¿ ($uname= htmlspecialchars($_SESSION['username'], ENT_QUOTES); !!!) ?

<?php
session_start(); // Initialize Session data
ob_start(); // Turn on output buffering
echo "Se crea o inicializa una session id : ".session_id ();
echo '<table border="1">';
echo "<tr><td>" . "SESION" ."</td><td>" . "SESION: ".$a . "</td></tr>";
foreach ($_SESSION as $k => $v){
echo "<tr><td>" . $k ."</td><td>" . $v . "</td></tr>";
}
echo "</table>";
//para ver $_SERVER
// $HTTP_COOKIE_VARS["TestCookie"];
echo '<table border="1">';
echo "<tr><td>" . "COOKIE" ."</td><td>" . "COOKIE" . "</td></tr>";
foreach ($_COOKIE as $k => $v){
echo "<tr><td>" . $k ."</td><td>" . $v . "</td></tr>";
}
echo "</table>";

echo '<table border="1">';
echo "<tr><td>" . "SERVER" ."</td><td>" . "SERVER" . "</td></tr>";
foreach ($_SERVER as $k => $v){
echo "<tr><td>" . $k ."</td><td>" . $v . "</td></tr>";
}
echo "</table>";
if(isset($_POST))
{
echo '<table border="1">';
echo "<tr><td>" . "POST/GET" ."</td><td>" . "POST/GET" . "</td></tr>";
foreach ($_POST as $kp => $vp){
echo "<tr><td>" . $kp ."</td><td>" . $vp . "</td></tr>";
}
echo "</table>";
}
else
{
echo '<table border="1">';
foreach ($_GET as $kg => $vg){
echo "<tr><td>" . $kg ."</td><td>" . $vg . "</td></tr>";
}
echo "</table>";
}
?>
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/-100003123

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档