鍍金池/ 問(wèn)答/ PHP問(wèn)答
凹凸曼 回答
  1. 使用MySQL中間件分表 (可以按月分表) (不是比較好的解決方案)
  2. 建議使用分布式數(shù)據(jù)庫(kù) 例如TiDB 或者阿里云的商用分布式數(shù)據(jù)庫(kù)

https://mp.weixin.qq.com/debu...

recorderManager.start(options) ,那個(gè)只是個(gè)回調(diào)函數(shù)吧,當(dāng)錄音開(kāi)始的時(shí)候就會(huì)調(diào)用那個(gè)函數(shù)。

尐潴豬 回答

max系統(tǒng)上可以訪問(wèn)鏡像里面的MySQL數(shù)據(jù)庫(kù) ,但是端口必須映射到本地的端口才能使用本地地址訪問(wèn)

九年囚 回答

當(dāng)你決定使用存儲(chǔ)過(guò)程的時(shí)候,那么整個(gè)事務(wù)是在MYSQL端完成的。

對(duì)于事務(wù)競(jìng)爭(zhēng)優(yōu)化的主要一點(diǎn)就是減少事務(wù)鎖時(shí)間。

你選擇了使用存儲(chǔ)過(guò)程就可以不用再代碼中開(kāi)啟事務(wù),深度優(yōu)化即將事務(wù)SQL在MYSQL端執(zhí)行(存儲(chǔ)過(guò)程)

以下是類似的秒殺事務(wù)落地的存儲(chǔ)過(guò)程

-- 秒殺執(zhí)行存儲(chǔ)過(guò)程
DELIMITER $$ -- ; 轉(zhuǎn)換為 $$
-- 定義存儲(chǔ)過(guò)程 in 輸入?yún)?shù)   out 輸出參數(shù)
-- ROW_COUNT 返回上一條修改類型sql(delete、insert、update)的影響函數(shù)
-- row_count 0 未修改數(shù)據(jù) >0修改的函數(shù) <0 SQL錯(cuò)誤、未執(zhí)行修改sql
CREATE PROCEDURE `seckill`.`execute_seckill`
  (in v_seckill_id bigint,in v_phone bigint,
    in v_kill_time TIMESTAMP ,out r_result int)
  BEGIN
    DECLARE insert_count int DEFAULT 0;
    START TRANSACTION ;
    insert ignore into success_killed
      (seckill_id,user_phone,create_time)
      VALUES (v_seckill_id,v_phone,v_kill_time)
    select ROW_COUNT() into insert_count;
    if (insert_count = 0) THEN
      ROLLBACK;
      set r_result = -1;
    ElSEIF(insert_count < 0) THEN
      ROLLBACK;
      set r_result = -2;
    ELSE
      UPDATE seckill
      set number = number - 1
      where seckill_id = v_seckill_id
        and end_time > v_kill_time
        and start_time < v_kill_time
        and number > 0;
        SELECT row_count() into insert_count;
        if (insert_count = 0) THEN
          ROLLBACK;
          set r_result = 0;
        ElSEIF(insert_count < 0) THEN
          ROLLBACK;
          set r_result = -2;
        ELSE
          COMMIT;
          SET r_result = 1;
        END if;
    END if;
  END;
$$
-- 存儲(chǔ)過(guò)程定義結(jié)束

DELIMITER ;

set @r_result=-3;
-- 執(zhí)行存儲(chǔ)過(guò)程
call execute_seckill(1003,18820116735,now(),@r_result);

-- 獲取結(jié)果
select @r_result;

這屬于并發(fā)優(yōu)化的階段了,不要過(guò)度依賴存儲(chǔ)過(guò)程,其一般用于簡(jiǎn)單的邏輯

使勁操 回答

之前做過(guò)這種需要,我們的實(shí)時(shí)性可能比你的要求高一點(diǎn)。我是將發(fā)的內(nèi)容和時(shí)間放在了rabbitMQ里面,開(kāi)了多個(gè)worker去拿取數(shù)據(jù)處理。

薄荷糖 回答

沒(méi)人知道嗎 ?求幫助

悶油瓶 回答

