<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[jonlys的专栏]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/jonlys</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; jonlys]]></copyright><item><title><![CDATA[mysql 随机取数据 高效]]></title><link>https://blog.csdn.net/jonlys/article/details/8588077</link><guid>https://blog.csdn.net/jonlys/article/details/8588077</guid><author>jonlys</author><pubDate>Mon, 18 Feb 2013 15:23:26 +0800</pubDate><description><![CDATA[mysql随机取数据 不连续

SELECT * FROM `table`
WHERE id >= (SELECT floor( RAND() * ((SELECT MAX(id) FROM `table`)-(SELECT MIN(id) FROM `table`)) + (SELECT MIN(id) FROM `table`)))
ORDER BY id LIMIT 1;]]></description><category></category></item><item><title><![CDATA[php生成xml文件]]></title><link>https://blog.csdn.net/jonlys/article/details/8252730</link><guid>https://blog.csdn.net/jonlys/article/details/8252730</guid><author>jonlys</author><pubDate>Mon, 03 Dec 2012 17:42:14 +0800</pubDate><description><![CDATA[<?php
function stripSpecial($str){
	$str = iconv('', 'utf-8', $str);
	$str = htmlspecialchars($str);
	//$str = '';
	return $str;
}
function setXmldata($loc, $lastmod, $changefreq, $priority){
	$loc =]]></description><category></category></item><item><title><![CDATA[图片页面慢慢滚动效果]]></title><link>https://blog.csdn.net/jonlys/article/details/7696694</link><guid>https://blog.csdn.net/jonlys/article/details/7696694</guid><author>jonlys</author><pubDate>Wed, 27 Jun 2012 16:37:05 +0800</pubDate><description><![CDATA[AAAAAAAAAAAAA
      BBBBBBBBBBBBB
      CCCCCCCCCCCCC
      DDDDDDDDDDDDD
      EEEEEEEEEEEEE
      FFFFFFFFFFFFF
    
  



&nbsp;
show A | 
show B | 
show C | 
show D | 
show E | 
s]]></description><category></category></item><item><title><![CDATA[遇到超链接自动加上a标签]]></title><link>https://blog.csdn.net/jonlys/article/details/7546067</link><guid>https://blog.csdn.net/jonlys/article/details/7546067</guid><author>jonlys</author><pubDate>Tue, 08 May 2012 14:13:53 +0800</pubDate><description><![CDATA[$jieshao = "I think you'll like the entrepreneur club, join here http://test.com/group/profile/68/ENTREPRENEUR_CLUB";


$message = eregi_replace("(((f|ht){1}tp://)[-a-zA-Z0-9@:%_+.~#?&//=]+)","\\1"]]></description><category></category></item><item><title><![CDATA[修改upload 按钮 样式]]></title><link>https://blog.csdn.net/jonlys/article/details/7382407</link><guid>https://blog.csdn.net/jonlys/article/details/7382407</guid><author>jonlys</author><pubDate>Thu, 22 Mar 2012 11:19:20 +0800</pubDate><description><![CDATA[input{border:1px solid red;}
div {width:300px;position:relative;}
p {float:left}
.file {position:absolute;top:20px;right:300px;+top:0;+right:73px;width:0px;height:20px;
    filter:alpha(opacity=0)]]></description><category></category></item><item><title><![CDATA[mysql 时间日期比较大小]]></title><link>https://blog.csdn.net/jonlys/article/details/7311926</link><guid>https://blog.csdn.net/jonlys/article/details/7311926</guid><author>jonlys</author><pubDate>Fri, 02 Mar 2012 13:29:59 +0800</pubDate><description><![CDATA[select * from student where '2012-02-27 00:00:00'  created_date


select * from student where UNIX_TIMESTAMP('2012-02-27 00:00:00')  UNIX_TIMESTAMP(created_date);


SELECT * FROM student WHERE (]]></description><category></category></item><item><title><![CDATA[字节转换MB]]></title><link>https://blog.csdn.net/jonlys/article/details/7190847</link><guid>https://blog.csdn.net/jonlys/article/details/7190847</guid><author>jonlys</author><pubDate>Tue, 10 Jan 2012 14:33:58 +0800</pubDate><description><![CDATA[function sizeformat($bytesize){
    $i=0;

    //当$bytesize 大于是1024字节时，开始循环，当循环到第4次时跳出；
    while(abs($bytesize)>=1024){       
        $bytesize=$bytesize/1024;
        $i++;
        if($i==4)]]></description><category></category></item><item><title><![CDATA[整块 div 连接 并不影响内部a标签的连接]]></title><link>https://blog.csdn.net/jonlys/article/details/7003603</link><guid>https://blog.csdn.net/jonlys/article/details/7003603</guid><author>jonlys</author><pubDate>Wed, 23 Nov 2011 12:00:47 +0800</pubDate><description><![CDATA[function amIclicked(e, element)
{
    e = e || event;
    var target = e.target || e.srcElement;

    if(target.id==element.id)
        return true;
    else
        return false;
}
function]]></description><category></category></item><item><title><![CDATA[js对日期年月日的相加减]]></title><link>https://blog.csdn.net/jonlys/article/details/6927692</link><guid>https://blog.csdn.net/jonlys/article/details/6927692</guid><author>jonlys</author><pubDate>Wed, 02 Nov 2011 11:04:37 +0800</pubDate><description><![CDATA[现在的日期：
    


    要加的天数：
    


    要加的周数：
    


    要加的月数：
    


    要加的年数：
    


    结果：
    


    要加的日期2：
    


    结果2：
    
