sql insert into / select from php


sql insert into / select from php

是否可以合并插入到和选择从?我想做的是让用户填写一个应用程序,用户可以填写尽可能多的应用程序,每个应用程序都是不同的。在应用程序的最后,用户必须输入一个电子邮件地址,他们需要输入用于登录的正确电子邮件地址。如果他们没有输入正确的电子邮件地址,就会显示一条消息,说电子邮件地址无效,他或她将无法继续,直到他们输入正确的电子邮件地址。我的问题是,消息显示无效的电子邮件地址,但信息仍在上传

插入页:

<?php
     require_once("configur.php");
     $mysqli = new mysqli(localhost);
     $query='INSERT INTO profile_table SET email="'.$_POST[email].'", name="'.$_POST[name].'", age="'.$_POST[age].'", status="display"';
     if ($mysqli->query($query) === TRUE) 
        {
          echo "Record updated successfully";
        }
     else
        {
          echo "Error updating record: " . $conn->error;
        }
     $mysqli->close();
 ?>

主页:

<?php 
    require_once("configur.php");
    $mysqli = new mysqli(localhost );
    # check connection
    if ($mysqli->connect_errno) 
        {
            echo "<p>MySQL error no {$mysqli->connect_errno} : {$mysqli->connect_error}</p>";
            exit();
        }
    $email=$_POST['email']; 
    $sql = "SELECT * from register_login WHERE  email='$email'";
    $result = $mysqli->query($sql);
    if (!$result->num_rows == 1) 
        {
            echo "<p>Invalid email Address</p>";
        }
    else 
        {
            $_SESSION['email'] = $email;
            echo "<p>Logged in successfully</p>";
            // do stuffs
        }
?>  
require_once("configur.php");
$mysqli = new mysqli(localhost );
# check connection
if ($mysqli->connect_errno) 
    {
        echo "<p>MySQL error no {$mysqli->connect_errno} : {$mysqli->connect_error}</p>";
        exit();
    }
$email=$_POST['email']; 
$sql = "SELECT * from register_login WHERE  email='$email'";
$result = $mysqli->query($sql);
if ($result->num_rows == 0 ) // email id not present
    {
        echo "<p>Invalid email Address</p>";
    }
else 
    {
        $_SESSION['email'] = $email;
        echo "<p>Logged in successfully</p>";
        $query='INSERT INTO profile_table SET email="'.$_POST[email].'", name="'.$_POST[name].'", age="'.$_POST[age].'", status="display"';
       if ($mysqli->query($query) === TRUE) 
       {
               echo "Record updated successfully";
       }
       else
       {
             echo "Error updating record: " . $conn->error;
       }
        $mysqli->close();
    }

你的代码让我感到困惑,我不明白这两个脚本是如何相关的,我的意思是主页代码调用或包括插入页

我仍然有一个解决方案给你,你可以像这样将两个脚本合并在一个脚本中。

您可以使用页面重定向来调用插入文件,但由于您使用相同的$_POST数组,您应该组合两个脚本