<php+mysql>PHP脚本对数据库的基本操作，查找，删除，循环输出

最新推荐文章于 2022-12-13 21:07:01 发布

MMMMMayC

最新推荐文章于 2022-12-13 21:07:01 发布

阅读量875

点赞数

分类专栏：实例代码文章标签： php mysql html5

本文链接：https://blog.csdn.net/qq_17615475/article/details/50408269

版权

实例代码专栏收录该内容

19 篇文章 0 订阅

订阅专栏

这篇博客记录了使用PHP和MySQL进行数据库操作的学习过程，包括订阅功能的实现（输入姓名和邮箱提交订阅），取消订阅功能（输入邮箱取消），以及向所有订阅用户发送邮件的功能。内容基于《Head First PHP & MySQL》一书。

摘要由CSDN通过智能技术生成

（《Head First PHP & MySQL》学习记录）

输入姓名及邮箱提交可订阅，订阅后可输入邮箱取消订阅，可给所有订阅用户发送邮件。

订阅界面：

<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Add Email</title>
</head>

<body>
	<h1>Add to our email list</h1>
    <p>Enter your name and email and get our updatest information!</p>
    <form method="post" action="email-list.php">
    	<label for="firstname">First Name: </label>
        <input type="text" id="firstname" name="firstname" /><br />
        <label for="lastname">Last Name:</label>
        <input type="text" id="lastname" name="lastname" /><br />
        <label for="email">Email: </label>
        <input type="text" id="email" name="email" /><br />
        <input type="submit" value="Add" />
    </form>
</body>
</html>

<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Add email</title>
</head>

<body>
	<h1>Add to our email list</h1>
    <?php
		$firstname=$_POST['firstname'];
		$lastname=$_POST['lastname'];
		$email=$_POST['email'];
		
    	$dbc=mysqli_connect('127.0.0.1','root','12345678','maystudio') or die('Error connecting to MySQL server.');
		
		$query="INSERT INTO email_list (first_name,last_name,email) VALUES ('$firstname','$lastname','$email')";
		
		mysqli_query($dbc,$query) or die('Error query database.');
		
		mysqli_close($dbc);
		
		echo '<p>Thank you for subscription, we are not going to let you down!</p>';
		echo '<a href="unsubscribe.html">Unsubscription</a>';
	?>
</body>
</html>

取消订阅界面：

<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Unsubscribe Us</title>
</head>

<body>
	<h1>Unsubscription</h1>
    <p>We are so sorry to let you down.=(</p>
    <form method="post" action="unsubscribe.php">
    	<label for="email">Enter your email address: </label>
        <input type="text" id="email" name="email" /><br />
        <input type="submit" value="Unsubscribe" />
    </form>
</body>
</html>

<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Unsubscribe Us</title>
</head>

<body>
	<h1>Unsubscription</h1>
	<?php
		$email=$_POST['email'];
		
		$dbc=mysqli_connect('127.0.0.1','root','12345678','maystudio') or die('Error connecting to MySQL server.');
		$query="DELETE FROM email_list WHERE email = '$email' ";
		mysqli_query($dbc,$query) or die('Error querying database.');
		mysqli_close($dbc);
		
		echo 'Successful unsubscription!';
	?>
</body>
</html>

发送邮件界面：

<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Untitled Document</title>
</head>

<body>
	<h1>Send email to subscribers</h1>
    <p>Maystudio's administrators only!</p>
    <form method="post" action="send-email.php">
    	<label for="subject">Subject: </label><br />
        <input type="text" id="subject" name="subject" /><br />
        <label for="body">Body: </label><br />
        <textarea id="body" name="body" rows="8" cols="60"></textarea><br />
        <input type="submit" name="submit" value="Send" />
    </form>
</body>
</html>

<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Send email</title>
</head>

<body>
	<h1>Email sent</h1>
	<?php
		$from='changingvan@163.com';
		$subject=$_POST['subject'];
		$body=$_POST['body'];
		
		$dbc=mysqli_connect('127.0.0.1','root','12345678','maystudio') or die('Error connecting to MySQL server.');
		$query="SELECT * FROM email_list";
		$result=mysqli_query($dbc,$query) or die('Error querying database.');
		while($row=mysqli_fetch_array($result)){
			$first_name=$row['first_name'];
			$last_name=$row['last_name'];
			$msg="Dear $first_name $last_name,\n $body";
			$to=$row['email'];
			mail($to,$subject,$msg,'From: '.$from);
			echo 'Email sent to '.$to.'<br />';
		}
		mysqli_close($dbc);
	?>
</body>
</html>

代码下载：http://download.csdn.net/detail/qq_17615475/9377903