php只能使用mysql，php 社區,社區(phpmysql)一

社區(php&&mysql)一

更新時間：2006年10月09日 00:00:00 ? 作者：

function cook_cooloff(){

global $PHP_SELF,$aid,$pgno;

php只能使用mysql，setcookie("OPEN_LIST",0,time()+ 31536000);

Header("Location:$PHP_SELF?aid=$aid&pgno=$pgno");

exit;

}

//===============================================================

php sqlserver。function cook_coolon(){

global $PHP_SELF,$aid,$pgno;

setcookie("OPEN_LIST",1,time()+ 31536000);

Header("Location:$PHP_SELF?aid=$aid&pgno=$pgno");

exit;

MySQL論壇？}

function check_mail($semail)

{

$str=strchr($semail,'@');

if ($str=="") return false;

php數據庫。$str=strchr($semail,".");

if ($str=="") return false;

return true;

}

//================================================================

php sql語句，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'";

php和mysql關系，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++;

php連接mysql實例？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);

}

//===============================================================

php與mysql基礎教程，function mail_list(){

global $PHP_SELF,$HTTP_HOST,$email;

global $aid,$sid,$rid;

global $way1,$way2;

if(check_mail($email)) {

php+mysql。$mailtype=0; //璹綷

if(strlen($way2)) $mailtype=1;//

$DROOT=getenv('DOCUMENT_ROOT');

include("sql.php3");

$db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);

mysql workbench、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')";

phpstudy配置php環境、$rs=mysql_db_query($sql['db'],$qsql);

} else {

echo "

alert('竒,ぃ惠狡');

";

php訪問mysql數據庫步驟？}

} 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) { //蟲

php論壇？$qsql="DELETE FROM??bbs_sml where sid='$sid' AND email='$email'";

$rs=mysql_db_query($sql['db'],$qsql);

} else {

echo "

alert('﹟ゼ蟲ず!');

";

}

}

} else {

echo "

alert('E-mailΑ巋粇');

";

}

echo "

document.location='$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$rid'

";

}

//===============================================================

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\n";

$message.="ゅ徹夾肈:$banner\n";

$message.="ゅ徹ず甧:$body\n";

$message.="\nㄤ閩ゅ徹叫 http://$HTTP_HOST$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$rid\n";

$message.="<>\n";

$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 ざ殘硂ゅ徹\n";

$message.="ゅ徹夾肈:$banner\n";

$message.="ゅ徹ず甧:$body\n";

$message.="\nㄤ閩ゅ徹叫 http://$HTTP_HOST$PHP_SELF?proc=view&sid=$sid&aid=$aid&rid=$rid\n";

$message.="<>\n";

$mailfrom="From:".$c_email;

mail($frmail,$subj,$message,$mailfrom);

}else {

echo "

alert('E-mailΑ巋粇');

";

}

//echo "rid=$rid a=$aid s=$sid p=$pgno";

echo "

document.location='$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$rid'

";

}

待續......

相關文章

解決RHAS3中Apache2的PHP上傳文件大小的限制...2006-10-10

這算是草稿吧，很簡單，稍后再去看一些session講解。All right ,上代碼2011-08-08

寫一個用戶在線顯示的程序...2006-10-10

PHP 與大多數面向對象編程語言一樣,不支持多重繼承.也就是說每個類只能繼承一個父類。2009-09-09

如何跨站抓取別的站點的頁面的補充...2006-10-10

漢字轉化為拼音(php版)...2006-10-10

PHP4 與 MySQL 數據庫操作函數詳解...2006-10-10

社區(php&&mysql)六...2006-10-10

一段php加密解密的代碼...2006-10-10

用libTemplate實現靜態網頁的生成...2006-10-10

最新評論