20206 articles
06-12MySQL SQL Optimization#Performance Optimization
06-05MySQL (CAP Theorem)
05-26Summary of MySQL Basic and Advanced Knowledge
03-22Alipay Payment Wrapper (For Understanding Internal Workflow)#Payment
02-22A Gentle Look at EXPLAIN#Performance Optimization
01-09MySQL Deadlocks#Deadlock
201935 articles
12-29MySQL Locks
12-28PHP's Composition and Lifecycle
12-26MySQL Transactions
12-24MySQL Development Standards
12-23MySQL Triggers#Trigger
12-23MySQL Stored Procedures#Stored Procedure
12-20MySQL Views#View
07-23PHP Iterator Pattern
07-15PHP Builder Pattern
07-11Laravel Runtime Principle Analysis (Source Code Analysis)#Laravel
07-05Common Composer Commands
05-31PHP Shell Sort
05-27PHP Merge Sort#Sorting Algorithms
05-11Using JWT
05-05Laravel vs Yii 2 Framework: Database Comparison#Laravel#YII2
04-25PHP Command Pattern
04-12PHP Proxy Pattern
04-02PHP Facade Pattern
03-29PHP Bridge Pattern
03-06New Retail: Database Table Design for Purchasing, Sales and Inventory (Suppliers, Purchasing, Stock-In)#New Retail
03-06New Retail: Database Table Design for Staff, Departments, Roles and Permissions#New Retail
03-06New Retail: Database Table Design for Orders, Returns and Reviews#New Retail
03-06New Retail: Database Table Design for Coupons#New Retail
03-06New Retail: Database Table Design for Product Inventory#New Retail
03-05New Retail: Multi-Spec Product Table Design#New Retail
03-03PHP Adapter Pattern
02-25PHP Decorator Pattern
02-15PHP Strategy Pattern
01-29PHP Chain of Responsibility Pattern
01-27PHP Observer Pattern
01-22PHP Abstract Factory Pattern
01-17PHP Factory Method Pattern
01-17PHP Simple Factory Pattern
01-12PHP Singleton Pattern
01-08Formatting a National Province/City/District List in PHP
201853 articles
12-29Generating a QR Code Image from a URL in PHP
09-26Using Redis in a PHP Project
09-26PHP Bubble Sort#Sorting Algorithms
08-22PHP Binary Search#Sorting Algorithms
08-22Frontend Performance Optimization: Requests, Caching & Compression#Frontend Optimization
08-21Choosing a MySQL Storage Engine: MyISAM, InnoDB & MEMORY
08-21Looping Over a 2D Array in PHP
08-21PHP Encryption/Decryption: From Deprecated mcrypt to OpenSSL Symmetric & Asymmetric#Encryption & Decryption
08-21Common Data Structures
08-21PHP Quick Sort#Sorting Algorithms
08-21CDN Acceleration Principles & Best Practices#CDN
08-21Using Memcache in a Project#Memcache
08-21PHP Password Storage: How to Choose Between md5 and password_hash#Encryption & Decryption
08-21Full Implementation of Forcing File Download in PHP
08-21PHP Insertion Sort#Sorting Algorithms
08-18Handling High Concurrency and Heavy Traffic in PHP#High Concurrency
08-15Four Common Website Features in PHP (Login, Registration, Third-Party Login, Third-Party Payment)
08-15PHP Autoloading Mechanism#composer#Autoload
07-28Sending Email via SMTP with PHPMailer in PHP
07-24Session Sharing and Validity Settings in PHP Distributed Clusters
07-22Using Nginx Rewrite Rules#Rewrite
07-18WebSocket in Practice: Principles and PHP Backend Implementation#Websocket
07-18Implementing MySQL Sharding in PHP (Application-Level Horizontal Split)
07-17MySQL Master-Slave Replication#High Availability
07-17How PHP Session Works and Session Design Notes for Large Sites
07-16Troubleshooting and Fixing MySQL Error "reading initial communication packet"#Troubleshooting
07-16What's the Real Difference Between GET and POST
07-11Building a Redis Cluster in Practice (Six Nodes, Three Masters Three Slaves)
07-09BigPipe Chunked Loading: Make the Page Render Block by Block (PHP + Nginx in Practice)
07-07The Caching System in a PHP Project
07-06Logging Errors in a PHP Project
06-29Nginx Dynamic/Static Separation: Using upstream to Split Static and Dynamic Requests
06-20Defining Your Own Error Pages on an Nginx Site
06-19Start Multiple Services at Once and Schedule Tasks on Linux
06-14Configuring CORS with Nginx for Cross-Origin Access#Cross-Origin
06-14Core E-Commerce Database Table Design in PHP
06-11Nginx Common Modules: Content Substitution, Request Rate Limiting, and Access Control
06-10Nginx Basics
06-03Redis Data Types and Their Use Cases
06-03Common Git Commands#Team Collaboration
05-28Implementing a Simple Flash Sale with a Redis List Queue: PHP Code
02-25PHP Recursion
02-23A Complete PHP Implementation of Uploading Images to a Database and Displaying Them
02-22Common PHP Functions for File and Directory Operations
02-22PHP Basics Interview Questions
02-21Implementing Search Autocomplete in PHP (jQuery UI Autocomplete + MySQL)#Autocomplete
02-21Precise Validation of ID Card Numbers in PHP
02-20Converting Numbers to Chinese Uppercase RMB Format in PHP
02-08MySQL Slow Query Log and SQL Optimization in Practice#Performance Optimization
02-04PHP Fundamentals (Must-Master Basics)
01-31Linux Common Commands (by category)
01-31vi and vim: Concepts, Three Modes, and Common Commands
01-30HTTP Status Codes Explained