コミュニティ (php&&mysql) 1_PHP チュートリアル

function Cook_cooloff(){
global $PHP_SELF,$aid,$pgno;
setcookie("OPEN_LIST",0,time()+ 31536000);
Header("Location:$PHP_SELF?aid=$aid&pgno=$pgno");
終了します。
}
//============================================ ==================
関数 Cook_coolon(){
global $PHP_SELF,$aid,$pgno;
setcookie("OPEN_LIST",1,time()+ 31536000);
Header("Location:$PHP_SELF?aid=$aid&pgno=$pgno");
終了します。
}
関数 check_mail($semail)
{
$str=strchr($semail,'@');   
if ($str=="") は false を返します。
$str=strchr($semail,".");
if ($str=="") は false を返します。
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;
グローバル $aid、$sid、$rid;
グローバル $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) names('$sid','$email')";
$rs=mysql_db_query($sql['db'],$qsql);
} else {
echo "

";     
}
} 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 "
";

}

}

} else {
echo "
  
}
echo "

」;  
}

//=========================================== ===================
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['ポスター'];
$banner=$row['banner'];
$body=$row['body'];

$subj=$c_poster."ㄓ璹綷ゅ彻";
$message=":$poster";
$message.="ゅ彻夹肈:$bannern";
$message.="ゅ彻ず甧:$bodyn";
$message.="nㄤ闽ゅ彻叫 http://$HTTP_HOST$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$ridn";
$message.="<<舧>>n";
$mailfrom="差出人: マジック ジェリー";


$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(){
グローバル $PHP_SELF,$HTTP_HOST,$c_email,$c_poster,$frmail;
グローバル $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 ざ残硂ゅ彻n";
    $message.="ゅ彻夹肈:$bannern";
    $message.="ゅ彻ず甧:$bodyn";
    $message.="nㄤ闽ゅ彻叫 http://$HTTP_HOST$PHP_SELF?proc=view&sid=$sid&aid=$aid&rid=$ridn";
    $message.="<<舧>>n";
    $mailfrom="From:".$c_email;

    mail($frmail,$subj,$message,$mailfrom);
    }else {
        echo "
          
         ";  
    }
    //echo "rid=$rid a=$aid s=$sid p=$pgno";

    echo "
          
         ";  
}

待续...... 

http://www.bkjia.com/PHPjc/315626.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/315626.htmlTechArticlefunction cook_cooloff(){ global $PHP_SELF,$aid,$pgno; setcookie(OPEN_LIST,0,time()+ 31536000); Header(Location:$PHP_SELF?aid=$aidquot;); exit; } //==================================...