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