Archive for December, 2009

用python连个mysql怎么就这么艰难呢……

By Symphony - Last updated: Sunday, December 27, 2009

Google了一下啊,说是要装mysqldb。 ubuntu下: 准备: sudo apt-get install libmysqlclient15-dev  python-reportlab    python-reportlab-accel libc6 libc6-dev python2.6-dev 下载:MySQL_python-1.2.3c1-py2.6-linux-i686.egg 安装: sudo easy_install MySQL_python-1.2.3c1-py2.6-linux-i686.egg 下载mysqldb:http://sourceforge.net/projects/mysql-python/ 解包&安装 sudo python setup.py build & sudo python setup.py install windows版 下载mysqldb:http://sourceforge.net/projects/mysql-python/ 解包,修改setup_windows.py文件: #serverKey = _winreg.OpenKey(_winreg.HKEY_LOCAL_MACHINE, options['registry_key'])   #mysql_root, dummy = _winreg.QueryValueEx(serverKey,'Location')   mysql_root = r'c:\wamp\mysql'    python setup.py build & python setup.py install #(需要先安装vc++ sdk)

file_get_contents和\n的那些事

By Symphony - Last updated: Tuesday, December 22, 2009

用file_get_contents去获取一段url的内容,结果总是显示404,实际上页面是存在的。搞了半天不明白,后来发现报错的url后带一个空白,猜想可能是url后面多了\n的话file_get_contents就会报错,就在url上加了个trim,马上就成功了!!-_-这file_get_contents的容错性真是……