[PHP] mysql에 데이터 삽입

    use this this will work i think so , use myl_sqli_query  or  mysql_query

    $cont = $idf;
    
        $idf = $user_profile['id'];
        
            $email = $user_profile['email'];
            
                $query = "SELECT idf from users where idf = $idf ";
                    $result = mysql_query($query);
                    
                    
                        if(mysql_num_rows($result) > 1)
                        
                        
                            {
                                    // row exists. so update
                                    
                                            mysql_query("UPDATE users SET name = '".$name."', birthday = '".$birthday."', gender = '".$gender."', email = '".$email."' WHERE idf = '".$idf."';") or die(mysqli_error());
                                            
                                                header( "refresh:4;url=/home.php" );
                                                
                                                    } 
                                                    
                                                        else 
                                                        
                                                            {
                                                            
                                                                $sql1 = "SELECT * FROM users WHERE email = $email ";
                                                                       $result1 = mysql_query($mysql,$sql1) or die(mysql_error());
                                                                       
                                                                              if (mysql_num_rows($result1) > 0)
                                                                              
                                                                              
                                                                              
                                                                                   echo "This Email is already used.";
                                                                                   
                                                                                       }
                                                                                       
                                                                                             else
                                                                                             
                                                                                             
                                                                                                 {
                                                                                                 
                                                                                                         // row  does not exists. so create new
                                                                                                                 //insertion dans la base de donnée
                                                                                                                     $sql= mysql_query("INSERT INTO users (name, email, birthday, gender,idl,idf ) VALUES ('".$name."', '".$email."', '".$birthday."', '".$gender."',NULL,'".$idf."');");
                                                                                                                     
                                                                                                                         //mysql_query ($sql) or die ('Erreur SQL !'.$sql.'<br />'.mysql_error());
                                                                                                                         
                                                                                                                         
                                                                                                                             //echo 'Le cookie existe   ' . $cont . '<br />';
                                                                                                                             
                                                                                                                                 mysql_close();
                                                                                                                                 
                                                                                                                                     setcookie("cokiz", $cont, time()+3600, "/", "NDD");
                                                                                                                                         setcookie("cokiz", $cont, time()+3600, "/", "NDD");
                                                                                                                                         
                                                                                                                                             header( "refresh:4;url=/home.php" );
                                                                                                                                             
                                                                                                                                             
                                                                                                                                                 }
                                                                                                                                                     }
                                                                                                                                                     
                                                                                                                                                     
                                                                                                                                                         ?>
                                                                                                                                                         

-------------------

오류는 당신이 놓친 것입니다

{

줄 앞에 :

echo "이 이메일은 이미 사용 중입니다.";

-------------------

이 코드는 괜찮습니다 : (ID로만 확인) :

$idf = $user_profile['id'];

$cont = $idf;

$query = "SELECT idf from users where idf = $idf ";
$result = mysql_query($query);


if(mysql_num_rows($result) > 1)
{
    // row exists. so update
    
        mysql_query("UPDATE users SET name = '".$name."', birthday = '".$birthday."', gender = '".$gender."', email = '".$email."' WHERE idf = '".$idf."';");
        } else {
        //echo $email;
            // row  does not exists. so create new
                //insertion dans la base de donnée
                $sql= mysql_query("INSERT INTO users (name, email, birthday, gender,idl,idf ) VALUES ('".$name."', '".$email."', '".$birthday."', '".$gender."',NULL,'".$idf."');");
                
                //mysql_query ($sql) or die ('Erreur SQL !'.$sql.'<br />'.mysql_error());
                
                
                //echo 'Le cookie existe   ' . $cont . '<br />';
                
                mysql_close();
                
                setcookie("cokiz", $cont, time()+3600, "/", "NDD");
                setcookie("cokiz", $cont, time()+3600, "/", "NDD");
                
                header( "refresh:4;url=/home.php" );
                
                
                }
                
                ?>
                

하지만 우편으로 확인을 추가하면 작동하지 않습니다 (아래 코드).

$cont = $idf;

    $idf = $user_profile['id'];
    
        $email = $user_profile['email'];
        
            $query = "SELECT idf from users where idf = $idf ";
                $result = mysql_query($query);
                
                
                    if(mysql_num_rows($result) > 1)
                    
                    
                    
                    
                        {
                                // row exists. so update
                                
                                        mysql_query("UPDATE users SET name = '".$name."', birthday = '".$birthday."', gender = '".$gender."', email = '".$email."' WHERE idf = '".$idf."';");
                                        
                                        
                                            } 
                                            
                                                else 
                                                
                                                    {
                                                    
                                                        $sql1 = "SELECT * FROM users WHERE email = $email ";
                                                               $result1 = mysql_query($mysql,$sql1) or die(mysql_error());
                                                               
                                                               
                                                                      if (mysql_num_rows($result1) > 0)
                                                                      
                                                                       {
                                                                       
                                                                            echo "This Email is already used.";
                                                                            
                                                                                }
                                                                                
                                                                                      else
                                                                                      
                                                                                      
                                                                                          {
                                                                                          
                                                                                                  // row  does not exists. so create new
                                                                                                          //insertion dans la base de donnée
                                                                                                              $sql= mysql_query("INSERT INTO users (name, email, birthday, gender,idl,idf ) VALUES ('".$name."', '".$email."', '".$birthday."', '".$gender."',NULL,'".$idf."');");
                                                                                                              
                                                                                                                  mysql_query ($sql) or die ('Erreur SQL !'.$sql.'<br />'.mysql_error());
                                                                                                                  
                                                                                                                  
                                                                                                                      //echo 'Le cookie existe   ' . $cont . '<br />';
                                                                                                                      
                                                                                                                          mysql_close();
                                                                                                                          
                                                                                                                              setcookie("cokiz", $cont, time()+3600, "/", "NDD");
                                                                                                                                  setcookie("cokiz", $cont, time()+3600, "/", "NDD");
                                                                                                                                  
                                                                                                                                      header( "refresh:4;url=/home.php" );
                                                                                                                                      
                                                                                                                                          }
                                                                                                                                              }
                                                                                                                                              
                                                                                                                                              
                                                                                                                                              
                                                                                                                                                  ?> 
                                                                                                                                                  

누군가 아이디어가 있습니까? 감사

출처
https://stackoverflow.com/questions/22019820