PHP - 将表单数据提交到本地主机数据库

问题描述：

错误：提交表单时屏幕变空白，并且数据库中没有新记录。有任何想法吗？PHP - 将表单数据提交到本地主机数据库

我的文件：

Conn.php

<?php 


$connect =mysqli_connect ("localhost", "root", "", "gym"); 


if(mysqli_connect_errno($connect)) 
{ 
    echo "Error Connecting to Database!"; 
} 


?>

form.php的

<html> 

<head> 

    <title>Gym Form</title> 
    <meta charset="UTF-8"> 
    <meta name="viewport" content="width=device-width, initial-scale=1.0"> 


</head> 

<body> 

    <form action="Proccess.php" method="post"> 

    <span>Gym Membership Registration</span><br><br> 

    <Span>Title: </Span><input type ="text" Value =" " name ="Title" /><br> 

    <Span>First Name: </Span><input type ="text" Value =" " name ="Fname" /><br> 

    <Span>Last Name: </Span><input type ="text" Value =" " name ="Lname" /><br><br> 

    <Span>Gender: </Span><select name ="Gender"> 

     <option value ="Junior">Male</option> 
     <option value ="Adult">Female</option> 
     <option value ="Senior">Private</option> 

    </select><br> 

    <Span>DOB: </Span><input type ="date" name ="DOB" /><br><br> 

    <Span>MembershipExpiry: </Span> <input type ="date" name ="MemX" /><br> 

    <Span>MembershipType: </Span><select name = "MemType"> 

     <option value ="Junior">Junior</option> 
     <option value ="Adult">Adult</option> 
     <option value ="Senior">Senior</option> 

    </select><br><br> 

    <Span>Email Address: </Span><input type ="email" name ="Email" /><br><br> 

    <input type="Submit" name="submit" value ="Submit Form">

的Proccess.php（这里的错误似乎是）：

<?php 

include 'Connect.php';?> 

<?php 

//variables 

$title = $_POST['Title']; 
$fname = $_POST['Fname']; 
$lname = $_POST['Lname']; 
$gender = $_POST['Gender']; 
$dob = $_POST['DOB']; 
$memx = $_POST['MemX']; 
$memtype = $_POST['MemType']; 
$email = $_POST['Email']; 

//query 

mysqli_query($connect, "INSERT INTO records(Title,Fname,Lname,Gender,DOB,MemX,MemType,Email) 
values ('$title', '$fname', '$lname', '$gender', '$dob', '$memx', '$memtype', '$email')");

错误： T提交表单时屏幕会变成空白，并且数据库中没有新记录。有任何想法吗？

数据库表被称为记录，并有列：

Title 
First Name 
Last Name 
Gender 
etc

请帮我接和形式的数据上传至数据库。

'mysqli_query（$ connect“INSERT' comma is missing –

mysqli_query（$ connect，”SELECT ............. – user1844933

答

尝试添加 '' 后$连接是这样的：

mysqli_query($connect, "INSERT INTO records(Title,Fname,Lname,Gender,DOB,MemX,MemType,Email) 
values ('$title', '$fname', '$lname', '$gender', '$dob', '$memx', '$memtype', '$email')");

谢谢你试图帮助我。现在错误消失了，但是，提交表单时屏幕会变成空白，并且数据库中没有新记录。有任何想法吗？ – JSint

在你的process.php中，你包含了connect.php，但是你的文件名是conn.php。修复并重播。 – denic

答

connection.php

<?php 
$connect = mysqli_connect ("localhost", "root", "", "gym") or die('Error Connecting to Database!'); 
?>

process.php

<?php 

//variables 

$title = $_POST['Title']; 
$fname = $_POST['Fname']; 
$lname = $_POST['Lname']; 
$gender = $_POST['Gender']; 
$dob = $_POST['DOB']; 
$memx = $_POST['MemX']; 
$memtype = $_POST['MemType']; 
$email = $_POST['Email']; 

//query 

$sql = 'INSERT INTO records (Title, Fname, Lname, Gender, DOB, MemX, MemType, Email) VALUES (?,?,?,?,?,?)'; 

if (! $stmt = mysqli_prepare($connection, $sql)) { 
trigger_error('Error: ' . mysqli_error($connection), E_USER_WARNING); 
} 

mysqli_stmt_bind_param($stmt, 'ssssssss', $title, $fname, $lname, $gender, $dob, $memx, $memtype, $email); 

mysqli_stmt_execute($stmt); 

mysqli_stmt_close($stmt); 

mysqli_close($db); 

redirect('Form.php');

检查了这一点http://php.net/manual/en/book.mysqli.php

PHP - 将表单数据提交到本地主机数据库

相关推荐