首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >Bootstrap 3注册表PHP

Bootstrap 3注册表PHP
EN

Stack Overflow用户
提问于 2014-07-11 03:54:31
回答 1查看 2.7K关注 0票数 0

这是我的register.php页面:

代码语言:javascript
复制
<!DOCTYPE html>
<html lang="it">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Circolari 2.0</title>
<link rel=stylesheet type="text/css" href="css/bootstrap.css">
<link rel=stylesheet type="text/css" href="css/styles.css">
</head>
<body>
<div class="container">
    <div class="row">
        <div class="col-md-4 col-md-offset-4">
           <div class="form-signup">
                <b><h1 class="text-center">Registrazione</h1></b>
                <br>
                <form action="register.php" method="post">
                    <div class="form-group">
                        <div class="left-inner-addon">
                            <i class="glyphicon glyphicon-user"></i>
                            <input class="form-control focus" type="text" placeholder="Nome" name="nome">
                        </div>
                    </div>
                    <div class="form-group">
                        <div class="left-inner-addon">
                            <i class="glyphicon glyphicon-user"></i>
                            <input class="form-control focus" type="text" placeholder="Cognome" name="cognome">
                        </div>
                    </div>
                    <div class="form-group">
                        <div class="left-inner-addon">
                            <i class="glyphicon glyphicon-envelope"></i>
                            <input class="form-control focus" type="text" placeholder="Email" name="email">
                        </div>
                    </div>
                    <div class="form-group">
                        <div class="left-inner-addon">
                            <i class="glyphicon glyphicon-lock"></i>
                            <input class="form-control focus" type="password" placeholder="Password" name="password">
                        </div>
                    </div>
                    <button class="btn btn-info" type="submit" name="submit_button">Registrati</button>
                    <a class="btn btn-warning" href="index.php">Home</a>
                </form>
            </div>
        </div>
    </div>
</div>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script type="text/javascript" src="js/bootstrap.js"></script>
</body>
</html>

<?php
if (isset($_POST['submit_button']))
{
    // Definisco le variabili Nome, Cognome, Email e Password
    $nome=$_POST['nome'];
    $cognome=$_POST['cognome'];
    $email=$_POST['email'];
    $password=$_POST['password'];

    if ($nome=="" or $cognome="" or $email="" or $password="")
    {
        echo "Tutti i campi sono obbligatori";
    }
    else
    {
        // Includo il file di configurazione
        include('config.php');

        // Connessione al database
        $conn=mysqli_connect("$db_host", "$db_username", "$db_password", "$db_name") or die (mysqli_error($conn)); 

        // Controllo se Email è già registrata
        $stmt=$conn->prepare("SELECT * FROM $tbl_name WHERE Email=?");
        $stmt->bind_param("s", $email);
        $stmt->execute();
        $result=$stmt->get_result();

        // Conto i risultati
        $count=$result->fetch_assoc();

        // Se Email e Password combaciano, otterrò un solo risultato
        if($count==1)
        {
            echo "Utente già registrato!";
        }
        else
        {
            // Query Database
            $stmt=$conn->prepare("INSERT INTO $tbl_name (Nome, Cognome, Email, Password) VALUES (?, ?, ?, ?)");
            $stmt->bind_param("ssss", $nome, $cognome, $email, $password);
            $stmt->execute();
            $result=$stmt->get_result();

            if ($stmt->execute())
            {
                echo "Registrazione effettuata con successo!";
                echo ($nome);
                echo ($cognome);
                echo ($email);
                echo ($password);
            }
            else 
            {
                echo (mysqli_error($conn));
            }
        }
    }
}
?>

问题是,当我单击SUBMIT按钮时,数据库中除了'Nome‘之外的所有空列都是空的。我真的不能理解这个问题。附言:我添加了所有变量的echo,实际上只有$nome显示在屏幕上。谢谢大家!

EN

回答 1

Stack Overflow用户

发布于 2014-08-05 03:31:45

我非常确定你需要有一个唯一的"id=xxx“给你的输入域,否则它不会在表单中发送

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/24685139

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档