我最近也寫(xiě)過(guò)一個(gè)類似模擬登錄的,由于你的html里面已經(jīng)有Modulus和Exponent了,你可以直接利用rsa庫(kù)對(duì)密碼進(jìn)行加密。我用的是nodejs自己封裝的,PHP的應(yīng)該也有。

var RSAUtils = {};

var biRadixBase = 2;
var biRadixBits = 16;
var bitsPerDigit = biRadixBits;
var biRadix = 1 << 16; // = 2^16 = 65536
var biHalfRadix = biRadix >>> 1;
var biRadixSquared = biRadix * biRadix;
var maxDigitVal = biRadix - 1;
var maxInteger = 9999999999999998;

//1024 * 2 / 16 = 128 digits of storage.
//
var maxDigits;
var ZERO_ARRAY;
var bigZero, bigOne;

RSAUtils.BigInt = function(flag) {
  if (typeof flag == "boolean" && flag == true) {
    this.digits = null;
  } else {
    this.digits = ZERO_ARRAY.slice(0);
  }
  this.isNeg = false;
};

RSAUtils.setMaxDigits = function(value) {
  maxDigits = value;
  ZERO_ARRAY = new Array(maxDigits);
  for (var iza = 0; iza < ZERO_ARRAY.length; iza++) ZERO_ARRAY[iza] = 0;
  bigZero = new RSAUtils.BigInt();
  bigOne = new RSAUtils.BigInt();
  bigOne.digits[0] = 1;
};
RSAUtils.setMaxDigits(20);

//The maximum number of digits in base 10 you can convert to an
//integer without JavaScript throwing up on you.
var dpl10 = 15;

RSAUtils.biFromNumber = function(i) {
  var result = new RSAUtils.BigInt();
  result.isNeg = i < 0;
  i = Math.abs(i);
  var j = 0;
  while (i > 0) {
    result.digits[j++] = i & maxDigitVal;
    i = Math.floor(i / biRadix);
  }
  return result;
};

//lr10 = 10 ^ dpl10
var lr10 = RSAUtils.biFromNumber(1000000000000000);

RSAUtils.biFromDecimal = function(s) {
  var isNeg = s.charAt(0) == '-';
  var i = isNeg ? 1 : 0;
  var result;
  // Skip leading zeros.
  while (i < s.length && s.charAt(i) == '0') ++i;
  if (i == s.length) {
    result = new RSAUtils.BigInt();
  }
  else {
    var digitCount = s.length - i;
    var fgl = digitCount % dpl10;
    if (fgl == 0) fgl = dpl10;
    result = RSAUtils.biFromNumber(Number(s.substr(i, fgl)));
    i += fgl;
    while (i < s.length) {
      result = RSAUtils.biAdd(RSAUtils.biMultiply(result, lr10),
        RSAUtils.biFromNumber(Number(s.substr(i, dpl10))));
      i += dpl10;
    }
    result.isNeg = isNeg;
  }
  return result;
};

RSAUtils.biCopy = function(bi) {
  var result = new RSAUtils.BigInt(true);
  result.digits = bi.digits.slice(0);
  result.isNeg = bi.isNeg;
  return result;
};

RSAUtils.reverseStr = function(s) {
  var result = "";
  for (var i = s.length - 1; i > -1; --i) {
    result += s.charAt(i);
  }
  return result;
};

var hexatrigesimalToChar = [
  '0', '1', '2', '3', '4', '5', '6', '7', '8', '9',
  'a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j',
  'k', 'l', 'm', 'n', 'o', 'p', 'q', 'r', 's', 't',
  'u', 'v', 'w', 'x', 'y', 'z'
];

RSAUtils.biToString = function(x, radix) { // 2 <= radix <= 36
  var b = new RSAUtils.BigInt();
  b.digits[0] = radix;
  var qr = RSAUtils.biDivideModulo(x, b);
  var result = hexatrigesimalToChar[qr[1].digits[0]];
  while (RSAUtils.biCompare(qr[0], bigZero) == 1) {
    qr = RSAUtils.biDivideModulo(qr[0], b);
    digit = qr[1].digits[0];
    result += hexatrigesimalToChar[qr[1].digits[0]];
  }
  return (x.isNeg ? "-" : "") + RSAUtils.reverseStr(result);
};

