php mysql注册表窗体不工作,没有错误

rdrgkggo  于 2021-06-21  发布在  Mysql
关注(0)|答案(2)|浏览(326)

这个问题在这里已经有答案了

我可以在php中混合mysql api吗(4个答案)
两年前关门了。
我对用php-mysql创建的注册表表单有问题。我已经在html和php的一部分与数据库连接和插入查询的形式。我需要用post方法从表单中获取输入数据并将其插入db中。没有错误,只是不会提交。
这是我的密码:

<form action="registriraj.php" method="post" >
                <div class="wrap-input100 validate-input m-b-23" data-validate = "Username is reauired">
                    <span class="label-input100">Ime:</span>
                    <input class="input100" type="text" name="imeregistracija" placeholder="Upišite ime">
                    <span class="focus-input100" data-symbol="&#xf206;"></span>
                </div>

                <div class="wrap-input100 validate-input" data-validate="Password is required">
                    <span class="label-input100">Prezime:</span>
                    <input class="input100" type="text" name="prezimeregistracija" placeholder="Upišite prezime">
                    <span class="focus-input100" data-symbol="&#xf206;"></span>
                </div>

                <div class="wrap-input100 validate-input m-b-23" data-validate = "Username is reauired" style="margin-top: 20px;">
                    <span class="label-input100">E-mail</span>
                    <input class="input100" type="email" name="emailregistracija" placeholder="Upišite E-mail">
                    <span class="focus-input100" data-symbol="&#xf206;"></span>
                </div>

                <div class="wrap-input100 validate-input" data-validate="Password is required">
                    <span class="label-input100">Lozinka</span>
                    <input class="input100" type="password" name="passregistracija" placeholder="Upišite lozinku">
                    <span class="focus-input100" data-symbol="&#xf190;"></span>
                </div>

            <button type="submit" class="btn btn-outline " style="background-color:#ff6e00;margin-top: 25px;" name="submit">Registriraj korisnika</button>

          </form></div></center>

php代码:

<?php
$connection = mysql_connect("localhost", "root", ""); // Establishing Connection with Server
$db = mysql_select_db("baza", $connection); // Selecting Database from Server
if(isset($_POST['submit'])){ // Fetching variables of the form which travels in URL
$imeregistracija = $_POST['imeregistracija'];
    $prezimeregistracija = $_POST['prezimeregistracija'];
    $emailregistracija = $_POST['emailregistracija'];
    $passregistracija = $_POST['passregistracija'];
if($imeregistracija !=''||$passregistracija !=''){
//Insert Query of SQL
$query = "INSERT INTO `users` (`ime`, `prezime`, `user_pass`, `user_email`) VALUES ('dva','jedan','tri','cetri')";
echo "<br/><br/><span>Data Inserted successfully...!!</span>";
mysqli_query($connection, $query);
}
else{
echo "<p>Insertion Failed <br/> Some Fields are Blank....!!</p>";
}
}
mysql_close($connection); // Closing Connection with Server
?>
ioekq8ef

ioekq8ef1#

此扩展 mysql_connect and mysql_select_db 在PHP5.5.0中被弃用,在PHP7.0.0中被删除。相反,应该使用mysqli或pdo\umysql扩展。使用 mysqli_select_db() 以及 mysqli_connect()

gev0vcfq

gev0vcfq2#

首先检查是否已连接到数据库。然后更改 $db = mysql_select_db("baza", $connection); 到mysqli stmt的改进版本,即 $db = mysqli_select_db($connection ,"baza"); 而且你的代码没有sql注入保护。它会帮助你

相关问题