6 posts
A guide to renumbering Typecho post cid values and category and tag mid values with a PHP script to eliminate gaps in IDs, with a reminder to back up the database before making any changes.
How to change the Typecho database and table encoding to utf8mb4 and update the configuration file so that the blog can correctly save and display emoji.
How to use a single Typecho codebase to build multiple independent websites, each with its own domain name and database table prefix.
A collection of PHP-wrapped third-party API call examples, covering interfaces such as Baidu Translate, mobile phone number location, ID card lookup, express delivery tracking, hot search trends, and weather.
This post records the troubleshooting process for the Database Server Error that appeared after migrating a Typecho blog to a VPS running a LAMP environment, along with the fix of switching the database adapter to PdoMysql.
A record of how I misused dpkg to purge leftover configuration files on a VPS, which ended up deleting the Git-related database, and the lessons learned.
