如何在WampServer环境下将指定PHP数组插入MySQL数据库（phpMyAdmin）

Alright, let's walk through how to get that PHP array data into your MySQL database using WampServer and phpMyAdmin. Here's a step-by-step breakdown that's safe and straightforward:

1. First, Set Up Your Database & Table in phpMyAdmin #

• Fire up WampServer, click the tray icon, and open phpMyAdmin.
• Create a new database (let's use travel_bookings as an example) if you don't have one ready.
• Create a table (e.g., passengers) with columns that match every key in your $register_data2 array. You can run this SQL directly in phpMyAdmin's SQL tab, or build the table manually:

  CREATE TABLE passengers (
      id INT AUTO_INCREMENT PRIMARY KEY,
      first_name VARCHAR(50) NOT NULL,
      last_name VARCHAR(50) NOT NULL,
      passport VARCHAR(20) NOT NULL,
      visa VARCHAR(20),
      address1 VARCHAR(100) NOT NULL,
      address2 VARCHAR(100),
      email VARCHAR(100) NOT NULL UNIQUE,
      contact VARCHAR(20) NOT NULL,
      pin VARCHAR(10),
      leaving_from VARCHAR(50) NOT NULL,
      going_to VARCHAR(50) NOT NULL,
      depart_date DATE NOT NULL,
      depart_time TIME NOT NULL,
      arrival_time TIME NOT NULL,
      grand_fare DECIMAL(10,2) NOT NULL,
      returning_from VARCHAR(50),
      returning_to VARCHAR(50),
      returning_date DATE,
      returning_time TIME,
      reaching_time TIME,
      fare DECIMAL(10,2)
  );
  

2. Update Your PHP Code to Connect & Insert Data Safely #

Never use raw SQL concatenation—it's a massive SQL injection risk. Instead, use prepared statements with MySQLi (the most common approach for Wamp setups):

// Connect to your MySQL database (default Wamp credentials below)
$servername = "localhost";
$username = "root"; // Default Wamp MySQL username
$password = ""; // Default Wamp MySQL password is empty
$dbname = "travel_bookings"; // Replace with your database name

// Create and verify connection
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Your existing array (ensure $j, $pieces, $pieces1 are properly defined!)
$register_data2 = array( 
    'first_name' => $_POST["fname"][$j], 
    'last_name' => $_POST["lname"][$j], 
    'passport' => $_POST["passport"][$j], 
    'visa' => $_POST["visa"][$j], 
    'address1' => $_POST["address1"][$j], 
    'address2' => $_POST["address2"][$j], 
    'email' => $_POST["email"][$j], 
    'contact' => $_POST["contact"][$j], 
    'pin' => $_POST["pin"][$j], 
    'leaving_from' => $pieces[0], 
    'going_to' => $pieces[2], 
    'depart_date' => $pieces[7], 
    'depart_time' => $pieces[12], 
    'arrival_time' => $pieces[17], 
    'grand_fare' => $pieces[22], 
    'returning_from' => $pieces1[0], 
    'returning_to' => $pieces1[2], 
    'returning_date' => $pieces1[7], 
    'returning_time' => $pieces1[11], 
    'reaching_time' => $pieces1[16], 
    'fare' => $pieces1[21] 
);

// Prepare the INSERT statement
$stmt = $conn->prepare("INSERT INTO passengers (first_name, last_name, passport, visa, address1, address2, email, contact, pin, leaving_from, going_to, depart_date, depart_time, arrival_time, grand_fare, returning_from, returning_to, returning_date, returning_time, reaching_time, fare) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");

// Bind parameters (s = string, d = double; adjust types to match your table schema)
$stmt->bind_param("sssssssssssssdsssssd", 
    $register_data2['first_name'],
    $register_data2['last_name'],
    $register_data2['passport'],
    $register_data2['visa'],
    $register_data2['address1'],
    $register_data2['address2'],
    $register_data2['email'],
    $register_data2['contact'],
    $register_data2['pin'],
    $register_data2['leaving_from'],
    $register_data2['going_to'],
    $register_data2['depart_date'],
    $register_data2['depart_time'],
    $register_data2['arrival_time'],
    $register_data2['grand_fare'],
    $register_data2['returning_from'],
    $register_data2['returning_to'],
    $register_data2['returning_date'],
    $register_data2['returning_time'],
    $register_data2['reaching_time'],
    $register_data2['fare']
);

// Execute and check results
if ($stmt->execute()) {
    echo "New record added successfully! ID: " . $stmt->insert_id;
} else {
    echo "Error: " . $stmt->error;
}

// Clean up connections
$stmt->close();
$conn->close();

3. Critical Checks to Avoid Failures #

• Validate Input: Before inserting, make sure $_POST data is valid (e.g., email format, dates in YYYY-MM-DD format). Invalid data will break the insertion.
• Verify $pieces & $pieces1: Double-check that these variables are pulling the correct values—they look like split strings, so confirm the indices are accurate.
• Wamp Service Status: Ensure Apache and MySQL are running (green tray icons). Place your PHP file in the www folder (e.g., C:\wamp64\www\booking-form.php) and access it via http://localhost/booking-form.php.
• Confirm Insertion: After submitting your form, go back to phpMyAdmin, navigate to the passengers table, and click Browse to see if the data was added.

Quick Troubleshooting #

• Column/Value Count Mismatch: Double-check that the number of columns in your INSERT statement matches the number of bound values.
• Date/Time Errors: Ensure $pieces/$pieces1 return MySQL-compatible formats (YYYY-MM-DD for dates, HH:MM:SS for times).
• Security Reminder: Never skip prepared statements—raw SQL concatenation is a critical vulnerability.

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