<?php include('myFunction.php');
consoleLog("include test");
//接收用户提交数据，并保存到数据库中
if($_POST){
if($_SERVER['REQUEST_METHOD']=="POST"){
//接收输入
$firstname=inputFormat($_POST['firstname']);
$lastname=inputFormat($_POST['lastname']);
$email=inputFormat($_POST['email']);
//非空判断
if($firstname!=null && $lastname!=null && $email!=null){
$tom=new person($firstname,$lastname,$email);
//连接数据库操作
$servername="localhost";
$username="root";
$passowrd="root";
//创建连接
$conn=new mysqli($servername,$username,$passowrd);
//检测连接
if($conn->connect_error){
die("连接失败".$conn->connect_error);
}else{
consoleLog("connect successful");
//创建数据库
$sql="create database if not exists db_test default charset utf8";
if($conn->query($sql)===true){
consoleLog("create database successful");
$conn->query("use db_test");


//创建表
$sql="create table if not exists db_person (id int(20) auto_increment  primary key not null,
firstname varchar(20) not null,
lastname varchar(20) not null,
email varchar(20) not null)";
$conn->query($sql);
//插入数据
$sql='insert into db_person (firstname,lastname,email) values ("'.$tom->getFirstName().'","'.$tom->getLastName().'","'.$tom->getEmail().'")';
consoleLog($sql);
$conn->query($sql);
$conn->close();


}else{
consoleLog($conn->connect_error);
consoleLog("create database fail");
}
}
}else{
echo "<script>alert('input is null');history.back(-1);</script>";
}
}
}else{
consoleLog("post is null");
}
// //登陆页面时，从数据库读取
// //连接数据库操作
// $servername="localhost";
// $username="root";
// $passowrd="root";
// //创建连接
// $conn=new mysqli($servername,$username,$passowrd);
// //检测连接
// if($conn->connect_error){
// die("连接失败".$conn->connect_error);
// }else{
// consoleLog("connect successful");
// //使用连接
// $conn->query("use db_test");
// //插入数据
//   $sql="select * from db_person";
// consoleLog($sql);
// $persons=$conn->query($sql);
// consoleLog($persons);
// // $conn->close();
// }
//创建一个对象
class person{
var $firstname;
var $lastname;
var $email;
function __construct($firstname,$lastname="",$email=""){
$this->firstname=$firstname;
$this->lastname=$lastname;
$this->email=$email;
}
function setFirstName($firstname){
$this->firstname=$firstname;
}
function setLastName($lastname){
$this->lastname=$lastname;
}
function setEmail($email){
$this->email=$email;
}
function getFirstName(){
return $this->firstname;
}
function getLastName(){
return $this->lastname;
}
function getEmail(){
return $this->email;
}
}
?>
<!DOCTYPE html>
<html>
<head>
  <title>Bootstrap 实例</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/4.0.0-beta/css/bootstrap.min.css">
  <script src="https://cdn.bootcss.com/jquery/3.2.1/jquery.min.js"></script>
  <script src="https://cdn.bootcss.com/popper.js/1.12.5/umd/popper.min.js"></script>
  <script src="https://cdn.bootcss.com/bootstrap/4.0.0-beta/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
  <h2>数据库练习</h2>           
  <table class="table">
    <thead>
      <tr>
        <th>Firstname</th>
        <th>Lastname</th>
        <th>Email</th>
      </tr>
    </thead>
    <tbody>
<?php 
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "db_test";
 
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
} 
 
$sql = "SELECT * FROM db_person";
$result = $conn->query($sql);
 
if ($result->num_rows > 0) {
    // 输出数据
    while($row = $result->fetch_assoc()) {
        echo '<tr><td>'. $row["firstname"].'</td><td>'. $row["lastname"].'</td><td>'. $row["email"].'</td></tr>';
    }
} else {
    echo "0 结果";
}
$conn->close();
?>
    </tbody>
  </table>
</div>
<div class="container">
  <h4>添加用户</h4>
  <form class="form-inline" action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']);?>" method="post">
  <label for="fname">Firstname:</label>
    <input name="firstname" type="text" class="form-control" id="fname" placeholder="Enter Firstname">
    <label for="lname">Lastname:</label>
    <input name="lastname" type="text" class="form-control" id="lname" placeholder="Enter Lastname">
    <label for="email">Email:</label>
    <input name="email" type="text" class="form-control" id="email" placeholder="Enter Email">
    <input type="submit" class="btn btn-primary" value="Submit"></input>
  </form>
</div>
</body>
</html>