个人中心
gpt4 book ai didi

php - 使用 PHP、mySQL 和 XAMPP 提交表单时出错

转载 作者：行者123 更新时间：2023-11-30 21:45:42 25 4
gpt4 key购买 nike

我有在教程帮助下编写的验证码。代码对我来说看起来是正确的，表单上的提交按钮使用“POST”方法链接到正确的页面。但是，在提交注册信息时，浏览器会打开一个后端页面，显示脚本的某些部分。显然，这并不是要这样做，而是访问所述页面以进行验证并链接回注册页面，并在 url 中嵌入一条成功消息。

这是包含表单的 signup.php 页面:

<!DOCTYPE html>
<html>
<head>
    <title>Signup</title>
    <link rel="stylesheet" type="text/css" href="signupstyle.css">
</head>

<body> 

    <div class="signup-wrapper">
        <h3>Sign Up</h3>
        <form class="signup-form" action="functions/signup.func.php" method="POST">
            <ul>
                <li>
                    <input type="text" name="fname" placeholder="First Name">
                </li>

                <li>
                    <input type="text" name="lname" placeholder="Last Name">
                </li>

                <li>
                    <input type="text" name="username" placeholder="Username">
                </li>

                <li>
                    <input type="email" name="email" placeholder="Email">
                </li>

                <li>
                    <input type="password" name="password" placeholder="Password">
                </li>

                <li>
                    <button>Sign Up</button>
                </li>
            </ul>
        </form>
    </div>

    <footer>

    </footer>   
</body>
</html>

它要发布到的页面是后端，这是它的代码:

<? php
if (isset($POST['submit'])) { //ensure that the submit button was pressed to 
access the page.
include_once 'dbc.func.php';

$fname = mysqli_real_escape_string($conn, $_POST['fname']);
$lname = mysqli_real_escape_string($conn, $_POST['lname']);
$username = mysqli_real_escape_string($conn, $_POST['username']);
$email = mysqli_real_escape_string($conn, $_POST['email']);
$password = mysqli_real_escape_string($conn, $_POST['password']);

//HANDLING ERRORS
//Checking for empty fields
if (empty($fname) || empty($lname) || empty($username) || empty($email) || ($password)) {
    header("Location: .../signup.php?signupfields=empty"); //if any of the above are empty, redirect to signup page.
    exit();
}else{
    //Checking for invalid input characters
    if (!preg_match("/^[a-zA-Z]*$/", $fname) || (!preg_match("/^[a-zA-Z]*$/", $lname)) {
        header("Location: .../signup.php?signupfields=invalidchars"); //if any of the above are empty, redirect to signup page.
        exit();
    }else{
        //Checking the email validity
        if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
            header("Location: .../signup.php?signupfields=invalidemail"); //if any of the above are empty, redirect to signup page.
            exit();
        }else{
            //Checking for username similarity
            $sql = "SELECT * FROM users WHERE username = '$username'"; 
            $resulter = mysqli_query($conn, $sql);
            $checkResulter = mysqli_num_rows($resulter);

            if ($checkResulter > 0) {
                header("Location: .../signup.php?signupfields=usernametaken"); //if any of the above are empty, redirect to signup page.
                exit();
            }else{
                //Hashing the inputted password 
                $hashedPassword = password_hash($password, PASSWORD_DEFAULT);
                //Inserting the inputted user details into the database 
                $inputer = "INSERT INTO users (fname, lname, username, email, password) VALUES ('$fname', '$lname', '$username', '$email', '$hashedPassword');";
                mysqli_query($conn,$inputer);
                header("Location: .../signup.php?signupsuccess"); //redirect to signup page.
                exit();
            }
        }
    }
}

}else{
header("Location: ../signup.php?badlogin"); //redirect users to the 
signup.php page.
exit();
}

看起来一切正常，但它会抛出 signup.func.php 页面，页面上显示以下代码:

