PHP学习日记丨PHP写一个留言板实战(2)-插入内容

好了,我们继续插入内容

为了能动态提交内容。我肯定先创建一个html,然后post提交

HTML文件名随意,一般我是index.html


<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>留言板</title>
<link rel="stylesheet" href="//cdn.bootcss.com/bootstrap/3.3.4/css/bootstrap.min.css">
<script src="//cdn.bootcss.com/jquery/1.11.2/jquery.min.js"></script>
<script src="//cdn.bootcss.com/bootstrap/3.3.4/js/bootstrap.min.js"></script>
</head>
<body>
    <div class="container" style="margin-top:9%;">
        <div class="jumbotron">
        <div class="panel panel-success">
        <div class="panel-heading"><h1>留言板</h1></div>
        </div>
          <form  method="post" action="data.php">
              <input type="text" name="username" placeholder="姓名"/>
              <input type="text" name="hone" placeholder="手机"/>
              <input type="text" name="email" placeholder="邮箱"/>
              <input type="text" name="address" placeholder="地址"/>
              <input type="text" name="texts" placeholder="留言内容"/>
              <button type="submit">提交</button>
          </form>
        </div>
    </div>
</body>
</html>

随便搞了一下

然后php接收数据,并且创建数据
PHP文件名与前端相应,上面代码是data.php这里也就是data.php


<?php
$servername = "localhost";
$username = "ly123";
$password = "ly123";
$dbname = "ly123";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // 设置 PDO 错误模式,用于抛出异常
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $sj=date('Y-m-d H:i:s');            //获取时间
    $username = $_POST['username'];     //接收用户名
    $hone = $_POST['hone'];             //接收手机号
    $email = $_POST['email'];           //接收邮箱
    $address = $_POST['address'];       //接收用户地址
    $texts = $_POST['texts'];           //接收留言内容
    //填写对应的值
    $sql = "INSERT INTO Tinly (username, hone, email,address,texts,reg_date)
    VALUES ('$username', '$hone', '$email','$address','$texts','$sj')";
    // 使用 exec() ,没有结果返回 
    $conn->exec($sql);
    echo "提交成功";
    echo "<a href="/">返回首页</a>"
}
catch(PDOException $e)
{
   echo $sql . "<br>" . $e->getMessage();
}

$conn = null;

然后前端提交,就可以了

说说你的见解

OωO
取消