本文介绍了PHP表单提交到MySQL数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有一个注册表。在数据库中，用户名和电子邮件是唯一索引。当表单提交并且用户名或电子邮件已存在于数据库中时，不会插入值。我想通知用户该值未被插入。
HTML < form action =register.phpmethod =postid =regonsubmit ='return validate（）;'> 公司名称：< input type =textclass =inputsname =nameid =name/>< br /> 电子邮件地址：< input type =textclass =inputsname =emailid =txtEmail/>< br /> 用户名：< input type =textclass =inputsname =unameid =uname/>< br /> 密码：< input type =passwordclass =inputsname =passid =pass1/>< br /> Conferm Password： register.php： include（db.php）; if（isset（$ _ POST ['register']））{ echo $ name =（$ _POST [name]）; echo $ email =（$ _POST [email]）; echo $ uname =（$ _POST [uname]）; echo $ password =（$ _POST [pass]）; mysqli_query（$ con，INSERT INTO company_profile（user_name，password，company_name，email，phone，country，activation_string）VALUES（'$ uname'，'$ password'，'$ name'，'$ email'， ''， ''， ''））;解决方案
Short *
首先使用 选择 查询结果是否为0（它表示不存在）， 插入 查询将提前运行
<？php if（$ _ POST ['register']）{ $ uname = $ _POST ['uname']; $ email = $ _POST ['email']; $ name = $ _POST ['name']; $ pass = $ _POST ['pass']; $ result = mysqli_query（$ con，'SELECT * from TABLE_NAME where email_id =''。$ email。'or username ='。$ uname。''）; if（mysqli_num_rows（$ result）> 0）{ echo用户名或电子邮件已存在。; } else { $ query = mysqli_query（$ con，'INSERT INTO TABLE_NAME（`email_id`，`username`，`name`，`pass`）VALUES（'。$ email。' ，''。$ email。'，'。$ uname。'，'。$ name。'，'。$ pass。'）'）; if（$ query）{ echo数据插入成功。; } else { echo无法插入数据。; } } } ？>
I have a registration form. In the database, the username and email are unique index. When the form submits and username or email are already present in the database, the values are not inserted. I want to notify the user that the values were not inserted. How can i do this?
HTML
<form action="register.php" method="post" id="reg" onsubmit='return validate();'> Company Name: <input type="text" class="inputs" name="name" id="name" /><br /> Email: <input type="text" class="inputs" name="email" id="txtEmail" /><br /> User name: <input type="text" class="inputs" name="uname" id="uname"/><br /> Password: <input type="password" class="inputs" name="pass" id="pass1"/><br /> Conferm Password: <input type="password" class="inputs" name="cpass" id="pass2"/><br /><br /> <input type="submit" value="Register" class="button" /> </form>register.php:
include ("db.php"); if (isset($_POST['register'])) { echo $name = ($_POST["name"]); echo $email = ($_POST["email"]); echo $uname = ($_POST["uname"]); echo $password = ($_POST["pass"]); mysqli_query($con,"INSERT INTO company_profile(user_name, password, company_name, email, phone, country, activation_string) VALUES ('$uname','$password','$name','$email','','','')"); }解决方案
*Sweet And Short *
First check that username or email is exist or not using select query if resulting is 0 (it means not exists), Insert query will run ahead
<?php if($_POST['register']){ $uname = $_POST['uname']; $email = $_POST['email']; $name= $_POST['name']; $pass= $_POST['pass']; $result = mysqli_query($con, 'SELECT * from TABLE_NAME where email_id = "'.$email.'" or username = "'.$uname.'" '); if(mysqli_num_rows($result) > 0){ echo "Username or email already exists."; }else{ $query = mysqli_query($con , 'INSERT INTO TABLE_NAME (`email_id`, `username`,`name`,`pass`) VALUES("'.$email.'", "'.$email.'", "'.$uname.'","'.$name.'", "'.$pass.'")'); if($query){ echo "data are inserted successfully."; }else{ echo "failed to insert data."; } } } ?>
更多推荐
PHP表单提交到MySQL数据库
发布评论