聊天室－ab1628的部落格

簡單聊天室 chat_log1 chat_log3

chat_log.php

<?php require_once('../Connections/allianz.php'); ?>
<?php
session_start();

$varMM_form = ""; if (isset($_POST["mm_form"]) ){ $varMM_form =$_POST["mm_form"];}
//echo "mm_form=" .$varMM_form ."<br>";

if( $varMM_form == "form1" ){
$varID = ""; if (isset($_SESSION["id"]) ){$varID =$_SESSION["id"];}
//echo "id = " .$varID ."<br>";

$varAct = ""; if (isset($_POST["act"]) ){ $varAct =$_POST["act"];}
//echo "act=" .$varAct ."<br>";

$varPwd = ""; if (isset($_POST["pwd"]) ){ $varPwd =$_POST["pwd"];}
//echo "pwd=" .$varPwd ."<br>";

if (
(strlen($varAct)>0) &&
(strlen($varPwd)>0)
){
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql = " select * from charlog where 1=1 ";
if ( strlen($varAct)>0 ){
$sql.=" and act='".$varAct."' ";
}
if ( strlen($varPwd)>0 ){
$sql.=" and pwd='".$varPwd."' ";
}
//echo " sql = " . $sql . "<br>";
//exit();
$Recordset1 = mysql_query($sql, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset1 = mysql_fetch_assoc($Recordset1); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset1 = mysql_num_rows($Recordset1); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1
//echo "totalRow_Recordset1 = " .$totalRow_Recordset1."<br>";

if( $totalRow_Recordset1 >0 ){
$_SESSION["id"] = $row_Recordset1["id"];
header(sprintf("Location: %s", "chat_room.php " ));

}else if( $totalRow_Recordset1 == 0){
echo "帳密錯誤";
}
} // end of if

}
/*
1.先有表單
2.把表單資料送出
3.如果表單= 表單資料
4.抓資料庫帳密欄位參數
5.資料庫下查詢語法
6.如果筆數大於0
7.抓資料庫編號=網頁存取編號
8.跳聊天室頁
否則表單!=表單資料
9.帳密錯誤

*/

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

<script src="http://code.jquery.com/jquery-1.10.2.js"></script>
<script src="../js/jquery-ui-1.11.1.custom/jquery-ui.js"></script>
<link rel="stylesheet" href="../js/jquery-ui-1.11.1.custom/jquery-ui.structure.css">
<link rel="stylesheet" href="../js/jquery-ui-1.11.1.custom/jquery-ui.theme.css">
<script>

</script>
</head>
<body>
<form method="post" name="form1" action="">
<table border="1">
<tr>
<td colspan="2">使用者登入</td>
</tr>
<tr>
<td>帳號</td><td><input type="text" name="act" value=""</td>
</tr>
<tr>
<td>密碼</td><td><input type="text" name="pwd" value=""</td>
</tr>
<tr>
<td><input type="submit" value="登入"</td><td><input type="button" value="建立新帳戶" onclick="location.href='chat_sign.php'"></td>
</tr>
</table>
<input type="hidden" name="mm_form" value="form1">
</form>
</body>

</html>

chat_sign.php

<?php require_once('../Connections/allianz.php'); ?>
<?php

// -- 共用函式 --
// 檔案處理區 ( "../../../../upload/news")
function isUploadFile($tmpFileName, $newFileName){
$isUpload = false;
if ( copy($tmpFileName, $newFileName) ){ // 更改檔名前置動作
$isUpload = true;
}
unlink($tmpFileName); // 清除暫存檔案
return $isUpload;
}
// 取得檔名
function getDateTimeFileName( $varIcon ){
$temp = explode(".",$varIcon);
return date("ymdHis") . "." . $temp[1];
}

$varMM_form = ""; if (isset($_POST["mm_form"]) ){ $varMM_form=$_POST["mm_form"];}
//echo " mm_form =" . $varMM_form."<br>";

if( $varMM_form == "form1"){
$varAct = ""; if (isset($_POST["act"]) ){ $varAct = $_POST["act"];}
//ehco " act = " . $varAct . "<Br>";

$varPwd = ""; if (isset($_POST["pwd"]) ){ $varPwd = $_POST["pwd"];}
//echo " pwd = " . $varPwd . "<br>";

$varSex = "";
if (isset($_POST["sex"]) ){ $varSex = implode(",", $_POST["sex"]); }

$varAge = ""; if (isset($_POST["age"])){ $varAge = $_POST["age"];}

$varInter = ""; if (isset($_POST["inter"])){ $varInter = implode(",", $_POST["inter"]); }

$varMail = ""; if (isset($_POST["mail"]) ){$varMail =$_POST["mail"];}
//echo "mail = " .$varMail ."<br>";

$varTel = ""; if (isset($_POST["tel"]) ){$varTel =$_POST["tel"];}
//echo "tel = " .$varTel ."<br>";

$varPhe = ""; if (isset($_POST["phe"]) ){$varPhe =$_POST["phe"];}
//echo "phe = " .$varPhe ."<br>";

$varAddr = ""; if (isset($_POST["addr"]) ){$varAddr =$_POST["addr"];}

$varIcon = ""; if (isset($_FILES["icon"]["name"]) ){$varIcon = $_FILES["icon"]["name"]; }

// 上傳圖片
$oldFileName = $_FILES["icon"]["name"]; //--讀取參數
$tmpFileName = $_FILES["icon"]["tmp_name"];
$fileType = $_FILES["icon"]["type"];
$fileSize = $_FILES["icon"]["size"];

$newFileName = getDateTimeFileName($oldFileName);
//$newFileName = $oldFileName; // "a.txt"; // 以原檔名存
$newFileName=$_FILES["icon"]["name"]; // 以原檔名存

$path = "./images/upload"; // images/upload/

if ( chdir($path) ){ // 是否有切換目錄成功
if ( isUploadFile($tmpFileName, $newFileName) ){ // 上傳成功
$msg .= "檔名=" . $oldFileName . "\\n";
$msg .= "大小=". ceil($fileSize / 1024) . " KB\\n";
$msg .= "\\n　成功上傳了 <br>";

} else {
$msg.= "\\n　上傳失敗，有可能您上傳的檔案太大了，";
$msg.= "不合規定，如有任何問題，請洽系統設計服務人員";
}
} else {
$msg.= "上傳檔案到指定的目錄失敗\\n";
}

mysql_select_db($database_allianz,$allianz); // 連線資料庫
$insert = " insert into charlog ( ";
$insert.= " act, pwd, sex, ";
$insert.= " age, inter, mail, ";
$insert.= " tel, phe, addr, ";
$insert.= " icon, ";
$insert= substr($insert, 0, strlen($insert)-2);
$insert.= " ) value ( ";
$insert.= " '".$varAct."', ";
$insert.= " '".$varPwd."', ";
$insert.= " '".$varSex."' , ";
$insert.= " '".$varAge."' , ";
$insert.= " '".$varInter."' , ";
$insert.= " '".$varMail."' , ";
$insert.= " '".$varTel."' , ";
$insert.= " '".$varPhe."' , ";
$insert.= " '".$varAddr."' , ";
$insert.= " '" . $_FILES["icon"]["name"] . "', ";
$insert = substr($insert, 0, strlen($insert)-2);
$insert.= ");";

//echo " insert = " . $insert . "<br>";
//exit();
$Recordset1=mysql_query($insert,$allianz) or die(mysql_error());// 執行查詢語法
header(sprintf("Location: %s", "chat_log.php" ));
}
/*
1.先有表單
2.表單資料送出
3.表單資料=表單=

新增語法

*/
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

<script src="http://code.jquery.com/jquery-1.10.2.js"></script>
<script src="../js/jquery-ui-1.11.1.custom/jquery-ui.js"></script>
<link rel="stylesheet" href="../js/jquery-ui-1.11.1.custom/jquery-ui.structure.css">
<link rel="stylesheet" href="../js/jquery-ui-1.11.1.custom/jquery-ui.theme.css">
<script>

</script>
</head>
<body>
<form method="post" name="form1" action="" enctype="multipart/form-data">
<table border="1">
<tr>
<td colspan="2">建立新使用者</td>
</tr>
<tr>
<td>帳號</td><td><input type="text" name="act" value=""></td>
</tr>
<tr>
<td>密碼</td><td><input type="text" name="pwd" value=""></td>
</tr>
<tr><td>圖示</td><td><input name="icon" type="file" id="icon" value="" size="32"></td></tr>
<tr>
<td>性別</td>
<td>
淑女<input type="radio" name="sex[]" value="0" checked>
男紳<input type="radio" name="sex[]" value="1">
</td>
</tr>
<tr>
<td>年紀</td>
<td>
<select name="age" id="age">
<?php for($i=18;$i<=40;$i++){?>
<option><?php echo $i;?>歲</opion>
<?php } ?>
</select>
</td>
</tr>
<tr>
<td>興趣</td>
<td>
運動<input name="inter[]" type="checkbox" id="inter[]" value="0">
旅遊<input name="inter[]" type="checkbox" id="inter[]" value="1">
音樂<input name="inter[]" type="checkbox" id="inter[]" value="2">
電影<input name="inter[]" type="checkbox" id="inter[]" value="3">
美食<input name="inter[]" type="checkbox" id="inter[]" value="4">
聚會<input name="inter[]" type="checkbox" id="inter[]" value="5">
動漫<input name="inter[]" type="checkbox" id="inter[]" value="6">
</td>
</tr>
<tr>
<td>電子郵件</td>
<td>
<input type="text" name="mail" value="">
</td>
</tr>
<tr>
<td>電話</td>
<td><input type="text" name="tel" value=""></td>
</tr>
<tr>
<td>手機</td>
<td><input type="text" name="phe" value="">
</td>
</tr>
<tr>
<td>地址</td>
<td><input type="text" name="addr" value=""></td>
</tr>
<tr>
<td><input type="submit" value="註冊"</td><td><input type="button" value="回登入" onclick="location.href='chat_log.php'"></td>
</tr>
</table>
<input type="hidden" name="mm_form" value="form1">
</form>
</body>

</html>

chat_room.php

<?php require_once('../Connections/allianz.php'); ?>
<?php
session_start();
date_default_timezone_set('Asia/Taipei');//時間函式
//接參數
if(!isset($_SESSION["id"] ) ){
header(sprintf("Location: %s", "chat_log.php") );
}

$varMM_form = ""; if (isset($_POST["mm_form"]) ){ $varMM_form =$_POST["mm_form"];}
//echo "mm_form=" .$varMM_form ."<br>";

if( $varMM_form=="form1" ){//第二次進入新增
//echo "a"."<br>";
$varSek = ""; if (isset($_POST["sek"]) ){$varSek =$_POST["sek"];}
//echo "sek = " .$varSek ."<br>";
$varCsg = ""; if (isset($_POST["csg"]) ){$varCsg =$_POST["csg"];}
//echo "csg = " .$varCsg ."<br>";
$varMsg = ""; if (isset($_POST["msg"]) ){$varMsg =$_POST["msg"];}
//echo "msg = " .$varMsg ."<br>";
//下新增語法
$insert = " insert into chatroom ( ";
$insert.= " sek, csg, ";
$insert.= " msg, dates, ip, ";
$insert = substr($insert, 0, strlen($insert)-2);
$insert.= ") values (";
$insert.= "'" . $varSek . "', ";
$insert.= "'" . $varCsg . "', ";
$insert.= "'" . $varMsg . "', ";
$insert.= "'" . date("Y/m/d H/i/s") . "', ";
$insert.= "'" . $_SERVER["REMOTE_ADDR"] . "', ";
$insert = substr($insert, 0, strlen($insert)-2);
$insert.= ")"; // 準備要新增的SQL指令
//echo "insert = " . $insert . "<Br>";
//exit();
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$Result1 = mysql_query($insert, $allianz) or die(mysql_error()); // 執行新增或修改或刪除的SQL語法
} else if( $varMM_form=="清除" ){
$sql = " truncate table chatroom "; // 準備要新增的SQL指令
//echo "insert = " . $insert . "<Br>";
//exit();
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$Result1 = mysql_query($sql, $allianz) or die(mysql_error()); // 執行新增或修改或刪除的SQL語法
}

$varID = ""; if (isset($_SESSION["id"]) ){$varID =$_SESSION["id"];}
//echo "id = " .$varID ."<br>";
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sql = " select * from charlog where 1=1 and id= ".$_SESSION["id"]." "; // 準備要查詢的SQL指令
// echo "sql =". $sql . "<br>";
$Recordset1 = mysql_query($sql, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset1 = mysql_fetch_assoc($Recordset1); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset1 = mysql_num_rows($Recordset1); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>聊天室</title>
<script>
<!--
function clears(){
var iptBx = document.getElementById("mm_form");
iptBx.value="清除";

form1.submit();
}

-->
</script>
</head>
<script>

</script>
<body>
<table border="1">
<tr>
<td valign="top">
<?php
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$sq2 = " select * from chatroom where 1=1 order by id "; // 準備要查詢的SQL指令
//echo "sq2 =". $sq2 . "<br>";
$Recordset2 = mysql_query($sq2, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset2 = mysql_fetch_assoc($Recordset2); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset2 = mysql_num_rows($Recordset2); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1

// 筆數>10
// 清掉資料庫
if($totalRow_Recordset2>10){
mysql_select_db($database_allianz, $allianz); // 連線資料庫
$del = " delete from chatroom where 1=1 "; // 準備要查詢的SQL指令
//echo "del =". $del . "<br>";
$Recordset2 = mysql_query($del, $allianz) or die(mysql_error()); // 執行查詢語法
}

$sq2 = " select * from chatroom where 1=1 order by id "; // 準備要查詢的SQL指令
//echo "sq2 =". $sq2 . "<br>";
$Recordset2 = mysql_query($sq2, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset2 = mysql_fetch_assoc($Recordset2); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset2 = mysql_num_rows($Recordset2); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1

?>
<table border="0" style="overflow:auto; width:300px;" >
<?php //$ii=0; ?>
<?php if ( $totalRow_Recordset2>0 ){ ?>
<?php do{ ?>
<tr>
<td >
<?php //echo $ii++;?>
<span style="color:#FF0404;"><?php echo $row_Recordset2["sek"];?></span>
<span style="font-size:20px;"> 對 </span>
<span style="color:#3CAF34;"><?php echo $row_Recordset2["csg"];?></span>
<span style="font-size:20px; "> 說 </span>
<span style="font-size:20px; color:#3300FF; "><?php echo $row_Recordset2["msg"];?></span>
</td>
</tr>
<?php }while( $row_Recordset2 = mysql_fetch_assoc($Recordset2) );?>

<?php } ?>
</table>
</td>



</tr>
<tr>
<td>
<form action="" name="form1" method="post">
<table border="0">
<tr>
<td>發話</td>
<td><input type="text" name="msg" value=""></td>
<td><input type="submit" value="留言"></td>

</tr>
<tr>
<td>對象</td>
<?php
mysql_select_db($database_allianz, $allianz); // 連線資料庫

$sql3 = " select * from charlog where 1=1 and id<> ". $_SESSION["id"] ." "; // 準備要查詢的SQL指令
//echo "sql3 =". $sql3 . "<br>";
$Recordset3 = mysql_query($sql3, $allianz) or die(mysql_error()); // 執行查詢語法
$row_Recordset3 = mysql_fetch_assoc($Recordset3); // 把查詢的結果帶到$row_Recordset1[]陣列中
$totalRow_Recordset3 = mysql_num_rows($Recordset3); // 把查詢後表格總共有幾列(幾筆資料)放到 $totalRows_Recordset1

?>
<td>
<select name="csg">
<?php if( $totalRow_Recordset3>0 ){ ?>
<?php do{ ?>
<option value="<?php echo $row_Recordset3["act"];?>"
<?php if( $_POST["csg"]==$row_Recordset3["act"] ){ echo "selected=\"selected\""; }?> >
<?php echo $row_Recordset3["act"];?></option>
<?php }while( $row_Recordset3 = mysql_fetch_assoc($Recordset3) );?>
</select>
</td>
<td><input type="button" value="清空" onclick="clears();"></td>
<?php }else{ ?>
<td>尚無資料</td>
<?php } ?>
<td>
</tr>
<tr>
<td colspan="6"><input type="button" value="登出" onclick="location.href='chat_logout.php';"></td>
<tr>
<td colspan="6"><input type="hidden" name="sek" value="<?php echo $row_Recordset1["act"];?>"></td>
</tr>
<tr>
<td colspan="6"><input type="hidden" name="dates" value="<?php echo date("Y/m/d H:i:s");?>"></td>
</tr>
<tr>
<td colspan="6"><input type="hidden" name="ip" value="<?php echo $_SERVER["REMOTE_ADDR"];?>"></td>
</tr>
</table>
<input type="hidden" id="mm_form" name="mm_form" value="form1">
</form>
</td>


</tr>
</table>
</body>
</html>

chat_logout.php

<?php
session_start();
$_SESSION["id"] = null;
header(sprintf("Location: %s", "chat_log.php " ));
?>

資料庫

-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
--
-- 主機: 127.0.0.1
-- 建立日期: Sep 23, 2014, 10:28 AM
-- 伺服器版本: 6.0.4
-- PHP 版本: 6.0.0-dev

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- 資料庫: `desire`
--

-- --------------------------------------------------------

--
-- 資料表格式： `charlog`
--

CREATE TABLE `charlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`act` varchar(10) NOT NULL,
`pwd` varchar(20) NOT NULL,
`icon` varchar(20) NOT NULL,
`sex` varchar(1) NOT NULL,
`age` int(10) NOT NULL,
`inter` varchar(10) NOT NULL,
`mail` varchar(30) NOT NULL,
`tel` int(10) NOT NULL,
`phe` int(10) NOT NULL,
`addr` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;

--
-- 列出以下資料庫的數據： `charlog`
--

INSERT INTO `charlog` (`id`, `act`, `pwd`, `icon`, `sex`, `age`, `inter`, `mail`, `tel`, `phe`, `addr`) VALUES (1, '若彤彤', '1', '74.jpg', 'A', 24, 'Array', 'asdfg1628@yahoo.com.tw', 2147483647, 2147483647, '台中市');
INSERT INTO `charlog` (`id`, `act`, `pwd`, `icon`, `sex`, `age`, `inter`, `mail`, `tel`, `phe`, `addr`) VALUES (2, 'Snowy雪', '123456', '17.jpg', 'A', 30, 'Array', 'sidmial1628@hotmail.com', 2147483647, 2147483647, '台南縣');
INSERT INTO `charlog` (`id`, `act`, `pwd`, `icon`, `sex`, `age`, `inter`, `mail`, `tel`, `phe`, `addr`) VALUES (3, '愛情守護天使', '879465', '04.jpg', 'A', 18, 'Array', 'sf798465@hotmail.com', 2147483647, 2147483647, '宜蘭市');
INSERT INTO `charlog` (`id`, `act`, `pwd`, `icon`, `sex`, `age`, `inter`, `mail`, `tel`, `phe`, `addr`) VALUES (4, '心醉紅顏', '987465321', '06.jpg', 'A', 18, 'Array', 'gfn789465@gmail.com', 2147483647, 2147483647, '花蓮市');
INSERT INTO `charlog` (`id`, `act`, `pwd`, `icon`, `sex`, `age`, `inter`, `mail`, `tel`, `phe`, `addr`) VALUES (5, '~粉戀金吉拉~', '123', '04.jpg', 'A', 27, 'Array', 'sdjk789@hotmail.com', 2147483647, 2147483647, '基隆市');
INSERT INTO `charlog` (`id`, `act`, `pwd`, `icon`, `sex`, `age`, `inter`, `mail`, `tel`, `phe`, `addr`) VALUES (6, 'MissPure', 'fedf', '08.jpg', 'A', 31, 'Array', 'sdf4825@yahoo.com.tw', 2147483647, 2147483647, '台北市');
INSERT INTO `charlog` (`id`, `act`, `pwd`, `icon`, `sex`, `age`, `inter`, `mail`, `tel`, `phe`, `addr`) VALUES (7, 'a', 'a', '01.jpg', 'A', 18, 'Array', 'a', 2147483647, 2147483647, 'a');
INSERT INTO `charlog` (`id`, `act`, `pwd`, `icon`, `sex`, `age`, `inter`, `mail`, `tel`, `phe`, `addr`) VALUES (8, 'b', 'b', '17.jpg', 'A', 30, 'Array', 'beb987@yahoo.com.tw', 2147483647, 2147483647, 'b');
INSERT INTO `charlog` (`id`, `act`, `pwd`, `icon`, `sex`, `age`, `inter`, `mail`, `tel`, `phe`, `addr`) VALUES (9, 'uo', 'uo', '08.jpg', 'A', 25, 'Array', 'uo978@hotmail.com', 2147483647, 2147483647, '高雄市');
INSERT INTO `charlog` (`id`, `act`, `pwd`, `icon`, `sex`, `age`, `inter`, `mail`, `tel`, `phe`, `addr`) VALUES (10, 'p', 'p', '05.jpg', '1', 29, '1', 'p@yahoo.com.tw', 2147483647, 2147483647, 'p');
INSERT INTO `charlog` (`id`, `act`, `pwd`, `icon`, `sex`, `age`, `inter`, `mail`, `tel`, `phe`, `addr`) VALUES (13, 'k', 'k', '05.jpg', '1', 18, '', 'k', 937894715, 2147483647, 'k');

程式-聊天室

ab1628

ab1628的部落格

ab1628 發表在痞客邦留言(0) 人氣()

E-mail轉寄

ab1628的部落格

新人初到請多指教

聊天室

留言列表

站方公告

活動快報

送亞洲...

我的好友

熱門文章

文章分類

最新文章

最新留言

動態訂閱

文章精選

文章搜尋

新聞交換(RSS)

誰來我家

參觀人氣

QR Code

POWERED BY

ab1628的部落格

新人初到 請多指教

聊天室

留言列表

站方公告

活動快報

送亞洲...

我的好友

熱門文章

文章分類

最新文章

最新留言

動態訂閱

文章精選

文章搜尋

新聞交換(RSS)

誰來我家

參觀人氣

QR Code

POWERED BY

新人初到請多指教