如何将本地PHP项目及数据库迁移至线上并获取永久访问链接

Got it, let's break down exactly how to move your XAMPP-based PHP app to a live web host—so you can get a permanent URL and keep your employee data stored online instead of relying on ngrok's temporary links. Here's a step-by-step guide tailored to your setup:

1. Pick a Compatible Web Host #

First, you'll need a host that supports PHP and MySQL (since XAMPP uses these). Most shared hosts, VPS, or cloud hosting services work—just make sure:

• The host offers a PHP version that matches what you used in XAMPP (e.g., if you built with PHP 8.0, don't pick a host that only supports 7.2).
• They include MySQL database access (almost all do, but double-check).

2. Backup Your Local Code & Database #

Before moving anything, lock in a copy of your work:

• Code backup: Locate your project folder in XAMPP's htdocs directory (e.g., C:\xampp\htdocs\employee-management). Zip or tar the entire folder to save it locally.
• Database backup: Open localhost/phpmyadmin in your browser, select your app's database, click the Export tab, choose the default SQL format, and save the .sql file to your computer.

3. Upload Your Code to the Live Host #

Next, get your code onto the host:

• Use an FTP tool like FileZilla, or your host's built-in file manager (found in their control panel, e.g., cPanel).
• Upload your zipped project folder to the host's root directory—this is usually named public_html or www. Unzip the folder once it's uploaded.
• Open your app's database configuration file (e.g., config.php or db_connect.php) and update the connection details to match your host's:

  // Replace these with your host's values
  $host = 'your-host-database-address'; // Often 'localhost' but sometimes a specific URL
  $dbname = 'your-new-online-db-name';
  $username = 'your-db-username';
  $password = 'your-db-password';
  

4. Set Up the Online Database & Import Your Data #

Now bring your local database to the cloud:

• Log into your host's control panel, find the MySQL Databases section.
• Create a new database (give it a name you'll remember), then create a database user and assign full permissions to this new database.
• Open your host's version of phpMyAdmin, select the new database, click the Import tab, upload your local .sql file, and run the import.

5. Test Your Live App & Fix Issues #

Time to make sure everything works:

• Use your host's assigned domain (or a custom domain you've linked to the host) to visit your app.
• Test all core features: logging in, adding/editing/deleting employee records, checking if data saves correctly.
• If you hit errors:
  • Check your host's PHP error logs (found in the control panel) for clues.
  • Verify your database connection settings are correct.
  • Ensure file permissions are set properly (e.g., if your app has an uploads folder, set it to 755).

6. Replace Temporary Ngrok Links #

Finally, update any hardcoded ngrok URLs in your app:

• Search through your frontend and backend code for links like https://xxxx.ngrok.io/api/employees.
• Replace them with your live domain, e.g., https://your-custom-domain.com/api/employees.

Quick Pro Tips #

• Enable SSL on your host (most offer free Let's Encrypt certificates) to use HTTPS—this keeps your app secure and avoids mobile browser restrictions.
• Set up regular backups: Most hosts offer automated backups, but it's smart to manually export your database and code every few weeks too.
• If you run into compatibility issues, check if your host allows you to switch PHP versions (many control panels let you toggle this easily).

内容的提问来源于stack exchange，提问作者Krishna Preetham