What are the common mistakes made when creating a MySQL table in PHP for Google Maps API integration?

Common mistakes when creating a MySQL table for Google Maps API integration in PHP include not setting the correct data types for latitude and longitude columns, not indexing these columns for faster retrieval, and not properly sanitizing user input to prevent SQL injection attacks. To solve these issues, ensure that latitude and longitude columns are set as DECIMAL(10,6), index these columns for efficient querying, and use prepared statements to sanitize user input.

// Create a MySQL table for storing location data
$sql = "CREATE TABLE locations (
    id INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    address VARCHAR(255) NOT NULL,
    latitude DECIMAL(10,6) NOT NULL,
    longitude DECIMAL(10,6) NOT NULL,
    INDEX(lat_lng_index(latitude, longitude)
)";

// Execute the SQL query
if ($conn->query($sql) === TRUE) {
    echo "Table created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}