dongxizhe9755 2016-11-23 21:36
浏览 48
已采纳

使用php将数据从html表单插入数据库

i have build following form it works 100%. only one problem. when i open this page a blank data insert to database every time with out press any submit button.

I do not want to use php on seprate file like action="php/doctor.php" I do want to use php on same page of html form.

<?php
$servername = "localhost";
$username = "root";
$password = "";

?>
<?php
if (isset($_POST["dname"]))
{
    $dname = $_POST['dname'];
} else {
    $dname = null;
}


if (isset($_POST["mobile"]))
{
    $mobile = $_POST['mobile'];
} else {
    $mobile = null;
}


if (isset($_POST["dusername"]))
{
    $dusername = $_POST['dusername'];
} else {
    $dusername = null;
}

if (isset($_POST["dpassword"]))
{
    $dpassword = $_POST['dpassword'];
} else {
    $dpassword = null;
}

try {
    $conn = new PDO("mysql:host=$servername;dbname=team", $username, $password);
    // set the PDO error mode to exception

    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "INSERT INTO doctor (dname, mobile, dusername, dpassword)
        VALUES ('$dname', '$mobile', '$dusername', '$dpassword')";
    // use exec() because no results are returned
    $conn->exec($sql);
    echo '<div class="alert alert-success alert-dismissible">
        <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
        <strong>Success!</strong> Indicates a successful or positive action.
        </div>';

}
catch(PDOException $e)
{
    echo $sql . "<br>" . $e->getMessage();
}

$conn = null;
?>

<script src="bootstrap/js/bootstrap.min.js"></script>
<script src="bootstrap/jquery-1.12.3.min.js"></script>

<link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="style/team.css">
<link rel="stylesheet" href="style/teams.css">
<script src="js/javas.js"></script>

</head>
<body >

<form class="form-horizontal" action="doctor.php" method="post"  role="form">
    <div class="form-group">
        <label class="control-label col-sm-2" >Doctor Name:</label>
        <div class="col-sm-8">
            <input type="text" class="form-control" name="dname" placeholder="Enter email">
        </div>
    </div>
    <div class="form-group">
        <label class="control-label col-sm-2" >Mobile:</label>
        <div class="col-sm-8">
            <input type="text" class="form-control" name="mobile" placeholder="Enter mobile">
        </div>
    </div>
    <div class="form-group">
        <label class="control-label col-sm-2">User name:</label>
        <div class="col-sm-8">
            <input type="text" class="form-control" name="dusername" placeholder="Enter username">
        </div>
    </div>
    <div class="form-group">
        <label class="control-label col-sm-2">Password:</label>
        <div class="col-sm-8"> 
            <input type="password" class="form-control" name="dpassword" placeholder="Enter password">
        </div>
    </div>
    <div class="form-group"> 
        <div class="col-sm-offset-2 col-sm-10">
            <button type="submit" class="btn btn-default">Submit</button>
        </div>
    </div>
</form>
</div>
  • 写回答

2条回答 默认 最新

  • doulangxun7769 2016-11-24 00:10
    关注

    You can use somethings like this

    if(isset($_POST['submit'])) {
// Enter the Code you want to execute after the form has been submitted

} else {
// Display the Form and the Submit Button
}

    Here's a complete example:

    <?php    
    if(isset($_POST['SubmitButton'])) { //check if form was submitted
        $input = $_POST['inputText']; //get input text
        echo "Success! You entered: " . $input;
    }    
?>
<html>
    <body>    
        <form action="" method="post">
            <input type="text" name="inputText"/>
            <input type="submit" name="SubmitButton"/>
        </form>    
    </body>
</html>
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？

悬赏问题

  • ¥15 宇视监控服务器无法登录
  • ¥15 PADS Logic 原理图
  • ¥15 PADS Logic 图标
  • ¥15 电脑和power bi环境都是英文如何将日期层次结构转换成英文
  • ¥15 DruidDataSource一直closing
  • ¥20 气象站点数据求取中~
  • ¥15 如何获取APP内弹出的网址链接
  • ¥15 wifi 图标不见了 不知道怎么办 上不了网 变成小地球了
  • ¥50 STM32单片机传感器读取错误
  • ¥50 power BI 从Mysql服务器导入数据，但连接进去后显示表无数据