XAMPP环境下MySQL数据库连接问题及代码求助

Hey Bryan, let's dig into why your database connection isn't working and fix it step by step! Here are the key issues in your code and additional checks to run:

Your code has a few obvious syntax errors that are breaking the connection:

• Reversed mysqli_select_db parameters: The correct order is mysqli_select_db($connection, $database_name), but you swapped them to mysqli_select_db(DB_NAME,$con). This means PHP can't locate the database you're trying to use.
• Deprecated error function: You used mysql_error()—this belongs to the old, outdated mysql extension, not the mysqli extension you're using. Use mysqli_error($con) instead, and remove the @ symbol (it hides the useful error messages you need to debug).

You don't need a separate mysqli_select_db call—you can specify the database directly in mysqli_connect to make the code cleaner and less error-prone:

$con = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

Directly accessing $_POST['email'] without checking if the parameters exist will throw errors if the form isn't submitted properly. Add a quick check first:

if (!isset($_POST['email'], $_POST['pass'], $_POST['name'])) {
    die("Missing required form fields!");
}

Your incomplete INSERT statement is wide open to SQL injection attacks. Always use prepared statements instead of directly inserting user input into your query:

// Example prepared statement (replace your_table_name with your actual table name)
$query = "INSERT INTO your_table_name (email, pass, name) VALUES (?, ?, ?)";
$stmt = mysqli_prepare($con, $query);
// "sss" means 3 string parameters (email, pass, name)
mysqli_stmt_bind_param($stmt, "sss", $_POST['email'], $_POST['pass'], $_POST['name']);
mysqli_stmt_execute($stmt);

<?php
define('DB_HOST', 'localhost');
define('DB_NAME', 'anyons');
define('DB_USER','root');
define('DB_PASSWORD','');

// Check for required POST parameters
if (!isset($_POST['email'], $_POST['pass'], $_POST['name'])) {
    die("Missing required form fields!");
}

// Connect directly to the target database
$con = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
if (!$con) {
    die("Failed to connect to MySQL: " . mysqli_connect_error());
}

// Use prepared statement to insert data safely
$query = "INSERT INTO your_table_name (email, pass, name) VALUES (?, ?, ?)";
$stmt = mysqli_prepare($con, $query);
mysqli_stmt_bind_param($stmt, "sss", $_POST['email'], $_POST['pass'], $_POST['name']);

if (mysqli_stmt_execute($stmt)) {
    echo "Data inserted successfully!";
} else {
    echo "Insert failed: " . mysqli_stmt_error($stmt);
}

// Clean up resources
mysqli_stmt_close($stmt);
mysqli_close($con);
?>

If you fix the code and still can't connect, check these XAMPP-specific details:

• Make sure the MySQL service is running in your XAMPP control panel (look for a green "Running" label next to MySQL).
• Verify the anyons database exists: Go to http://localhost/phpmyadmin and check if anyons appears in the left-hand database list. If not, create it first.
• Confirm your root password is actually empty: XAMPP defaults to an empty root password, but if you changed it during setup, update the DB_PASSWORD constant to match.
• Check for non-default ports: If you changed MySQL's port from 3306, add it to DB_HOST like this: localhost:3307 (replace 3307 with your custom port).

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