<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>hemono</title>
	<atom:link href="http://www.hemono.com/?feed=rss2" rel="self" type="application/rss+xml" />
	<link>http://www.hemono.com</link>
	<description>常记溪亭日暮，沉醉不知归路……</description>
	<lastBuildDate>Wed, 18 Apr 2012 14:07:23 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=3.1</generator>
		<item>
		<title>dump一个表的正确方法</title>
		<link>http://www.hemono.com/?p=636</link>
		<comments>http://www.hemono.com/?p=636#comments</comments>
		<pubDate>Wed, 18 Apr 2012 13:53:13 +0000</pubDate>
		<dc:creator>hemon</dc:creator>
				<category><![CDATA[未分类]]></category>

		<guid isPermaLink="false">http://www.hemono.com/?p=636</guid>
		<description><![CDATA[set_time_limit(0); header("Content-type: application/x-msexcel"); header('Content-Disposition: attachment; filename="'.$_SERVER['REQUEST_TIME'].'.xls"'); mysql_connect('localhost','root',''); mysql_select_db('test'); $fp = fopen('php://output', 'w'); // mysql_query会获取结果集缓存到PHP运行空间，以支持mysql_num_rows,mysql_data_seek，所以大结果集查询时，占有内存巨大 //$res = mysql_query('SELECT * FROM bigTable'); $res = mysql_unbuffered_query('SELECT * FROM bigTable'); while ($row = mysql_fetch_array($res, MYSQL_NUM)) { //echo implode("\t", $row), "\n"; fputcsv($fp, $row); } mysql_free_result($res); fclose($fp);]]></description>
		<wfw:commentRss>http://www.hemono.com/?feed=rss2&#038;p=636</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>安装ngx_lua</title>
		<link>http://www.hemono.com/?p=625</link>
		<comments>http://www.hemono.com/?p=625#comments</comments>
		<pubDate>Thu, 08 Mar 2012 16:33:17 +0000</pubDate>
		<dc:creator>hemon</dc:creator>
				<category><![CDATA[未分类]]></category>

		<guid isPermaLink="false">http://www.hemono.com/?p=625</guid>
		<description><![CDATA[推荐使用openresty，自带所有扩展依赖包：http://openresty.org/ wget http://agentzh.org/misc/nginx/ngx_openresty-1.0.11.21.tar.gz tar xzvf ngx_openresty-1.0.11.21.tar.gz cd ngx_openresty-VERSION/ ./configure --with-luajit make make install 搞定！喜欢从头开始继续看！ ————————————————————————————————————— 1、安装Luajit http://luajit.org/download.html wget http://luajit.org/download/LuaJIT-2.0.0-beta9.tar.gz tar xvf LuaJIT-2.0.0-beta9.tar.gz make make PREFIX=/home/myself/lj2 # 指定安装目录 sudo make install ==== Installing LuaJIT 2.0.0-beta9 to /usr/local ==== mkdir -p /usr/local/bin /usr/local/lib /usr/local/include/luajit-2.0 /usr/local/share/man/man1 /usr/local/lib/pkgconfig /usr/local/share/luajit-2.0.0-beta9/jit /usr/local/share/lua/5.1 /usr/local/lib/lua/5.1 …… ==== Successfully installed LuaJIT 2.0.0-beta9 to /usr/local [...]]]></description>
		<wfw:commentRss>http://www.hemono.com/?feed=rss2&#038;p=625</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>#vmware#使用HOST-ONLY替换NAT模式</title>
		<link>http://www.hemono.com/?p=620</link>
		<comments>http://www.hemono.com/?p=620#comments</comments>
		<pubDate>Mon, 20 Feb 2012 13:40:00 +0000</pubDate>
		<dc:creator>hemon</dc:creator>
				<category><![CDATA[未分类]]></category>

		<guid isPermaLink="false">http://www.hemono.com/?p=620</guid>
		<description><![CDATA[装在ubuntu11.04上的vmware，使用nat模式网络，结果vmware虚拟的网关服务器192.168.172.2经常莫名其妙挂死，换成桥连模式，虽然显示已连接，一样上不了网，我哭死啊，最后，只有切换到HOST-ONLY模式，然后用shorewall把Ubuntu母机建成网关服务器。 #/etc/sysctl.conf net.ipv4.ip_forward=1 #/etc/default/shorewall startup=1 #/etc/shorewall/interfaces #ZONE INTERFACE BROADCAST OPTIONS net eth0 detect dhcp,tcpflags,nosmurfs,routefilter,logmartians loc vmnet1 detect tcpflags,nosmurfs,routefilter,logmartians #/etc/shorewall/policy #SOURCE DEST POLICY LOG LEVEL LIMIT:BURST $FW all ACCEPT loc $FW ACCEPT loc net ACCEPT net loc REJECT info # THE FOLLOWING POLICY MUST BE LAST all all REJECT info #/etc/shorewall/routestopped #INTERFACE HOST(S) OPTIONS vmnet1 -]]></description>
		<wfw:commentRss>http://www.hemono.com/?feed=rss2&#038;p=620</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>openresty:把nginx变成应用服务器</title>
		<link>http://www.hemono.com/?p=601</link>
		<comments>http://www.hemono.com/?p=601#comments</comments>
		<pubDate>Fri, 23 Dec 2011 13:54:57 +0000</pubDate>
		<dc:creator>hemon</dc:creator>
				<category><![CDATA[未分类]]></category>

		<guid isPermaLink="false">http://www.hemono.com/?p=601</guid>
		<description><![CDATA[http://openresty.org 安装基础库 apt-get install libreadline-dev libpcre3-dev libssl-dev perl 安装libdrizzle wget http://agentzh.org/misc/nginx/drizzle7-2011.07.21.tar.gz tar xzvf drizzle7-2011.07.21.tar.gz cd drizzle7-2011.07.21/ ./configure &#8211;without-server make libdrizzle-1.0 make install-libdrizzle-1.0 安装openresty wget http://agentzh.org/misc/nginx/ngx_openresty-1.0.10.24.tar.gz tar xzvf ngx_openresty-1.0.10.24.tar.gz ./configure &#8211;with-luajit &#8211;with-http_drizzle_module make -j2 # 2是CPU双核，单核就直接 make make install 安装目录：/usr/local/openresty，写程序就是改nginx配置 /usr/local/openresty/nginx/conf/nginx.conf 怎么用nginx.conf写程序呢？ http://agentzh.org/misc/slides/nginx-conf-scripting/ http://agentzh.org/misc/slides/recent-dev-nginx-conf/ http://agentzh.org/misc/slides/nginx-state-of-the-art/ http://agentzh.org/misc/slides/perl-lz-apps/]]></description>
		<wfw:commentRss>http://www.hemono.com/?feed=rss2&#038;p=601</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>timeout</title>
		<link>http://www.hemono.com/?p=599</link>
		<comments>http://www.hemono.com/?p=599#comments</comments>
		<pubDate>Sat, 29 Oct 2011 17:47:09 +0000</pubDate>
		<dc:creator>hemon</dc:creator>
				<category><![CDATA[未分类]]></category>

		<guid isPermaLink="false">http://www.hemono.com/?p=599</guid>
		<description><![CDATA[Nginx client_header_timeout = 60 client_body_timeout = 60 send_timeout = 60 fastcgi_connect_timeout = 60 fastcgi_read_timeout = 60 fastcgi_send_timeout = 60 proxy_connect_timeout = 60 proxy_read_timeout = 60 proxy_send_timeout = 60 PHP-FPM request_terminate_timeout = 0 request_slowlog_timeout = 0 PHP max_input_time = 60 max_execution_time = 30]]></description>
		<wfw:commentRss>http://www.hemono.com/?feed=rss2&#038;p=599</wfw:commentRss>
		<slash:comments>1</slash:comments>
		</item>
		<item>
		<title>使用SQL-SERVER查询Excel的数据</title>
		<link>http://www.hemono.com/?p=590</link>
		<comments>http://www.hemono.com/?p=590#comments</comments>
		<pubDate>Fri, 28 Oct 2011 12:11:54 +0000</pubDate>
		<dc:creator>hemon</dc:creator>
				<category><![CDATA[未分类]]></category>

		<guid isPermaLink="false">http://www.hemono.com/?p=590</guid>
		<description><![CDATA[这里用到了OPENROWSET，生成一个数据源： OPENROWSET(&#8216;Microsoft.Jet.OLEDB.4.0&#8242;, &#8216;Excel 8.0;HDR=Yes;IMEX=1;Database=C:\book1.xls&#8217;, [sheet1$]) 文件名：C:\book1.xls 工作表名：sheet1 [sheet1$] $是结束符，工作表名是sheet1 文件名、工作表名可以含有汉字，空格……总之就是SQL-SERVER很NB。 例如： SELECT * FROM OPENROWSET(&#8216;Microsoft.Jet.OLEDB.4.0&#8242;, &#8216;Excel 8.0;HDR=Yes;IMEX=1;Database=C:\book1.xls&#8217;, [sheet1$]) 实现Excel干不了的：JOIN联表查询！ SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=Yes;IMEX=1;Database=C:\book1.xls', [sheet1$]) AS a LEFT OUTER JOIN OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;HDR=Yes;IMEX=1;Database=C:\book1.xls', [sheet2$]) AS b ON a.ID = b.ID]]></description>
		<wfw:commentRss>http://www.hemono.com/?feed=rss2&#038;p=590</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>MySQL运行时启用general_log</title>
		<link>http://www.hemono.com/?p=583</link>
		<comments>http://www.hemono.com/?p=583#comments</comments>
		<pubDate>Fri, 28 Oct 2011 03:02:48 +0000</pubDate>
		<dc:creator>hemon</dc:creator>
				<category><![CDATA[未分类]]></category>

		<guid isPermaLink="false">http://www.hemono.com/?p=583</guid>
		<description><![CDATA[可以运行时 启动/终止 MySQL查询log // 1.1记录到mysql数据库mysql.general_log中，engine=CSV，文件在/var/lib/mysql/mysq/general_log.CSV SET GLOBAL log_output=&#8217;TABLE&#8217;; // 1.2.记录到文本文件 SET GLOBAL log_output=&#8217;FILE&#8217;; SET GLOBAL general_log_file=’/tmp/general.log’; // 指定输出日志文件 // 2. 启动 SET GLOBAL general_log=ON; // 3. 关闭 SET GLOBAL general_log=OFF; // 4.1 读取mysql.general_log SELECT * FROM mysql.general_log;. tail -f /var/lib/mysql/mysq/general_log.CSV; // 4.2 读取文本日志 tail -f /tmp/general.log;]]></description>
		<wfw:commentRss>http://www.hemono.com/?feed=rss2&#038;p=583</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>PDO-MYSQL支持多语句执行</title>
		<link>http://www.hemono.com/?p=578</link>
		<comments>http://www.hemono.com/?p=578#comments</comments>
		<pubDate>Fri, 28 Oct 2011 02:37:31 +0000</pubDate>
		<dc:creator>hemon</dc:creator>
				<category><![CDATA[未分类]]></category>

		<guid isPermaLink="false">http://www.hemono.com/?p=578</guid>
		<description><![CDATA[使用mysql_query/mysqli_query都不支持分号分隔的多语句执行，会报1064错误，神奇的PDO-MySQL->exec()通过了！ 对于MySQL注入来说，无疑是大开了方便之门 对于MySQL开发来说，可以批量执行SQL，不用自己foreach一条一条搞了。 示例执行SQL： select * from test;DELETE FROM test WHERE qq = &#8217;1&#8242; $link = mysql_connect('localhost','root','zzzizzz1'); mysql_select_db('xm_shop'); $result = mysql_query("select * from test;DELETE FROM test WHERE qq = '1'"); if(!$result){ echo mysql_errno($link) . ": " . mysql_error($link) . "\n"; } $mysqli = new mysqli("localhost", "root", "zzzizzz1", "xm_shop"); $result = $mysqli->query("select * from test;DELETE FROM [...]]]></description>
		<wfw:commentRss>http://www.hemono.com/?feed=rss2&#038;p=578</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Ubuntu装NV显卡</title>
		<link>http://www.hemono.com/?p=576</link>
		<comments>http://www.hemono.com/?p=576#comments</comments>
		<pubDate>Sat, 15 Oct 2011 14:03:40 +0000</pubDate>
		<dc:creator>hemon</dc:creator>
				<category><![CDATA[未分类]]></category>

		<guid isPermaLink="false">http://www.hemono.com/?p=576</guid>
		<description><![CDATA[sudo add-apt-repository ppa:ubuntu-x-swat/x-updates sudo apt-get update sudo apt-get install nvidia-current nvidia-settings]]></description>
		<wfw:commentRss>http://www.hemono.com/?feed=rss2&#038;p=576</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>分页函数</title>
		<link>http://www.hemono.com/?p=570</link>
		<comments>http://www.hemono.com/?p=570#comments</comments>
		<pubDate>Mon, 05 Sep 2011 09:54:14 +0000</pubDate>
		<dc:creator>hemon</dc:creator>
				<category><![CDATA[未分类]]></category>

		<guid isPermaLink="false">http://www.hemono.com/?p=570</guid>
		<description><![CDATA[以前开培训班，教学生写的一个分页函数 function page_html($page, $total, $size=10, $show=10, $url=null, $name='page'){ $page = intval($page); $page = ($page == 0) ? 1 : $page; $max = ceil($total/$size); $page = ($page > $max) ? $max : $page; $show = ($show < $max) ? $show : $max; $start = page_start($page, $max, $show); $end = $start + $show; $url = page_url($url, $name); [...]]]></description>
		<wfw:commentRss>http://www.hemono.com/?feed=rss2&#038;p=570</wfw:commentRss>
		<slash:comments>1</slash:comments>
		</item>
	</channel>
</rss>

