技术类类别

技术大类

PHP
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
<?php
/**
* Created by PhpStorm.
* User: xiaoniba
* Date: 15/1/30
* Time: 下午9:42
* 用pdo链接mysql数据库
*/
 
$host = "localhost";
$user = "root";
$password = "";
$db = "test";
 
try {
    $dbh = new PDO("mysql:host=localhost;dbname={$db};charset=utf8",$user,$password);
 
    foreach($dbh->query('SELECT * FROM user ') as $row){
        print_r($row);
    }
 
} catch (PDOException $e) {
    print "Error! :" . $e->getMessage() . "
";
}
 
?>

PHP
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
//utf8中文字串截取
function csubstr($str,$start,$len){
preg_match_all("/[\x01-\x7f]|[\xc2-\xdf][\x80-\xbf]|\xe0[\xa0-\xbf][\x80-\xbf]|[\xe1-\xef][\x80-\xbf][\x80-\xbf]|\xf0[\x90-\xbf][\x80-\xbf][\x80-\xbf]|[\xf1-\xf7][\x80-\xbf][\x80-\xbf][\x80-\xbf]/", $str, $ar);
$x=1;
for($i=0;$i<sizeof($ar[0]);$i++){
if($i>$len){
break;
}
if(ord($ar[0][$i])<128){
if($x==2){
$len=$len+1;
$x=0;
}
$x++;
}
}
 
return join("",array_slice($ar[0],$start,$len));
}

sublime text3

Shell
1
import urllib.request,os,hashlib; h = '7183a2d3e96f11eeadd761d777e62404' + 'e330c659d4bb41d3bdf022e94cab3cd0'; pf = 'Package Control.sublime-package'; ipp = sublime.installed_packages_path(); urllib.request.install_opener( urllib.request.build_opener( urllib.request.ProxyHandler()) ); by = urllib.request.urlopen( 'http://packagecontrol.io/' + pf.replace(' ', '%20')).read(); dh = hashlib.sha256(by).hexdigest(); print('Error validating download (got %s instead of %s), please try manual install' % (dh, h)) if dh != h else open(os.path.join( ipp, pf), 'wb' ).write(by)

sub… 继续阅读 sublime text安装包管理插件