大佬教程收集整理的这篇文章主要介绍了尝试使用来自注册表的PHP / HTML将数据输入到SQL表中,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
我尝试了很多不同的事情,并且进行了很多搜索,但都没有解决方案.我正在尝试使用html表单将数据提交到sql表.
$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);
@H_403_9@我的HTML文件是:
<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>
@H_403_9@我为那些奇怪的命名变量提前道歉,我担心其他文件会打扰我在这里试图做的事情.
解决方法:
$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);
@H_403_9@
以上是大佬教程为你收集整理的尝试使用来自注册表的PHP / HTML将数据输入到SQL表中全部内容,希望文章能够帮你解决尝试使用来自注册表的PHP / HTML将数据输入到SQL表中所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。