RSAUtils.biToDecimal = function(x) {
  var b = new RSAUtils.BigInt();
  b.digits[0] = 10;
  var qr = RSAUtils.biDivideModulo(x, b);
  var result = String(qr[1].digits[0]);
  while (RSAUtils.biCompare(qr[0], bigZero) == 1) {
    qr = RSAUtils.biDivideModulo(qr[0], b);
    result += String(qr[1].digits[0]);
  }
  return (x.isNeg ? "-" : "") + RSAUtils.reverseStr(result);
};

var hexToChar = ['0', '1', '2', '3', '4', '5', '6', '7', '8', '9',
  'a', 'b', 'c', 'd', 'e', 'f'];

RSAUtils.digitToHex = function(n) {
  var mask = 0xf;
  var result = "";
  for (i = 0; i < 4; ++i) {
    result += hexToChar[n & mask];
    n >>>= 4;
  }
  return RSAUtils.reverseStr(result);
};

RSAUtils.biToHex = function(x) {
  var result = "";
  var n = RSAUtils.biHighIndex(x);
  for (var i = RSAUtils.biHighIndex(x); i > -1; --i) {
    result += RSAUtils.digitToHex(x.digits[i]);
  }
  return result;
};

RSAUtils.charToHex = function(c) {
  var ZERO = 48;
  var NINE = ZERO + 9;
  var littleA = 97;
  var littleZ = littleA + 25;
  var bigA = 65;
  var bigZ = 65 + 25;
  var result;

  if (c >= ZERO && c <= NINE) {
    result = c - ZERO;
  } else if (c >= bigA && c <= bigZ) {
    result = 10 + c - bigA;
  } else if (c >= littleA && c <= littleZ) {
    result = 10 + c - littleA;
  } else {
    result = 0;
  }
  return result;
};

RSAUtils.hexToDigit = function(s) {
  var result = 0;
  var sl = Math.min(s.length, 4);
  for (var i = 0; i < sl; ++i) {
    result <<= 4;
    result |= RSAUtils.charToHex(s.charCodeAt(i));
  }
  return result;
};

RSAUtils.biFromHex = function(s) {
  var result = new RSAUtils.BigInt();
  var sl = s.length;
  for (var i = sl, j = 0; i > 0; i -= 4, ++j) {
    result.digits[j] = RSAUtils.hexToDigit(s.substr(Math.max(i - 4, 0), Math.min(i, 4)));
  }
  return result;
};

RSAUtils.biFromString = function(s, radix) {
  var isNeg = s.charAt(0) == '-';
  var istop = isNeg ? 1 : 0;
  var result = new RSAUtils.BigInt();
  var place = new RSAUtils.BigInt();
  place.digits[0] = 1; // radix^0
  for (var i = s.length - 1; i >= istop; i--) {
    var c = s.charCodeAt(i);
    var digit = RSAUtils.charToHex(c);
    var biDigit = RSAUtils.biMultiplyDigit(place, digit);
    result = RSAUtils.biAdd(result, biDigit);
    place = RSAUtils.biMultiplyDigit(place, radix);
  }
  result.isNeg = isNeg;
  return result;
};

RSAUtils.biDump = function(b) {
  return (b.isNeg ? "-" : "") + b.digits.join(" ");
};

RSAUtils.biAdd = function(x, y) {
  var result;

  if (x.isNeg != y.isNeg) {
    y.isNeg = !y.isNeg;
    result = RSAUtils.biSubtract(x, y);
    y.isNeg = !y.isNeg;
  }
  else {
    result = new RSAUtils.BigInt();
    var c = 0;
    var n;
    for (var i = 0; i < x.digits.length; ++i) {
      n = x.digits[i] + y.digits[i] + c;
      result.digits[i] = n % biRadix;
      c = Number(n >= biRadix);
    }
    result.isNeg = x.isNeg;
  }
  return result;
};

