<?
//require ('common.inc');
$arr_request=array();
if (count($HTTP_GET_VARS))
{
while (list($key,$value)=each($HTTP_GET_VARS))
{
$arr_request[strtolower($key)]=$value;
}
}
if (count($HTTP_POST_VARS))
{
WHILE (list($key,$value)=each($HTTP_POST_VARS))
{
$arr_request[strtolower($key)]=$value;
}
}
$link=@mysql_connect("localhost","kong","kong");
mysql_select_db("mywebdb");
$ip=$REMOTE_ADDR;
$current=getdate(time());
$day=$current["mday"];
$query="select * from addcount where day=\"$day\"";
$result=@mysql_query($query);
if(!$num=@mysql_num_rows($result))
$num=1;
while($row=@mysql_fetch_row($result))
{
if (strcmp($ip,$row[1])==0)
{
$i=1;
$id=$row[0];
$click=$row[3]+1;
$up="update addcount set click_count=click_count+1 where id=$id";
$result2=@mysql_query($up);
// break;
}
$total+=$row[3];
}
$total++;
if(!$i){
$query1="insert into addcount (ip,day,click_count )values ('$ip','$day',1)";
mysql_db_query("mywebdb",$query1,$link);
$click=1;
}
echo "<html><head><title>计数器</title></head>";
echo "你是第" .$num."访问者<BR>";
echo "今天你第".$click."次点击<BR>";
echo "今天总点击".$total."次<BR>";
/*
表：
addcount
CREATE TABLE addcount (
id int(6) DEFAULT '0' NOT NULL auto_increment,
ip char(20) NOT NULL,
day int(2) NOT NULL,
click_count int(3) NOT NULL,
PRIMARY KEY (id)
);
*/
?>
当前位置: 编程技术>php
本页文章导读:
▪改进的IP计数器
<? //require ('common.inc'); $arr_request=array(); if (count($HTTP_GET_VARS)) { while (list($key,$value)=each($HTTP_GET_VARS)) { $arr_request[strtolower($key)]=$value; } }.........
▪聊天室php&mysql(五)
第五个页面name="changenick.php" <? include "../signup/mysql.php"; //echo $userid; if($action=="ok") { $sql="select * from chat_user_list where userid='$nick'"; $result=mysql_query($sql) or die(mysql_error()); if(!$result) echo "该呢.........
▪聊天室php&mysql(四)
第四个页面 name="index.php" <? include "../signup/mysql.php"; header("Expires: Sun, 28 Dec 1997 09:32:45 GMT"); header("Cache-Control: no-cache, must-revalidate"); header("Pragma: no-cache"); header("Content-Type: text/html; charset=${Charse.........
[1]改进的IP计数器
来源: 互联网 发布时间: 2013-11-30
[2]聊天室php&mysql(五)
来源: 互联网 发布时间: 2013-11-30
第五个页面name="changenick.php"
<?
include "../signup/mysql.php";
//echo $userid;
if($action=="ok")
{
$sql="select * from chat_user_list where userid='$nick'";
$result=mysql_query($sql) or die(mysql_error());
if(!$result) echo "该呢称已被他人占用 请重新填写";
else
{
$sql="update chat_user_list set id='$nick',passwd='$passwd',sex='$sex' where userid='$userid'";
$result=mysql_query($sql)or die(mysql_error());
$sql="update chat_user set id='$nick',passwd='$passwd',sex='$sex' where userid='$userid'";
$result=mysql_query($sql)or die(mysql_error());
}
if($result){
echo "<script language='JavaScript'> window.close() </script>";
}
}
?>
<html>
<head>
<title>:::FEIT聊天室:::</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
</head>
<body bgcolor="#ffffff" text="#000000">
<div id="Layer1" ></div>
<div id="Layer2" >
<form name="form1" method="post" action="/blog_article/</echo $PHP_SELF/gt;action/ok.html">
<p>
<input type="text" name="nick" size="12" maxlength="20">
</p>
<p>
<input type="text" name="passwd" size="12" maxlength="20">
<input type="hidden" name="userid" value="<?echo $userid ;?>">
</p>
<p>
<select name="sex">
<option value="帅哥">帅哥</option>
<option value="妹妹">美眉</option>
</select>
</p>
<p>
<input type="submit" name="ok" value="更改" align="center">
</p>
</form>
</div>
<div id="Layer3" >用户呢称</div>
<div id="Layer4" >用户密码</div>
<div id="Layer5" >性别</div>
</body>
</html>
<?
include "../signup/mysql.php";
//echo $userid;
if($action=="ok")
{
$sql="select * from chat_user_list where userid='$nick'";
$result=mysql_query($sql) or die(mysql_error());
if(!$result) echo "该呢称已被他人占用 请重新填写";
else
{
$sql="update chat_user_list set id='$nick',passwd='$passwd',sex='$sex' where userid='$userid'";
$result=mysql_query($sql)or die(mysql_error());
$sql="update chat_user set id='$nick',passwd='$passwd',sex='$sex' where userid='$userid'";
$result=mysql_query($sql)or die(mysql_error());
}
if($result){
echo "<script language='JavaScript'> window.close() </script>";
}
}
?>
<html>
<head>
<title>:::FEIT聊天室:::</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// -->
</script>
</head>
<body bgcolor="#ffffff" text="#000000">
<div id="Layer1" ></div>
<div id="Layer2" >
<form name="form1" method="post" action="/blog_article/</echo $PHP_SELF/gt;action/ok.html">
<p>
<input type="text" name="nick" size="12" maxlength="20">
</p>
<p>
<input type="text" name="passwd" size="12" maxlength="20">
<input type="hidden" name="userid" value="<?echo $userid ;?>">
</p>
<p>
<select name="sex">
<option value="帅哥">帅哥</option>
<option value="妹妹">美眉</option>
</select>
</p>
<p>
<input type="submit" name="ok" value="更改" align="center">
</p>
</form>
</div>
<div id="Layer3" >用户呢称</div>
<div id="Layer4" >用户密码</div>
<div id="Layer5" >性别</div>
</body>
</html>
[3]聊天室php&mysql(四)
来源: 互联网 发布时间: 2013-11-30
第四个页面 name="index.php"
<?
include "../signup/mysql.php";
header("Expires: Sun, 28 Dec 1997 09:32:45 GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
header("Content-Type: text/html; charset=${Charset}");
?>
<html>
<head>
<title>charmain</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Refresh" content="4; url=<? echo $PHP_SELF; ?>?userid=<?echo $userid?>">
</head>
<body bgcolor="#99CCFF" text="#000000">
<?
$max_row_length=30;
$select="select row from user_message order by row DESC";
$result=mysql_query($select)or die(" false fgfg");
$rowlist=mysql_fetch_array($result)or die("false");
$max_row=$rowlist["row"];
if($max_row>$max_row_length){
$delete_row=$max_row-$max_row_length+1;
// echo $max_row."<br>".$delete_row;
$select="select row from user_message where row<".$delete_row;
$result=mysql_query($select)or die(" false");
while($row=mysql_fetch_array($result))
{
$sql="delete from user_message where row <".$delete_row;
mysql_query($sql)or die ("del false1");
}
$left=$delete_row;
}
else {$left=1;
}
for($i=$max_row; $i>=$left ;$i--)
{
$sql="SELECT message,userid,object,status,color,action1,time1 FROM user_message where row='$i'";
$result=mysql_query($sql)or die(mysql_error());
$row=mysql_fetch_array($result);
$time1=$row["time1"];
$usert1=$row["userid"];
$objectt1=$row["object"];
$sql="select id from chat_user_list where userid='$usert1'";
$result=mysql_query($sql)or die(mysql_error());
$rowt1=mysql_fetch_array($result);
$usert5=$rowt1["id"];
$sql="select id from chat_user_list where userid='$objectt1'";
$result=mysql_query($sql)or die(mysql_error());
if($rowt2=mysql_fetch_array($result))
$bojectt5=$rowt2["id"];
else $bojectt5="大家";
if($row["userid"]!=$userid){
$user1="<a href='".$PHP_SELF."?userid=$userid' onClick=parent.bottom.user('".$usert5."')>".$usert5."</a>";
}
else $user1=$usert5;
if($row["object"]!=$userid){
$user2="<a href='".$PHP_SELF."?userid=$userid' onClick=parent.bottom.user('".$bojectt5."')>".$bojectt5."</a>"; }
else $user2=$bojectt5;
$message2=$row["message"];
$message3=htmlspecialchars($message2);
$message1="<font size=3 color=".$row["color"]."><i>".$user1."</i> 对".$user2." <i>".$row["action1"].": </i>".$message3."</font>" ;
if($row["status"]==1){
if($row["object"]==$userid||$row["userid"]==$userid)
echo "<font size=2 color=ff0000 >私聊</font>".$time1." ".$message1."<br>";
else continue;
}
else {
echo $time1." ".$message1."<br>";
}
}
?>
</body>
</html>
<?
include "../signup/mysql.php";
header("Expires: Sun, 28 Dec 1997 09:32:45 GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
header("Content-Type: text/html; charset=${Charset}");
?>
<html>
<head>
<title>charmain</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta http-equiv="Refresh" content="4; url=<? echo $PHP_SELF; ?>?userid=<?echo $userid?>">
</head>
<body bgcolor="#99CCFF" text="#000000">
<?
$max_row_length=30;
$select="select row from user_message order by row DESC";
$result=mysql_query($select)or die(" false fgfg");
$rowlist=mysql_fetch_array($result)or die("false");
$max_row=$rowlist["row"];
if($max_row>$max_row_length){
$delete_row=$max_row-$max_row_length+1;
// echo $max_row."<br>".$delete_row;
$select="select row from user_message where row<".$delete_row;
$result=mysql_query($select)or die(" false");
while($row=mysql_fetch_array($result))
{
$sql="delete from user_message where row <".$delete_row;
mysql_query($sql)or die ("del false1");
}
$left=$delete_row;
}
else {$left=1;
}
for($i=$max_row; $i>=$left ;$i--)
{
$sql="SELECT message,userid,object,status,color,action1,time1 FROM user_message where row='$i'";
$result=mysql_query($sql)or die(mysql_error());
$row=mysql_fetch_array($result);
$time1=$row["time1"];
$usert1=$row["userid"];
$objectt1=$row["object"];
$sql="select id from chat_user_list where userid='$usert1'";
$result=mysql_query($sql)or die(mysql_error());
$rowt1=mysql_fetch_array($result);
$usert5=$rowt1["id"];
$sql="select id from chat_user_list where userid='$objectt1'";
$result=mysql_query($sql)or die(mysql_error());
if($rowt2=mysql_fetch_array($result))
$bojectt5=$rowt2["id"];
else $bojectt5="大家";
if($row["userid"]!=$userid){
$user1="<a href='".$PHP_SELF."?userid=$userid' onClick=parent.bottom.user('".$usert5."')>".$usert5."</a>";
}
else $user1=$usert5;
if($row["object"]!=$userid){
$user2="<a href='".$PHP_SELF."?userid=$userid' onClick=parent.bottom.user('".$bojectt5."')>".$bojectt5."</a>"; }
else $user2=$bojectt5;
$message2=$row["message"];
$message3=htmlspecialchars($message2);
$message1="<font size=3 color=".$row["color"]."><i>".$user1."</i> 对".$user2." <i>".$row["action1"].": </i>".$message3."</font>" ;
if($row["status"]==1){
if($row["object"]==$userid||$row["userid"]==$userid)
echo "<font size=2 color=ff0000 >私聊</font>".$time1." ".$message1."<br>";
else continue;
}
else {
echo $time1." ".$message1."<br>";
}
}
?>
</body>
</html>
最新技术文章: