脚本宝典收集整理的这篇文章主要介绍了用PHP验证后未将数据插入数据库，脚本宝典觉得挺不错的，现在分享给大家，也给大家做个参考。

HTML和PHP验证代码：“ postresume.PHP”

<?PHP
$firstName = $lastName = $emailId = $phoneNo = $qualification = $dob = $totex = $address="";
$firstNameErr = $lastNameErr = $emailIdErr = $phoneNoErr = $qualificationErr = $dobErr = $totexErr = $addressErr = "";

if ($_SERVER['REQUEST_METHOD']== "POST") {
    $valid = true; 

    if (empty($_POST["firstName"])) {
        $firstNameErr = "*First name is required";
        $valid = false; //false
    }
    else {
        $firstName = test_input($_POST["firstName"]);
    }

    //LastName Error
    if (empty($_POST["lastName"])) {
        $lastNameErr = "*Last name is required";
        $valid = false;
    }
    else {
        $lastName = test_input($_POST["lastName"]);
    }

    // validation for,email,phoneno,qualification,dob,totex,address will be same as the above

    if($valid){
        echo '<Meta HTTP-EQUIV="Refresh" Content="0; URL=datasubmitted.PHP">';    
        exit;
    }
}

function test_input($data) {
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    return $data;
}
?>

这是我在“ postresume.PHP”中的表格：

<form action="<?PHP echo htmlspecialchars($_SERVER['PHP_SELF']);?>" method="post">
    <div class="label">*First Name:
        <div class="txtBox">
            <input name="firstName" type="text" id="txt" placeholder="Enter Your First Name." value="<?PHP echo $firstName; ?>"/>
            <span class="error"><p></p><?PHP echo  $firstNameErr; ?></span>
        </div>
    </div>
    <div class="label">Last Name:
        <div class="txtBox">
            <input name="lastName" type="text" id="txt" placeholder="Enter Your Last Name." value="<?PHP echo $lastName; ?>"/>
            <span class="error"><p></p><?PHP echo $lastNameErr; ?>
        </div>
    </div>
    // email,phoneno,qualification,dob,totex,address will be same as the above

用于将数据插入数据库MysqL的PHP代码：“ datasubmitted.PHP”

<?PHP
$con=MysqLi_connect("localhost","root","geetha@99","test");
// Check connection
if (MysqLi_connect_errno())
{
    echo "Failed to connect to MysqL: " . MysqLi_connect_error();
}

$sql="INSERT INTO register (fname, lname, emailid, phoneno, qualification, dob,   totalex, address)
    VALUES   ('$_POST[firstname]','$_POST[lastname]','$_POST[email]','$_POST[phoneno]','$_POST[qualifi]','$_POST[dob]','$_POST[totex]','$_POST[address]')";

if (!MysqLi_query($con,$sql))
{
    die('Error: ' . MysqLi_error($con));
}
echo "1 record added";

MysqLi_close($con);
?> 

请帮助我,并告诉我我的代码有什么问题.

解决方法:

您可以在下面的代码段中更改吗

   if($valid){ 
         echo '<Meta HTTP-EQUIV="Refresh" Content="0; URL=datasubmitted.PHP">'; 
         exit; 
     }

进入

  if($valid){ 
       include  'datasubmitted.PHP';
       echo '<Meta HTTP-EQUIV="Refresh" Content="0; URL=successpage.PHP">'; 
       exit;       
  } 

脚本宝典总结

以上是脚本宝典为你收集整理的用PHP验证后未将数据插入数据库全部内容，希望文章能够帮你解决用PHP验证后未将数据插入数据库所遇到的问题。

如果觉得脚本宝典网站内容还不错，欢迎将脚本宝典推荐好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。