RSAUtils.biSubtract = function(x, y) {
  var result;
  if (x.isNeg != y.isNeg) {
    y.isNeg = !y.isNeg;
    result = RSAUtils.biAdd(x, y);
    y.isNeg = !y.isNeg;
  } else {
    result = new RSAUtils.BigInt();
    var n, c;
    c = 0;
    for (var i = 0; i < x.digits.length; ++i) {
      n = x.digits[i] - y.digits[i] + c;
      result.digits[i] = n % biRadix;
      // Stupid non-conforming modulus operation.
      if (result.digits[i] < 0) result.digits[i] += biRadix;
      c = 0 - Number(n < 0);
    }
    // Fix up the negative sign, if any.
    if (c == -1) {
      c = 0;
      for (var i = 0; i < x.digits.length; ++i) {
        n = 0 - result.digits[i] + c;
        result.digits[i] = n % biRadix;
        // Stupid non-conforming modulus operation.
        if (result.digits[i] < 0) result.digits[i] += biRadix;
        c = 0 - Number(n < 0);
      }
      // Result is opposite sign of arguments.
      result.isNeg = !x.isNeg;
    } else {
      // Result is same sign.
      result.isNeg = x.isNeg;
    }
  }
  return result;
};

RSAUtils.biHighIndex = function(x) {
  var result = x.digits.length - 1;
  while (result > 0 && x.digits[result] == 0) --result;
  return result;
};

RSAUtils.biNumBits = function(x) {
  var n = RSAUtils.biHighIndex(x);
  var d = x.digits[n];
  var m = (n + 1) * bitsPerDigit;
  var result;
  for (result = m; result > m - bitsPerDigit; --result) {
    if ((d & 0x8000) != 0) break;
    d <<= 1;
  }
  return result;
};

RSAUtils.biMultiply = function(x, y) {
  var result = new RSAUtils.BigInt();
  var c;
  var n = RSAUtils.biHighIndex(x);
  var t = RSAUtils.biHighIndex(y);
  var u, uv, k;

  for (var i = 0; i <= t; ++i) {
    c = 0;
    k = i;
    for (j = 0; j <= n; ++j, ++k) {
      uv = result.digits[k] + x.digits[j] * y.digits[i] + c;
      result.digits[k] = uv & maxDigitVal;
      c = uv >>> biRadixBits;
      //c = Math.floor(uv / biRadix);
    }
    result.digits[i + n + 1] = c;
  }
  // Someone give me a logical xor, please.
  result.isNeg = x.isNeg != y.isNeg;
  return result;
};

RSAUtils.biMultiplyDigit = function(x, y) {
  var n, c, uv;

  result = new RSAUtils.BigInt();
  n = RSAUtils.biHighIndex(x);
  c = 0;
  for (var j = 0; j <= n; ++j) {
    uv = result.digits[j] + x.digits[j] * y + c;
    result.digits[j] = uv & maxDigitVal;
    c = uv >>> biRadixBits;
    //c = Math.floor(uv / biRadix);
  }
  result.digits[1 + n] = c;
  return result;
};

RSAUtils.arrayCopy = function(src, srcStart, dest, destStart, n) {
  var m = Math.min(srcStart + n, src.length);
  for (var i = srcStart, j = destStart; i < m; ++i, ++j) {
    dest[j] = src[i];
  }
};

var highBitMasks = [0x0000, 0x8000, 0xC000, 0xE000, 0xF000, 0xF800,
  0xFC00, 0xFE00, 0xFF00, 0xFF80, 0xFFC0, 0xFFE0,
  0xFFF0, 0xFFF8, 0xFFFC, 0xFFFE, 0xFFFF];

RSAUtils.biShiftLeft = function(x, n) {
  var digitCount = Math.floor(n / bitsPerDigit);
  var result = new RSAUtils.BigInt();
  RSAUtils.arrayCopy(x.digits, 0, result.digits, digitCount,
    result.digits.length - digitCount);
  var bits = n % bitsPerDigit;
  var rightBits = bitsPerDigit - bits;
  for (var i = result.digits.length - 1, i1 = i - 1; i > 0; --i, --i1) {
    result.digits[i] = ((result.digits[i] << bits) & maxDigitVal) |
      ((result.digits[i1] & highBitMasks[bits]) >>>
        (rightBits));
  }
  result.digits[0] = ((result.digits[i] << bits) & maxDigitVal);
  result.isNeg = x.isNeg;
  return result;
};

var lowBitMasks = [0x0000, 0x0001, 0x0003, 0x0007, 0x000F, 0x001F,
  0x003F, 0x007F, 0x00FF, 0x01FF, 0x03FF, 0x07FF,
  0x0FFF, 0x1FFF, 0x3FFF, 0x7FFF, 0xFFFF];

