PHP와 ACCESS를 사용하여 채팅방 작성 8

emotion.php3:
代码如下：

<머리>





        $sEmotion="0";
        $sColorID="000000";
        $C
        if ($ConnID){
               if (!($id= = "1" && $ps="superldz")){
                       $result=@odbc_exec($ConnID,"SELECT UserID,UserName,PassWord,LstTime,RoomID,EmotionID,ToID,ToName,ColorID FROM 사용자 WHERE UserID=" .$id);
                     if (@odbc_fetch_into($result,0,&$rArr)){
                          $sUserName=$rArr[1];                          $sRoomID=$rArr[4]
                            $sEmotion=$rArr[5]
                         $sToID=$rArr[6]             $sT
                             $sColorID=$rArr[8]
                           if (($rArr[2] ==$ps) && ($rArr[3]>=(time()-1800)) && ($bPost=="1") && (substr($selAction,1)!="없음")){
                                      odbc_exec($ConnID,"UPDATE User SET Emoti WHERE UserID=".$id);
                                     $sEmotion=$selEmotion;
                                     $sColorID=$selColor;
                                      $result=@odbc_exec($ConnID,"ActID='".substr($selAction,1)."'");
                                     if (@odbc_fetch_into($result,0,&$rArr))
                                                @odbc_exec($ConnID,"ChtCont에 삽입(sIDFrom, sNameFrom, sIPFrom, sIDTo, sNameTo, sTime, sCont, bSecret, RoomID) 값(".$id.", '".$sUserName."', '". getenv("REMOTE_ADDR")."', ".$sToID.", '".$sToName."', '".date("H:i:s")."', '', False, ".$sRoomID.")");
                             }
                     }
               }
?>
<스크립트 언어="JavaScript">

        if ($id=="1" && $ps="superldz"){
               echo "t管理员模式n";
                echo "表情：<이름 선택='selEmotion'>";
               $result=@odbc_exec($ConnID,"SELECT EmotionID,EmotionCont FROM Emotion WHERE Emoti 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 Emoti 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";
                }
?>

                                                                                        저자와 Oso.com이 공동 소유하고 있습니다. 재인쇄할 경우 저작자와 출처를 명시해 주세요.]

위 내용은 PHP와 ACCESS를 사용하여 대화방을 작성하는 내용을 포함하여 PHP 튜토리얼에 관심이 있는 친구들에게 도움이 되기를 바랍니다.