doujiao6507 2018-07-14 09:04
浏览 49
已采纳

表单提交不适用于PHP

When I click on Submit button nothing happens neither it redirects nor the data in html form is posted to database.

Here is my code for date and time and location:

<?php
session_start();
$date1="";
$time1="";
$location="";
$db=mysqli_connect("localhost","root","","registration");
if(isset($_POST['submit'])) {
    $date1 = mysqli_real_escape_string($db, $_POST['date1']);
    $time1 = mysqli_real_escape_string($db, $_POST['time1']);
    $location = mysqli_real_escape_string($db, $_POST['location']);


    if (!empty($date)) {
        $query = "INSERT INTO cars(date1,time1,location) VALUES('$date1', '$time1', '$location')";
        mysqli_query($db, $query);
        header('location:tariff.php');
    }
}


?>

In this HTML sample the button name is Submit, when it is clicked the PHP is set to True and the code should be executed, but there are some errors.

<html>
<head>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">

    <!-- jQuery library -->
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>

    <!-- Latest compiled JavaScript -->
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>


    <style>
        .form-inline{
            text-align: center;
            position: absolute;
            top: 100px;
            left: 500px;

        }
        .btn{
            position: absolute;
            top: auto;
            left: 500px;
        }
    </style>
</head>
<body>
<div class="container"
     <div class="panel panel-default"
<form class="form-inline" method="post" action="bookcar.php">
    <div class="panel-body">
    <p><label> Pick a date:</label><input class="form-control" type="date" name="date1" placeholder="Date"></p>
    </div>
    <div class="panel-body">
    <p><label> Pick a Time:</label><input class="form-control" type="time" name="time1" placeholder="Time"></p>
    </div>
    <div class="panel-body">
        <p><label> Pick a Location:</label><input class="form-control" type="text" name="location" placeholder="Location"></p>
    </div>
    <input type="submit" name="submit" value="submit" class="btn btn-lg btn-primary">

</form>
</div>
</div>
</body>
</html>
  • 写回答

3条回答 默认 最新

  • duanjiao8871 2018-07-14 09:13
    关注
     session_start();
    
     $db=mysqli_connect("localhost","root","","registration");
    
     if(isset($_POST['date1'])){
    
         $date1 = mysqli_real_escape_string($db, $_POST['date1']);
    
     }
    
     if(isset($_POST['time1'])){
    
         $time1 = mysqli_real_escape_string($db, $_POST['time1']);
    
     }
    
     if(isset($_POST['location'])){
    
         $location = mysqli_real_escape_string($db, $_POST['location']);
    
     }
    
     if(isset($_POST['submit'])){
    
         if (!empty($date1)){
    
             $query = "INSERT INTO cars(date1,time1,location) VALUES('$date1', '$time1', '$location')";
             mysqli_query($db, $query);
             header('location:tariff.php');
             exit(); // Quit current page and go to tariff.php
    
         }
     } 
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 win2012磁盘空间不足,c盘正常,d盘无法写入
  • ¥15 用土力学知识进行土坡稳定性分析与挡土墙设计
  • ¥70 PlayWright在Java上连接CDP关联本地Chrome启动失败,貌似是Windows端口转发问题
  • ¥15 帮我写一个c++工程
  • ¥30 Eclipse官网打不开,官网首页进不去,显示无法访问此页面,求解决方法
  • ¥15 关于smbclient 库的使用
  • ¥15 微信小程序协议怎么写
  • ¥15 c语言怎么用printf(“\b \b”)与getch()实现黑框里写入与删除?
  • ¥20 怎么用dlib库的算法识别小麦病虫害
  • ¥15 华为ensp模拟器中S5700交换机在配置过程中老是反复重启