PHP和MySQL实现的简单Demo

实现对输入的数据进行保存数据库的操作：

index.html:

<html lang="en">
<head>
    <meta charset="utf-8">
    <title>MySQL在PHP中的使用</title>
</head>
<body>
<h1>使用Demo</h1>
<form action="result.php" method="post">
Choose Search Type: <br/>
    <select name="searchtype">
        <option value="author">Author</option>
        <option value="title">Title</option>
        <option value="isbn">ISBN</option>
    </select>
    <br/>
    Enter Search Term: <br/>
    <input name="serachterm" type="text" size="40">
    <br/><br/><br/>
    <input type="submit" name="submit" value="Search">
</form>
</body>
</html>

result.php:

<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
</head>
<body>
<?php

$searchType = $_POST["searchtype"];
$searchTerm = $_POST["serachterm"];
if (!$searchTerm || !$searchType) {
    echo "请输入和选择" . '<br/>';
    exit;
}
// 存入数据库
// 1.连接数据库
$servername = "localhost";
$username = "root";
$password = "pengsi";
$dbname = "myDB";

// 创建连接
$conn = new mysqli($servername, $username, $password);

// 检测连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error) . '<br/>';
    exit;
}
echo "连接成功" . '<br/>';


// 2.创建数据库
$sql = "CREATE DATABASE if Not Exists myDB";
if ($conn->query($sql) === TRUE) {
    echo "数据库创建成功" . '<br/>';

    // select database
    $conn->select_db($dbname);

    // 3.创建一个表
    // 使用 sql 创建数据表
    $sql = "CREATE TABLE if Not Exists MyGuests (
            id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, 
            searchType VARCHAR(30) NOT NULL,
            searchTerm VARCHAR(30) NOT NULL
        )";

    if ($conn->query($sql) === TRUE) {
        echo "Table MyGuests created successfully" . '<br/>';


        // 4.插入数据
        $sql = "INSERT INTO MyGuests (searchType, searchTerm)
                VALUES ('$searchType', '$searchTerm')";

        if ($conn->query($sql) === TRUE) {
            echo "新记录插入成功" . '<br/>';
        } else {
            echo "Error: " . $sql . "<br>" . $conn->error . '<br/>';
        }

        $conn->close();
    } else {
        echo "创建数据表错误: " . $conn->error . '<br/>';
    }
} else {
    echo "Error creating database: " . $conn->error . '<br/>';
}

?>
</body>
</html>

刚开始学PHP，勿喷😄有好的学习PHP的资料或者建议，可以告诉我哟，感谢了😝

posted on 2017-12-12 15:02  玉思盈蝶  阅读(1502)  评论(0)    收藏  举报

导航