一、PHP操作数据库及表单验证
效果要求:按如图所示界面,实现单击提交按钮时,对表单进行非空验证,验证通过,则这写入数据库,数据库中除了上述3项外,应包含提交的时间。
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
</head>
<body>
<form method="post" action="">
<lable name="name">Name</lable>
<br>
<input type="text" name="name">
<br>
<lable name="email">Email Address</lable>
<br>
<input type="text" name="email">
<br>
<lable name="message">Your Message</lable>
<br>
<textarea name="message" cols="30" rows="10"></textarea>
<br>
<input type="submit" value="SUBMIT">
</form>
</body>
</html>
<?php
$conn = new mysqli("localhost","root","root");
$name = $_POST['name'];
$email = $_POST['email'];
$message = $_POST['message'];
if(empty($name) or empty($email) or empty($message)){
}else{
$sql = "create table if not exists www_test_com.web(name varchar(20),email varchar(50),message varchar(1000),submit_time TIMESTAMP);";
$re = $conn->query($sql);
$sql1 = "insert into www_com.web values('$name','$email','$message',now())";
$re1 = $conn->query($sql1);
}
?>
二、php与web交互(2)
效果要求:
在页面a.php中输入姓名和性别,提交跳转到页面b.php;在页面b中,根据性别的不同显示“XXX先生,你好!”或者“XXX女士,你好!”
<!-- a.php -->
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<body>
<form action="b.php" method="POST">
请输入您的姓名:<input type="text" name="name"><br>
请选择您的性别:<select name="gender" id="gender">
<option value="男">男</option>
<option value="女">女</option>
</select><br>
<input type="submit">
</form>
</body>
</html>
<!-- b.php -->
<?php
$name = $_POST["name"];
$gender = $_POST["gender"];
if ($gender == "男") {
$val = "先生,你好!";
$color = "blue";
} else {
$val = "女士,你好!";
$color = "pink";
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<style>
.color{
color:<?php echo $color; ?>;
}
</style>
</head>
<body>
<h1><?php echo $name.$val; ?></h1>
</body>
</html>
三、php与web交互(3)
效果要求:页面a.php上有两个超链接,文本内容分别是“行程绿码”、“行程灰麻”。点击超链接后,通过url传值到页面b.php;分别对应显示,“你好,你可以顺利出行。”;“你好,你未核酸。请及时核酸。”
<!-- a -->
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<body>
<a href="b.php?status=green">行程绿码</a>
<a href="b.php?status=gray">行程灰麻</a>
</body>
</html>
<!-- b -->
<?php
$status = $_GET['status'];
if ($status === 'green') {
echo '你好,你可以顺利出行。';
} elseif ($status === 'gray') {
echo '你好,你未核酸。请及时核酸。';
}
?>