dq05304 2017-11-07 17:17
浏览 84

使用php / html插入mysql - 无法正常工作

I'm trying to enter data into a mysql database using php / html form but it isn't working and I don't know why. The record is not inserted and the page just refresh

I apologize for some of it being written in Danish

I have 2 files 1 with html and php and 1 with only php

My database: Database image

This is the html form and php:

<div class="row">
        <div class="col-sm-12">
            <?php
            if (isset($_POST['Submit'])) {

                    // echo "<pre>", print_r($_POST), "</pre>";

                    $apply_name = mysqli_real_escape_string($db, $_POST ['apply_name']);
                    $apply_age = mysqli_real_escape_string($db, $_POST ['apply_age']);
                    $apply_ingame_name = mysqli_real_escape_string($db, $_POST ['apply_ingame_name']);
                    $apply_email = mysqli_real_escape_string($db, $_POST ['apply_email']);
                    $apply_steamID = mysqli_real_escape_string($db, $_POST ['apply_steamID']);
                    $apply_text = mysqli_real_escape_string($db, $_POST ['apply_text']);

                    $errors = []; // Array

                    if ($apply_name == "") {
                        $errors['apply_name'] = "<div class='alert alert-danger'>
                                  <strong>Du har ikke angivet noget navn!</strong>
                                </div>";
                    } elseif (strlen($apply_name) < 2) {
                        $errors['apply_name'] = "<div class='alert alert-info'>
                                  <strong>Dit navn skal minimum være 2 karatere</strong>
                                </div>";
                    }

                    if ($apply_age == "") {
                        $errors['create_apply_age'] = "<div class='alert alert-danger'>
                                  <strong>Du har ikke angivet din alder!</strong>
                                </div>";
                    }

                    if ($apply_ingame_name == "") {
                        $errors['create_apply_ingame_name'] = "<div class='alert alert-danger'>
                                  <strong>Du har ikke angivet noget In-Game navn!</strong>
                                </div>";
                    } elseif (strlen($apply_ingame_name) < 2) {
                        $errors['create_apply_ingame_name'] = "<div class='alert alert-info'>
                                  <strong>Dit In-Game navn skal minimum være 2 karatere</strong>
                                </div>";
                    }

                    if ($apply_email == "") {
                        $errors['create_apply_email'] = "<div class='alert alert-danger'>
                                  <strong>Email skal udfyldes!</strong>
                                </div>";
                    } elseif (!filter_var($apply_email, FILTER_VALIDATE_EMAIL)) {
                        $errors['create_apply_email'] = "<div class='alert alert-info'>
                                  <strong>Email er ugyldig</strong>
                                </div>";
                    }

                    if ($apply_steamID == "") {
                        $errors['create_apply_steamID'] = "<div class='alert alert-danger'>
                                  <strong>Du har ikke angivet noget SteamID!</strong>
                                </div>";
                    } elseif (strlen($apply_steamID) < 18) {
                        $errors['create_apply_steamID'] = "<div class='alert alert-info'>
                                  <strong>Dit SteamID ser sådan her ud STEAM_0:0:XXXXXXXX</strong>
                                </div>";
                    }

                    if ($apply_text == "") {
                        $errors['create_apply_text'] = "<div class='alert alert-danger'>
                                  <strong>Du har ikke skrevet noget om dig selv!</strong>
                                </div>";
                    }

                    if (empty($errors)) {
                        // Send ansøning

                        $created = create_apply($apply_name, $apply_age, $apply_ingame_name, $apply_email, $apply_steamID, $apply_text);

                        if ($created) {
                            echo "
                                <div class='alert alert-info'>
                                  <strong>Din ansøning er sendt.</strong>
                                </div>
                            ";
                        } else {
                            // Ansøning kunne ikke sendes
                            $create_error = "Ansøningen kunne ikke sendes, SteamID eksistere i forvejen";
                        }

                    } else {
                        $create_error = "Der opstod en fejl, Prøv igen";
                    }
                }
                ?>

            <section>
                <hr>
                <form class="form-horizontal" enctype="multipart/form-data" id="signup" method="post" name="signup" action="?p=askforsignup">
                                <?php 
                                    if (isset($errors['apply_name'])) {
                                        echo $errors['apply_name'];
                                    }
                                ?>
                    <div class="form-group">
                        <label class="control-label col-sm-3">Navn <span class="text-danger">*</span></label>
                        <div class="col-md-8 col-sm-9">
                            <div class="input-group">
                                <span class="input-group-addon"><i class="fa fa-user"></i></span><input class="form-control" id="mem_name" name="apply_name" placeholder="Navn" type="text" value="" >
                            </div>
                        </div>
                    </div>
                                <?php 
                                    if (isset($errors['create_apply_age'])) {
                                        echo $errors['create_apply_age'];
                                    }
                                ?>
                    <div class="form-group">
                        <label class="control-label col-sm-3">Alder <span class="text-danger">*</span></label>
                        <div class="col-md-8 col-sm-9">
                            <div class="input-group">
                                <span class="input-group-addon"><i class="fa fa-calendar"></i></span><input class="form-control" id="age" name="apply_age" placeholder="Alder" type="date" value="" >
                            </div>
                        </div>
                    </div>
                                <?php 
                                    if (isset($errors['create_apply_ingame_name'])) {
                                        echo $errors['create_apply_ingame_name'];
                                    }
                                ?>
                    <div class="form-group">
                        <label class="control-label col-sm-3">In-Game Name <span class="text-danger">*</span></label>
                        <div class="col-md-8 col-sm-9">
                            <div class="input-group">
                                <span class="input-group-addon"><i class="fa fa-user"></i></span><input class="form-control" id="ingame_game" name="apply_ingame_name" placeholder="In-Game Name" type="text" value="" >
                            </div>
                        </div>
                    </div>
                                <?php 
                                    if (isset($errors['create_apply_email'])) {
                                        echo $errors['create_apply_email'];
                                    }
                                ?>
                    <div class="form-group">
                        <label class="control-label col-sm-3">Email <span class="text-danger">*</span></label>
                        <div class="col-md-8 col-sm-9">
                            <div class="input-group">
                                <span class="input-group-addon"><i class="fa fa-envelope"></i></span><input class="form-control" id="emailid" name="apply_email" placeholder="Email" type="email" value="" >
                            </div><small>Your Email is being used for ensuring the security of your account, authorization and access recovery.</small>
                        </div>
                    </div>
                                <?php 
                                    if (isset($errors['create_apply_steamID'])) {
                                        echo $errors['create_apply_steamID'];
                                    }
                                ?>
                    <div class="form-group">
                        <label class="control-label col-sm-3">Steam ID <span class="text-danger">*</span></label>
                        <div class="col-md-5 col-sm-8">
                            <div class="input-group">
                                <span class="input-group-addon"><i class="fa fa-steam"></i></span><input class="form-control" id="contactnum" name="apply_steamID" placeholder="Steam ID" type="text" value="" >
                            </div>
                        </div>
                    </div>
                                <?php 
                                    if (isset($errors['create_apply_text'])) {
                                        echo $errors['create_apply_text'];
                                    }
                                ?>
                    <div class="form-group">
                        <label class="control-label col-sm-3">Beskriv dig selv <span class="text-danger">*</span></label>
                        <div class="col-md-8 col-sm-9">
                            <div class="input-group">
                                <span class="input-group-addon"><i class="fa fa-id-card"></i></span>
                                <textarea class="form-control" rows="5" id="message" name="apply_text" placeholder="Beskriv dig selv." ></textarea>
                            </div><br>
                            <div class="col-xs-offset-8 col-xs-10 pull-right">
                                <input class="btn btn-primary" name="Submit" type="submit" value="Sign Up">
                            </div>
                        </div>
                    </div>
                </form>
            </section>
        </div><!--/.col-sm-8-->
    </div>

And this is the php code:

function create_apply($apply_name, $apply_age, $apply_ingame_name, $apply_email, $apply_steamID, $apply_text) {

    global $db;

    $steamID_exists = steamID_exists($apply_steamID);

    if ($steamID_exists == false) {

        $apply_name = mysqli_real_escape_string($db, $apply_name);
        $apply_age = mysqli_real_escape_string($db, $apply_age);
        $apply_ingame_name = mysqli_real_escape_string($db, $apply_ingame_name);
        $apply_email = mysqli_real_escape_string($db, $apply_email);
        $apply_steamID = mysqli_real_escape_string($db, $apply_steamID);
        $apply_text = mysqli_real_escape_string($db, $apply_text);

        $query = "INSERT INTO member_applys
                  (apply_name, apply_age, apply_ingame_name, apply_email, apply_steamID, apply_text, apply_date)
                  VALUES
                  ('$apply_name', '$apply_age', '$apply_ingame_name', '$apply_email', '$apply_steamID', '$apply_text', NOW())";

        $result = $db->query($query);

        return true;
    } else {
        // Brugeren eksistere opret = falsk
        return false;
    }
    }

Solved

the problem was google autocomplete was on not off

  • 写回答

1条回答 默认 最新

  • dongyinzheng6572 2017-11-07 20:07
    关注

    Di you be sure that your script call well the form? I see:

     ....action="?p=askforsignup">
    

    try:

     ....action="your_script.php">
    
    评论

报告相同问题?

悬赏问题

  • ¥15 求解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果