PHP表单提交到MySQL数据库 [英] php form submission to mysql database

问题描述

我有一个注册表。在数据库中，用户名和电子邮件是唯一索引。当表单提交并且用户名或电子邮件已存在于数据库中时，不会插入值。我想通知用户该值未被插入。

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：
 < input type =submitvalue =Registerclass =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'， ''， ''， ''））; 
 
  

解决方案

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数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！