本文实例讲述了PHP实现通过get方式识别用户发送邮件的方法。分享给大家供大家参考。具体如下:
send_email.php如下:
1
2
3
4
5
6
7
8
9
10
11
12
|
<?php
$conn =mysql_connect( "localhost" , "root" , "admin" );
mysql_select_db( "songyunb_development" , $conn );
$id = $_GET [ "id" ];
$sql = "insert into email (sender_id,accepter_id,flag) values ('" . $_SESSION [ "id" ]. "','" . $id . "','no')" ;
$query =mysql_query( $sql );
if ( $query )
{
echo "<script>alert('?????????');</script>" ;
echo "<script>window.location.href='reg.php'</script>" ;
}
?>
|
reg.php如下:
1
2
3
4
5
6
7
8
9
10
|
<?php
$conn =mysql_connect( "localhost" , "root" , "admin" );
mysql_select_db( "songyunb_development" , $conn );
$sql = "select * from comments" ;
$query =mysql_query( $sql );
while ( $out =mysql_fetch_array( $query ))
{
echo $out [ "content" ]. "-------<a href='newfile.php?id=" . $out [ "id" ]. "'>查看邮件</a><br/>" ;
}
?>
|
newfile.php如下:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
<?php
$conn =mysql_connect( "localhost" , "root" , "admin" );
mysql_select_db( "songyunb_development" , $conn );
$result = "" ;
$id = "" ;
if (isset( $_GET [ "id" ]))
{
$id = $_GET [ "id" ];
$sql = "select * from comments where id='" . $_GET [ "id" ]. "'" ;
$result =mysql_query( $sql );
}
$out =mysql_fetch_array( $result );
echo $out [ "content" ]. "<br/>" ;
echo $out [ "created_at" ]. "<br/>" ;
echo "<a href='send_email.php?id=" . $out [ "id" ]. "'>发送邮件</a><br/><hr>" ;
//看看有没有新邮件
$sql_search_email = "select * from email where accepter_id='" . $id . "'" ;
$query =mysql_query( $sql_search_email );
$result_email =mysql_fetch_array( $query );
if ( $result_email [ "accepter_id" ]== $_SESSION [ "id" ]&& $result_email [ "flag" ]== "no" )
{
echo "<strong><a href='see_email.php?id=" . $result_email [ "id" ]. "'>您有新邮件</a></strong>" ;
}
?>
|
login.php如下:
1
2
3
4
5
6
7
|
<?php
$conn =mysql_connect( "localhost" , "root" , "admin" );
mysql_select_db( "songyunb_development" , $conn );
$_SESSION [ "id" ]=15;
echo "<a href='delete_session.php'>清除session</a>" ;
echo "<a href='reg.php'>重新注册</a>" ;
?>
|
delete_session.php如下:
1
2
3
4
5
6
7
|
<?php
if (isset( $_SESSION [ "id" ]))
{
unset( $_SESSION [ "id" ]);
}
echo "<script>alert('清除成功');</script>" ;
?>
|
希望本文所述对大家的php程序设计有所帮助。