最受欢迎

保存引导表单助手国家选择器到我的数据库

Save Bootstrap Form Helpers Country picker to my database

本文关键字：选择器 我的 数据库 国家 表单 保存 | 更新日期: 2023-09-27

我使用了Bootstrap-Form-Helpers来通过下拉框显示国家和国旗。我使用了以下Html 

<div class="bfh-selectbox bfh-countries" data-country="US" data-flags="true">
    <input type="hidden" value="">
    <a class="bfh-selectbox-toggle" role="button" data-toggle="bfh-selectbox" href="#">
        <span class="bfh-selectbox-option input-medium" data-option=""></span>
        <b class="caret"></b>
    </a>
    <div class="bfh-selectbox-options">
        <input type="text" class="bfh-selectbox-filter" name="country">
        <div role="listbox">
            <ul role="option">
            </ul>
        </div>
    </div>
</div>
保存到数据库的PHP代码为 
if (isset($_POST['btn_signup'])) {
    $fname = $_POST['fname'];
    $lname = $_POST['lname'];
    $email = $_POST['email'];
    $username = $_POST['username'];
    $pass = $_POST['password'];
    $cpass = $_POST['conf_pass'];
    $country = $_POST['country'];
    $dropdown = $_POST['dropdown'];
    $query3 = "SELECT * from tbl_users WHERE email = '" . $email . "'";
    $result3 = mysql_query($query3, $con) or die(mysql_error());
    $query = "SELECT * from tbl_users WHERE username = '" . $username . "'";
    $result = mysql_query($query, $con) or die(mysql_error());
    if (mysql_num_rows($result) > 0) {
        echo '<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">';
        echo '<div class="alert alert-danger alert-dismissable">';
        echo '<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>';
        echo 'Username is not available! Please Try another username!!.' . mysql_error();
        echo '</div>';
        echo '</div>';
    }
    elseif ($pass != $cpass) {
        echo '<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">';
        echo '<div class="alert alert-danger alert-dismissable">';
        echo '<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>';
        echo 'Password typed doesnt match please retype the password correctly!!.' . mysql_error();
        echo '</div>';
        echo '</div>';
    }
    elseif (mysql_num_rows($result3) > 0) {
        echo '<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">';
        echo '<div class="alert alert-danger alert-dismissable">';
        echo '<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>';
        echo 'Email Already exist please try another email!!.' . mysql_error();
        echo '</div>';
        echo '</div>';
    }
    else {
        $query2 = "INSERT INTO tbl_users (first_name,last_name,username,password,confPass,email,country,user_type)VALUES('{$fname}','{$lname}','{$username}','{$pass}','{$cpass}','{$email}','{$country}','{$dropdown}')";
        $result2 = mysql_query($query2);
        echo '<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">';
        echo '<div class="alert alert-success alert-dismissable">';
        echo '<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>';
        echo 'Success! Well done its submitted.';
        echo '</div>';
        echo '</div>';
    }
}

我所有的其他数据都输入到我的数据库中。但不是这个国家。请帮助! !

您可以在下面的div标签中使用data-name="country"。然后您可以在$_POST中获得所选国家/地区。

<div class="bfh-selectbox bfh-countries" data-country="US" data-name="country" data-flags="true"> ..............remaining code here.............. </div>
$country = $_POST['country'];

让我知道这是否有帮助。

谢谢

您获取的输入字段被表单辅助函数

覆盖

试试下面的代码

