<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[追梦丨星辰]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/v02160219v</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; v02160219v]]></copyright><item><title><![CDATA[iis php web.config处理404，500等，跳转友好页面，显示500错误信息]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/42804513</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/42804513</guid><author>v02160219v</author><pubDate>Sat, 17 Jan 2015 12:36:02 +0800</pubDate><description><![CDATA[显示500错误信息

     	    
            
            
                
            
        


404，500友好提示跳转]]></description><category></category></item><item><title><![CDATA[YII开发技巧分享——模型（models）中rules自定义验证规则]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/42524539</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/42524539</guid><author>v02160219v</author><pubDate>Thu, 08 Jan 2015 14:28:46 +0800</pubDate><description><![CDATA[YII的models中的rules部分是一些表单的验证规则，对于表单验证十分有用，在相应的视图（views）里面添加了表单，在表单被提交之前程序都会自动先来这里面的规则里验证，只有通过对其有效的限制规则后才能被提交，可以很有效地保证表单安全和信息的有效性。还是给大家具体说明一下：
        以下是视图（views）部分的简单代码：
beginWidget('CActiveForm', a]]></description><category></category></item><item><title><![CDATA[yii扩展自带的时间选择器插件cjuidatepicker]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/42489975</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/42489975</guid><author>v02160219v</author><pubDate>Wed, 07 Jan 2015 11:41:41 +0800</pubDate><description><![CDATA[数据库时间字段用的是 int 类型，存储的是时间戳。并且我写文章的时候，时间是需要可以修改的。
来一张最终效果图：

首先我用了 Yii 自带的 Zii CJuiDatePicker 扩展，非常的强大的把 jQuery UI 的 Datepicker 继承进去了，使用非常的简单，手册上有。但是这个有个缺陷，没有小时分钟，只能配置日期。这个有点坑爹了。然后没办法，去找了一个 yii 的扩展。我]]></description><category></category></item><item><title><![CDATA[mysql 中取得汉字字段的各汉字首字母]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/38403651</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/38403651</guid><author>v02160219v</author><pubDate>Wed, 06 Aug 2014 16:53:02 +0800</pubDate><description><![CDATA[DROP FUNCTION IF EXISTS `getPY`;
DELIMITER ;;
CREATE FUNCTION `getPY`(in_string VARCHAR(65534)) RETURNS mediumtext CHARSET utf8
BEGIN
DECLARE tmp_str VARCHAR(65534) charset gbk DEFAULT '' ; #截取字符串，每次做]]></description><category></category></item><item><title><![CDATA[MySQL拼音首字母查询]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/38403597</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/38403597</guid><author>v02160219v</author><pubDate>Wed, 06 Aug 2014 16:51:22 +0800</pubDate><description><![CDATA[DROP FUNCTION IF EXISTS `GET_FIRST_PINYIN_CHAR`;
CREATE FUNCTION `GET_FIRST_PINYIN_CHAR`(PARAM VARCHAR(255)) RETURNS VARCHAR(2) CHARSET utf8
BEGIN
    DECLARE V_RETURN VARCHAR(255);
    DECLARE V_FIRS]]></description><category></category></item><item><title><![CDATA[用yii发送邮件]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/30091247</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/30091247</guid><author>v02160219v</author><pubDate>Wed, 11 Jun 2014 19:28:09 +0800</pubDate><description><![CDATA[1，首先，去官网把邮件类down下来，网址http://www.yiiframework.com/extension/mailer/#download
2，解压，把mailer文件夹放在extensions文件夹下，extensions可以自己建立，与config，modules等同级，
3，在控制器中应用，一句$mail = Yii::createComponent('application]]></description><category></category></item><item><title><![CDATA[mysql日期 获取本月第一天 获取下个月的第一天]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/30052675</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/30052675</guid><author>v02160219v</author><pubDate>Wed, 11 Jun 2014 14:19:34 +0800</pubDate><description><![CDATA[select curdate();                       --获取当前日期
select last_day(curdate());                    --获取当月最后一天。
select DATE_ADD(curdate(),interval -day(curdate())+1 day);   --获取本月第一天
select date_add(curda]]></description><category></category></item><item><title><![CDATA[mysql获得60天前unix时间]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/26476099</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/26476099</guid><author>v02160219v</author><pubDate>Wed, 21 May 2014 14:59:48 +0800</pubDate><description><![CDATA[mysql获得60天前unix时间]]></description><category></category></item><item><title><![CDATA[MySQL 获得当前日期时间(以及时间的转换)]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/24633739</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/24633739</guid><author>v02160219v</author><pubDate>Mon, 28 Apr 2014 12:39:22 +0800</pubDate><description><![CDATA[1.1 获得当前日期+时间（date + time）函数：now()
除了 now() 函数能获得当前的日期时间外，MySQL 中还有下面的函数：
current_timestamp()   current_timestamp
localtime()   localtime
localtimestamp()   localtimestamp     
这些日期时间函数，都等同于 now(]]></description><category></category></item><item><title><![CDATA[mysql存储过程查看，修改，删除，创建方法]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/24453717</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/24453717</guid><author>v02160219v</author><pubDate>Fri, 25 Apr 2014 09:38:19 +0800</pubDate><description><![CDATA[mysql教程存储过程查看，修改，删除，创建方法

文章主要简单的介绍关于mysql存储过程查看，修改，删除，创建的方法哦，下面举了四个实例来证明一下关于存储过程的操作。
询数据库教程中的存储过程：

方法一：（直接查询）

select `specific_name` from mysql.proc where db = 'your_db_name' and `type` = 'p]]></description><category></category></item><item><title><![CDATA[php guid]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/23827727</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/23827727</guid><author>v02160219v</author><pubDate>Wed, 16 Apr 2014 10:39:37 +0800</pubDate><description><![CDATA[function create_guid() {
	$charid = strtoupper(md5(uniqid(mt_rand(), true)));
	$hyphen = chr(45);// "-"
	$uuid = chr(123)// "{"
	.substr($charid, 0, 8).$hyphen
	.substr($charid, 8, 4).$hyphen
	.substr]]></description><category></category></item><item><title><![CDATA[根据汉字首字母排序 mysql]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/21695203</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/21695203</guid><author>v02160219v</author><pubDate>Fri, 21 Mar 2014 09:37:06 +0800</pubDate><description><![CDATA[select areaName from area order by convert(areaName USING gbk) COLLATE gbk_chinese_ci asc
说明：areaName为列名
area为表名


文章来自：http://blog.youkuaiyun.com/lpz283929516/article/details/8206851]]></description><category></category></item><item><title><![CDATA[yii上传图片、yii上传文件、yii控件activeFileField使用]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/20457933</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/20457933</guid><author>v02160219v</author><pubDate>Tue, 04 Mar 2014 13:54:09 +0800</pubDate><description><![CDATA[model



  public function rules()
  {
    // NOTE: you should only define rules for those attributes that
    // will receive user inputs.
    return array(
      array('hits', 'numerical', ]]></description><category></category></item><item><title><![CDATA[PHP JSON 数据解析代码]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/19398961</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/19398961</guid><author>v02160219v</author><pubDate>Tue, 18 Feb 2014 10:05:43 +0800</pubDate><description><![CDATA[$json_string='{"id":1,"name":"jb51","email":"admin@jb51.net","interest":["wordpress","php"]} ';
$obj=json_decode($json_string);
echo $obj->name; //prints foo
echo $obj->interest[1]; //prints php]]></description><category></category></item><item><title><![CDATA[MySql 里的IFNULL、NULLIF和ISNULL用法]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/19121331</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/19121331</guid><author>v02160219v</author><pubDate>Wed, 12 Feb 2014 15:54:08 +0800</pubDate><description><![CDATA[今天用到了MySql里的isnull才发现他和MSSQL里的还是有点区别，现在简单总结一下：
mysql中isnull,ifnull,nullif的用法如下：
isnull(expr) 的用法：
如expr 为null，那么isnull() 的返回值为 1，否则返回值为 0。
mysql> select isnull(1+1);
-> 0
mysql> select isnull(1/]]></description><category></category></item><item><title><![CDATA[yii 设置loginUrl]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/19109593</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/19109593</guid><author>v02160219v</author><pubDate>Wed, 12 Feb 2014 10:01:35 +0800</pubDate><description><![CDATA[编辑文件夹config下的main.phparray(
    ......
    'components'=>array(
        'user'=>array(
            // 这实际上是默认值
            'loginUrl'=>array('site/login'),
        ),
    ),
)]]></description><category></category></item><item><title><![CDATA[MySQL中UNION和UNION ALL的使用]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/19086099</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/19086099</guid><author>v02160219v</author><pubDate>Tue, 11 Feb 2014 19:53:53 +0800</pubDate><description><![CDATA[在数据库中，UNION和UNION ALL关键字都是将两个结果集合并为一个，但这两者从使用和效率上来说都有所不同。
MySQL中的UNION
UNION在进行表链接后会筛选掉重复的记录，所以在表链接后会对所产生的结果集进行排序运算，删除重复的记录再返回结果。实际大部分应用中是不会产生重复的记录，最常见的是过程表与历史表UNION。如：
select * from gc_dfys union ]]></description><category></category></item><item><title><![CDATA[phpMyAdmin设置存储过程及其问题]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/18711791</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/18711791</guid><author>v02160219v</author><pubDate>Thu, 23 Jan 2014 18:27:21 +0800</pubDate><description><![CDATA[这几天需要用到数据库，使用的是MySQL，数据库管理软件使用的是phpMyAdmin，要创建一个存储过程，就需要执行一个SQL语句，语句如下，结果报错了，报错如下：
“#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th]]></description><category></category></item><item><title><![CDATA[ASP.NET获取两个日期之间的天数]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/18224223</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/18224223</guid><author>v02160219v</author><pubDate>Mon, 13 Jan 2014 16:22:01 +0800</pubDate><description><![CDATA[ASP.NET获取两个日期之间的天数，Subtract]]></description><category></category></item><item><title><![CDATA[104款JavaScript jQuery高级页面组件开源软件]]></title><link>https://blog.youkuaiyun.com/v02160219v/article/details/18040079</link><guid>https://blog.youkuaiyun.com/v02160219v/article/details/18040079</guid><author>v02160219v</author><pubDate>Thu, 09 Jan 2014 14:19:32 +0800</pubDate><description><![CDATA[开源社区
http://www.oschina.net/project/tag/292/jquery-components?lang=28&os=0&sort=time&p=1]]></description><category></category></item></channel></rss>