-->



function   DateAdd(strInt]]></description><category></category></item><item><title><![CDATA[js版省市级联效果]]></title><link>https://blog.csdn.net/jonlys/article/details/6927623</link><guid>https://blog.csdn.net/jonlys/article/details/6927623</guid><author>jonlys</author><pubDate>Wed, 02 Nov 2011 10:53:46 +0800</pubDate><description><![CDATA[省市关联菜单


body,select
{
 font-size:9pt;
 font-family:Verdana;
}
select {background-color:#F0F0F0;}


var nowPro='湖北省';
var nowCity="宜昌市";
var pro_City=new Array();
var province='--请选择--,北]]></description><category></category></item><item><title><![CDATA[Html+css 实现级联菜单效果]]></title><link>https://blog.csdn.net/jonlys/article/details/6448126</link><guid>https://blog.csdn.net/jonlys/article/details/6448126</guid><author>jonlys</author><pubDate>Thu, 26 May 2011 17:41:00 +0800</pubDate><description><![CDATA[test menu]]></description><category></category></item><item><title><![CDATA[PHP+MYSQL 如何准确实现页面访问统计次数]]></title><link>https://blog.csdn.net/jonlys/article/details/6432737</link><guid>https://blog.csdn.net/jonlys/article/details/6432737</guid><author>jonlys</author><pubDate>Thu, 19 May 2011 17:57:00 +0800</pubDate><description><![CDATA[统计页面访问次数]]></description><category></category></item><item><title><![CDATA[js+css 模仿淘宝评分效果]]></title><link>https://blog.csdn.net/jonlys/article/details/6297501</link><guid>https://blog.csdn.net/jonlys/article/details/6297501</guid><author>jonlys</author><pubDate>Sat, 02 Apr 2011 11:17:00 +0800</pubDate><description><![CDATA[模仿淘宝评分效果 插件]]></description><category></category></item><item><title><![CDATA[mysql 中的数据类型]]></title><link>https://blog.csdn.net/jonlys/article/details/5715142</link><guid>https://blog.csdn.net/jonlys/article/details/5715142</guid><author>jonlys</author><pubDate>Tue, 06 Jul 2010 09:33:00 +0800</pubDate><description><![CDATA[mysql 中的数据类型2008-01-29  13:23数据类型描述字节推荐使用SMALLINT整数，从-32000到 +32000范围2存储相对比较小的整数。比如: 年纪，数量INT整数，从-2000000000 到 +2000000000
 范围4存储中等整数例如: 距离BIGINT不能用SMALLINT 或 INT描述的超大整数。8存储超大的整数例如: 科学/数学数据FLOAT单精度浮点型数据4存储小数数据例如:测量，温度DOUBLE双精度浮点型数据8需要双精度存储的小数数据例如:科学数据DECI]]></description><category></category></item><item><title><![CDATA[A样式总结]]></title><link>https://blog.csdn.net/jonlys/article/details/5686018</link><guid>https://blog.csdn.net/jonlys/article/details/5686018</guid><author>jonlys</author><pubDate>Tue, 22 Jun 2010 11:57:00 +0800</pubDate><description><![CDATA[<br />                <head> <br />
<style type="text/css">TD { <br />
    FONT-SIZE: 12px; FONT-FAMILY: 宋体 <br />
} <br />
A { <br />
    FONT-SIZE: 9pt; FONT-FAMILY: "宋体"; TEXT-DECORATION: none <br />
} <br />
.t1 { <br />
    COLOR: #cc0000; TEX]]></description><category></category></item><item><title><![CDATA[php cakephp]]></title><link>https://blog.csdn.net/jonlys/article/details/5639035</link><guid>https://blog.csdn.net/jonlys/article/details/5639035</guid><author>jonlys</author><pubDate>Tue, 01 Jun 2010 11:57:00 +0800</pubDate><description><![CDATA[<br />http://article.yeeyan.org/view/11302/48601?from_com]]></description><category></category></item></channel></rss>