<php+mysql>PHP脚本条件判断，foreach循环，以及粘性表单

最新推荐文章于 2024-07-30 02:08:36 发布

MMMMMayC

最新推荐文章于 2024-07-30 02:08:36 发布

阅读量626

点赞数

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

本文链接：https://blog.youkuaiyun.com/qq_17615475/article/details/50439782

版权

实例代码专栏收录该内容

19 篇文章

订阅专栏

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

php代码：

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

<body>
	<h1>Send email to subscribers</h1>
    <p>Maystudio's administrators only!</p>
    	<?php
			$dbc=mysqli_connect('127.0.0.1','root','12345678','maystudio') or die('Error connecting MySQL server.');
			$query="SELECT * FROM email_list";
			$result=mysqli_query($dbc,$query) or die('Error querying database.');
			$subject=$_POST['subject'];
			$body=$_POST['body'];
			$from='changingvan@163.com';
			$output_form=false;
			
			/*如果按下提交按钮*/
			if(isset($_POST['submit'])){
				/*如果主题或内容项为空，提示并显示表*/
				if(empty($subject)||empty($body)){
					echo "You haven't complete the form yet...<br />";
					$output_form=true;
				}
				/*如果收件人项为空，提示并显示表*/
				if(empty($_POST['to'])){
					echo "You haven't select receivers...<br />";
					$output_form=true;
				}
				/*都不为空，发送邮件*/
				else{
					echo "Email sent to: <br />";
					foreach($_POST['to'] as $toid){
						$query="SELECT * FROM email_list WHERE id = $toid";
						$result=mysqli_query($dbc,$query) or die('Error querying database.');
						$subscriber=mysqli_fetch_array($result);
						$firstname=$subscriber['first_name'];
						$lastname=$subscriber['last_name'];
						$to=$subscriber['email'];
						$msg="Dear $firstname $lastname, \n $body";
						mail($to,$subject,$msg,'From: '.$from);
						echo $firstname.' '.$lastname.' '.$to.'<br />';
					}
					/**/
					echo '<a href="send-email.php">Back</a>';
				}
			}
			/*如果没有按下提交按钮，显示表*/
			else{
				$output_form=true;
			}
			/*显示表*/
			if($output_form){
		?>
     <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
     	<label for="to">To: </label><br />
        <?php
			/*循环输出收件人选项*/
			while($row=mysqli_fetch_array($result)){
				echo '<input type="checkbox" value="'.$row['id'].'" name="to[]" />';
				echo $row['first_name'];
				echo ' '.$row['last_name'];
				echo ' '.$row['email'].'<br />';
			}
		?>
    	<label for="subject">Subject: </label><br />
        <input type="text" id="subject" name="subject" value="<?php echo $subject; ?>" /><br /> <!--信息填写错误时仍在表格中留有填写的数据-->
        <label for="body">Body: </label><br />
        <textarea id="body" name="body" rows="8" cols="60"><?php echo $body; ?></textarea><br /><!--同上-->
        <input type="submit" name="submit" value="Send" />
    </form>
    	<?php
			}
		?>
</body>
</html>

代码下载： http://download.youkuaiyun.com/detail/qq_17615475/9384957