如何在mysql数据库中输入用户表单输入的数据 - how to enter data enter by user in form in mysql database

how to enter data enter by user in form in mysql database

我已经在其中创建了数据库和表。但是它显示了一个错误"input data failed"

reg form的代码如下表单login2.php的代码:

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Login Form</title>
<link rel="stylesheet" href="style.css" type="text/css" media="screen, projection" />
</head>
<body>
<div id="div-regForm">
<div class="form-title" align ="center">VIDEO CHAT </div>
<br></br>
<div class="form-sub-title" align="center">If already registered</div>
<P align="center">
<td><input type="submit" class="blueButton" value="Sign in" align="right"/>
</P>
<br></br>
<div class="form-title">For New User</div>
<div class="form-title">Sign Up</div>
<div class="form-sub-title">It's free and anyone can join</div>
<form id="regForm" action="validate_login.php" method="post">
<table>
<tbody>
<tr>
    <td><label for="fname">First Name:</label></td>
    <td><div class="input-container">
    <input name="fname" id="fname" type="text" />
    </div></td>
</tr>
<tr>
    <td><label for="lname">Last Name:</label></td>
    <td><div class="input-container">
    <input name="lname" id="lname" type="text" />
    </div></td>
</tr>
<tr>
    <td><label for="email">Your Email:</label></td>
    <td><div class="input-container">
    <input name="email" id="email" type="text" />
    </div></td>
</tr>
<tr>
    <td><label for="npass">New Password:</label></td>
    <td><div class="input-container">
    <input name="npass" id="npass" type="password" />
    </div></td>
</tr>
<tr>
    <td><label for="cpass">Confirm Password:</label></td>
    <td><div class="input-container">
    <input name="cpass" id="cpass" type="password" />
    </div></td>
</tr>
<tr>
    <td><label for="sex-select">I am:</label></td>
    <td>
    <div class="input-container">
    <select name="sex-select" id="sex-select">
    <option value="0">Select Sex:</option>
    <option value="1">Female</option>
    <option value="2">Male</option>
    </select>
    </div>
    </td>
</tr>
    <td>
    <div class="input-container">
<tr>
    <td>&nbsp;</td>
    <td><input type="submit" class="greenButton" value="Sign Up"  value="Sent" />
    <img id="loading" src="img/ajax-loader.gif" alt="working.." />
    </td>
</tr>
</tbody>
</table>
</form>
<div id="error">
&nbsp;
</div>
</div>
</body>
</html>

在数据库代码validate_login.php:

<?php
// Grab User submitted information
$db_host= "localhost";
$db_user = "root";
$db_pass = "";
$db_name = "testdb";
@mysql_connect("$db_host", "$db_user", "$db_pass")
or die("Could not connect to MySQL server!");
/*@mysql_select_db("$db_name") or die("No DATABASE");
echo"hi how r u";*/
$fname = $_POST["fname"];
$lname = $_POST["lname"];
$email = $_POST["email"];
$npass = $_POST["npass"];
$cpass = $_POST["cpass"];
$gender = $_POST["sex-select"];

// Select the database to use
@mysql_select_db("testdb")
or die("Could not select database!");
$order = "Insert INTO 'data_user'
            (fname, lname, email, npass, cpass, sex-select)
            VALUES
            ('$fname',
            '$lname','$email','$npass', '$cpass','$gender')";
            $result = mysql_query($order);  //order executes
if($result){
    echo("<br>Input data is succeed");
} else{
    echo("<br>Input data is fail");
}
?>

尽快告诉我解决办法

Step1:

请将列名称从sex-select更改为sex_select

步骤2:

并将表名'data_user'中的引号删除为data_user