<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[hansoy的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/hansoy</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; hansoy]]></copyright><item><title><![CDATA[ZendStudio的常用设置]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/46355857</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/46355857</guid><author>hansoy</author><pubDate>Thu, 04 Jun 2015 09:05:19 +0800</pubDate><description><![CDATA[1、安装颜色主题
① 顶部菜单栏
② 帮助（help）
③ 安装新软件（install new software）
④ 输入路径: http://eclipse-color-theme.github.com/update/ ，右侧添加 
⑤ 勾选 Eclipse Color Theme 下一步安装完成即可


2、设置主题及字体
① 窗口（window）
② 首选项（prefe]]></description><category></category></item><item><title><![CDATA[wamp中因root密码修改，而导致无法直接登录phpMyAdmin的解决方法]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/45372173</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/45372173</guid><author>hansoy</author><pubDate>Wed, 29 Apr 2015 21:42:16 +0800</pubDate><description><![CDATA[wamp装完，root用户密码默认为空；
有时安装集成框架包时，会先在phpMyAdmin里修改root密码，再安装集成框架包(因为有些安装root密码不能为空)；
这时，再用wamp直接访问phpMyAdmin，就无法正常访问了，需要做如下设置：
路径：C:\wamp\apps\phpmyadmin4.1.14
文件：config.inc.php
修改：$cfg['Servers'][]]></description><category></category></item><item><title><![CDATA[win7最大内存设置问题，导致系统无法启动的解决方法]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/45191857</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/45191857</guid><author>hansoy</author><pubDate>Wed, 22 Apr 2015 10:43:38 +0800</pubDate><description><![CDATA[cmd-msconfig-引导-高级选项-最大内存不能随便勾！否则可能会出现系统无法启动的情况！

最便捷的解决办法，亲测可用：

1、拔掉主板电池，用PS2口键盘按F8进入安全模式，然后在相同路径下去掉最大内存前面的勾，关机！

2、装上主板电池，开机正常启动！]]></description><category></category></item><item><title><![CDATA[XP桌面背景文件路径]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/45191765</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/45191765</guid><author>hansoy</author><pubDate>Wed, 22 Apr 2015 10:35:42 +0800</pubDate><description><![CDATA[XP下当前正在使用的桌面背景图片路径（需要显示全部文件和文件夹）：

C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Wallpaper1.bmp




XP默认壁纸路径

C:\WINDOWS\Web\Wallpaper]]></description><category></category></item><item><title><![CDATA[解决运行wamp提示“MSVCR110.dll”丢失（win7 x64）]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/45191639</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/45191639</guid><author>hansoy</author><pubDate>Wed, 22 Apr 2015 10:30:01 +0800</pubDate><description><![CDATA[打开：http://www.microsoft.com/zh-CN/download/details.aspx?id=30679 

下载：vcredist_x64.exe

安装下载文件即可。]]></description><category></category></item><item><title><![CDATA[SublimeText 3的下载、安装及使用]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/45054447</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/45054447</guid><author>hansoy</author><pubDate>Wed, 15 Apr 2015 09:09:54 +0800</pubDate><description><![CDATA[1、官网下载：www.sublimetext.com/3，下载系统对应版本安装
2、ctrl+` : 打开命令行(注意屏蔽键值冲突，如遨游的老板键)
2、复制下列代码，回车执行
import urllib.request,os,hashlib; h = 'eb2297e1a458f27d836c04bb0cbaf282' + 'd0e7a3098092775ccb37ca9d6b2e4b7d]]></description><category></category></item><item><title><![CDATA[PHP用jQuery实现无刷新验证]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44968453</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44968453</guid><author>hansoy</author><pubDate>Fri, 10 Apr 2015 00:21:03 +0800</pubDate><description><![CDATA[$(function(){ 
	$("#codeno").blur(function(){ //文本框鼠标焦点消失事件 
	$.post("postCard.php?codeno="+$("#codeno").val(),null,function(data) //post方式按需求调整
	{ 
	$("#check").html(data); //向ID为check的元素内添加html代码]]></description><category></category></item><item><title><![CDATA[在SAE上用PHP连接MySQL]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44955223</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44955223</guid><author>hansoy</author><pubDate>Thu, 09 Apr 2015 09:24:18 +0800</pubDate><description><![CDATA[<?php
    $con = mysql_connect(SAE_MYSQL_HOST_M.':'.SAE_MYSQL_PORT,SAE_MYSQL_USER,SAE_MYSQL_PASS);
    mysql_select_db("app_XXX", $con) or die("选择数据库失败"); 
?>
将上面代码保存为conn.php，
其他页面里：include("conn.p]]></description><category></category></item><item><title><![CDATA[MySQL 用phpMyAdmin导入Excel中的数据]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44955171</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44955171</guid><author>hansoy</author><pubDate>Thu, 09 Apr 2015 09:21:24 +0800</pubDate><description><![CDATA[1、将Excel另存为：CSV（逗号分隔）文档；

2、修改字段分隔符为","；



3、点击右下角"执行"。]]></description><category></category></item><item><title><![CDATA[mysql 数据库导入frm文件]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44955143</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44955143</guid><author>hansoy</author><pubDate>Thu, 09 Apr 2015 09:19:49 +0800</pubDate><description><![CDATA[1、wamp装完以后，在新数据库下建立一个与老数据库的同名文件夹。

参考路径：C:\wamp\bin\mysql\mysql5.6.17\data




2、把mysql停止[停止所有服务]，net stop mysql。




3、把老数据库的frm数据复制到新文件夹下。




4、把老数据库data目录下的ibdata1文件复制到新数据库的data目录]]></description><category></category></item><item><title><![CDATA[PHP mysql_fetch_array遍历数据时的问题(指针需要复位)]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44955093</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44955093</guid><author>hansoy</author><pubDate>Thu, 09 Apr 2015 09:12:49 +0800</pubDate><description><![CDATA[遍历时少一行数据，将指针复位即可
<?php
include("conn.php");
$sql=mysql_query("select price from ticprice");
$row=mysql_fetch_array($sql);
mysql_data_seek($sql,0);   //指针复位
while($row=mysql_fetch_array($sql)){
?>
">
]]></description><category></category></item><item><title><![CDATA[微信公众平台开发 获取用户基本信息(nickname等)]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44955005</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44955005</guid><author>hansoy</author><pubDate>Thu, 09 Apr 2015 09:04:41 +0800</pubDate><description><![CDATA[<?php	
	
	$appid = "wxXXXXXXXXXXXXXXXXXX";
	$appsecret = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX";
	$url = "https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=$appid&secret=$appsecret"]]></description><category></category></item><item><title><![CDATA[微信公众平台开发 获得公众号的access_token]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44954969</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44954969</guid><author>hansoy</author><pubDate>Thu, 09 Apr 2015 09:00:40 +0800</pubDate><description><![CDATA[$appid = "wxXXXXXXXXXXXXXX";
$appsecret = "XXXXXXXXXXXXXXXXXXXXXXXXX";
$url = "https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=$appid&secret=$appsecret";
 
$ch = curl_init()]]></description><category></category></item><item><title><![CDATA[微信公众平台开发 获得所有关注者的Openid]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44954895</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44954895</guid><author>hansoy</author><pubDate>Thu, 09 Apr 2015 08:58:30 +0800</pubDate><description><![CDATA[<?php
    $appid = "wxXXXXXXXXXXXXXXXXXXX";
    $appsecret = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX";
    $url = "https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=$appid&secret=$app]]></description><category></category></item><item><title><![CDATA[delphi 去掉popupmenu的快捷键自动显示]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44954873</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44954873</guid><author>hansoy</author><pubDate>Thu, 09 Apr 2015 08:55:27 +0800</pubDate><description><![CDATA[直接在后面加“&”即可，如“复制到剪贴板&”。]]></description><category></category></item><item><title><![CDATA[delphi 按回车选中下一个控件]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44954845</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44954845</guid><author>hansoy</author><pubDate>Thu, 09 Apr 2015 08:51:06 +0800</pubDate><description><![CDATA[procedure TForm1.FormKeyPress(Sender: TObject; var Key: Char);
begin
  if Key = #13 then
  begin
    Key := #0;
    SelectNext(ActiveControl, True, True);
  end;
end;]]></description><category></category></item><item><title><![CDATA[delphi 通过事务插入数据]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44954805</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44954805</guid><author>hansoy</author><pubDate>Thu, 09 Apr 2015 08:46:03 +0800</pubDate><description><![CDATA[orsn1.StartTransaction;
   try
       qry1.Sql.Clear;
       qry1.Sql.Text:=' select * from log ';
       qry1.Open;

       qry1.Insert;
       qry1.FieldByName('Rq').AsDateTime:=StrToDate(FormatDate]]></description><category></category></item><item><title><![CDATA[delphi 让程序状态栏显示今天星期几]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44954761</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44954761</guid><author>hansoy</author><pubDate>Thu, 09 Apr 2015 08:37:48 +0800</pubDate><description><![CDATA[procedure TForm1.FormShow(Sender: TObject);
const
  cWeek:array[1..7]  of string =
  ('星期天', '星期一', '星期二', '星期三', '星期四', '星期五', '星期六');
begin
  rzstspn1.Caption:=cWeek[DayofWeek(Now)];
end;]]></description><category></category></item><item><title><![CDATA[delphi ”invalid argument to date encode“的解决方法]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44941879</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44941879</guid><author>hansoy</author><pubDate>Wed, 08 Apr 2015 15:46:04 +0800</pubDate><description><![CDATA[yy,mm,dd:word; 

// 同比(去年同期) 闰年2月29日无同比，就取去年的2月28日
 decodedate(dtp1.Date,yy,mm,dd);
  if MonthDays[IsLeapYear(yy - 1), mm] < dd then  
    QnDate := FormatDateTime('yyyy.mm.dd',EncodeDate(yy-1,mm,dd-1]]></description><category></category></item><item><title><![CDATA[delphi Application.MessageBox 添加数据提示]]></title><link>https://blog.youkuaiyun.com/hansoy/article/details/44941759</link><guid>https://blog.youkuaiyun.com/hansoy/article/details/44941759</guid><author>hansoy</author><pubDate>Wed, 08 Apr 2015 15:41:18 +0800</pubDate><description><![CDATA[Application.MessageBox(Pchar('号码：' + dm.qry1.ParamByName('p_1').AsString+ '删除成功！'), '提示', MB_OK + MB_ICONINFORMATION);

 Application.MessageBox(Pchar('注意，昨天的日期是：' + dateToStr(now-1) + '！'), '提示', MB_O]]></description><category></category></item></channel></rss>