RSAUtils.biShiftRight = function(x, n) {
  var digitCount = Math.floor(n / bitsPerDigit);
  var result = new RSAUtils.BigInt();
  RSAUtils.arrayCopy(x.digits, digitCount, result.digits, 0,
    x.digits.length - digitCount);
  var bits = n % bitsPerDigit;
  var leftBits = bitsPerDigit - bits;
  for (var i = 0, i1 = i + 1; i < result.digits.length - 1; ++i, ++i1) {
    result.digits[i] = (result.digits[i] >>> bits) |
      ((result.digits[i1] & lowBitMasks[bits]) << leftBits);
  }
  result.digits[result.digits.length - 1] >>>= bits;
  result.isNeg = x.isNeg;
  return result;
};

RSAUtils.biMultiplyByRadixPower = function(x, n) {
  var result = new RSAUtils.BigInt();
  RSAUtils.arrayCopy(x.digits, 0, result.digits, n, result.digits.length - n);
  return result;
};

RSAUtils.biDivideByRadixPower = function(x, n) {
  var result = new RSAUtils.BigInt();
  RSAUtils.arrayCopy(x.digits, n, result.digits, 0, result.digits.length - n);
  return result;
};

RSAUtils.biModuloByRadixPower = function(x, n) {
  var result = new RSAUtils.BigInt();
  RSAUtils.arrayCopy(x.digits, 0, result.digits, 0, n);
  return result;
};

RSAUtils.biCompare = function(x, y) {
  if (x.isNeg != y.isNeg) {
    return 1 - 2 * Number(x.isNeg);
  }
  for (var i = x.digits.length - 1; i >= 0; --i) {
    if (x.digits[i] != y.digits[i]) {
      if (x.isNeg) {
        return 1 - 2 * Number(x.digits[i] > y.digits[i]);
      } else {
        return 1 - 2 * Number(x.digits[i] < y.digits[i]);
      }
    }
  }
  return 0;
};

RSAUtils.biDivideModulo = function(x, y) {
  var nb = RSAUtils.biNumBits(x);
  var tb = RSAUtils.biNumBits(y);
  var origYIsNeg = y.isNeg;
  var q, r;
  if (nb < tb) {
    // |x| < |y|
    if (x.isNeg) {
      q = RSAUtils.biCopy(bigOne);
      q.isNeg = !y.isNeg;
      x.isNeg = false;
      y.isNeg = false;
      r = biSubtract(y, x);
      // Restore signs, 'cause they're references.
      x.isNeg = true;
      y.isNeg = origYIsNeg;
    } else {
      q = new RSAUtils.BigInt();
      r = RSAUtils.biCopy(x);
    }
    return [q, r];
  }

  q = new RSAUtils.BigInt();
  r = x;

  // Normalize Y.
  var t = Math.ceil(tb / bitsPerDigit) - 1;
  var lambda = 0;
  while (y.digits[t] < biHalfRadix) {
    y = RSAUtils.biShiftLeft(y, 1);
    ++lambda;
    ++tb;
    t = Math.ceil(tb / bitsPerDigit) - 1;
  }
  // Shift r over to keep the quotient constant. We'll shift the
  // remainder back at the end.
  r = RSAUtils.biShiftLeft(r, lambda);
  nb += lambda; // Update the bit count for x.
  var n = Math.ceil(nb / bitsPerDigit) - 1;

  var b = RSAUtils.biMultiplyByRadixPower(y, n - t);
  while (RSAUtils.biCompare(r, b) != -1) {
    ++q.digits[n - t];
    r = RSAUtils.biSubtract(r, b);
  }
  for (var i = n; i > t; --i) {
    var ri = (i >= r.digits.length) ? 0 : r.digits[i];
    var ri1 = (i - 1 >= r.digits.length) ? 0 : r.digits[i - 1];
    var ri2 = (i - 2 >= r.digits.length) ? 0 : r.digits[i - 2];
    var yt = (t >= y.digits.length) ? 0 : y.digits[t];
    var yt1 = (t - 1 >= y.digits.length) ? 0 : y.digits[t - 1];
    if (ri == yt) {
      q.digits[i - t - 1] = maxDigitVal;
    } else {
      q.digits[i - t - 1] = Math.floor((ri * biRadix + ri1) / yt);
    }

    var c1 = q.digits[i - t - 1] * ((yt * biRadix) + yt1);
    var c2 = (ri * biRadixSquared) + ((ri1 * biRadix) + ri2);
    while (c1 > c2) {
      --q.digits[i - t - 1];
      c1 = q.digits[i - t - 1] * ((yt * biRadix) | yt1);
      c2 = (ri * biRadix * biRadix) + ((ri1 * biRadix) + ri2);
    }

    b = RSAUtils.biMultiplyByRadixPower(y, i - t - 1);
    r = RSAUtils.biSubtract(r, RSAUtils.biMultiplyDigit(b, q.digits[i - t - 1]));
    if (r.isNeg) {
      r = RSAUtils.biAdd(r, b);
      --q.digits[i - t - 1];
    }
  }
  r = RSAUtils.biShiftRight(r, lambda);
  // Fiddle with the signs and stuff to make sure that 0 <= r < y.
  q.isNeg = x.isNeg != origYIsNeg;
  if (x.isNeg) {
    if (origYIsNeg) {
      q = RSAUtils.biAdd(q, bigOne);
    } else {
      q = RSAUtils.biSubtract(q, bigOne);
    }
    y = RSAUtils.biShiftRight(y, lambda);
    r = RSAUtils.biSubtract(y, r);
  }
  // Check for the unbelievably stupid degenerate case of r == -0.
  if (r.digits[0] == 0 && RSAUtils.biHighIndex(r) == 0) r.isNeg = false;

  return [q, r];
};