0) { header("Location: .../signup.php?signupfields=usernametaken"); //if any of the above are empty, redirect to signup page. exit(); }else{ //Hashing the inputted password $hashedPassword = password_hash($password, PASSWORD_DEFAULT); //Inserting the inputted user details into the database $inputer = "INSERT INTO users (fname, lname, username, email, password) VALUES ('$fname', '$lname', '$username', '$email', '$hashedPassword');"; mysqli_query($conn,$inputer); header("Location: .../signup.php?signupsuccess"); //redirect to signup page. exit(); } } } } }else{ header("Location: ../signup.php?badlogin"); //redirect users to the signup.php page. exit(); }

不出所料，这并不意味着这样做，我已经厌倦了在代码中没有发现任何错误。谁能帮我吗？

编辑:

阅读提供的文章后，我使用了错误处理程序

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

当我再次运行代码时，它给了我这个:

Warning: mysqli_connect(): php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\xampp\htdocs\Rizeapp\functions\dbc.func.php on line 10

fatal error :未捕获 mysqli_sql_exception:php_network_getaddresses:getaddrinfo 失败:不知道这样的主机。在 C:\xampp\htdocs\Rizeapp\functions\dbc.func.php:10 堆栈跟踪:#0 C:\xampp\htdocs\Rizeapp\functions\dbc.func.php(10): mysqli_connect('localhost, root ...') #1 C:\xampp\htdocs\Rizeapp\functions\signup.func.php(4): include_once('C:\xampp\htdocs...') #2 {main} 抛出在 C:\xampp\htdocs\Rizeapp\functions\dbc.func.php 第 10 行

如果这是我认为的意思，那就是 XAMPP 服务器详细信息不正确。我会研究解决这个问题，看看代码是否会运行。

编辑 2:当它起作用时，我真的很高兴。上面 EDIT 1 中抛出的第二个错误是由于我所知道的最愚蠢的错误:我这样做了:

$conn = mysqli_connect("$dbServername, $dbUsername, $dbPassword, 
$dbName");

取而代之的是:

$conn = mysqli_connect("$dbServername", "$dbUsername", "$dbPassword", 
"$dbName");

感谢大家的迅速回复，最终解决了问题。现在，我可以继续全力推进该项目。干杯。

erroneous page

最佳答案

发现的问题:

  • 第一行代码错误:<? php . php 文件然后像文本文件一样显示代码。正确:<?php .
  • 第二个之前!preg_match...在if语句是一个错误的字符( .正确:将被删除。
  • 在 php 代码中，当编写注释行时不以 // 开头, 或外面 /* ... */ , 发生错误。
  • 错误:$POST['submit'] . HTTP POST 方法的正确全局变量名为 $_POST .所以，正确的代码是:$_POST['submit'] .
  • 如果你定义<button>Sign Up</button> ，那么你必须给它一个名字(比如 <button name="submit">Sign Up</button> )，以便能够用 if (isset($_POST['submit'])) {...} 来引用它。 .
  • 错误:.../abc/xyz.php .正确:../abc/xyz.php .
  • 错误:if (... || empty($email) || ($password)) {...} .正确:if (... || empty($email) || empty($password)) {...} .

建议:

  • 将php处理代码放在signup.php中, 而不是 signup.func.php并相应地改变它。表单的 action 属性将为 signup.php , 或 ""对于 HTML5，那么。这样您就可以直接(例如现场)向用户显示任何消息，并且在注册处理成功时最后只执行一次重定向(例如到 login.php 页面)。
  • 申请好error reporting系统，以便查看并相应地处理 php 引擎可能抛出的错误和异常。专门针对 mysqli:here .对于 PDO here .
  • 开始使用所谓的 prepared statements ，为了防止SQL injection .阅读this小而有效的文章。
  • 开始使用面向对象的 mysqli 扩展而不是过程式扩展——每个 mysqli 函数都有以两种形式呈现的 php.net 文档。更好的是:开始使用 PDO extension而不是 mysqli。这里(同上)tutorial .

promise 的替代代码(使用面向对象的 mysqli)

它包括我上面的建议。按原样运行它以对其进行测试。但是首先更改表结构(参见下面的标题使用的表结构)，更改connection.php中的数据库凭据(参见标题includes/connection.php 下面)并按照下面代码部分的标题建议创建一个文件系统结构。

要从生产环境(当错误未显示在屏幕上时)切换到开发环境(当所有引发的错误都显示在屏幕上时)，只需更改常量 APP_ENV 的值(在 handlers.php 中)从 'prod' 到 'dev' 并返回(参见标题 includes/handlers.php)。然后，为了测试它，将表名“users”重命名为另一个错误的名称，例如。或者将两条sql语句的第一条设置为NULL : $sql = NULL; .

注册.php

<?php
require 'includes/handlers.php';
require 'includes/connection.php';

// Signalize if a new account could be created, or not.
$accountCreated = FALSE;

/*
 * ====================================
 * Operations upon form submission.
 * ====================================
 */
if (isset($_POST['submit'])) {
    /*
     * ====================================
     * Read the posted values.
     * ====================================
     */
    $firstName = isset($_POST['firstName']) ? $_POST['firstName'] : '';
    $lastName = isset($_POST['lastName']) ? $_POST['lastName'] : '';
    $email = isset($_POST['email']) ? $_POST['email'] : '';
    $username = isset($_POST['username']) ? $_POST['username'] : '';
    $password = isset($_POST['password']) ? $_POST['password'] : '';

    /*
     * ====================================
     * Validate all posted values together.
     * ====================================
     */
    if (empty($firstName) && empty($lastName) && empty($email) && empty($username) && empty($password)) {
        $errors[] = 'All values are mandatory. Please provide them.';
    }

    /*
     * ====================================
     * Validate each value separately.
     * ====================================
     */
    if (!isset($errors)) {
        // Validate the first name.
        if (empty($firstName)) {
            $errors[] = 'Please provide a first name.';
        } elseif (!preg_match('/^[a-zA-Z]*$/', $firstName)) {
            $errors[] = 'The first name contains invalid characters.';
        } /* Other validations here using elseif statements */

        // Validate the last name.
        if (empty($lastName)) {
            $errors[] = 'Please provide a last name.';
        } elseif (!preg_match('/^[a-zA-Z]*$/', $lastName)) {
            $errors[] = 'The last name contains invalid characters.';
        } /* Other validations here using elseif statements */

        // Validate the email.
        if (empty($email)) {
            $errors[] = 'Please provide an email address.';
        } elseif (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
            $errors[] = 'The email address is not in a valid format.';
        } /* Other validations here using elseif statements */

        // Validate the username.
        if (empty($username)) {
            $errors[] = 'Please provide a username.';
        } /* Other validations here using elseif statements */

        // Validate the password.
        if (empty($password)) {
            $errors[] = 'Please provide a password.';
        } /* Other validations here using elseif statements */
    }

    /*
     * ====================================
     * Check if user exists. Save if not.
     * ====================================
     */
    if (!isset($errors)) {
        /*
         * ====================================
         * Check if user already exists.
         * ====================================
         */

        /*
         * The SQL statement to be prepared. Notice the so-called markers,
         * e.g. the "?" signs. They will be replaced later with the
         * corresponding values when using mysqli_stmt::bind_param.
         *
         * @link http://php.net/manual/en/mysqli.prepare.php
         */
        $sql = 'SELECT COUNT(*)
                FROM users
                WHERE username = ?';

        /*
         * Prepare the SQL statement for execution - ONLY ONCE.
         *
         * @link http://php.net/manual/en/mysqli.prepare.php
         */
        $statement = $connection->prepare($sql);

        /*
         * Bind variables for the parameter markers (?) in the
         * SQL statement that was passed to prepare(). The first
         * argument of bind_param() is a string that contains one
         * or more characters which specify the types for the
         * corresponding bind variables.
         *
         * @link http://php.net/manual/en/mysqli-stmt.bind-param.php
         */
        $statement->bind_param('s', $username);

        /*
         * Execute the prepared SQL statement.
         * When executed any parameter markers which exist will
         * automatically be replaced with the appropriate data.
         *
         * @link http://php.net/manual/en/mysqli-stmt.execute.php
         */
        $statement->execute();

        /*
         * Transfer the result set resulted from executing the prepared statement.
         * E.g. store, e.g. buffer the result set into the (same) prepared statement.
         *
         * @link http://php.net/manual/en/mysqli-stmt.store-result.php
         * @link https://stackoverflow.com/questions/8321096/call-to-undefined-method-mysqli-stmtget-result
         */
        $statement->store_result();

        /*
         * Bind the result set columns to corresponding variables.
         * E.g. these variables will hold the column values after fetching.
         *
         * @link http://php.net/manual/en/mysqli-stmt.bind-result.php
         */
        $statement->bind_result($numberOfFoundUsers);

        /*
         * Fetch the results from the result set (of the prepared statement) into the bound variables.
         *
         * @link http://php.net/manual/en/mysqli-stmt.fetch.php
         */
        $statement->fetch();

        /*
         * Free the stored result memory associated with the statement,
         * which was allocated by mysqli_stmt::store_result.
         *
         * @link http://php.net/manual/en/mysqli-result.free.php
         */
        $statement->free_result();

        /*
         * Close the prepared statement. It also deallocates the statement handle.
         * If the statement has pending or unread results, it cancels them
         * so that the next query can be executed.
         *
         * @link http://php.net/manual/en/mysqli-stmt.close.php
         */
        $statement->close();

        if ($numberOfFoundUsers > 0) {
            $errors[] = 'The given username already exists. Please choose another one.';
        } else {
            /*
             * ====================================
             * Save a new user account.
             * ====================================
             */
            // Create a password hash.
            $passwordHash = password_hash($password, PASSWORD_BCRYPT);

            $sql = 'INSERT INTO users (
                        first_name,
                        last_name,
                        email,
                        username,
                        password
                    ) VALUES (
                        ?, ?, ?, ?, ?
                    )';

            $statement = $connection->prepare($sql);
            $statement->bind_param('sssss', $firstName, $lastName, $email, $username, $passwordHash);
            $statement->execute();

            // Signalize that a new account was successfully created.
            $accountCreated = TRUE;

            // Reset all values so that they are not shown in the form anymore.
            $firstName = $lastName = $email = $username = $password = NULL;
        }
    }
}
?>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />
        <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=yes" />
        <meta charset="UTF-8" />
        <!-- The above 3 meta tags must come first in the head -->

        <title>Demo - Sign Up </title>

        <!--<link href="assets/images/favicon.ico" rel="icon" type="image/png" />-->

        <!-- CSS assets -->
        <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,400,600,700,800" rel="stylesheet">
        <link href="https://fonts.googleapis.com/css?family=Roboto+Condensed:300,400,700" rel="stylesheet">
        <link href="assets/css/app.css" type="text/css" rel="stylesheet">
        <link href="assets/css/signup.css" type="text/css" rel="stylesheet">

        <!-- JS assets -->
        <script src="https://code.jquery.com/jquery-3.2.1.min.js" type="text/javascript"></script>
    </head>
    <body>

        <div class="page-container">

            <nav class="navbar">
                <ul class="navbar-nav">
                    <li>
                        <a href="#">Home</a>
                    </li>
                    <li>
                        <a href="#">About Us</a>
                    </li>
                    <li>
                        <a href="#">Login</a>
                    </li>
                    <li>
                        <a href="signup.php" class="active">Sign Up</a>
                    </li>
                </ul>
            </nav>

            <header class="page-header">
                <h2 class="page-title">
                    Sign Up
                </h2>
                <div class="page-subtitle">
                    Hello. We are happy to see you here. Please fill in the form to register.
                </div>
            </header>

            <section class="page-content">

                <section class="form-container-outer">
                    <section class="form-container-inner">
                        <?php
                        if (isset($errors)) {
                            ?>
                            <div class="messages danger">
                                <?php echo implode('<br/>', $errors); ?>
                            </div>
                            <?php
                        } elseif ($accountCreated) {
                            ?>
                            <div class="messages success">
                                You have successfully created your account.
                                <br/>Would you like to <a href="#">login</a> now?
                            </div>
                            <?php
                        }
                        ?>

                        <form id="signup-form" action="" method="post">

                            <div class="form-group">
                                <label for="firstName">First Name <span class="mandatory">*</span></label>
                                <input type="text" id="firstName" name="firstName" value="<?php echo isset($firstName) ? $firstName : ''; ?>" placeholder="First Name" required>
                            </div>

                            <div class="form-group">
                                <label for="lastName">Last Name <span class="mandatory">*</span></label>
                                <input type="text" id="lastName" name="lastName" value="<?php echo isset($lastName) ? $lastName : ''; ?>" placeholder="Last Name" required>
                            </div>

                            <div class="form-group">
                                <label for="email">Email <span class="mandatory">*</span></label>
                                <input type="email" id="email" name="email" value="<?php echo isset($email) ? $email : ''; ?>" placeholder="Email" required>
                            </div>

                            <div class="form-group">
                                <label for="username">Username <span class="mandatory">*</span></label>
                                <input type="text" id="username" name="username" value="<?php echo isset($username) ? $username : ''; ?>" placeholder="Username" required>
                            </div>

                            <div class="form-group">
                                <label for="password">Password <span class="mandatory">*</span></label>
                                <input type="password" id="password" name="password" value="<?php echo isset($password) ? $password : ''; ?>" placeholder="Password" required>
                            </div>

                            <button type="submit" id="signupButton" name="submit" value="signup">
                                Create account
                            </button>
                        </form>
                    </section>
                </section>

            </section>

            <footer class="footer">
                &copy; <?php echo date('Y'); ?> <a href="#" title="Demo">Demo</a>. All rights reserved.
            </footer>

        </div>
    </body>
</html>

包含/connection.php

<?php

/*
 * This page contains the code for creating a mysqli connection instance.
 */

// Db configs.
define('HOST', 'localhost');
define('PORT', 3306);
define('DATABASE', 'tests');
define('USERNAME', 'root');
define('PASSWORD', 'root');

/*
 * Enable internal report functions. This enables the exception handling,
 * e.g. mysqli will not throw PHP warnings anymore, but mysqli exceptions
 * (mysqli_sql_exception).
 *
 * MYSQLI_REPORT_ERROR: Report errors from mysqli function calls.
 * MYSQLI_REPORT_STRICT: Throw a mysqli_sql_exception for errors instead of warnings.
 *
 * @link http://php.net/manual/en/class.mysqli-driver.php
 * @link http://php.net/manual/en/mysqli-driver.report-mode.php
 * @link http://php.net/manual/en/mysqli.constants.php
 */
$mysqliDriver = new mysqli_driver();
$mysqliDriver->report_mode = (MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

/*
 * Create a new db connection.
 *
 * @see http://php.net/manual/en/mysqli.construct.php
 */
$connection = new mysqli(HOST, USERNAME, PASSWORD, DATABASE, PORT);

includes/handlers.php

<?php

/*
 * Include this page in all PHP pages of the application.
 *
 * This page contains:
 *  - The APP_ENV constant, used to decide in which environment this application runs.
 *  - The functions for handling all the errors, or exceptions, raised by the application.
 *  - The code for setting them as error/exception handlers.
 *  - The code deciding if the errors should be displayed on the screen. The errors
 *    display MUST be activated ONLY in the development stage of the application. When
 *    the website goes live, ALL ERRORS must be written in a/the log file and NO ERRORS
 *    should be displayed on screen, but only a general, user-friendly message, or a
 *    custom error page.
 */

/*
 * Decide in which environment this application runs. Possible values:
 *  - 'prod' (app in production, e.g. live). The errors are not displayed, but only logged.
 *  - 'dev' (app in development). The errors are displayed on screen and logged.
 *  - 'test' (app in tests). Same as 'dev'.
 *  - etc.
 */
define('APP_ENV', 'dev');

// Activate the errors/exceptions logging.
ini_set('log_errors', 1);

// Set the error reporting level: report all errors.
error_reporting(E_ALL);

// Decide how to handle the errors/exceptions.
if (APP_ENV === 'prod') { // App in production, e.g. live.
    // DON'T display the errors/exceptions on the screen.
    ini_set('display_errors', 0);

    // Set the handler functions.
    set_error_handler('errorHandler');
    set_exception_handler('exceptionHandler');
} else { // App in development, tests, etc.
    // Display the errors/exceptions on the screen.
    ini_set('display_errors', 1);
}

/**
 * Error handler:
 *  - Print a user-friendly message, or show a custom error page.
 *  - Log the error.
 *
 * @link http://php.net/manual/en/function.set-error-handler.php set_error_handler.
 * @param int $errno
 * @param string $errstr
 * @param string $errfile
 * @param int $errline
 */
function errorHandler($errno, $errstr, $errfile, $errline) {
    echo 'An error occurred during your request. Please try again, or contact us.';
    error_log('Error ' . $errno . ' - ' . $errstr . ' in file ' . $errfile . ' on line ' . $errline);
    exit();
}

/**
 * Exception handler:
 *  - Print a user-friendly message, or show a custom error page.
 *  - Log the error.
 *
 * @link http://php.net/manual/en/function.set-exception-handler.php set_exception_handler.
 * @param Exception $exception
 */
function exceptionHandler($exception) {
    echo 'An error occurred during your request. Please try again, or contact us.';
    error_log('Exception ' . $exception->getCode() . ' - ' . $exception->getMessage() . ' in file ' . $exception->getFile() . ' on line ' . $exception->getLine());
    exit();
}

Assets /css/app.css

/***************************************/
/* Base settings */
/***************************************/

html {
    -moz-box-sizing: border-box;
    -webkit-box-sizing: border-box;
    box-sizing: border-box;
}

*, *:before, *:after {
    -moz-box-sizing: inherit;
    -webkit-box-sizing: inherit;
    box-sizing: inherit;
}

/* Font size: 100% = 16px (in almost all web browsers) */
html, body {
    width: 100%;
    height: 100%;
    min-height: 100%;
    margin: 0;
    padding: 0;
    font-size: 100%;
    font-weight: 400;
    line-height: 1.8;
    color: #000;
    font-family: "Open Sans", Verdana, Arial, sans-serif !important;
    background-color: #fff;
}

/*
    A font size of 1rem means 16px. E.g. 100% of the font size of the "html" tag, which is 16px.
    A font size of 0.9375rem means: 0.9375 * 16px = 15px.
    From this point on, for font sizes, work with "rem", or "em" units, not anymore with px.
    The "rem" units are always relative to the font size of the "html" tag (here 16px, because is set as 100%).
    The "em" units are always relative to the font size of the parent tag.
*/
body {
    font-size: 0.9375rem;
    position: relative;
}

a {
    text-decoration: none;
    outline: none;
    color: #DF9237;
}

a:hover {
    text-decoration: none;
    outline: none;
    color: #000;
}

h1, h2, h3, h4, h5, h6 {
    margin: 0;
    padding: 0;
    line-height: 1;
    font-weight: 300;
}

/* A font size of 2.5rem means: 2.5 * 16px = 40px */
h2 {
    font-weight: 300;
    font-size: 2.5rem;
}

/***************************************/
/* Fonts settings */
/***************************************/

html, body {
    font-family: "Open Sans", Verdana, Arial, sans-serif !important;
}

h1, h2, h3, h4, h5, h6,
.navbar-nav li a,
.page-title,
.page-subtitle {
    font-family: "Roboto Condensed", Verdana, Arial, sans-serif !important;
}

/***************************************/
/* Layout settings */
/***************************************/

/* Page container */

/*
    The top-padding is the navbar's height (70px) + some additional pixels (30px).
    The bottom-padding is the footer's height (60px) + some additional pixels (30px).
*/
.page-container {
    /* Making relative position so, that we can absolute position the footer on the bottom */
    position: relative;
    padding: 100px 30px 90px 30px;
    width: 100%;
    min-height: 100%;
    overflow: hidden;
    margin: 0;
    background-color: #fff;
}

/* Navigation bar */

/*
    Navbar must have a fixed height. Example here: 70px (padding is included because of
    box-sizing: border-box in html). Then make the top-padding of the .page-container
    the same height (70px) + some additional pixels, in order to avoid overlapping!
*/
.navbar {
    height: 70px;
    padding: 22px 0 0 0;
    margin: 0;
    position: absolute;
    top: 0;
    left: 0;
    right: 0;
    border-bottom: 1px solid #f3f3f3;
    background-color: #fff;
}

.navbar-nav {
    margin: 0;
    padding: 0 60px;
    float: right;
    list-style: none;
    text-transform: uppercase;
}

.navbar-nav li {
    display: block;
    float: left;
    position: relative;
}

.navbar-nav li a {
    padding: 7px;
    margin-left: 5px;
    color: #000;
    font-size: 1rem;
    font-weight: 300;
    border-bottom: 0px solid transparent;
}

.navbar-nav li a:hover {
    color: #DF9237;
}

.navbar-nav li a.active {
    color: #DF9237;
}

.navbar-nav li a.active:hover {
    color: #000;
}

/* Page header */

.page-header {
    margin: 0 0 30px 0;
    padding: 0;
    text-align: center;
}

.page-title {
    margin: 0;
    padding: 10px;
    color: #DF9237;
    text-transform: uppercase;
}

.page-subtitle {
    /*margin-top: 10px;*/
    padding: 0;
    text-align: center;
    font-weight: 300;
    font-size: 1.0625rem;
    font-size: 1.1rem;
}

.page-content {

}

/* Messages */

.messages {
    padding: 10px;
    margin: 0;
    border-radius: 4px;
}

.success {
    color: #3c763d;
    border-color: #d6e9c6;
    background-color: #dff0d8;
}

.danger {
    color: #a94442;
    border-color: #ebccd1;
    background-color: #f2dede;
}

.warning {
    color: #8a6d3b;
    border-color: #faebcc;
    background-color: #fcf8e3;
}

/* Mandatory fields in forms */

.mandatory {
    font-size: 0.75rem;
    color: #DF9237;
}

/* Footer */

/*
    Footer must have a fixed height. Example here: 60px (padding is included because of
    box-sizing: border-box in html). Then make the bottom-padding of the .page-container
    the same height (60px) + some additional pixels, in order to avoid overlapping!
*/
.footer {
    height: 60px;
    padding-top: 20px;
    position: absolute;
    bottom: 0;
    left: 0;
    right: 0;
    margin: 0;
    font-weight: 300;
    text-align: center;
    background-color: #fff;
}

Assets /css/signup.css

/* Form */

.form-container-outer {
    padding: 30px;
    position: relative;
    text-align: center;
    border-radius: 4px;
    background-color: #f4f4f4;
}

.form-container-inner {
    display: inline-block;
    margin: 0 auto;
    padding: 0;
}

.messages {
    text-align: left;
}

.messages a {
    text-transform: uppercase;
    font-weight: 600;
}

.messages.success {
    text-align: center;
}

#signup-form {
    padding: 20px;
    display: inline-block;
    text-align: left;
}

.form-group {
    margin-bottom: 20px;
}

.form-group label {
    display: inline-block;
    min-width: 100px;
}

input {
    padding: 5px;
    width: 250px;
    font-size: 0.9375rem;
}

button {
    padding: 7px 10px;
    display: block;
    float: right;
    color: #fff;
    font-size: 0.9375rem;
    cursor: pointer;
    border: none;
    border-radius: 4px;
    background-color: #5cb85c;
}

button:hover {
    background-color: #449d44;
}

使用的表结构

由于您使用的是正确的哈希函数 ( password_hash )，所以 password列的长度至少为 255 个字符。

CREATE TABLE `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

关于php - 使用 PHP、mySQL 和 XAMPP 提交表单时出错，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/49603108/

25 4 0
文章推荐： c - 为什么这个程序在将 j 赋值给 k 后返回 10 作为 j 的值？其中 k=12
文章推荐： c# - 忽略大小写比较两个字符串的最佳方法
文章推荐： c# - 如何将标签的可见性属性绑定(bind)到多个单选按钮？
文章推荐： c - 如何在while循环中编写if条件来终止它
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com