尝试使用注册表单中的PHP / Html将数据输入到SQL表中 [英] Trying to input data into SQL table using PHP / Html from Registration form

问题描述

我尝试了很多不同的东西，并且做了很多搜索，但没有解决方案。我正在尝试使用HTML表单将数据提交到一个SQL表。

以下是我的register.php文件的代码。

  $ con = mysqli_connect（localhost，database_name，passworddatabase_user）; 
 
 if（$ con === false）{
 die（ERROR Could not Connect。。mysqli_connect_error（））; 
} 
 $ lasty = mysqli_real_escape_string（$ _ POST ['laz']）; 
 $ namez = mysqli_real_escape_string（$ _ POST ['namer']）; 
 $ emailAddr = mysqli_real_escape_string（$ _ POST ['emaila']）; 
 $ userName = mysqli_real_escape_string（$ _ POST ['usrn']）; 
 $ passwo = mysqli_real_escape_string（$ _ POST ['passw']）; 
 $ b $ sq $ =INSERT INTO'database_name'。'用户名，姓氏，姓氏，电子邮件地址，用户名，密码）
 VALUES（NULL，'$ namez'，'$ lasty' ，'$ emailAddr'，'$ userName'，'$ passwo'）; 
 
 
 if（mysqli_query（$ con，$ sqql））{
 echoSuccessfull; 
} else {
 echo没有工作！ 。 $ CON组>误差; 
} 
 
 mysqli_close（$ con）; 
  

我的HTML档案是：

 < form action =register.phpmethod =POST> 
名字：< input type =textname =namerplaceholder =First Name/> <峰; br> 
姓氏：< input type ='text'name ='laz'/> <峰; br> 
电子邮件地址：< input type ='text'name ='emaila'/> <峰; br> 
用户名：< input type ='text'name ='usrn'/> 
密码：< input type ='password'name ='passw'/> 
< input type ='submit'id ='button'value ='Submit'name ='login'/> 
 
< / form> 
  

我为奇怪的命名变量提前道歉，我担心其他文件会中断我试图在这里做。

解决方案

  $ con = mysqli_connect（localhost，database_name，password database_user）; //打开连接
 
 if（mysqli_connect_errno（））{//连接失败
 die（Connect failed：，mysqli_connect_error（））; 
 exit（）; 
} 
 
 $ lasty = mysqli_real_escape_string（$ con，$ _POST ['laz']）; //添加$ con需要两个参数（连接，输入）
 $ namez = mysqli_real_escape_string（$ con，$ _POST ['namer']）; 
 $ emailAddr = mysqli_real_escape_string（$ con，$ _POST ['emaila']）; 
 $ UserName = mysqli_real_escape_string（$ con，$ _POST ['usrn']）; 
 $ password = mysqli_real_escape_string（$ con，$ _POST ['passw']）; 
 
 
 $ b $ sq $ =INSERT INTO`table_name`（UserID，FirstName，LastName，Email，UserName，Password）
 VALUES（NULL，'$ namez' ，'$ lasty'，'$ emailAddr'，'$ userName'，'$ passwo'）; 
 
 
 if（mysqli_query（$ con，$ sqql））{
 echoRow inserted; 
} else {
 die（Error：。mysqli_sqlstate（$ con））; 
} 
 
 mysqli_close（$ con）; 
  

I've tried so many different things and did many searches with no solution. I am trying to use an html form to submit data to a sql table.

Here is the code for my register.php file.

$con = mysqli_connect("localhost", "database_name", "password" "database_user");

if($con === false) {
    die("ERROR Could not Connect." . mysqli_connect_error());
}
$lasty= mysqli_real_escape_string($_POST['laz']);
$namez=mysqli_real_escape_string($_POST['namer']);
$emailAddr=mysqli_real_escape_string($_POST['emaila']);
$userName=mysqli_real_escape_string($_POST['usrn']);
$passwo=mysqli_real_escape_string($_POST['passw']);

$sqql = "INSERT INTO 'database_name' . table' (UserID, FirstName, LastName,   Email, UserName, Password) 
        VALUES (NULL, '$namez', '$lasty', '$emailAddr', '$userName', '$passwo')";


if (mysqli_query($con, $sqql)) {
    echo "Successfull";
} else {
    echo "Did not work!" . $con->error;
}

mysqli_close($con);

My HTML file is:

<form action="register.php" method="POST">
    First Name: <input type="text" name="namer"  placeholder="First Name"/> <br>
    Last Name: <input type='text' name='laz' /> <br>
    Email Address: <input type='text' name='emaila' /> <br>
    UserName: <input type='text' name='usrn' />
    Password: <input type='password' name='passw' />
    <input type='submit' id='button' value='Submit' name='login' />

</form>

I apologize in advance for the weirdly named variables, I was afraid that the other files would interrupt what I was trying to do here.

解决方案

$con = mysqli_connect("localhost", "database_name", "password" "database_user"); //open connection

if (mysqli_connect_errno()) { //if connection failed
    die("Connect failed: ", mysqli_connect_error());
    exit();
}

$lasty      = mysqli_real_escape_string($con, $_POST['laz']); //added $con needs two parameter (connection, input)
$namez      = mysqli_real_escape_string($con, $_POST['namer']);
$emailAddr  = mysqli_real_escape_string($con, $_POST['emaila']);
$UserName   = mysqli_real_escape_string($con, $_POST['usrn']);
$password   = mysqli_real_escape_string($con, $_POST['passw']);



$sqql = "INSERT INTO `table_name`(UserID, FirstName, LastName,   Email, UserName, Password) 
VALUES (NULL, '$namez', '$lasty', '$emailAddr', '$userName', '$passwo')";


if (mysqli_query($con, $sqql)) {
    echo "Row inserted";
}else{
    die("Error: ". mysqli_sqlstate($con));
}

mysqli_close($con);

这篇关于尝试使用注册表单中的PHP / Html将数据输入到SQL表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！