我创建了一个已创建日期验证的网站,将数据库中的日期值更改为“唯一值”,但是它将查看重复的条目“ 12-1-2015”,例如,如何将其更改为消息或弹出式窗口抱歉,该日期已被保留。。
这是我的验证代码,但是没有用。。
<?php
include 'connection.php';
$date = $_POST['date'];
$rand = rand ();
session_start();
$_SESSION['random']=$rand;
$type = $_POST['typeofballroom'];
$setup = $_POST['setup'];
$name = $_POST['name'];
$conNum = $_POST['contactnumber'];
$email = $_POST['email'];
$themes = $_POST['theme'];
$menu = $_POST['menu'];
$note = $_POST['notes'];
$query = "SELECT * FROM ballroom_form WHERE date = '$date' ";
$result = mysql_query($query);
$person = mysql_fetch_array($result);
if($date == $person['date']) {
echo "unvalid refference number";
}
else
{
mysql_query ("INSERT INTO ballroom_form (`ID`,`random_number`,`ballroom_type`,`set_up`,`date`,`name`,`contact_number`,`email`,`themes`,`menu`,`note`) VALUES (NULL,'$rand','$type','$setup','$date','$name','$conNum','$email','$themes','$menu','$note')") or die(mysql_error());
echo "user has been added";
header ('location: randomNum.php');
}
?>
简单的方法
if($date == $person['date']) {
header("location:your_page.php?Status=no");
}
在您的“ your_page.php”中添加此代码或在php {}中使用弹出脚本
<?php if(isset($_REQUEST['Status']=='no')){?>
<h3 >invalid reference number</h3>
<?php }
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句