RSAUtils.biDivide = function(x, y) {
  return RSAUtils.biDivideModulo(x, y)[0];
};

RSAUtils.biModulo = function(x, y) {
  return RSAUtils.biDivideModulo(x, y)[1];
};

RSAUtils.biMultiplyMod = function(x, y, m) {
  return RSAUtils.biModulo(RSAUtils.biMultiply(x, y), m);
};

RSAUtils.biPow = function(x, y) {
  var result = bigOne;
  var a = x;
  while (true) {
    if ((y & 1) != 0) result = RSAUtils.biMultiply(result, a);
    y >>= 1;
    if (y == 0) break;
    a = RSAUtils.biMultiply(a, a);
  }
  return result;
};

RSAUtils.biPowMod = function(x, y, m) {
  var result = bigOne;
  var a = x;
  var k = y;
  while (true) {
    if ((k.digits[0] & 1) != 0) result = RSAUtils.biMultiplyMod(result, a, m);
    k = RSAUtils.biShiftRight(k, 1);
    if (k.digits[0] == 0 && RSAUtils.biHighIndex(k) == 0) break;
    a = RSAUtils.biMultiplyMod(a, a, m);
  }
  return result;
};


RSAUtils.BarrettMu = function(m) {
  this.modulus = RSAUtils.biCopy(m);
  this.k = RSAUtils.biHighIndex(this.modulus) + 1;
  var b2k = new RSAUtils.BigInt();
  b2k.digits[2 * this.k] = 1; // b2k = b^(2k)
  this.mu = RSAUtils.biDivide(b2k, this.modulus);
  this.bkplus1 = new RSAUtils.BigInt();
  this.bkplus1.digits[this.k + 1] = 1; // bkplus1 = b^(k+1)
  this.modulo = RSAUtils.BarrettMu_modulo;
  this.multiplyMod = RSAUtils.BarrettMu_multiplyMod;
  this.powMod = RSAUtils.BarrettMu_powMod;
};

RSAUtils.BarrettMu_modulo = function(x) {
  var q1 = RSAUtils.biDivideByRadixPower(x, this.k - 1);
  var q2 = RSAUtils.biMultiply(q1, this.mu);
  var q3 = RSAUtils.biDivideByRadixPower(q2, this.k + 1);
  var r1 = RSAUtils.biModuloByRadixPower(x, this.k + 1);
  var r2term = RSAUtils.biMultiply(q3, this.modulus);
  var r2 = RSAUtils.biModuloByRadixPower(r2term, this.k + 1);
  var r = RSAUtils.biSubtract(r1, r2);
  if (r.isNeg) {
    r = RSAUtils.biAdd(r, this.bkplus1);
  }
  var rgtem = RSAUtils.biCompare(r, this.modulus) >= 0;
  while (rgtem) {
    r = RSAUtils.biSubtract(r, this.modulus);
    rgtem = RSAUtils.biCompare(r, this.modulus) >= 0;
  }
  return r;
}

RSAUtils.BarrettMu_multiplyMod = function(x, y) {
  /*
    x = this.modulo(x);
    y = this.modulo(y);
    */
  var xy = RSAUtils.biMultiply(x, y);
  return this.modulo(xy);
}

RSAUtils.BarrettMu_powMod = function(x, y) {
  var result = new RSAUtils.BigInt();
  result.digits[0] = 1;
  var a = x;
  var k = y;
  while (true) {
    if ((k.digits[0] & 1) != 0) result = this.multiplyMod(result, a);
    k = RSAUtils.biShiftRight(k, 1);
    if (k.digits[0] == 0 && RSAUtils.biHighIndex(k) == 0) break;
    a = this.multiplyMod(a, a);
  }
  return result;
}

function RSAKeyPair(encryptionExponent, decryptionExponent, modulus) {
  this.e = RSAUtils.biFromHex(encryptionExponent);
  this.d = RSAUtils.biFromHex(decryptionExponent);
  this.m = RSAUtils.biFromHex(modulus);
  // We can do two bytes per digit, so
  // chunkSize = 2 * (number of digits in modulus - 1).
  // Since biHighIndex returns the high index, not the number of digits, 1 has
  // already been subtracted.
  this.chunkSize = 2 * RSAUtils.biHighIndex(this.m);
  this.radix = 16;
  this.barrett = new RSAUtils.BarrettMu(this.m);
};

RSAUtils.getKeyPair = function(encryptionExponent, decryptionExponent, modulus) {
  return new RSAKeyPair(encryptionExponent, decryptionExponent, modulus);
};

RSAUtils.twoDigit = function(n) {
  return (n < 10 ? "0" : "") + String(n);
};

RSAUtils.encryptedString = function(key, s) {
  var a = [];
  var sl = s.length;
  var i = 0;
  while (i < sl) {
    a[i] = s.charCodeAt(i);
    i++;
  }

  while (a.length % key.chunkSize != 0) {
    a[i++] = 0;
  }

  var al = a.length;
  var result = "";
  var j, k, block;
  for (i = 0; i < al; i += key.chunkSize) {
    block = new RSAUtils.BigInt();
    j = 0;
    for (k = i; k < i + key.chunkSize; ++j) {
      block.digits[j] = a[k++];
      block.digits[j] += a[k++] << 8;
    }
    var crypt = key.barrett.powMod(block, key.e);
    var text = key.radix == 16 ? RSAUtils.biToHex(crypt) : RSAUtils.biToString(crypt, key.radix);
    result += text + " ";
  }
  return result.substring(0, result.length - 1); // Remove last space.
};

RSAUtils.decryptedString = function(key, s) {
  var blocks = s.split(" ");
  var result = "";
  var i, j, block;
  for (i = 0; i < blocks.length; ++i) {
    var bi;
    if (key.radix == 16) {
      bi = RSAUtils.biFromHex(blocks[i]);
    }
    else {
      bi = RSAUtils.biFromString(blocks[i], key.radix);
    }
    block = key.barrett.powMod(bi, key.d);
    for (j = 0; j <= RSAUtils.biHighIndex(block); ++j) {
      result += String.fromCharCode(block.digits[j] & 255,
        block.digits[j] >> 8);
    }
  }
  // Remove trailing null, if any.
  if (result.charCodeAt(result.length - 1) == 0) {
    result = result.substring(0, result.length - 1);
  }
  return result;
};

RSAUtils.setMaxDigits(130);

module.exports = RSAUtils;

使用方式也:

var RSAUtils = require('./RSA')

