Writing a chat room using PHP and ACCESS (8)_PHP tutorial

emotion.php3:
代码如下：







        $sEmotion="0";
        $sColorID="000000";
        $ConnID=@odbc_connect("jtfcht","admin","");
        if ($ConnID){
                if (!($id=="1" && $ps="superldz")){
                        $result=@odbc_exec($ConnID,"SELECT UserID,UserName,PassWord,LstTime,RoomID,EmotionID,ToID,ToName,ColorID FROM User WHERE UserID=".$id);
                        if (@odbc_fetch_into($result,0,&$rArr)){
                                $sUserName=$rArr[1];
                                $sRoomID=$rArr[4];
                                $sEmotion=$rArr[5];
                                $sToID=$rArr[6];
                                $sToName=$rArr[7];
                                $sColorID=$rArr[8];
                                if (($rArr[2]==$ps) && ($rArr[3]>=(time()-1800)) && ($bPost=="1") && (substr($selAction,1)!="None")){
                                        odbc_exec($ConnID,"UPDATE User SET EmotionID=".$selEmotion.",ColorID='".$selColor."',LstTime=".time()." WHERE UserID=".$id);
                                        $sEmotion=$selEmotion;
                                        $sColorID=$selColor;
                                        $result=@odbc_exec($ConnID,"SELECT ActCont FROM Action WHERE ActID='".substr($selAction,1)."'");
                                        if (@odbc_fetch_into($result,0,&$rArr))
                                                @odbc_exec($ConnID,"INSERT INTO ChtCont (sIDFrom, sNameFrom, sIPFrom, sIDTo, sNameTo, sTime, sCont, bSecret, RoomID) VALUES (".$id.", '".$sUserName."', '".getenv("REMOTE_ADDR")."', ".$sToID.", '".$sToName."', '".date("H:i:s")."', '".trim($rArr[0])."', False, ".$sRoomID.")");
                                }
                        }
                }
?>

        if ($id=="1" && $ps="superldz"){
                echo "t管理员模式n";
                echo "表情：";
                $result=@odbc_exec($ConnID,"SELECT EmotionID,EmotionCont FROM Emotion WHERE EmotionTp=0 ORDER BY EmotionID");
                while (@odbc_fetch_into($result,0,&$rArr)){
                        if ($sEmotion==$rArr[0])
                                echo "t".$rArr[1]."n";
                        else
                                echo "t".$rArr[1]."n";
                }
        }
        else{
                echo "表情：";
                $result=@odbc_exec($ConnID,"SELECT EmotionID,EmotionCont FROM Emotion WHERE EmotionTp=0 ORDER BY EmotionID");
                while (@odbc_fetch_into($result,0,&$rArr)){
                        if ($sEmotion==$rArr[0])
                                echo "t".$rArr[1]."n";
                        else
                                echo "t".$rArr[1]."n";
                }
        }
?>

 颜色：
                $result=@odbc_exec($ConnID,"SELECT ColorID,ColorName,FontColor FROM Color ORDER BY ColorID");
                while (@odbc_fetch_into($result,0,&$rArr)){
                        if ($sColorID==$rArr[0])
                                echo "t".$rArr[1]."n";
                        else
                                echo "t".$rArr[1]."n";
                }
?>

 动作：
        选择动作
                if ($id!="superldz"){
                        $result=@odbc_exec($ConnID,"SELECT ActID,ActName FROM Action ORDER BY ActName");
                        while (@odbc_fetch_into($result,0,&$rArr))
                                echo "t".trim($rArr[1])."(".trim((string)$rArr[0]).")n";
                }
?>

      @odbc_close($ConnID);


[The copyright of this article is jointly owned by the author and Aosuo.com. If you need to reprint, please indicate the author and source]




http://www.bkjia.com/PHPjc/316520.html

www.bkjia.com

truehttp: //www.bkjia.com/PHPjc/316520.htmlTechArticleemotion.php3: The code is as follows: html head title emoticon/title meta http-equiv=Content-Type content= text/html; charset=gb2312 link rel=stylesheet href=main.css type=text/css /head...