<?php
session_start();
require_once ("includes/db.php");
print_r($_POST);
if (isset($_POST['btn_signup'])) {
    $fname = $_POST['fname'];
    $lname = $_POST['lname'];
    $email = $_POST['email'];
    $username = $_POST['username'];
    $pass = $_POST['password'];
    $cpass = $_POST['conf_pass'];
    $country = $_POST['country'];
    $dropdown = $_POST['dropdown'];
    $query3 = "SELECT * from tbl_users WHERE email = '" . $email . "'";
    $result3 = mysql_query($query3, $con) or die(mysql_error());
    $query = "SELECT * from tbl_users WHERE username = '" . $username . "'";
    $result = mysql_query($query, $con) or die(mysql_error());
    if (mysql_num_rows($result) > 0) {
        echo '<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">';
        echo '<div class="alert alert-danger alert-dismissable">';
        echo '<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>';
        echo 'Username is not available! Please Try another username!!.' . mysql_error();
        echo '</div>';
        echo '</div>';
    }
    elseif ($pass != $cpass) {
        echo '<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">';
        echo '<div class="alert alert-danger alert-dismissable">';
        echo '<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>';
        echo 'Password typed doesnt match please retype the password correctly!!.' . mysql_error();
        echo '</div>';
        echo '</div>';
    }
    elseif (mysql_num_rows($result3) > 0) {
        echo '<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">';
        echo '<div class="alert alert-danger alert-dismissable">';
        echo '<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>';
        echo 'Email Already exist please try another email!!.' . mysql_error();
        echo '</div>';
        echo '</div>';
    }
    else {
        $query2 = "INSERT INTO tbl_users (first_name,last_name,username,password,confPass,email,country,user_type)VALUES('{$fname}','{$lname}','{$username}','{$pass}','{$cpass}','{$email}','{$country}','{$dropdown}')";
        $result2 = mysql_query($query2);
        echo '<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">';
        echo '<div class="alert alert-success alert-dismissable">';
        echo '<button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>';
        echo 'Success! Well done its submitted.';
        echo '</div>';
        echo '</div>';
    }
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Mycricprofle</title>
<link rel="shortcut icon" href="http://faviconist.com/icons/be7b568b1a766b3888e5326879e1a9b8/favicon.ico" />
<link rel="stylesheet" href="css/bootstrap.min.css"/>
<link rel="stylesheet" href="css/bootstrap-theme.min.css"/>
<link rel="stylesheet" href="css/bootstrap-formhelpers-countries.flags.css"/>
<link rel="stylesheet" href="css/bootstrap-formhelpers.min.css"/>
<script src="js/vendor/jquery-1.11.2.min.js"></script>
<script src="js/vendor/bootstrap.min.js"></script>
<script src="js/bootstrap-formhelpers.min.js"></script>
<script src="js/bootstrap-formhelpers-countries.js"></script>
<style>
.style {
    color: #761c19;
    text-decoration: none;
}
.style a {
    text-decoration: none;
    font-weight: bold;
}
</style>
</head>
<body>
<div class="container">
    <div class="col-md-6 col-sm-6 col-xs-12">
        <h2>Signup to Create a New Account</h2>
        <br/>
        <form action="signup.php" method="post" enctype="multipart/form-data">
            <div class="form-group">
                <label for="text">First Name:</label>
                <input type="text" class="form-control" placeholder="Firstname" name="fname" required/>
            </div>
            <br/>
            <div class="form-group">
                <label for="text">Last Name:</label>
                <input type="text" class="form-control" placeholder="Last name" name="lname" required/>
            </div>
            <br/>
            <div class="bfh-selectbox bfh-countries" data-country="US" data-flags="true">
                <input type="hidden" id="country" name="country" value="">
                <a class="bfh-selectbox-toggle" role="button" data-toggle="bfh-selectbox" href="#"> <span class="bfh-selectbox-option input-medium" data-option=""></span> <b class="caret"></b> </a>
                <div class="bfh-selectbox-options">
                    <input type="text" class="bfh-selectbox-filter">
                    <div role="listbox">
                        <ul role="option">
                        </ul>
                    </div>
                </div>
            </div>
            <br/>
            <div class="form-group">
                <label for="text">Email:</label>
                <input type="email" class="form-control" placeholder="Email" name="email" required/>
            </div>
            <br/>
            <div class="form-group">
                <label for="text">Username:</label>
                <input type="text" class="form-control" placeholder="Username" name="username" required/>
            </div>
            <br/>
            <div class="form-group">
                <label for="text">Password:</label>
                <input type="password" class="form-control" placeholder="Password" name="password" required/>
            </div>
            <br/>
            <div class="form-group">
                <label for="text">Confirm Password:</label>
                <input type="password" class="form-control" placeholder="Confirm Password" name="conf_pass" required/>
            </div>
            <br/>
            <select class="form-control selectpicker" name="dropdown" id="type_user" required/>
            <option value="player">Player</option>
            <option value="recruiter">Recruiter</option>
            </select>
            <br/>
            <br/>
            <button class="mdl-button mdl-js-button mdl-button--raised mdl-button--accent" id="btn_signup" name="btn_signup">Submit</button>
        </form>
        <br/>
        <p class="style">Back to <a href='index.php'>Home</a></p>
        <p class="style">Signin to Get in <a href='signin.php'>Sigin in</a></p>
    </div>
</div>
<script>
$(document).ready(function(e) { 
$(document).find(".bfh-countries input[type=hidden]").attr("name","country");
}); 
</script>
<?php
// include('includes/footer.php');
 ?>
</body>
</html>

关于DOM，请参考

关于DOM操作，请参考

假设您使用的是至少2.3版的formhelpers库，您应该能够替换这个:

<div class="bfh-selectbox bfh-countries" data-country="US" data-flags="true">
            <input type="hidden" id="country" name="country" value="">
            <a class="bfh-selectbox-toggle" role="button" data-toggle="bfh-selectbox" href="#"> <span class="bfh-selectbox-option input-medium" data-option=""></span> <b class="caret"></b> </a>
            <div class="bfh-selectbox-options">
                <input type="text" class="bfh-selectbox-filter">
                <div role="listbox">
                    <ul role="option">
                    </ul>
                </div>
            </div>
        </div>
与这个:

<div class="country bfh-selectbox bfh-countries" data-flags="true" data-filter="true" data-name="country"></div>

data-name属性指定用于存储两个字符的国家代码的隐藏字段的名称。您还可以指定data-country的值，它将提供默认值或在回发后保持该值，但这取决于您如何处理它。

相关文章：
最新更新
www.56WenDa.com 2012-2023 | php问答网 | php学习