###倒计时
console.log(time_to_str(-60850977));
function time_to_str(time){
var time = Math.abs(time/1000);
var h = Math.floor(time/3600);
var m = Math.floor(time%3600/60);
var s = Math.floor(time%3600%60);
return '还剩' + h + '小时' + m + '分钟' + s + '秒';
}
function toStr(n) {
n = n.toString();
return n[1] ? n : '0' + n;
}
switch (string) {
case "yyyy-mm-dd":
time = [year, month, date].map(toStr).join('-');
break;
...
}###php单例
//public修饰的方法才可以在类的外部访问，protected方法和private方法只能在类中访问，区别在与protected方法可以在子类中访问而private方法不可以
在线demohttps://www.bytelang.com/o/s/c/NQbmUaRIXyA=
class ClassName {
static $instance;
private function __construct(){}
public static function getInstance() {
if (static::$instance instanceof static) {
return static::$instance;
}
return static::$instance = new static();
}
}数组解构赋值的话，右值必需是iterable(可迭代的)，下面的例子的错误与[] = 1是一样错误，所以应该会先检查右值是否为iterable时，先抛出类型错误:
[] = '1'不会有错误，是因为字符串是属于iterable(可迭代的)。###省市数据库联动表
CREATE TABLE `ecs_region` (
`region_id` smallint(5) unsigned NOT NULL auto_increment,
`parent_id` smallint(5) unsigned NOT NULL default '0',
`region_name` varchar(120) NOT NULL default '',
`region_type` tinyint(1) NOT NULL default '2',
`agency_id` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`region_id`),
KEY `parent_id` (`parent_id`),
KEY `region_type` (`region_type`),
KEY `agency_id` (`agency_id`)
) TYPE=MyISAM;
sql:https://git.oschina.net/xujian_jason/codes/3bqvj8s7wkupeitmy0cl252
http://www.stats.gov.cn/tjsj/tjbz/xzqhdm/201608/t20160809_1386477.html
小程序 http://www.php.cn/toutiao-348128.htmlvar str='hello';
str.len=5;
console.log(str.len); //undefined
var str=new String("Hello");
str.len=5;
console.log(str.len); //5###jsonp是get形式，承载的信息量有限 fastcgi request record is too big
header("Access-Control-Allow-Origin：* "); // * 可改为[域名|ip], 多个地址用逗号,分割
header("Access-Control-Request-Method: POST"); // 设置只允许POST请求跨域
$.ajax({
...,
dataType: 'json'
});var compress = function(source_img_obj, quality, output_format){
var mime_type = "image/jpeg";
if(output_format!=undefined && output_format=="png"){
mime_type = "image/png";
}
alert(source_img_obj);
var cvs = document.createElement('canvas');
//naturalWidth真实图片的宽度
cvs.width = source_img_obj.naturalWidth;
cvs.height = source_img_obj.naturalHeight;
var ctx = cvs.getContext("2d").drawImage(source_img_obj, 0, 0);
var newImageData = cvs.toDataURL(mime_type, quality/100);
var result_image_obj = new Image();
result_image_obj.src = newImageData;
return result_image_obj;
}###setInterval
var a = function(){
};
// 或者
function a() {}
setInterval(a, 1000);
var a = function(){
};
// 或者
function a() {
}
setInterval("a", 1000);
setInterval(function(){
}, 1000);
如果setInterval(foo(), 1000); 最终timer执行的是这个foo的return
这个参数对于setInterval来说实际上是对timeShow函数的引用，支持以函数名，函数名称字符串的方式，但是timeShow()就不行了，直接使用timeShow()的话这个timeShow函数会直接执行，传给setInterval的参数就不是该函数，而是该函数的返回值了import selenium.webdriver as webdriver
import selenium.webdriver.support.ui as ui
from selenium.webdriver.common.keys import Keys
from time import sleep
browser = webdriver.Firefox()
browser.get('https://www.google.com?q=python#q=python')
first_result = ui.WebDriverWait(browser, 15).until(lambda browser: browser.find_element_by_class_name('rc'))
first_link = first_result.find_element_by_tag_name('a')
# Save the window opener (current window, do not mistaken with tab... not the same)
main_window = browser.current_window_handle
# Open the link in a new tab by sending key strokes on the element
# Use: Keys.CONTROL + Keys.SHIFT + Keys.RETURN to open tab on top of the stack
first_link.send_keys(Keys.CONTROL + Keys.RETURN)
# Switch tab to the new tab, which we will assume is the next one on the right
browser.find_element_by_tag_name('body').send_keys(Keys.CONTROL + Keys.TAB)
browser.execute_script('''window.open("about:blank", "_blank");''')
# Put focus on current window which will, in fact, put focus on the current visible tab
browser.switch_to_window(main_window)
# do whatever you have to do on this page, we will just got to sleep for now
sleep(2)
# Close current tab
browser.find_element_by_tag_name('body').send_keys(Keys.CONTROL + 'w')
# Put focus on current window which will be the window opener
browser.switch_to_window(main_window)###postman 设置参数
var param="dt=IM-A900S&uid=13753541&sid=13131432-3b20c3fb2c2f68d64&pf=android&cn=3G&imei=359678051085074&pn=&imsi=460004660651885&cv=4.1&cc=qq";
var atom = btoa(param);
postman.setGlobalVariable("atom", atom);请求url text.com/index.php?atom={{atom}}###Number.isNaN
Number.isNaN = Number.isNaN || function(value) {
return typeof value === "number" && isNaN(value);
}
因为Number(null)会返回0，isNaN()内部会先调用Number(value)转换下值,然后再比较，所以
isNaN(null)，即isNaN(0),会返回false###把每个对象加一个逗号放一行
notepad++ 然后查找 '},' 替换成'},\n' str.replace(/},/g,'},\n');
###更新nodejs
列出安装npm包npm list -g --depth=0 ls `npm root -g`
下载https://npm.taobao.org/mirrors/node/latest-v6.x/node-v6.9.3-x64.msi
npm config set registry=https://registry.npm.taobao.org### js把php的内置函数都实现一遍
http://locutus.io/php http://phpjs.hertzen.com/console.html?gist=3171392 http://pdfmyurl.com/###JSON 重组
var src = {
"title": "限制标题字数",
"desc": "",
"tagInput": "",
"interest": "1",
"fwb": "这是富文本11111",
"goodImg01": "",
"goodTitle01": "富文本1下面礼物名字1",
"goodPrice01": "富文本1下面礼物1的价格",
"goodId01": "富文本1下面礼物1的ID",
"goodImg02": "",
"goodTitle02": "富文本1下面礼物2名字2",
"goodPrice02": "富文本1下面礼物2的价格",
"goodId02": "富文本1下面礼物2的ID",
"goodImg03": "",
"goodTitle03": "富文本1下面礼物3名字",
"goodPrice03": "富文本1下面礼物3的价格",
"goodId03": "富文本1下面礼物3的ID",
"fwb1": "这是富文本2222",
"goodImg11": "",
"goodTitle11": "富文本2下面的礼物名字",
"goodPrice11": "富文本2下面的礼物价格",
"goodId11": "富文本2下面的礼物ID"
}
[{
"fwb": "这是富文本11111",
"good": [{
"goodImg": "",
"goodTitle": "富文本1下面礼物名字1",
"goodPrice": "富文本1下面礼物1的价格",
"goodId": "富文本1下面礼物1的ID"
},
{
"goodImg": "",
"goodTitle": "富文本1下面礼物2名字2",
"goodPrice": "富文本1下面礼物2的价格",
"goodId": "富文本1下面礼物2的ID"
},
{
"goodImg": "",
"goodTitle": "富文本1下面礼物3名字",
"goodPrice": "富文本1下面礼物3的价格",
"goodId": "富文本1下面礼物3的ID"
}
]
},
{
"fwb": "这是富文本2222",
"good": [{
"goodImg": "",
"goodTitle": "富文本2下面礼物名字1",
"goodPrice": "富文本2下面礼物1的价格",
"goodId": "富文本2下面礼物1的ID"
},
{
"goodImg": "",
"goodTitle": "富文本2下面礼物2名字2",
"goodPrice": "富文本2下面礼物2的价格",
"goodId": "富文本2下面礼物2的ID"
},
{
"goodImg": "",
"goodTitle": "富文本2下面礼物3名字",
"goodPrice": "富文本2下面礼物3的价格",
"goodId": "富文本2下面礼物3的ID"
}
]
}
]
var srcStr=JSON.stringify(src);
//加fwb
srcStr=srcStr.replace(/("goodId\d{2}":"[^"]*",)("goodImg\d{2}":)/g,'$1"fwb":"",$2');
//自定义一个符号比如::分隔
srcStr=srcStr.replace(/,("fwb[^"]*")/g,'::"fwb"');
srcStr=srcStr.split('::');
var srcRes=[];
var i=1;
var temp={};
//一项一项取就好了
while(srcStr[i]){
srcStr[i]=srcStr[i].replace(/,"([a-zA-Z]+)\d{2}"/g,',"$1"');
srcStr[i]= srcStr[i+1]?('{'+srcStr[i]+'}'):('{'+srcStr[i]);
temp=JSON.parse(srcStr[i]);
temp.mark=i;
srcRes.push(temp);
i++;
}
console.log(srcRes);###正则表达式replace
String.prototype.replace.call('223322', /22(\d{2})22/, 'replaced!')
//"replaced!"
String.prototype.replace是会搜寻整个正则表达式/22(d{2})22/的内容并用'replaced!'字符串来替换, 不管正则内有没有分组;
String.prototype.replace.call('223322', /22(\d{2})22/, '$1')
//"33"
'$1'则指代捕获组1的内容, 在这里就是'33'. 因此整个正则所匹配的内容会被替换成为'$1'的内容.
具体到这里, /((d{3}))/g匹配的是'(555)', 捕获组1捕获到的则是'555', 因此'(555)'会被替换为'555' + '-'.###redis sAdd数组不能为空
var apiMenu = $.parseJSON('{!! $jsonListArray !!}'); #将php数组转为js数组对象
if (!empty($tmpList)) {
$keyWord = array_column($tmpList, 'keywords');
RedisFacade::sAdd(Kwd::WHOLE_KEY_LIMIT, $keyWord);
}###数组扁平化
>>> vec = [[1,2,3], [4,5,6], [7,8,9]]
>>> [num for elem in vec for num in elem]
[1, 2, 3, 4, 5, 6, 7, 8, 9]http://ctf4.shiyanbar.com/web/false.php?name[]=a&password[]=b
如果 GET 参数中设置 name[]=a，那么 $_GET['name'] = [a]，php 会把 []=a 当成数组传入， $_GET 会自动对参数调用 urldecode。
$_POST 同样存在此漏洞，提交的表单数据，user[]=admin，$_POST['user'] 得到的是 ['admin'] 是一个数组
md5([]) === false
echo is_numeric(233333); # 1
echo is_numeric('233333'); # 1
echo is_numeric(0x233333); # 1
echo is_numeric('0x233333'); # 1
echo is_numeric('233333abc'); # 0
变量覆盖 extract
//var.php?var=new
$var='init';
parse_str($_SERVER['QUERY_STRING']);
print $var;###比较
// 0x 开头会被当成16进制54975581388的16进制为 0xccccccccc
// 十六进制与整数，被转换为同一进制比较
'0xccccccccc' == '54975581388'
// 字符串在与数字比较前会自动转换为数字，如果不能转换为数字会变成0
1 == '1'
1 == '01'
10 == '1e1'
100 == '1e2'
0 == 'a' // a 转换为数字为 0
// 十六进制数与带空格十六进制数，被转换为十六进制整数
'0xABCdef' == ' 0xABCdef'
'0010e2' == '1e3'
// 0e 开头会被当成数字，又是等于 0*10^xxx=0
// 如果 md5 是以 0e 开头，在做比较的时候，可以用这种方法绕过
'0e509367213418206700842008763514' == '0e481036490867661113260034900752'
'0e481036490867661113260034900752' == '0'
var_dump(md5('240610708') == md5('QNKCDZO'));
var_dump(md5('aabg7XSs') == md5('aabC9RqS'));
var_dump(sha1('aaroZmOk') == sha1('aaK1STfY'));
var_dump(sha1('aaO8zKZF') == sha1('aa3OFF9m'));###python发送邮件
#! /usr/bin/env python
# -*- coding: utf-8 -*-
#http://www.restran.net/2015/02/12/python-postfix-email/
import smtplib
import time, traceback, sys, os
from email.mime.text import MIMEText
def send_mail(mail_from, password, mail_to, subject, content):
handle = smtplib.SMTP('smtp.163.com', 25)
handle.login(mail_from, password)
time_str = time.strftime('%Y-%m-%d %X', time.localtime(time.time()))
msg = '<html><body>' + content + "<br><br><span style='color:#999;font-size:"\
+ "10px;font-family:Verdana;'>" \
+ time_str + " by " + mail_from + "</span>"+'</body></html>'
send_msg = MIMEText(msg, 'html', 'utf-8')
send_msg['Subject'] = subject
handle.sendmail(mail_from, mail_to, send_msg.as_string())
handle.close()
if __name__ == '__main__':
send_mail('[email protected]', 'your_password', 'Hello Python!', 'Say hello to Python! :)')>>> a = [
... 'foo'
... 'bar',
... 'tree'
... ]
>>>
>>> b = 'foo' 'bar'
>>>
>>> print a
['foobar', 'tree']
>>> print b
foobar
只要把两个字符串放在一起，中间有空白或者没有空白，两个字符串自动连接为一个字符串。
也就是说 'foo' + 'bar' 等价于 'foo' 'bar'
>>> a = {'foo': 'bar'}
>>> b = a.get('foo'),
>>> c = a.get('foo')
>>> print(b)
('bar',)
>>> print(c)
bar把 mydata.zi p解压到 mydatabak 目录里面
unzip mydata.zip -d mydatabak
sudo pkill -f uwsgi -9
cd /proc ll 进程号
# -p 后面跟的是端口
ssh 192.168.1.102 -l root -p 22###[Python 对小整数的定义是 -5, 257)
所有位于这个范围内的整数使用的都是同一个对象 id 函数可以用来查看一个对象的唯一标志，可以认为是内存地址
>>> a = 1
>>> id(a)
40059744
>>> b = 1
>>> id(b)
40059744
>>> c = 257
>>> id(c)
41069072
>>> d = 257
>>> id(257)
41069096###nginx 反向代理
server {
listen *:5000;
access_log logs/mysite_access.log;
error_log logs/mysite_error.log;
# 为了调试方便，我不缓存
expires 0;
# 开启 gzip，跟真实环境一样
gzip on;
# 网站的路径
location / {
root "D:/path/to/mysite/html";
index index.html index.htm;
}
# 静态文件的路径
location /static {
alias "D:/path/to/mysite/static";
}
# 我们的 api 接口会使用特殊前缀 @ 来区分
# 把所有 uri 以 /@api_some_data 开头的转发到接口服务器
location /@api_some_data {
# 看情况，是否需要重写 uri
# rewrite /@api_some_data/(.*) /$1 break;
# 转发到接口服务器的地址
proxy_pass http://192.168.1.2:8000;
proxy_set_header Cookie $http_cookie;
}
}
$.ajax({
url: '/@api_some_data/get_data/',
type: 'POST',
cache: false,
dataType: 'json',
contentType: 'application/json; charset=utf-8',
data: JSON.stringify(post_data),
success: function (response) {
// handle success
},
error: function () {
// handle error
}
});###zhihu-card
<div class="zhihu-card" data-userhash="your hash"></div>
<script src="//cdn.jsdelivr.net/zhihu-card/latest/widget.js"></script>import requests
from collections import defaultdict
from os.path import join
from pprint import pprint
class GetLangStat():
api_url = "https://api.github.com/orgs"
ORGANIZATIONS = (
'Microsoft', 'aws', 'google', 'twitter', 'facebook',
'alibaba'
)
stats = {org: defaultdict(int) for org in ORGANIZATIONS}
@classmethod
def get_one_org_repos(cls, org):
print(org)
url = join(cls.api_url, org, 'repos')
r = requests.get(url)
for repo in r.json():
cls.stats[org][repo['language']] += 1
@classmethod
def get_all_org_repos(cls):
for org in cls.ORGANIZATIONS:
cls.get_one_org_repos(org)
pprint(cls.stats)
if __name__ == '__main__':
GetLangStat.get_all_org_repos()###获取登录用户
echo $username = getenv("username");
###文件夹上传
<form method="POST" enctype=multipart/form-data>
<input type='file' name="file" webkitdirectory >
<button>upload</button>
</form>
<input type='file' webkitdirectory >
<button id="upload-btn" type="button">upload</button>
var files = [];
$(document).ready(function(){
$("input").change(function(){
files = this.files;
});
});
$("#upload-btn").click(function(){
var fd = new FormData();
for (var i = 0; i < files.length; i++) {
fd.append("file", files[i]);
}
$.ajax({
url: "/upload/",
method: "POST",
data: fd,
contentType: false,
processData: false,
cache: false,
success: function(data){
console.log(data);
}
});
});去掉VerifyCsrfToken中间件，也可以在app/Http/Middleware/VerifyCsrfToken.php的$except数组中加上要跳过Csrf验证的路由
$http({
method: 'post',
url: 'http://www.b.com/test/index',
data: {
//withCredentials: true,
customers: 'testname',
email: '[email protected]'
},
headers: {
'Content-Type': 'application/x-www-form-urlencoded'
}
}).success(function (r) {
console.log(r);
});###闭包实现一个缓存型函数
function cache(fn){
var map = {};
return function(){
var args = arguments;
var key = Array.prototype.join.call(args, ',');
console.log("--key=" + key);
if(map[key]){
console.log("该调用被缓存");
return map[key];
}else{
console.log("该调用未被缓存");
return map[key] = fn.apply(this, args);
}
}
}
var factorial = cache(function(n){
return n < 1?1:n* factorial(n-1);
});
console.log(factorial(3));
console.log(factorial(4));'937493453453'.replace(/(\d{4})/g, '$1 ').trim()//"9374 9345 3453"
'937493453453'.split('').reverse().join('').replace(/(\d{3})/g, '$1,').replace(/,$/,'').split('').reverse().join('');###事件绑定
function on(type, fn) {
var el = this;
if (el.addEventListener) {
el.addEventListener(type, fn, false);
} else if (el.attacheEvent) {
el.attachEvent('on' + type, fn.bind(el));
} else {
el['on' + type] = fn;
}
}
var $ = function(selector) {
document.getElementById(selector).__proto__.on = on;
return document.getElementById(selector);
}
$('test').on('click', function(e) {
console.log('obj');
});###实现ajax请求函数
function ajax(opt){
let xhr;
if(window.ActiveXObject){
xhr = new ActiveXObject('Microsoft.XMLHTTP');
}else{
xhr = new XMLHttpRequest();
}
xhr.open(opt.type, opt.url, true);
xhr.send(opt.data);
xhr.onreadystatechange = function(){
if(xhr.readyState === 4 && xhr.status === 200){
opt.success(xhr.responseText);
}else{
opt.error(xhr.error);
}
}
}
ajax({
type: 'get',
url: 'http://www.a.com',
data: {
name: 'ouven'
},
success: function(data){
console.log(data);
},
error: function(e){
console.log(e);
}
});###两个大数相加
function add(num1, num2) {
var numArr1 = num1.toString().split('').reverse(),
numArr2 = num2.toString().split('').reverse(),
maxLength = numArr1.length > numArr2.length?numArr1.length:numArr2.length;
flowArr = [0],
resultArr = [];
for(let i = 0; i < maxLength; i++){
numArr1[i] = parseInt(numArr1[i], 10) || 0;
numArr2[i] = parseInt(numArr2[i], 10) || 0;
if(numArr1[i] + numArr2[i] + (flowArr[i] || 0) >= 10){
resultArr[i] = numArr1[i] + numArr2[i] - 10;
flowArr[i+1] = 1;
}else{
resultArr[i] = numArr1[i] + numArr2[i];
flowArr[i+1] = 0;
}
}
for(let i = 0; i < flowArr.length; i++){
resultArr[i] = (resultArr[i] || 0) + (flowArr[i] || 0);
}
if(resultArr[flowArr.length -1] === 0){
resultArr.pop();
}
return resultArr.reverse().join('');
}
console.log(add('410', '699'));var seed;
element.addEventListener('keyup',function(e){
if(seed){
clearTimeout(seed);
}
seed = setTimeout(saveDraft, 5000);
})###id不能为数字
var id=Math.random();
$('body').html('<div id='+id+'>hha</div>');
//$('#'+id).removeAttr('id');
$(('#'+id).replace('.', '\\.')).removeAttr('id');###版本比较
function version( v1, v2 ) {
var arr1 = v1.replace(/-/g,'.').split('.');
var arr2 = v2.replace(/-/g,'.').split('.');console.log(arr1,arr2);
var maxLen = Math.max(arr1.length, arr2.length);
for ( var i = 0; i < maxLen; i++ ) {
if(parseInt(arr1[i]) == parseInt(arr2[i])) continue;
return parseInt(arr1[i]) > parseInt(arr2[i]) ? true :false;
}
return false;
}
versionCompare('10.11.111','10.2.2');//
var VersionCompare = function (currVer, promoteVer) {
currVer = currVer || "0.0.0";
promoteVer = promoteVer || "0.0.0";
if (currVer == promoteVer) return false;
var currVerArr = currVer.split(".");
var promoteVerArr = promoteVer.split(".");
var len = Math.max(currVerArr.length, promoteVerArr.length);
for (var i = 0; i < len; i++) {
var proVal = ~~promoteVerArr[i],
curVal = ~~currVerArr[i];
if (proVal < curVal) {
return false;
} else if (proVal > curVal) {
return true;
}
}
return false;
};###正则匹配id
var span = document.createElement("span");
span.innerHTML = '<xml xmlns="http://www.w3.org/1999/xhtml"><block type="variables_get" id="nLf_BhSsE?miY*(Kqsak" x="237" y="65"><field name="NAME">qqqqq</field></block></xml>';
var field= span.getElementsByTagName('field')[0];
var text = field.innerHTML;//qqqqq###根据距离和时间算平均
$distance=5;
$time=strtotime('0:30:30');
$time= date('s',$time)+date('i',$time)*60+date('H',$time)*3600;
$pace = $time / $distance;//366
$strtime=gmstrftime('%H:%M:%S',$pace);//00:06:06###多维数组判断
function in_array_recursive($needle, $haystack) {
$it = new RecursiveIteratorIterator(new RecursiveArrayIterator($haystack));
foreach($it as $element) {
if($element == $needle) {
return true;
}
}
return false;
}
$arr= [
[
"id" => 1,
"type" => 1
],
[
"id" => 2,
"type" => 2
],
[
"id" => 3,
"type" => 3
],
[
"id" => 4,
"type" => 4
]
];
var_dump(in_array_recursive(2,$arr));
var_dump(in_array_recursive(5,$arr));
//laravel
in_array(2,array_dot($arr));
function array_dot($array, $prepend = '')
{
$results = [];
foreach ($array as $key => $value) {
if (is_array($value)) {
$results = array_merge($results, array_dot($value, $prepend.$key.'.'));
} else {
$results[$prepend.$key] = $value;
}
}
return $results;
}
function recursiveFind(array $array, $needle)
{
$iterator = new RecursiveArrayIterator($array);
$recursive = new RecursiveIteratorIterator($iterator, RecursiveIteratorIterator::SELF_FIRST);
$aHitList = array();
foreach ($recursive as $key => $value) {print_r($value);
if ($key === $needle) {
array_push($aHitList, $value);
}
}
return $aHitList;
}###search
function search($array, $key, $value)
{
$results = array();
if (is_array($array)) {
if (isset($array[$key]) && $array[$key] == $value) {
$results[] = $array;
}
foreach ($array as $subarray) {
$results = array_merge($results, search($subarray, $key, $value));
}
}
return $results;
}
$arr = array(0 => array(id=>1,name=>"cat 1"),
1 => array(id=>2,name=>"cat 2"),
2 => array(id=>3,name=>"cat 1"));
print_r(search($arr, 'name', 'cat 1'));
Array
(
[0] => Array
(
[id] => 1
[name] => cat 1
)
[1] => Array
(
[id] => 3
[name] => cat 1
)
)###php保存为word
<?php
$fileName = 'test.doc';
// header('Content-Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document');
// header('Content-Type: application/msword');
header("Content-type: application/vnd.ms-word");
// header("Content-Disposition: attachment; Filename=SaveAsWordDoc.doc");
header('Content-Disposition: attachment;filename=' . $fileName);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=Windows-1252\">
<title>Saves as a Word Doc</title>
</head>
<body>
<h1>Header</h1>
php保存为word
<ul>
<li>List 1</li>
<li>List 2</li>
</ul>
</body>
</html>###mysql查询逗号分隔
SELECT data.id,GROUP_CONCAT(seal.name) AS name
FROM data
left join seal on FIND_IN_SET(seal.id,data.seal_id)
GROUP BY data.id;
seal表
seal_id name
1 合同章
2 财务章
3 法人章
data表
id seal_id
1 1,2
2 1,3
3 1,2,3
如何查询data表连seal表 得到
array(
[0]=>array('id'=1,'name'=合同章,财务章)，
[1]=>array('id'=2,'name'=合同章,法人章 )，
[2]=>array('id'=3,'name'=合同章,财务章,法人章 )，
)###JSON.parse
var a = JSON.parse('{"name":"小明","age":14}',function (key,value) {debugger
if(key === "name"){
return value+"同学";
}
else if(key === ""){return value}
else {return undefined;}
});
// Object {name: "小明同学"}
JSON.parse('{"p": 5}', function (k, v) {
if(k === '') return v; // 如果到了最顶层，则直接返回属性值，
return v * 2; // 否则将属性值变为原来的 2 倍。
}); // { p: 10 }
JSON.parse('{"1": 1, "2": 2,"3": {"4": 4, "5": {"6": 6}}}', function (k, v) {
console.log(k); // 输出当前的属性名，从而得知遍历顺序是从内向外的，
// 最后一个属性名会是个空字符串。
return v; // 返回原始属性值，相当于没有传递 reviver 参数。
});
// 1
// 2
// 4
// 6
// 5
// 3
// ""
遍历的时候，最后一次key是"",需要直接返回原值。
var a = JSON.parse('{"name":"小明","age":14}',function (key,value) {
if(key === "name") return value+"同学";
return value;
});
console.log(a);###判断一个进程是否在运行
[root@nginx conf.d]# ps -aux | grep "nginx" | grep -v "grep"
root 1950 0.0 0.4 47904 2232 ? Ss 03:43 0:00 nginx: master process nginx
nginx 13545 0.0 0.5 48336 2504 ? S 22:27 0:00 nginx: worker process
[root@nginx conf.d]# ps -aux | grep "nginx" | grep -v "grep" > /dev/null
[root@nginx conf.d]# echo $?
0###无限级联动下拉菜单
<script src="js/jquery.js"></script>
<script src="js/comm.js"></script>
<script src="js/linkagesel-min.js"></script>
<script src="js/district-all.js"></script>
<script>
//https://github.com/waitingsong/LinkageSel
$(document).ready(function(){
var data1 = {
1: {name: '蔬菜', cell: { 10: {name: '菠菜', price: 4 }, 11: {name: '茄子', price: 5} }
},
3: {name: '水果',
cell: {
20: {name: '苹果', cell: {201: {name: '红富士', price: 20} } } ,
21: {name: '桃',
cell: {
210: {name: '猕猴桃', price: 30},
211: {name: '油桃', price: 31},
212: {name: '蟠桃', priece: 32} }
}
}
},
9: {name: '粮食',
cell: {
30: {name: '水稻', cell: { 301: {name: '大米', cell: {3001: {name: '五常香米', price: 50}} } } }
}
}
};
var opts = {
data: data1,
select: '#demo1'
};
var linkageSel1 = new LinkageSel(opts);
$('#getSelectedValue').click(function() {
var v = linkageSel.getSelectedValue();
alert(v);
});
$('#getSelectedData').click(function() {
var name = linkageSel.getSelectedData('name'),
price = linkageSel.getSelectedData('price');
alert('名称:' + name + ' 价格:' + price);
});
});
</script>###urllib2.urlopen()相当于python3.X中的urllib.request.urlopen()
使用带参数的GET方法取回URL
>>> import urllib
>>> params = urllib.urlencode({'spam': 1, 'eggs': 2, 'bacon': 0})
>>> f = urllib.urlopen("http://www.musi-cal.com/cgi-bin/query?%s" % params)
>>> print f.read()
使用POST方法
>>> import urllib
>>> params = urllib.urlencode({'spam': 1, 'eggs': 2, 'bacon': 0})
>>> f = urllib.urlopen("http://www.musi-cal.com/cgi-bin/query", params)
>>> print f.read()
使用HTTP代理,自动跟踪重定向
>>> import urllib
>>> proxies = {'http': 'http://proxy.example.com:8080/'}
>>> opener = urllib.FancyURLopener(proxies)
>>> f = opener.open("http://www.python.org")
>>> f.read()
不使用代理
>>> import urllib
>>> opener = urllib.FancyURLopener({})
>>> f = opener.open("http://www.python.org/")
>>> f.read()
GET一个URL
>>> import urllib2
>>> f = urllib2.urlopen('http://www.python.org/')
>>> print f.read()
使用基本的HTTP认证
import urllib2
auth_handler = urllib2.HTTPBasicAuthHandler()
auth_handler.add_password(realm='PDQ Application',
uri='https://mahler:8092/site-updates.py',
user='klem',
passwd='kadidd!ehopper')
opener = urllib2.build_opener(auth_handler)
urllib2.install_opener(opener)
urllib2.urlopen('http://www.example.com/login.html')
build_opener() 默认提供很多处理程序, 包括代理处理程序, 代理默认会被设置为环境变量所提供的.
一个使用代理的例子
proxy_handler = urllib2.ProxyHandler({'http': 'http://www.example.com:3128/'})
proxy_auth_handler = urllib2.ProxyBasicAuthHandler()
proxy_auth_handler.add_password('realm', 'host', 'username', 'password')
opener = urllib2.build_opener(proxy_handler, proxy_auth_handler)
opener.open('http://www.example.com/login.html')
添加HTTP请求头部
import urllib2
req = urllib2.Request('http://www.example.com/')
req.add_header('Referer', 'http://www.python.org/')
r = urllib2.urlopen(req)
更改User-agent
import urllib2
opener = urllib2.build_opener()
opener.addheaders = [('User-agent', 'Mozilla/5.0')]
opener.open('http://www.example.com/')初始状态只有函数有prototype.
实例的__proto__指向其构造函数的prototype.
函数也有__proto__因为函数是Function函数构造函数的实例。
var obj = {};
//等价与
var obj = new Object();
function fn() {};
var fn = new Function();###数组遍历
var arr = [{
s: 8,
e: 16
}, {
s: 17,
e: 23.5
}, {
s: 7,
e: 11
}, {
s: 23.5,
e: 24
}, {
s: 23.5,
e: 24
},{
s: 4,
e: 5
},{
s: 3,
e: 4.5
}];
arr.sort(function(a,b){
return a.s == b.s ? a.e - b.e : a.s - b.s
});
for(item of arr)console.log(item);
var result = [];
while(arr.length){
var obj = arr[0];
arr.splice(0,1);
for(var i = 0 ; i < arr.length ; i ++){
var cur = arr[i];
if(cur.s > obj.e){
result.push(obj);
break;
}else if(cur.e >= obj.e){
obj.e = cur.e;
arr.splice(i--,1);
}else{
arr.splice(i--,1);
}
}
}
result.push(obj); [{s:7,e:24},{3,5}]
mysql> show variables like "sql_mode";
+---------------+--------------------------------------------+
| Variable_name | Value |
+---------------+--------------------------------------------+
| sql_mode | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+---------------+--------------------------------------------+
NOT NULL 列没有默认值但代码里也没给值，在非严格模式下，int列默认为0，string列默认为’’了，所以不成问题；但在严格模式下，是直接返回失败的。
mysql配置文件的加载顺序：
$ mysqld --help --verbose|grep -A1 -B1 cnf
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
mysql按照上面的顺序加载配置文件，后面的配置项会覆盖前面的。最后终于在 /usr/my.cnf 找到有一条sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES，把这个文件删掉，/etc/my.cnf 里面的就生效了。
存储过程里把 ‘’ 传给int型的，严格模式是不允许，而非严格模式只是一个warning。（命令行执行完语句后，show warnings 可看见）
那么解决这类问题的终极（推荐）办法其实是，考虑到数据的兼容性和准确性，MySQL就应该运行在严格模式下！无论开发环境还是生产环境，否则代码移植到线上可能产生隐藏的问题。
查看当前连接会话的sql模式：
mysql> select @@session.sql_mode;
或者从环境变量里取
mysql> show variables like "sql_mode";
查看全局sql_mode设置：
mysql> select @@global.sql_mode;
只设置global，需要重新连接进来才会生效###无限分类
$tree = [
[
"id" => 4583,
"menu_id" => 1,
"role_id" => 1,
"type" => "admin",
"created_at" => "-0001-11-30 00:00:00",
"updated_at" => "-0001-11-30 00:00:00",
"menu" =>[
"id" => 1,
"name" => "后台首页",
"url" => "0",
"parent_id" => 0,
"created_at" => "2015-05-15 18:13:12",
"updated_at" => "2015-08-25 15:12:20",
]
],
[
"id" => 4584,
"menu_id" => 3,
"role_id" => 1,
"type" => "admin",
"created_at" => "-0001-11-30 00:00:00",
"updated_at" => "-0001-11-30 00:00:00",
"menu" => [
"id" => 3,
"name" => "用户管理",
"url" => "0",
"parent_id" => 0,
"created_at" => "2015-05-15 18:13:30",
"updated_at" => "2015-05-15 18:13:33",
]
],
[
"id" => 4586,
"menu_id" => 5,
"role_id" => 1,
"type" => "admin",
"created_at" => "-0001-11-30 00:00:00",
"updated_at" => "-0001-11-30 00:00:00",
"menu" => [
"id" => 5,
"name" => "用户管理",
"url" => "/admin",
"parent_id" => 3,
"created_at" => "2015-05-15 18:13:30",
"updated_at" => "2015-05-15 18:13:33",
]
]
];
$data = [];
foreach($tree as $key=>$val){
$temp=$val['menu'];
if(empty($temp)){
continue;
}
if(!empty($temp['url']) && !empty($temp['parent_id'])){
$data[$temp['parent_id']]['children'][$temp['id']] = $temp;
}else{
$data[$temp['id']]['parent'] = $temp;
}
}
print_r($data);
Array
(
[1] => Array
(
[parent] => Array
(
[id] => 1
[name] => 后台首页
[url] => 0
[parent_id] => 0
[created_at] => 2015-05-15 18:13:12
[updated_at] => 2015-08-25 15:12:20
)
)
[3] => Array
(
[parent] => Array
(
[id] => 3
[name] => 用户管理
[url] => 0
[parent_id] => 0
[created_at] => 2015-05-15 18:13:30
[updated_at] => 2015-05-15 18:13:33
)
[children] => Array
(
[5] => Array
(
[id] => 5
[name] => 用户管理
[url] => /admin
[parent_id] => 3
[created_at] => 2015-05-15 18:13:30
[updated_at] => 2015-05-15 18:13:33
)
)
)
)
授权菜单：
后台首页
默认首页
用户管理
用户列表 付费会员
菜单管理
菜单列表 添加菜单 角色分配 用户授权 内部用(权限标识，不是产品