首页 / 网页编程 / PHP / 社区（php&&mysql）一

function cook_cooloff（）{
    global $PHP_SELF,$aid,$pgno;
    setcookie（"OPEN_LIST",0,time（）+ 31536000）;
    Header（"Location:$PHP_SELF？aid=$aid&pgno=$pgno"）;
    exit;
}
//===============================================================
function cook_coolon（）{
    global $PHP_SELF,$aid,$pgno;
    setcookie（"OPEN_LIST",1,time（）+ 31536000）;
    Header（"Location:$PHP_SELF？aid=$aid&pgno=$pgno"）;
    exit;
}
function check_mail（$semail）
{
    $str=strchr（$semail,"@"）;   
    if （$str==""） return false;
    $str=strchr（$semail,"."）;
    if （$str==""） return false;
    return true;
}
//================================================================
function addhitviews（$sid,$rid） {
    $DROOT=getenv（"DOCUMENT_ROOT"）;
    include（"sql.php3"）;
    $db=mysql_connect（$sql["host"], $sql["user"] , $sql["passwd"]）;  
    if（$sid==$rid）     $qsql="SELECT * from bbs_subj where id="$rid"";
    else $qsql="SELECT * from bbs_docs where id="$rid"";
    $rs=mysql_db_query（$sql["db"],$qsql）;
    $row=mysql_fetch_array（$rs）;
    $views=$row["views"];
    $views++;
    if（$sid==$rid）     $qsql="UPDATE bbs_subj SET views="$views" where id="$rid"";
    else $qsql="UPDATE bbs_docs SET views="$views" where id="$rid"";

    mysql_db_query（$sql["db"],$qsql）;
}

//===============================================================
function mail_list（）{
    global $PHP_SELF,$HTTP_HOST,$email;
    global $aid,$sid,$rid;
    global $way1,$way2;

    if（check_mail（$email）） {
    $mailtype=0; //璹綷
    if（strlen（$way2）） $mailtype=1;//

    $DROOT=getenv（"DOCUMENT_ROOT"）;
    include（"sql.php3"）;
    $db=mysql_connect（$sql["host"], $sql["user"] , $sql["passwd"]）;  
    if（$mailtype==0） { //璹綷
        $qsql="SELECT * from bbs_sml where sid="$sid" AND email="$email"";
        $rs=mysql_db_query（$sql["db"],$qsql）;
        if（mysql_num_rows（$rs）==0） { //临⊿
          $qsql="INSERT INTO  bbs_sml （sid,email） values（"$sid","$email"）";
          $rs=mysql_db_query（$sql["db"],$qsql）;
        } else {
          echo "
          <script language=javascript>
          alert（"竒,ぃ惠狡"）;
          </script>
         ";     
        }
    } else { //璹綷
        $qsql="SELECT * from bbs_sml where sid="$sid" AND email="$email"";
        $rs=mysql_db_query（$sql["db"],$qsql）;
        if（mysql_num_rows（$rs） > 0） { //虫
          $qsql="DELETE FROM  bbs_sml where sid="$sid" AND email="$email"";
          $rs=mysql_db_query（$sql["db"],$qsql）;
        } else {
          echo "
          <script language=javascript>
            alert（"﹟ゼ虫ず！"）;
          </script>
         ";

        }

    }

    } else {
        echo "
          <script language=javascript>
              alert（"E-mailΑ岿粇"）;
          </script>
         ";  
    }
    echo "
          <script language=javascript>
          document.location="$PHP_SELF？proc=view&aid=$aid&sid=$sid&rid=$rid"
          </script>
         ";  
}

//===============================================================
function Send_the_doc_to_mail_list（$aid,$sid,$rid）{
    global $PHP_SELF,$HTTP_HOST;
    $DROOT=getenv（"DOCUMENT_ROOT"）;
    include（"sql.php3"）;
    $db=mysql_connect（$sql["host"], $sql["user"] , $sql["passwd"]）;  
    if（$sid==$rid）     $qsql="SELECT * from bbs_subj where id="$sid"";
    else $qsql="SELECT * from bbs_docs where id="$rid"";

    $rs=mysql_db_query（$sql["db"],$qsql）;
    $row=mysql_fetch_array（$rs）;
    $poster=$row["poster"];
    $banner=$row["banner"];
    $body=$row["body"];

    $subj=$c_poster."ㄓ璹綷ゅ彻";
    $message=":$poster ";
    $message.="ゅ彻夹肈:$banner ";
    $message.="ゅ彻ず甧:$body ";
    $message.=" ㄤ闽ゅ彻叫 http://$HTTP_HOST$PHP_SELF？proc=view&aid=$aid&sid=$sid&rid=$rid ";
    $message.="<<舧>> ";
    $mailfrom="From:Magic Jerry";


    $qsql="SELECT * from bbs_sml where sid="$sid"";
    $rs=mysql_db_query（$sql["db"],$qsql）;
    while（$row=mysql_fetch_array（$rs）） { //mail_list
        $email=$row["email"];
        mail（$email,$subj,$message,$mailfrom）;
        echo $email;
    }
    //盚倒恨瞶
    $qsql="SELECT * from bbs_area where id="$aid"";
    $rs=mysql_db_query（$sql["db"],$qsql）;
    $row=mysql_fetch_array（$rs）;
    $email=$row["email"];
    $banner=$row["banner"];

    mail（$email,"$banner 穝秈ゅ彻",$message,$mailfrom）;


}
//===============================================================
function mail_friend（）{
    global $PHP_SELF,$HTTP_HOST,$c_email,$c_poster,$frmail;
    global $aid,$sid,$rid;
    if（check_mail（$frmail）） {
    $DROOT=getenv（"DOCUMENT_ROOT"）;
    include（"sql.php3"）;
    $db=mysql_connect（$sql["host"], $sql["user"] , $sql["passwd"]）;
    if（$sid==$rid） {  
        $qsql="SELECT * from bbs_subj where id="$rid" ";
    } else {
        $qsql="SELECT * from bbs_docs where id="$rid" ";
    }
    $rs=mysql_db_query（$sql["db"],$qsql）;
    $row=mysql_fetch_array（$rs）;

    $banner=$row["banner"];
    $body=$row["body"];

    $subj=$c_poster."ざ残ゅ彻";
    $message="狟ね: $c_poster ざ残硂ゅ彻 ";
    $message.="ゅ彻夹肈:$banner ";
    $message.="ゅ彻ず甧:$body ";
    $message.=" ㄤ闽ゅ彻叫 http://$HTTP_HOST$PHP_SELF？proc=view&sid=$sid&aid=$aid&rid=$rid ";
    $message.="<<舧>> ";
    $mailfrom="From:".$c_email;

    mail（$frmail,$subj,$message,$mailfrom）;
    }else {
        echo "
          <script language=javascript>
              alert（"E-mailΑ岿粇"）;
          </script>
         ";  
    }
    //echo "rid=$rid a=$aid s=$sid p=$pgno";

    echo "
          <script language=javascript>
          document.location="$PHP_SELF？proc=view&aid=$aid&sid=$sid&rid=$rid"
          </script>
         ";  
}

待续......