<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/saonek</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; saonek]]></copyright><item><title><![CDATA[yii 下获取url]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/11059005</link><guid>https://blog.youkuaiyun.com/saonek/article/details/11059005</guid><author>saonek</author><pubDate>Wed, 04 Sep 2013 14:53:10 +0800</pubDate><description><![CDATA[//当前域名
echo Yii::app()->request->hostInfo;

//除域名外的URL
echo Yii::app()->request->getUrl();

//除域名外的首页地址
echo Yii::app()->user->returnUrl;

//除域名外的根目录地址
echo Yii::app()->homeUrl;

echo Yii::app()->requ]]></description><category></category></item><item><title><![CDATA[yii 直接执行SQl语句]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/10346599</link><guid>https://blog.youkuaiyun.com/saonek/article/details/10346599</guid><author>saonek</author><pubDate>Mon, 26 Aug 2013 15:42:46 +0800</pubDate><description><![CDATA[$db = Yii::app()->db; //you have to define db connection in config/main.php
$sql = "select sum(if(starttime>'09:00:00',1,0)) as late,

  sum(if(endtime<'18:00:00',1,0)) as early         

from present]]></description><category></category></item><item><title><![CDATA[mysql存储过程-操作符]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/9835545</link><guid>https://blog.youkuaiyun.com/saonek/article/details/9835545</guid><author>saonek</author><pubDate>Thu, 08 Aug 2013 14:05:47 +0800</pubDate><description><![CDATA[mysql存储过程学习总结－操作符


算术运算符

+     加   SET var1=2+2;       4
-     减   SET var2=3-2;       1
*     乘   SET var3=3*2;       6
/     除   SET var4=10/3;      3.3333
DIV   整除 SET var5=10 DIV 3;  3]]></description><category></category></item><item><title><![CDATA[mysql 储存过程的流程控制]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/9835155</link><guid>https://blog.youkuaiyun.com/saonek/article/details/9835155</guid><author>saonek</author><pubDate>Thu, 08 Aug 2013 13:39:17 +0800</pubDate><description><![CDATA[/*
该代码是创建了一个名叫"p4"的存储过程并设置了s1,s2,s3两个int型一个varchar型参数，还可以是其他数据类型，内部创建了x1,x2两个变量

DELIMITER是修改分隔符的
DELIMITER $$的意思是把默认分隔符";"换成"$$"，这样分段写的存储过程就能整个被执行，而不是被当成多条sql语句单独执行
创建完过程再将分隔符改回成";"

两种创建变量并赋值的方式
SET]]></description><category></category></item><item><title><![CDATA[mysql 主从配置原理]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/9792667</link><guid>https://blog.youkuaiyun.com/saonek/article/details/9792667</guid><author>saonek</author><pubDate>Tue, 06 Aug 2013 15:44:42 +0800</pubDate><description><![CDATA[mysql主从复制
（超简单）

怎么安装mysql数据库，这里不说了，只说它的主从复制，步骤如下：

1、主从服务器分别作以下操作：
  1.1、版本一致
  1.2、初始化表，并在后台启动mysql
  1.3、修改root的密码

2、修改主服务器master:
   #vi /etc/my.cnf
       [mysqld]
       log-bin=my]]></description><category></category></item><item><title><![CDATA[mysql 的启动与关闭]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/9791177</link><guid>https://blog.youkuaiyun.com/saonek/article/details/9791177</guid><author>saonek</author><pubDate>Tue, 06 Aug 2013 14:25:31 +0800</pubDate><description><![CDATA[/usr/local/mysql/bin/mysqld_safe --user=mysql &


/usr/local/mysql/support-files/mysql.server stop]]></description><category></category></item><item><title><![CDATA[mysql 导入数据]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/9790363</link><guid>https://blog.youkuaiyun.com/saonek/article/details/9790363</guid><author>saonek</author><pubDate>Tue, 06 Aug 2013 13:08:49 +0800</pubDate><description><![CDATA[啥也不说了  source  百度一搜一大把]]></description><category></category></item><item><title><![CDATA[mysql pod 插入 乱码的解决方案]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/9721141</link><guid>https://blog.youkuaiyun.com/saonek/article/details/9721141</guid><author>saonek</author><pubDate>Fri, 02 Aug 2013 19:36:36 +0800</pubDate><description><![CDATA[首先检查 文件 数据库 以及
$dbh->exec("SET NAMES 'GBK'"); 设置情况
如果还不行的话 那就试试这个偏方


    $st = "INSERT INTO `test` (`id`, `tname`, `tid`) VALUES (NULL, '呵呵322211', '54');";
$sql = unicode_encode($st,"GBK");
$]]></description><category></category></item><item><title><![CDATA[js 标签自定义属性attributes]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/9226739</link><guid>https://blog.youkuaiyun.com/saonek/article/details/9226739</guid><author>saonek</author><pubDate>Tue, 02 Jul 2013 17:24:43 +0800</pubDate><description><![CDATA[$("#is_confirm").click(function(){
			var listcal = [];
			var listval = []
			var chboxs = document.getElementsByName("userid");
			var ss = 0;
			for(i=0;i<chboxs.length;i++){
				if(chboxs[i].check]]></description><category></category></item><item><title><![CDATA[解决 ci yii 下nginx 404  错误]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/8553833</link><guid>https://blog.youkuaiyun.com/saonek/article/details/8553833</guid><author>saonek</author><pubDate>Tue, 29 Jan 2013 19:36:13 +0800</pubDate><description><![CDATA[location ~ \.php { # 这里减掉一个“$”原本是\.php$
    fastcgi_pass 127.0.0.1:9000;
    fastcgi_index index.php; # 这一句不知道什么用处
    fastcgi_split_path_info ^(.+\.php)(.*)$; # 加了这一句
    fastcgi_param PATH_INFO]]></description><category></category></item><item><title><![CDATA[linux 下安装软件学习到的]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/8484987</link><guid>https://blog.youkuaiyun.com/saonek/article/details/8484987</guid><author>saonek</author><pubDate>Wed, 09 Jan 2013 11:48:53 +0800</pubDate><description><![CDATA[configure是用来进行用户个性配置的工具，   一般- -开头的说明的是需要配置的选项，比如你给的这个 - - prefix就是说软件额安装目录设置在哪里，后面的=/usr就是你给出的安装目录，当然你完全可以换一个目录。]]></description><category></category></item><item><title><![CDATA[php正则  模式修正符 需要研究]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/8453168</link><guid>https://blog.youkuaiyun.com/saonek/article/details/8453168</guid><author>saonek</author><pubDate>Sun, 30 Dec 2012 17:32:06 +0800</pubDate><description><![CDATA[ismUe]]></description><category></category></item><item><title><![CDATA[一句话搞定PHP 内存溢出]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/8439121</link><guid>https://blog.youkuaiyun.com/saonek/article/details/8439121</guid><author>saonek</author><pubDate>Wed, 26 Dec 2012 14:58:36 +0800</pubDate><description><![CDATA[ini_set("memory_limit","-1");]]></description><category></category></item><item><title><![CDATA[一句话搞定 php操作内存溢出]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/8288848</link><guid>https://blog.youkuaiyun.com/saonek/article/details/8288848</guid><author>saonek</author><pubDate>Thu, 13 Dec 2012 02:27:39 +0800</pubDate><description><![CDATA[ini_set("memory_limit","-1");]]></description><category></category></item><item><title><![CDATA[js 简单拖动窗口]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/7676390</link><guid>https://blog.youkuaiyun.com/saonek/article/details/7676390</guid><author>saonek</author><pubDate>Tue, 19 Jun 2012 14:01:26 +0800</pubDate><description><![CDATA[asdfdsf  var posX;  
var posY;  
var popDiv;  
var dragable;  
  
function down(e){  
    popDiv = document.getElementById("pop-editor");  
    e = e || window.event; //如果是IE   
    posX = e.clientX -]]></description><category></category></item><item><title><![CDATA[vim 编辑器简单的操作]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/7225200</link><guid>https://blog.youkuaiyun.com/saonek/article/details/7225200</guid><author>saonek</author><pubDate>Wed, 01 Feb 2012 12:55:32 +0800</pubDate><description><![CDATA[命令



简单说明





:w


保存编辑后的文件内容，但不退出vim编辑器。这个命令的作用是把内存缓冲区中的数据写到启动vim时指定的文件中。





:w!


强制写文件，即强制覆盖原有文件。如果原有文件的访问权限不允许写入文件，例如，原有的文件为只读文件，则可使用这个命令强制写入。但是，这种命令用法仅当用户是文件的属主时才适用，而超级用]]></description><category></category></item><item><title><![CDATA[判断远程文件是否存在。、]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/7193467</link><guid>https://blog.youkuaiyun.com/saonek/article/details/7193467</guid><author>saonek</author><pubDate>Wed, 11 Jan 2012 13:42:48 +0800</pubDate><description><![CDATA[function check_remote_file_exists($url)
{
    $curl = curl_init($url);
    // 不取回数据
    curl_setopt($curl, CURLOPT_NOBODY, true);
    curl_setopt($curl, CURLOPT_CUSTOMREQUEST, 'GET'); //不加这个会返回403，加了才]]></description><category></category></item><item><title><![CDATA[vsftpd中锁定用户目录]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/7186602</link><guid>https://blog.youkuaiyun.com/saonek/article/details/7186602</guid><author>saonek</author><pubDate>Mon, 09 Jan 2012 10:33:40 +0800</pubDate><description><![CDATA[vsftpd锁定虚拟用户目录
配置/etc/vsftpd/vsftpd.conf
[root@hostname]#vi /etc/vsftpd/vsftpd.conf
-------------------------------------------------------------------
chroot_list_enable=YES
# (锁定目录)
#chroot_li]]></description><category></category></item><item><title><![CDATA[关闭防火墙]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/7178081</link><guid>https://blog.youkuaiyun.com/saonek/article/details/7178081</guid><author>saonek</author><pubDate>Thu, 05 Jan 2012 14:05:33 +0800</pubDate><description><![CDATA[前阵子在虚拟机上装好了centos5.6，并配好了nginx+php+mysql，但是本机就是无法访问。一直就没去折腾了。 

具体情况如下 ：
1.本机能ping通虚拟机 
2.虚拟机也能ping通本机 
3.虚拟机能访问自己的web 
4.本机无法访问虚拟己的web 

后来发现是防火墙将80端口屏蔽了的缘故。 

检查是不是服务器的80端口被防火墙堵了，可以通过命令：]]></description><category></category></item><item><title><![CDATA[CentOS 5.6 Final下FTP安装及配置]]></title><link>https://blog.youkuaiyun.com/saonek/article/details/7177827</link><guid>https://blog.youkuaiyun.com/saonek/article/details/7177827</guid><author>saonek</author><pubDate>Thu, 05 Jan 2012 13:09:09 +0800</pubDate><description><![CDATA[y Scripts:
[root@localhost ~]# useradd -u 100 -g ftp -d /tmp/upload/ -c "Upload user" -m -s /sbin/nologin vendor
[root@localhost ~]# service vsftpd restart
[root@localhost vsftpd]# setsebool -P ftp]]></description><category></category></item></channel></rss>