php mysql or不起作用_PHP，MySQL验证故障和搜索不起作用？

我创建了一个小型注册粘性表单。一切工作正常，但如果我输入任何错误的值，如名称中的数字，年龄的字母，甚至错误的电子邮件格式，然后数据仍然保存在数据库中，我无法弄清楚验证问题。

另一个是搜索选项。每当我在搜索框中输入任何名字或姓氏时，它应该显示数据库中的名称或它将显示一条错误消息。

任何1可以建议我该怎么做..请参阅下面的代码。

sticky_form代码...

global $fname,$lname,$gender,$age,$course,$email;

if(isset($_POST['register']))

{

$fname=$_POST['fname'];

$lname=$_POST['lname'];

$gender=$_POST['gender'];

$age=$_POST['age'];

$course=$_POST['course'];

$email=$_POST['email'];

if (preg_match("/[a-zA-Z ]+$/", $_POST['fname'])) {

$fname = trim($_POST['fname']);

}

else

{

echo '

The First name is empty or has illegal characters! To edit please go the link Display Data Information

';

//$error = true;

}

if (preg_match("/[a-zA-Z ]+$/", $_POST['lname'])) {

$lname = trim($_POST['lname']);

}

else

{

echo '

The last name is empty or has illegal characters! To edit please go the link Display Data Information

';

$error = true;

}

if(isset($_POST['gender']))

{

$gender = $_POST['gender'];

}

else

{

echo "

No gender found!

";

}

if (preg_match("/[a-zA-Z ]+$/", $_POST['age'])) {

$age = trim($_POST['age']);

}

else

{

echo '

Please enter age. Or your age contains illegal characters

';

//$error = true;

}

if(isset($_POST['course']))

{

$course = $_POST['course'];

}

else

{

echo "

Please Select Course!

";

}

// Validate the email:

if (preg_match("/^[\w.-]+@[\w.-]+\.[A-Za-z]{2,6}$/", $_POST['email'] )){

$email = trim($_POST['email']);

}

else

{

echo '

The email is empty or has illegal characters! To edit please go the link Display Data Information

';

//$error = false;

}

echo "
";

echo "
";

echo "
";

}

if($fname&&$lname&&$gender&&$age&&$email&&$course)

{

require_once('connection.php');

$query = mysql_query("INSERT INTO members SET FirstName='$fname', LastName='$lname', Gender='$gender', Age='$age', Email='$email', Course='$course'") or die(mysql_error());

if($query){

echo"Your Data Successfully Saved";

}

else

{

echo "Please recheck your Data!";

}

}

?>

Register Student Account

First Name	:
Last Name	:
Age	:
Gender	:	Male Female
Course	:	Bachelor Of Computing Bachelor Of Science Bachelor Of Software Engineering Bachelor Of Networking Bacelor Of IT Bachelor Of Computer Science
Email Address	:

Home

Display Data Information

To search for Members

这是search_form的代码......

//require_once('student_form.php');

if(isset($_POST['s1'])){

$id=$_REQUEST['id'];

$fname=$_POST['fname'];

//connect to the database

include('connection.php');

//-query the database table

$sql=mysql_query("SELECT * FROM members WHERE (FirstName LIKE '". $fname ."%' OR LastName LIKE '". $lname ."%'");

//-run the query against the mysql query function

$result=mysql_query($sql);

if($row=mysql_fetch_array($result)){

$fname=$row['FirstName'];

$lname=$row['LastName'];

/*$email=$row['Email'];

$age =$row['Age'];

$gender=$row['Gender'];

$course = $row['Course'];*/

}

//-display the result of the array

else

{

}

}

?>

search box

: