代码片段仓库

-- 获取用户及其订单信息
SELECT 
    u.id AS user_id,
    u.name AS user_name,
    o.id AS order_id,
    o.amount,
    o.order_date
FROM 
    users u
JOIN 
    orders o ON u.id = o.user_id
WHERE 
    u.status = 'active'
ORDER BY 
    o.order_date DESC;

// 使用Fetch API发送POST请求
fetch('/api/data', {
    method: 'POST',
    headers: {
        'Content-Type': 'application/json'
    },
    body: JSON.stringify({
        key: 'value'
    })
})
.then(response => response.json())
.then(data => console.log(data))
.catch(error => console.error('Error:', error));

# 对字典列表进行多条件排序
users = [
    {'name': 'Alice', 'age': 30, 'score': 85},
    {'name': 'Bob', 'age': 25, 'score': 92},
    {'name': 'Charlie', 'age': 30, 'score': 78}
]

# 按年龄升序，然后按分数降序
sorted_users = sorted(users, key=lambda x: (x['age'], -x['score']))

// 获取当前页面URL
const currentUrl = window.location.href;

function generateRandomString(length) {
  const chars = 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789';
  let result = '';
  for (let i = 0; i < length; i++) {
    result += chars.charAt(Math.floor(Math.random() * chars.length));
  }
  return result;
}

function generateRandomString($length) {
  $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
  $result = '';
  for ($i = 0; $i < $length; $i++) {
    $result .= $characters[rand(0, strlen($characters) - 1)];
  }
  return $result;
}