PHP初学之防水计数器
这是我写的第一个计数器
<?
$s_ht="127.0.0.1";
$s_user="root";
$s_pas="123456";
$s_data="ceshi";
if (empty($_SERVER['HTTP_X_FORWARDED_FOR']))
{
$myip = $_SERVER['REMOTE_ADDR'];
$myip = $_SERVER['REMOTE_ADDR'];
}
else {
$myip = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR']);
$myip = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR']);
$myip = $myip[0]; $myip = $myip[0];
}
//------链接数据库----------
$conn=mysql_connect($s_ht,$s_user,$s_pas);
//-----------防止多次刷新判断，下面先进行查询-----------------
$sql="select * from `ceshi`.`jishuqi` where ip = '$myip'";
$result=mysql_db_query($s_data,$sql,$conn);
$row=mysql_fetch_row($result);
mysql_free_result($result);
if(!$row)
{
$sql="insert into `ceshi`.`jishuqi` ( `jishu`, `ip`, `time_at` ) values ( '1', '$myip', now() )";
mysql_select_db($s_data,$conn);
$result=mysql_query($sql);
mysql_close($conn);
}
else
{
$sql="select time_to_sec(now()) - time_to_sec(time_at) from jishuqi where ip='$myip' order by time_to_sec(now()) - time_to_sec(time_at) asc";
$result=mysql_db_query($s_data,$sql,$conn);
$row=mysql_fetch_row($result);
mysql_free_result($result);
if($row[0] > 10)
{
$sql="insert into `ceshi`.`jishuqi` ( `jishu`, `ip`, `time_at` ) values ( '1', '$myip', now() )";
mysql_select_db($s_data,$conn);
$result=mysql_query($sql);
}
}
$sql="select count(*) from `ceshi`.`jishuqi`";
$result=mysql_db_query($s_data,$sql,$conn);
$row=mysql_fetch_row($result);
mysql_free_result($result);
$ss="select * from `ceshi`.`jishuqi` order by 3 desc";
$cha=mysql_db_query($s_data,$ss,$conn);
$guo=mysql_fetch_row($cha);
?>
<!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=gb2312" />
<title>计数器</title>
相关文档：
在PHP里得到前天和昨天的日期的代码前天去面试的时候也是这样,不过我当时记不起来了.就记得MYSQL里面的date_sub(now(),'interval 1 day');date('Y/m/d h:i:s',mktime(date('h'), date('i'), date('s'), date('m') , date('d')+1, date('Y'))); -------------------------------------------------------------------------- ......
一、安装
1. 首先安装SSH
sudo apt-get install ssh
2.安装MySQL(虽然现在最新版为5.1，但是还只能装5.0版本)
sudo apt-get install mysql-server-5.0
3.安装Apache
sudo apt-get install apache2
4.安装PHP
sudo apt-get install php5 libapache2-mod-php5
5.重启Apache
sudo /etc/init.d/apache2 restart ......
返回一个结果全世界都知道怎么处理，关键是返回多个结果集就不好办了，下面有一解决办法
存储过程代码
DELIMITER $$;
DROP PROCEDURE IF EXISTS `test`.`sp_test`$$
CREATE PROCEDURE `test`.`sp_test` ()
BEGIN
select * from `user`.`user` limit 0, 50;
select coun ......
