XAMPP-表单到数据库 - XAMPP - Form to Database

XAMPP - Form to Database

本文关键字：数据库表单 XAMPP- | 更新日期: 2023-09-27

我尝试过类似的问题，但是，我被自己的代码绊倒了，试图理解出了什么问题。

我的设置：

examplepGymPHP（编写代码）本地主机上名为gym的数据库数据库中的表调用了具有9列的记录

我已经创建了一个表单，现在正试图在表单和数据库之间建立连接，以便将数据从表单移动到数据库中。

我的代码：

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="Login.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">


    </form>
</body>

Connect.php：

    <?php
$conn = mysql_connect("localhost", "root", "");
mysql_select_db("gym");
if(!$conn)
    echo"Error Connecting to Database!";
else
    echo"Connected to Database!";

include "Connect.php";
$title = $_POST['Title'];
$fname = $_POST['Fname'];
$lname = $_POST['Lname'];
$gender = $_POST['Gender'];
$dob = $_POST['DOB'];
$memx = $_POST['MemX'];
$memtype = $_POST['MemType'];
$email = $_POST['Email'];
$sql = mysql_query("INSERT INTO records (Title, Fname, Lname, Gender, DOB,                   MemX, MemType, Email) values ('$title', '$fname', '$lname', '$gender', '$dob', '$memx', '$memtype', '$email')", $conn);

然而，当我检查数据库时，我填写了表格并收到一条消息，说连接已经建立。。没有添加记录？请帮忙，谢谢。

以下代码将帮助您查找错误并解决Deprecation错误。

<?php
$con=mysqli_connect("localhost","root","","gym");
// Check connection
if (mysqli_connect_errno()){
   echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
// Perform queries 
mysqli_query($con, "INSERT INTO records (Title, Fname, Lname, Gender, DOB,MemX, MemType, Email) values ('" . $title . "', '" . $fname . "', '" . $lname . "', '" . $gender . "', '" . $dob . "', '" . $memx . "', '" . $memtype . "', '" . $email . "');" or die(mysqli_error($con));
mysqli_close($con);
?>