// 獲取RSA的公鑰,計(jì)算加密后的用戶名、密碼
function step_2(result) {
  return new Promise((resolve, reject) => {
    console.log(`即將訪問(wèn):${url_get_key}`)
    request.post({
      url: url_get_key
    }, (err, r, body) => {
      let publicKeyModulus, publicKeyExponent
      let obj = JSON.parse(body)
      publicKeyModulus = obj.publicKeyModulus
      publicKeyExponent = obj.publicKeyExponent
      let key = new RSAUtils.getKeyPair(publicKeyExponent, '', publicKeyModulus)
      let username_encrypted = RSAUtils.encryptedString(key, user_name.split('').reverse().join(''))
      let passwd_encrypted = RSAUtils.encryptedString(key, passwd.split('').reverse().join(''))
      result.publicKeyModulus = publicKeyModulus
      result.publicKeyExponent = publicKeyExponent
      result.username_encrypted = username_encrypted
      result.passwd_encrypted = passwd_encrypted
      resolve(result)
    })
  })
}
心上人 回答
$arr = $arr['data'];

$arr1 = array_filter($arr, function ($item){
    return $item['symbol'] == 'BTC';
});
var_dump($arr1);

/<a.+title="?(.+.(source|plan|unit|e_keywordid)).+?.".+href/i
錯(cuò)誤的

短嘆 回答

workerman更新后有變化,最后按workerman官網(wǎng)文檔上的安裝方式使用

a標(biāo)簽有個(gè)download的屬性

<a href="images/tupian.jpg" download="tupian">下載圖片</a>
哚蕾咪 回答

git-bash里沒(méi)有環(huán)境變量吧

冷溫柔 回答

select count(*) from table_name where ~~~
手機(jī)碼字,大概意思是這樣

雨蝶 回答

你是要用CREATE TABLE table_name1 AS SELECT * from table_name2

悶騷型 回答

在模型中 請(qǐng)使用 protected $name='member';(會(huì)自動(dòng)加前綴)
或者 protected $table='addons_member';(不會(huì)自動(dòng)加前綴)

影魅 回答

這是PHP?
我一個(gè)菜逼前端 BB一句?
是不是 $this 指向的問(wèn)題?

網(wǎng)妓 回答

1.文檔里說(shuō)的如果是snsapi_base就給你openid是什么意思???snsapi_userinfo也給的?。。。?br>兩種都給,沒(méi)說(shuō)snsapi_userinfo不給。
2.snsapi_base是靜默授權(quán),而且也可以獲得用來(lái)?yè)Q取用戶信息code,這對(duì)用戶來(lái)說(shuō)豈不是很危險(xiǎn)???
snsapi_base不可以獲取用戶信息。
3.《snsapi_base式的網(wǎng)頁(yè)授權(quán)流程即到此為止》是什么意思???我明明還想獲取用戶信息,為什么讓我到此為止???
到此為止是因?yàn)槟阋呀?jīng)拿到了openid,再往下走就是獲取用戶信息了,和snsapi_base沒(méi)關(guān)系,所以結(jié)束了。
想要獲取用戶信息需要用snsapi_userinfo參數(shù)。
好好用心看文檔。

神曲 回答

Xdebug

可以通過(guò)來(lái)服務(wù)端安裝Xdebug來(lái)實(shí)現(xiàn)遠(yuǎn)程調(diào)試,但是難點(diǎn)就在于PHP的遠(yuǎn)程調(diào)試很難安裝,嘗試過(guò)好幾次都不成功,這得歸功于現(xiàn)在的服務(wù)器提供商的安全策略 能有100+種方式讓你調(diào)不通,當(dāng)然 除了這種方式 就還有一種更暴力的方式。

var_dump

畢竟php的代碼不需要編譯后執(zhí)行 所以可以直接修改后就能看到結(jié)果。這樣 就可以打開(kāi)開(kāi)發(fā)工具的自動(dòng)部署功能,通過(guò)FTP或者SFTP 連接上遠(yuǎn)程服務(wù)器。首先 為了能夠重現(xiàn)你手機(jī)發(fā)出的請(qǐng)求,你就需要一個(gè)抓包工具 且支持重放的,比如 Fiddler,然后 在編輯器一步步var_dump,然后 通過(guò)Fiddler 選中請(qǐng)求 按下 R 鍵 重放請(qǐng)求,直到調(diào)出結(jié)果為止。

PHP Debug Bar

PHP Debug Bar

如果是Laravel項(xiàng)目 還有

Laravel-debugbar

【擴(kuò)展推薦】Laravel-debugbar 開(kāi)發(fā)調(diào)試?yán)?/a>